What version of SQL do you have on your home PC? (run SELECT @@version)

ushasheokand (2/23/2009)

---

Tracing is really not adaptable in my case because the application is live and turning on the tracing might slow down the application. The production people will not allow...

Job postings belong in the jobs forum please, not repeatedly posted all over the site.

Switch traceflag 1222 on. That will result in a deadlock graph been written to the error log every time a deadlock occurs. Post the result of that graph here.

DBCC TRACEON(1222,-1)

The syntax is correct. Is that all that was in the query window?

Enable traceflag 1222. It causes the deadlock monitor to write a deadlock graph into the error log whenever a deadlock occurs. The graph will show both processes involved in the...

Duplicate post. No replies to this thread please. Direct replies to:http://www.sqlservercentral.com/Forums/Topic662376-148-1.aspx

Are you trying to add the 1 - 12 columns for each row, or are you trying to aggregate multiple rows together?

The latter is what SUM is for. If...

?????

David.Poole (2/22/2009)

---

To be honest I am shocked to hear that people don't verify their backups.

I'm also surprised that it isn't the default action for a backup and requires a DBA...

What backups?

Please post new questions in a new thread.

Thanks.

Yup, that should work.

Just one thing. What happens if the parameter is not string, into or decimal? May I suggest you make that a switch statement that covers all the...

The MCDBA is an older cert. It was for SQL 2000 and...

Use a server-side trace. Much lighter weight than profiler

so I've queried DMVs a few...