Pleasure!

I went to respond to your interpretation of the SSMS shorthand and decided that it would look too much like picking on the guy who did it....

Introductory error handling article[/url]. It includes 2000 and 2005/2008 syntax.

Can you post the code you tried that didn't work?

It is possible in a single query.

Guessing:

Please tell me how to see the output of the profiler?

But I could sure be wrong. Whole words make...

jcrawf02 (8/13/2009)

---

No kidding. I've only been plagiarized the once and it probably didn't count since it was really the SQLServerPedia feed that was getting ripped off. I'm feeling decidedly unloved...

What's in your query window? For that matter, what does the procedure look like? Is the tab "Execution Plan" opening when you request the estimated plan? If so, maybe you...

Run a query using the EXISTS keyword. Look it up in the Books Online.

Personally, being a paranoid type, I'd use backup & restore. Why not. It leaves the database in place on the first server in case something goes wrong while getting it...

What's wrong with using a server side trace?

But, you can also query the dynamic management views (dmv), such as sys.dm_exec_requests to see which database is getting a lot of activity....

Look up the command sp_msforeachdb. It's considered to be an undocumented command, but it's been around for a very long time with no signs of going away. You can use...

Personally, I'd recommend both. Put the constraint in the database to prevent accidental violation of the rules, and put code into the front-end that checks on the rules and neatly...

Jack Corbett (8/13/2009)

---

Grant Fritchey (8/13/2009)

---

This is going to become a new badge of honor for people going for jobs or qualifying for MVP:

"And this article I wrote was plagiarized five...

This is going to become a new badge of honor for people going for jobs or qualifying for MVP:

"And this article I wrote was plagiarized five times in the last...

Do you mean hints?