Disregard-I finally found it. Here's a sample statement:

DUMP DATABASE model

TO DISK = '\\[SERVERNAME]\[FOLDERLOCATION]\model_test.BAK'

WITH INIT

I thought I would be the only one to say that being a database developer is both my hobby and job! I tinkered with databases in my previous career...

One of the things I do during development of a stored procedure that includes dynamic SQL is instead of executing the statement I PRINT (http://msdn.microsoft.com/en-us/library/ms176047.aspx) the statement. ...

The database's owner should actually be the SA account not dbo. To change the database owner use the following statement:

USE <DatabaseName>

exec sp_changedbowner @loginame = 'sa'

GO

Another option, since you're using SSIS, is to create a Script Task, use the System.IO namespace, and delete the files that way.

I would try creating a table function instead of a view since you want to pass parameters; there are some limitations on what can be done in a function:

Amen, brother!!! That is why I quit going to conferences and other events (aside from SSUG's). I get a little tired of getting beaten by the Microsoft marketing...

I hope this answer is not too simplistic. A few questions first:

• How many tables currently house entries related to the contract(s) in question?
• Also, how are the foreign...

I agree. I would give them the database shell with no live data in it. If they need to they can create their own data.

I agree in that you need to name the database in a way that you can track. In the past I've seen companies name the database a series of...

Beautifully stated, Mr. Jones.

OK-thanks for the reply.

Another option is to use ROBOCOPY, which ships with the Windows Server products (http://www.microsoft.com/technet/technetmag/issues/2006/11/UtilitySpotlight/). It has both GUI and command line options.

Very cool. Congratulations!

I've developed DTS packages that collected zip files from FTP sites and then unzipped to do the magic. I used WinZip (had to buy a copy). They have...