If I understand the question, you can simply use the Database Diagrams to see all the tables and their relationships. Assuming those relationships in your database are all through primary...

D'oh!

Did Steve see?

And following up on what Matt says, you want to know that too. Except for extreme circumstances (you're about to lose the house, the family is hungry, etc.) lying your...

Bad news. I just ran this little in 2008:

goto MyLabel

exec sp_who

Mylabel:

It's STILL there. I'm planning on being in Seattle in November for PASS... I'll brink an Ozark Tire Thumper and...

I agree. We work with XML a lot out in the applications, but the database mostly just returns regular old result sets.

However, if you really had to, in addition to...

You can run DBCC OPENTRAN('dbname') to verify that there are no open transactions. Run the Activity Monitor will also let you know if a transaction is still open in the...

Tell them the truth. Anything else will get you into trouble.

"I've been working for these insane college kids at this dot com and I can't stand it any more."

I used...

Oh man, don't they have to kick you off the boards for 8 months like Don Imus if you use language like that?

I still don't understand the problem fully, so I'm not sure I can help.

The second line is just a short cheat that's available with the "go" statement that makes it...

The way I did it early in my career was answer as many questions for my peers as possible. Then I'd take the question & answer to the guys I...

Books Online

Hey Sandy,

Can you simply use a WHILE loop?

WHILE [SomeCondition = TRUE]

BEGIN

EXEC sp_proc

[Change Condition]

END

Or do you need something more like:

exec sp_who

go 5

Putting the number next to the GO statement will make...

Hey Sandy,

Sorry I'm late to the game, but everything Jeff said goes double for me. 😀

The two things I saw that stood out was that there was a join without a predicate. That's usually not a good thing. Joins, for the most part, should have...

Looks good. Thanks.