I used to make available a bunch of scripts from my old place that helped in migrating from SQL 2000 to 2005, one of which scripted tables. As they...

Both EM and QA do their scripting using calls to a SQL scripting API. My experience is this can be buggy when you try to get everything scripted out...

alien,

The data that is being stored in SQL Server is the valid result of the UuidCreate() function. They are not junk characters.

In order to generate a globally unique value,...

When SQL allocates a new extent to a table, it will put as many rows as possible on each data page, up to the limit given in the freespace values....

You need to check the actual permissions on the folders containing your database files. When SQL 2005 is installed, it will set its own permissions on the folders it...

I have never had this issue, but please post the solution when you find it.

I noticed this is in the SQL 2000 forum and the erplies have all used SQL 2005 facilities...

The best way to disable xp_cmdshell in SQL 2000 or SQL 7 is...

Simple recovery does not truncate the log at every checkpoint. SQL will always, regardless of recovery mode, keep track of the oldest active transaction. The LRSN of the...

Google

You may need to look at the memory available to DTS.

My old shop had a situation where DTS batch jobs sometimes failed for no apparent reason. When...

You can script all of your packages out of SQL 2000 and script them in to SQL 2005. This forum has examples, or look up Nigel Rivett's examples.

However, any...

The message actually means 'the input data that relates to destination row xxx caused an error'. You need to work out what is the input data that would cause...

If you use Intel chips, you may (or may not) get a small performance gain using 2 x 2-core processors over 1 x 4-core processor.

If you are specifying a server...

After you install the DTS Designer components into SQL 2005 you can maintain your packages in the same way as on SQL 2000. We needed to apply the fix...

More thoughts on security...

It is very difficult to run SQL 2000 without the service account having Windows local administrator authority. It is easy and recommended to run SQL 2005...