ALZDBA,

I put the code in one exec

set @statement = N'use [' + @name +']'+ " exec sp_grantdbaccess 'PRODUCTION\DCT_SQL_VALIDATION','DCT_SQL_VALIDATION'"

exec sp_executesql @statement

but it still refuses to switch database context!

the truncateonly option only deallocates space up to the last used extent, so you were probably not getting much space back as you had an allocated extent near the end...

space required =

size of .mdf + size of all .ndf (if present) + size of .ldf + size of .bak file

The .bak will almost always be smaller than the...

I would not try and move over the master database just script out logins, server roles, default database and language and run in on the other side (no problems with...

Also, remove builtin\administrators group from SQL (after setting up alternative group with sysadmin to run sql under.)

but a local admin with a bit of knowledge could get round that................

I think SQL Oracle had your answer early on in that you set the client up so the only access they gave is via the app, and their only permissions...

you can use standard. Its only limitation (cluster-wise) is it only goes up to two nodes, which is what you have got. No. of instances, active\passive or active\active is not...

Also, if you are restoring a backup of a production database, you are possibly in some sort of DR situation, and in those cases you want the database back as...

usual reason for this error is the sql instance is set to only accept windows authenticated logins but you are trying to connect with a sql authenticated ID. check the...

Marios, got it, cheers

so high i/o queries benefit from parallelism? And one hope queries in OLTP do not produce high i/o (hence comment about tuning, by which I presume you mean code)

Its heavy...

....which brings me on to a question, is parallelism a good thing in the database engine?

Amount of times I see CXPACKET waits and PAGEIOLATCH_* waits on parallel queries, especially on...

in the job properties, who owns the job.? If it is not sa or the service account, change the job owner to one of them

yes paul;, realised that as soon as I posted, which is why I deleted post, but you were too quick for me! :blush:

Are you sure there are no 'UMS Scheduler Hung' messages in the SQL errorlog?

This is the only thing I am aware of which will completely freeze a SQL instance. If...