The only problem with going to the next step on failure is there is no indication that a failure occured.  Some of my jobs I have inserted an addtional step...

You might consider removing the SysAdmin privilege from builtin\Administrators group before getting rid of it away in case something is using the group unaware (like backup software, etc.).  Then you...

Query Analyzer is an appropriate tool for initial testing of stored proceedures.  See Books on Line (BOL) for the correct syntax for EXECUTE.  You can pass parameters and check return...

Are you talking about stored procedures you have written or existing ones?

Has a problem popped up or are you trying to provide quality control?

A general rule for testing any...

Does the DSN use Windows NT Authentication or SQL Server Authentication?  Who are you logged in as for the Enterprise Mananger session?  It could be a permissions problem.

Steve

I do the following before dts:

sp_msforeachtable "ALTER TABLE ? NOCHECK CONSTRAINT all"

go

sp_msforeachtable "ALTER TABLE ? DISABLE TRIGGER all"

go

After dts:

sp_msforeachtable "ALTER TABLE ? WITH CHECK CHECK CONSTRAINT all"

go

sp_msforeachtable "ALTER TABLE...

I'm not particularly interested in a different job right now but it would be helpful if you gave a state or region (if in US) or a country.  If you...

A Pet Peeve.  When giving answers in the newletter, could you give all the choices again?  I view QOD as a good learning tool but when the answer is "A...

If the databases have not been created yet, try putting the shared tables in the model database and then when a new database is created it will start out with...

I have some jobs that use dtsrun in multiple steps.  I created them by going selecting "Schedule Package", which creates a job with the same name as the Package.  I then...

The solution, as Mr. Komacsar suggested, would be don't assign Windows Groups to access a specific database.  Instead, assign individual Windows logins with access to SQL-Server and then assign that user...

Depending upon your reason for wanting to drop and re-create indexes, dbcc dbreindex may be something you wish to explore.  It can rebuild all the indexes for a table without...

If you prefer seeing it from Enterpise Manager, change the view to Taskpad, Select the Table Info tab and Scroll down or Next to the table desired.  All of the...

I agree that dts is reliable.  If you want to check the data a few times just to be sure you could use something like Red Gate's SQL Data Compare.

Steve

The general rule is to use an apostrophe is to embed to apostrophes for one.  Thus the following is correct:

select * from oname

where lname = 'O''BRIEN'

When assembling SQL from...