Or, if you want to remove the dashes as well:

DECLARE @BackupFileName varchar(100)

SET @BackupFileName = 'C:\temp\TestDB_' + REPLACE(REPLACE(REPLACE(CONVERT(varchar,GETDATE(), 20),'-',''),':',''),' ','') + '.BAK'

BACKUP DATABASE TestDB

TO <A href="mailto

For what it's worth also, the SYSLOCKS table should no longer be used as it has been replaced with SYSLOCKINFO.  In your query, you are joining them both together.  You...

"SQL Server will "feel" confused"

I've always kind of thought that SQL Server had feelings!  Anyhow, I'd agree with SQL Oracle that it is possible that the file is corrupt or...

Run RESTORE FILELISTONLY FROM DISK='fully qualified backup path and file name' to get the abc_data and abc_log values for below.  Then restore the DB using a QA session opened up...

Please keep us posted as to an update on how your volume testing goes with this approach.  I will help those who read this thread going forward. 

Thanks.

How can a trace definition be any more re-usable than saving off a template?  Can you explain why this is clunky?  I think we may be missing something here.  Please...

"It has the down side that you have effectively created a temp table name that you now cannot reuse in another procedure."

Michael, I think what Sergiy was impying here is...

"Not a 64-bit guy, just what I read."

Me either.  Maybe I shouldn't have answered this post!!  Sorry if I caused anyone confusion.....

SQL Server treats an application lock just as it would a lock on any other physical resource such as a table.  I have not played around with it enough to...

Along with what I've said here: http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=8&messageid=357553

Create an 'Execute Process' task in your package and call the command line command to unzip your file. 

I went through and looked at your recent posts and it appears that your file import is more than just a simple bulk insert.  It looks like you have a...

You may also consider writing logic into your stored procedure to take advantage of SQL Server's application locks.  Use BOL to read up on sp_getapplock.  In a nut shell, you'd...

If I'm reading you correctly, you want to know how much of the 8GB you should give to SQL Server?  I would recommend giving SQL Server 7GB of the memory...

I would definately consider re-designing the process here.  Many database developers will try to code things into triggers simply because the word 'Trigger' makes them think to use triggers to...