One additional note, if you plan to schedule the DTS Package, the Data Source must be defined on the database machine and must be a system dsn.

Is the ODBC defined as a SYSTEM or a USER DSN ?

garethl: were you aware that DATEFORMAT only controls the conversion of characters to dates but does not control the conversion of dates to characters that you see on a client...

Looks like this is a known problem since December 1, 2003 and there is no fix, just workarounds.

PRB: DBCC SHRINKFILE and SHRINKDATABASE Commands May Not Work Because of Sparsely Populated...

How very intersting.

What are the types of tasks within this DTS package?

ActiveX, BulkInsert, Transform Data?

One thing that any naming standard needs to consider is the concept of namespace, which define which database objects are within the same uniqueness constraint.

Columns have a namespace where column...

Welcome to SQLServerCentral.

Please provide DDL and sample data

Since this is your first post, you should be aware that you will often get responses such as this that state "Please provide...

Dang !

When you nest sp_MSforeachtable within sp_MsForEachDb, I get the below message for each database:

Server: Msg 16915, Level 16, State 1, Line 1

A cursor with the name 'hCForEach' already exists.

create...

Check for an anti-virus program.

The usual practice is to exclude database files from virus scans which are files with extention *.mdf, *.ndf or *.ldf

See the post at

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=23&messageid=135329

This is not a threading problem.

'TEMPDB' is the work space for SQL Server and as your process needs more work space than is currently available, the size of the tempdb...

UTC Seconds, also called Epoch Start Seconds, is the number of seconds since January 1st, 1970, with the local date and time adjusted to the UTC timezone.

declare @EpochStartTs datetime

, @GregorianTs...

You could use the SQL Server password encryption routine.

Create table App_users

( auserid - bigint

, ausername varchar(20)

, EncryptedPassword varbinary(256)

)

Then, during the login process with a password, encrypt it and then...

"Raid 5 was selected because of cost/GB Using Raid1 or 1+0 cost more since you have to buy 2 drives to get 1 drive worth of capacity. "

If you...

Only if you have explicitly started a transaction.

For example, to transfer $1000 from one account to another account, you might write:

Update account set balance = balance - 1000

where AccountId =...