I havent seen much scan. I saw that the performance was pretty good for it. The main reason I came up with the idea was because the developers were...

I always write an upsert statement if it is based on primary key. Blindly update the table with new values (Primary key is the Where Clause). If Rowcount is 0...

It should not be a problem... If they ask you to change it, it would only mean one thing. Their app does not work well with 2005. They must have...

Is this stored proc Called from a Web site? I did not understand your question. If so, You can look in the IIS log to see who called that report...

We use Surround to keep all the Objects from the DB in source control. We also make sure that we add scripts to any manual Data Change for tracking.

You can use the profiler to identify. You just have to add the Hostname to you list of columns to be displayed. You can also just specify a condition to...

It does make sense from DBA's point of view. It is the Network Admins point of view that I am thinking.. 🙂

I know that the network admins will freak...

I am not a big fan of SAN. We had our prodiction set up with Clustering (Ofcourse SAN as well) . Everything was redundant and there is one point where...

Brian,

Before you had only two passwords to forget. Now you are adding 80 more service accounts passwords to forget. Dont you think it is counter productive? Yea, you can secure...

Try this.

Select [Text] from syscomments where [Text] like '%spInsert%'

You will get teh whole body of the SP. If you want just the name, then link the Object ID to get...

Thats a tough one to look at. It can come in from text box, It can be in teh URL Strings. So there are way too many ways an SQL...

I have a freind by the name of Bill Wonder (MVP for 3 yrs) who set up SQLH2 in one of our servers. This one would collect traces from all...

If I am not mistaken, you just need to give execute permission for the stored proc. I dont think you need to give Sys previleges.

It all depends on how busy your DB Server is. If it is a high transaction based Server, then I would recommend a transaction log back up with a 10...

Yes, it is a object problem. If I am not mistaken, you created the table with the name "db.document". If this is the case, then you will have issues.

SQL Query...