ctrl+mo :: Function Collapse Code
Sunday, October 18, 2020
Thursday, October 1, 2020
Auto Database Backup to Drive
--exec usp_DataBaseBackupgHRM
CREATE Procedure [dbo].[usp_DataBaseBackupgHRM]
As
Begin
Declare @BackUpname varchar(255)
Select @BackUpname='S:\gHRMDBBackup\gHRM_'+RTRIM(LTRIM(Convert(Varchar(50),Getdate(),112)))+'.BAK'
BACKUP DATABASE gHRM
TO DISK = @BackUpname
WITH INIT
End
Subscribe to:
Posts (Atom)
-
ALTER Procedure [dbo].[SetEmploymentDetails] ( @LoanSummaryID AS bigint ,@OfficeId AS int ,@MemberId A...
-
ALTER FUNCTION [pksf].[fn_SplitString] ( @Input NVARCHAR(MAX), @Character CHAR(1) ) RETURNS @Output TABLE ( Item NVA...
-
Configuration option 'remote query timeout (s)' changed from 600 to 0. GO EXEC sp_configure 'remote query timeout', 0 ...
