I believe that SP2 was also released for Windows Server 2003 R2 Enterprise x64 Edition.  This is the version of the OS we are running for our Data Warehouse development...

Cursors are not bad, you just have to use them appropriately.

Check BOL, CAST AND CONVERT.  You will find the different format codes for converting dates to character strings there.

Okay, I guess I am getting confused.  If you are looking for a code with '12%', how can you get a code like 'AB12'?  Still need to know what is...

John, True.  Like I said, wrote it off the top of my head.  At least I was trying to get read of the space in the datetime stamp.  I don't...

But good questions.

David,

I'd be interested in learning more about this wrapper you use.  What, where, how much, are the basic questions, plus where can I learn more.

declare @backupfile nvarchar(2000)

set @backupfile = N'C:\TESTDB\TESTDB_db_' + replace(convert(nvarchar(50), getdate(), 120), ' ',':') + N'.BAK'

BACKUP DATABASE [TESTDB] TO DISK = @backupfile ...

I think.  Give it a try, I wrote this off...

Feels good when you figure something out on your own, doesn't it?  Now, if someone else has a similiar problem, you are in a position to help out.

Here is where you need to start, BOL.  Lookup the tables sysjobs and sysjobhistory.  After your stored procedure starts the job, it needs to loop while waiting for the job...

It could also depend on high large your database is expected to get.  Using filegroups can speed up backup processes by allowing you to backup only the filegroups where data...

The N in front of a string constant, like N'false', simply indicates that the string is converted into Unicode (nchar or nvarchar data types.

The stored procedure msdb.dbo.sp_start_job, starts the job and then returns.  If it returns 0, then the job was successfully started, else it failed to start.  If you want to know...

I have an idea how to do this, but I need a little more information.  What do your product values look like, and how do they increment?

Start here:

http://www.microsoft.com/sql/howtobuy/default.mspx