I had this on SQL 2005 so until i loaded the CU 6 patch i couldn't get linked servers to work.

What patch are you on. Plus you can...

If you are sa you should be able to just change the account..what message does it gives.

Can you just make the account be your new one.

You wouldn't have to do this...You could have it in master no need to do in every database.

If you have a system database ..i.e SYSADMIN which is where your putting...

Developers shouldn't be on a production database, if it is a test database then i would give them sa rights...after all it is a development system.

If you don't want to...

Does the average user get what sp_lock is telling them, why don't you just do an alert with email to the user instead that there is a lock, also what...

Need to look into certificates this way you can allow the user to do this.

I would do it for say 80.....not the 100.

Then once you have done this you can do the shrink on the data files. (not the log as it not...

Depends if the sp needs to have system admin rights which sounds like it does.

If the user needs to be able to run this and it is something like alter...

Hope i read it correctly but the Log size didnt grew it only 39 mg so one of the tables grew 50 GIG...?

Oh the reindex

EXEC sp_MSforeachtable @command1="print '?' DBCC...

This is the latest update version... What is the smile faces - what do i replace the smiley faces in the code with...

Take away System Admin rights to every one then they cannot add these logins.

Reboot always fixes it - could have just been a record that was trying to be hit and deleted something like that....I would do a dbcc checkdb on the database...

Had quick look around it seems to be from linked server

http://kbalertz.com/954950/Error-message-distributed-query-Server-provider-linked-server-returned-message-transaction.aspx

I go look at the trace files now and see who changed this to the mode...im sure you can get that out of the trace files...or the right click on...

Oh someone changed it to FULL Recovery mode - oh that may do it if your not backing up logs every x minutes.