To be fair, SQLTeam is also an interesting site. A comparison between the method suggested by Scott and another one can be found here on the blog of SQL Server...

No, actually that's my elder brother. He's got the brain, I got the good looking.

Someone once wrote that the upper classes make illegal those pleasures of the lower classes of which they disapprove.

Oh, man, this must be the very reason for TV soaps,...

Germans have been voted the most desirable tourists in Europe and British the least!

Who did this vote? While it might be true that Germans spent more on their holidays, look...

1. No, not really. master..sysdatabases can be read by anyone who connects, AFAIK. The regulating factor however is the access to those dbs.

2. I guess there are quite a few...

mumble, mumble, forgot the CENTRAL, of course...

...and there we go. Will add a better one when I find some.

NOCHECK is not the same as DROP.

create table t

(

 c1 int primary key

)

create table t1

(

 c2 int constraint fk_me foreign key references t(c1)

)

drop table t

Server: Nachr.-Nr. 3726, Schweregrad 16, Status 1, Zeile...

Well, the error message is pretty much self-describing. There you have another table referencing it. You need to drop that foreign constraint first in order to drop thast table.

Okay, I might have had a glas of Californian Zinfandel too much right now, but I'll try. Therefore, let's make it easy and assume we have a table with only...

Do a search in the script section here. I'm pretty sure you'll find something useful there.

What is the easiest way to monitor the successful/unsuccessful completion of triggers? Is there an easy way to fire off alerts when a trigger fails?

If you are sure that the...

Well, not much, but I would first have a look at the Outlook object model. This will lead you to those subtypes like mail, contact, appointment and so on... The...

IMHO, Yoda already gave the solution to your problem. Why make things harder and more difficult than they need to be? I think you should follow the way of the...

Hey, then perhaps you should do what Joe does in that case. Write a book and post to online communities. And then suggest people to buy this book in order...

In 1977, at 18 years old, I was tearing up the streets in my hopped up VW, chasing wine (well, beer), women, and song! 

Hm, did the same thing 9 years...