Are your parameters setup to allow nulls?

The SCOPE_IDENTITY() returns the username of the person instead of the UserID which is created when a new record is entered.

I don't understand this. SCOPE_IDENTITY() returns the last IDENTITY...

As Helen mentioned, just because you have two CPU doesn't mean that they will be used by SQL Server every time. If the DB engine determines that it can accomplish...

I don't understand your requirements for having different databases. Maybe you should explain your overall process a bit more.

In SQL Server having 100 scripts is by no means a lot....

I don't see any need for seperate databases.

One of the main reasons for not putting information in different databases would be data integrity. You can't define foreign key constraints for...

Just specify the destination directory without the filename.

EG: exec master.dbo.xp_cmdshell N'xcopy D:\testing\testbat.bat D:\testing\DTS'

Instead of just returning the UserID by using @@IDENTITY. Assign the value to a local variable and the execute another INSERT statement with the new value.

Also, to avoid and multi-user and scope...

SQL Server Developer Edition is equivalent to Enterprise Edition.

For details on the different editions take a look at this document from the resource kit,

http://www.microsoft.com/sql/techinfo/planning/SQLReskChooseEd.asp

How do you insert the information into the Users table? If you use a stored proc, you can add an insert statement, or call another stored proc, after the insert...

Is the error during the full backup or transaction log backup?

If it's the transaction log backup, check the recovery model of the databases that fail. You can't do transaction log...

That's what it seems like, although I've never implemented anything like that. My way of thinking is that the errors collection is for errors, not informational messages.

If I have...

You will need to have the appropriate DLL's etc... in order to run DTS. From memory, I think that there is a list over a http://www.sqldts.com

Bear in mind that DTS...

Ok, this is the fourth discussion thread all about the same thing,

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=6&messageid=161763

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=5&messageid=161765

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=5&messageid=162099#bm162479

If you didn't get the answer you wanted in those other threads, why not post to the...

The double FROM syntax is a T-SQL extension to the ANSI standard. The ANSI standard only provides for specifying criteria in the WHERE clause of a DELETE statment. That probably...

I don't recall anything that shows different database limitations between SQL Standard and Enterprise.

However, I'd say with the 2 GB memory limitation in SQL Standard, you're likely to run into performance...