Yep. Right click the database in SSMS (either 2008 or 2005 SSMS), and select Tasks->Generate Scripts.

Then follow the wizard to select the stored procs and all of the options.

Jim

I remember those days! I ran a very small BBB back in the 80's. Those were the days.

Anyway, what you describe is...

Try sqlcmd.exe which is documented here: http://msdn.microsoft.com/en-us/library/ms170207.aspx. Then you can use the same SQL commands that you learned earlier this evening when you posted here: http://www.sqlservercentral.com/Forums/Topic1051241-392-1.aspx.

Also, the log files...

HA! That graphic is priceless.

It is all too easy to begin the development process by configuring the application to use "sa" (or another sysadmin account), and even demo using...

Nice question Ron!

Grant,

Nice description; down to earth and understandable.

I would guess (perhaps wrongly) that almost all people in the room have probably backed up a database. A full backup at least....

Studying is for mere mortals. This is how we learn stuff that we didn't already know. Probably sounds strange to you, I know. Consider this post 'study', so now you...

You studied straight from the BOL as your primary textbook?! Ha! That's a reference, not an instruction guide.

For the rest of us non-savants, the books do well....

Yes, this I'd another way. CDC is Enterprise only if I remember correctly. Also, the tables can get...

Yep. Piece of cake to do this. UMG has some good caution about the licensing differences and to be careful not to violate the agreement for using the Developer edition.

But...

Looks to me like you want to allow the user to read and write all data, but not change the structure of the database. Grant the database role of db_datareader...

That's great. Thanks for the slides. We just finished sqlsaturday #63 in Dallas today. Nice turnout.

Jim

You can ensure the checkbox to add the step details to the job history is checked. I also found it helpful to go to the step details and specify...

Select out of the system tables which hold the proper data. For example, sysobjects (where type = 'U'), sysindexes, syscomments, etc.

Sql2005 and greater use slightly different table names (sys.indexes...

There are a variety of methods to do this. You can add update code to your front end app, to a stored procedure, a trigger, etc.

Likely, a trigger will work...