Are you looking to have all stored procedures in the original database (dbA) access the tables in the new databases (dbB) and the tables will be deleted from dbA?

You need...

update sd2

set sd2.distinguishedname = sd.distinguishedname

from staffdetails2 sd2

inner join staffdetails sd

on sd2 = displayname = sd.displayname

I don't think this is possible. There should not be anything in an insert that needs to know about other threads unless this is some type of performance monitoring application.

My apologies. I've made some security changes and removed the offending script.

Steve

I like the above advice. There are times a job is just a job. Look for a challenge elsewhere, either in technology or outside it.

If you're really bored, maybe take...

Thanks for the comments.

They don't "hold" the book for you. At least not for me. I've added stuff to my cart and then been notified that it's out of...

I'd call MS support for this. Sounds like maybe they either changed functionality or it's a bug in the SP.

select top 6 newid(), col1, col2

from table

order by newid()

http://www.sqldts.com

3-4M rows a day shouldn't be too bad. Are your quieries indexed? I'd start trying to optimize those, but don't make too many indexes with that many rows. 3-4 max.

If you do updates through stored procedures, make the change there. If you have updates through T-SQL and want to be sure they are captured, use a trigger.

Yes, goes as a named instance.

I've seen something similar when the secure channel between teh SQL server and the domain controller is broken. Can't authenticate. Is this a new user? Or someone that hasn't logged...

Thanks for the replies and it's interesting to read.

Luke! Send me some SQL-Beer samples and I'll get them reviewed for the site! Always on the lookout for new and interesting...

Congrats on the MS job. Let us know how it goes if you can.