There is a good article on SQL Agent tokens over at http://www.sqldev.net

While my experience many years ago wasn't with Veritas, I think it's pretty pertinant here. When I started as the DBA the company was already using the ArcServe SQL Agent....

If you drop the table, you'll also lose those ever dependable dependencies

Maybe thats wher the accuracy comes into play,

From BOL,

Date and time data from January 1, 1753, through December 31, 9999, with an accuracy of three-hundredths of a second, or 3.33...

SQL Server is very unforgiving when there is any latency between it and the backup device. A single delayed packet can cause the backup to fail. That's why it's always...

One thing to watch when looking at CALS is whether they are user or device CALS.

200 device CALS will license you for 200 unique devices (workstations, other servers, etc...).

200 users...

You should re-write the query using the ANSI join syntax (INNER JOIN, OUTER JOIN, etc...).

If you use a derived table instead of an IN clause in the WHERE statement, SQL...

How about this?

use master
go
DECLARE @intErrorCode INT

alter database inventory set SINGLE_USER with ROLLBACK immediate

SELECT @intErrorCode = @@ERROR
IF (@intErrorCode = 0) 
BEGIN
 -- do database update, drop databae, schema change...

Did you select CR/LF as the row delimiter? Selecting "Fixed Field" is only for the columns. You still have to supply the appropriate row delimiter.

Yes there is that option, but I think it still excludes foreign key constraints?

That's the main reason I script out the changes seperate from the data.

When you initially setup the file connection in DTS make sure the first row has the last column populated. This is the important part.

Then select "Fixed Width" instead of "Delimited" in...

Yes SQL Server will run a database that has been designed for Access much slower than Access itself.

If you're not prepared, or not able, to re-design your database to take...

The last time I used ERWin was version 4.1 and it was a real dogs breakfast. After losing my model about 2-3 times due to crashes, I got into the...

Haven't come across a need for sleep in my DTS packages, only in my day-to-day life

How about using WScript.Shell to call NTSLEEP...

I second the call to use xp_smtp_sendmail. since implementing at our site we've had no problems at all.