Prev: Determine a server specific ID
Next: Steps for copying databases?
From: SAC on 2 Jul 2010 11:19
Can stored procedures be included in a backup file, .bak? I'm thinking only
the data is in the bak file, but is there some way I can include the stored
procedures?

Thanks for your help.


From: Scott Morris on 2 Jul 2010 12:20
"SAC" <sac(a)somewhere.com> wrote in message
news:%233IirnfGLHA.4120(a)TK2MSFTNGP02.phx.gbl...
> Can stored procedures be included in a backup file, .bak? I'm thinking
> only the data is in the bak file, but is there some way I can include the
> stored procedures?

A backup file created using the backup command contains everything in the
database - including stored procedures.


From: SAC on 2 Jul 2010 14:06
Excellent. Thanks.

"Scott Morris" <bogus(a)bogus.com> wrote in message
news:%23BwUFKgGLHA.3732(a)TK2MSFTNGP02.phx.gbl...
> "SAC" <sac(a)somewhere.com> wrote in message
> news:%233IirnfGLHA.4120(a)TK2MSFTNGP02.phx.gbl...
>> Can stored procedures be included in a backup file, .bak? I'm thinking
>> only the data is in the bak file, but is there some way I can include the
>> stored procedures?
>
> A backup file created using the backup command contains everything in the
> database - including stored procedures.
>

 | 
Pages: 1
Prev: Determine a server specific ID
Next: Steps for copying databases?