In addtion, two things

When you transfer logins they will not necessarily retain their default database.

If you transfer sql logins be careful of passwords. If the destination server has a different...

Another way is to BACKUP the db and use RESTORE ... WITH MOVE

Use CREATE DATABASE ... FOR ATTACH see

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/tsqlref/ts_create_1up1.asp

When a SQL7 db is attached to SQL2K it is converted, the same is true of restoring a db from a backup.

A SQL2K database cannot be attached to SQL7.

I have...

Alternatives to Kenneth's

select number

from master.dbo.spt_values

where type ='P'

and number between 1 and 52

order by newid()

select top 5 number

from master.dbo.spt_values

where type ='P'

and number between...

The error is a result of passing and empty string to a int parameter (int,smallint,tinyint). .NET will not convert empty strings to integer.

As an additional note you are implicitly converting...

Gosh, don't we all take these things a bit too seriously.

Probably

Bragging...

How can a question like this get through QA ?

Wow a volunteer for QA !!!