Use Darren Green's DTSBackup 2000 to save all the packages. It's free and works well. Get it here: http://www.sqldts.com/242.aspx

Like a lot of people, what I listen to depends on what I'm doing.

I alternate between no headphones, listening to NPR, and listening to music (alt rock & blues).

Because I...

Try the method I mention in this link:

http://www.sqlservercentral.com/Forums/Topic607599-19-1.aspx

Not that I've ever noticed. I've had packages log to SQL Server and to text files and never noticed a significant performance difference between that and no logging.

bothaellen (10/27/2010)

---

We have a production server running at a remote site. We would like to restore Transactional backups from the production server to the Development Server Database every night so...

Unlike a sequence, which is a database object, identity is a column property which can't be shared among tables.

You could could do what you want by creating a table with...

I usually generate a TRUNCATE script outside the Wizard and run it right before copying data.

select 'truncate table ' + name

from sys.sysobjects

...

No. Only a log backup truncates the transaction log.

Have you considered the SQLAgent roles, SQLAgentOperatorRole SQLAgentReaderRole, SQLAgentUserRole, in msdb?

Look at their definitions in BOL and see if one of them fits what you want the user to be...

Could you use a script that executes sp_add_job, sp_add_jobstep, sp_add_jobschedule, and sp_add_jobserver? I don't know what kind of database checks you include, but you can put DBCC

commands in a...

Try Restore Headeronly.

RESTORE HEADERONLY FROM <backup device>

From what I gather by searching this site and Google, Autosys is a job scheduling product from Computer Associates. I don't have any experience with it, but there are...

Being a member of the db_owner role isn't the same as being dbo as far as object ownership goes. The owner of the object will default to the user's...

You can save a DTS package as a Visual Basic file by opening it with DTS Designer, expand Package, Save As..., make the location "Visual Basic File". You can...

You can't create a single role that works in multiple databases because database roles only exist in the database where they're created.

If your aim is to allow a...