Thanks for the help, but I'm afraid both do not help me in this case.

As mentioned, I need to do this in T-SQL not EM.

The set identity_insert on doesn't work...

Nope I've not tested this, but I remember reading this on a forum somewhere some time ago, but cannot find it now maybe my memory is playing tricks on me...

You can add the /3GB switch to the boot.ini file which I believe allows SS200 Standad edition to use 3GB, athough this server should be a dedicated SQL server machine.

Neil.

A starting point for you could be to run a maintenance plan against this database.

You have the options in the Plan for shrinking the database and defragging existing indexes.

After this is done,...

Their SQL login should prevent them from querying the system databases unless they are 'sysadmin' level people, so even though they can see them, they shouldn't be able query those...

You can 'translate' between collations on the fly if needed

For example, on the pubs..employee table the pub_id column on my machine is defined as

 [pub_id] [char] (4) COLLATE Latin1_General_CI_AS NOT NULL ,

However...

If the users are not supposed to be in the database when the backups are to be performed you can kill their spids quite easily.

There are lots of example scripts...

As db_id with no parameters returns only the ID for the current database, if you need to know the id's of all databases use this T-SQL

select name,dbid from master..sysdatabases

hth

Neil.

Maybe those that spotted that the question was bogus should get a bonus 1,000,000 points for attention to detail etc. 

The given 'correct' answer is wrong.

The table is not named foo it is named People.

Therefore a run time error of object does not exist would appear.

NAA