YELL BACK is a pretty good option. I have had to do that. We the DBA have managed to be the most hated department of our company..:D

But we are not...

This what I recommend, When ever a Programmer is making a change to the database, like adding a stored proc or a table, check it and see if they comply...

I am totally with Grant. Only thing I would add is to make this into a stored Proc with xid as a parameter and call the stored from your code.

From the knowledge I have seen in this web site, I really am sure that I am just a Junior DBA..:-) All of you guys and ladies are very knowledgeable...

You can use

Select * from syscomments

where text like '%id_name%'

I have seen lots of advice from everyone here how to take care of the Dead Locks and concurrency issues. How come no one ever advices to use sp_GetAppLock ....

If I am not mistaken, they are the Statistics details of each Object.These are Statistics generated by the system itself.

Hi Adam,

In 2000, you are also seeing the Statistics of the tables as well. Atleast that is what I am seeing here. They all start with _WA. I modified your...

Trigger could help you here pretty good but just keep in mind that in 2005, Triggers work by using Row Level version. That would mean increase use of TempDB.

Honesty is something that will be appreciated by the interviewer for sure. We were looking for a DBA here and we got some resumes of Sr DBAs. I consider myself...

Jeffrey Irish (2/29/2008)

---

Your USE DATABASE statement has to be it's own line, not inline with the update.

Running the following:

USE DATABASE SELECT * FROM TABLE

Gets me the error:

Msg 156, Level 15,...

fn_get_sql(sqlhandle) actually returns the text of the Stored Proc. So what you see is not recreating of stored proc. It is just showing the create script of the SP.

What Jeff said should do the trick but if by any chance you get Deadlocks again, you should look at sp_getapplock. That should solve the issue once and for all.

Ok.. That clarifies it a bit more. Thx

Just something that you can check, See if the Domain of the user is assigned to the groups that the SQL Server creates when it is being Installed.