Click here to Skip to main content
15,506,757 members
Home / Discussions / Database
   

Database

 
QuestionAccessing multiple result sets from a stored procedure Pin
Rashmi Deshpande14-Jul-08 0:56
Rashmi Deshpande14-Jul-08 0:56 
AnswerRe: Accessing multiple result sets from a stored procedure Pin
Declan Bright14-Jul-08 2:26
Declan Bright14-Jul-08 2:26 
QuestionError message in Stored procedure Pin
IamAmit14-Jul-08 0:21
IamAmit14-Jul-08 0:21 
AnswerRe: Error message in Stored procedure Pin
leoinfo14-Jul-08 3:54
leoinfo14-Jul-08 3:54 
AnswerRe: Error message in Stored procedure Pin
TheFM23414-Jul-08 7:31
TheFM23414-Jul-08 7:31 
QuestionAutomate database backup ? Pin
rajg8213-Jul-08 23:03
rajg8213-Jul-08 23:03 
AnswerRe: Automate database backup ? Pin
Syed Mehroz Alam14-Jul-08 1:51
Syed Mehroz Alam14-Jul-08 1:51 
AnswerRe: Automate database backup ? Pin
leoinfo14-Jul-08 4:10
leoinfo14-Jul-08 4:10 
You can put the code below inside a stored procedure and then create and schedule a job to run whenever you want.

DECLARE @cmd NVARCHAR(100);
SET @cmd = N'C:\BackUp_MyDatabase_'+REPLACE( CONVERT(NVARCHAR,GETDATE(), 121) ,':','.')  +'.bak'
BACKUP DATABASE [MyDatabase] TO DISK =  @cmd
GO

QuestionSQL SERVER DATABASE Pin
Anubhava Dimri13-Jul-08 22:54
Anubhava Dimri13-Jul-08 22:54 
AnswerRe: SQL SERVER DATABASE [modified] Pin
Syed Mehroz Alam14-Jul-08 1:42
Syed Mehroz Alam14-Jul-08 1:42 
Questiongeneralized statements for update delete insert Pin
santosh04213-Jul-08 22:37
santosh04213-Jul-08 22:37 
AnswerRe: generalized statements for update delete insert Pin
Ashfield14-Jul-08 2:14
Ashfield14-Jul-08 2:14 
GeneralRe: generalized statements for update delete insert Pin
santosh04214-Jul-08 5:11
santosh04214-Jul-08 5:11 
AnswerRe: generalized statements for update delete insert Pin
leoinfo14-Jul-08 5:27
leoinfo14-Jul-08 5:27 
Questionconnection string Pin
nelsonpaixao13-Jul-08 16:06
nelsonpaixao13-Jul-08 16:06 
AnswerRe: connection string Pin
Vimalsoft(Pty) Ltd13-Jul-08 16:48
professionalVimalsoft(Pty) Ltd13-Jul-08 16:48 
AnswerRe: connection string Pin
Ashfield13-Jul-08 22:01
Ashfield13-Jul-08 22:01 
GeneralRe: connection string Pin
nelsonpaixao14-Jul-08 14:11
nelsonpaixao14-Jul-08 14:11 
Questionhelp me to write procedure Pin
amistry_petlad13-Jul-08 8:40
amistry_petlad13-Jul-08 8:40 
AnswerRe: help me to write procedure Pin
nelsonpaixao13-Jul-08 14:35
nelsonpaixao13-Jul-08 14:35 
AnswerRe: help me to write procedure Pin
amistry_petlad13-Jul-08 14:41
amistry_petlad13-Jul-08 14:41 
AnswerRe: help me to write procedure Pin
nelsonpaixao13-Jul-08 15:37
nelsonpaixao13-Jul-08 15:37 
GeneralRe: help me to write procedure Pin
amistry_petlad13-Jul-08 15:47
amistry_petlad13-Jul-08 15:47 
AnswerRe: help me to write procedure Pin
leoinfo13-Jul-08 18:21
leoinfo13-Jul-08 18:21 
GeneralRe: help me to write procedure Pin
amistry_petlad13-Jul-08 18:57
amistry_petlad13-Jul-08 18:57 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.