The best way to do it is run a manual trace. Create a Profiler session with the Login as a filter. Then script out the trace and set it up...

Ditto to what DNA said. Here's the ReadMe file for SP2.

http://download.microsoft.com/download/2/b/5/2b5e5d37-9b17-423d-bc8f-b11ecd4195b4/ReadmeSQL2005SP2.htm

Hope this helps.

NP. Glad we could help.

Sounds like you had a cache problem. Happens sometimes.

No worries. Glad we could try to help, anyway. @=)

Wait, nevermind.

Tools-> Options works for all.

Then go to Help -> Online.

At the top is the various types (online first or local first). On the left, underneath that, are check boxes....

Ken,

How are you accessing BOL? Via the program files menu or via SSMS?

You're absolutely right, JacekO. There's nothing left to be said on the subject except, from what I read, you are the only person you proved your point to. I didn't...

Lee,

You can also nest IF...ELSE statements and CASE statements. It could be...

JacekO (3/19/2009)

---

The SQL Server transactions can be called nested transactions but they are not. Plain and simple. If they were nested they should work the way I described. There might...

Lee,

Before I go any further, Label 1 confuses me.

label1:

-- 1st check - do we have a customer record in CP

IF EXISTS (Select * From DATABASE.OWNER.TABLE 6 WHERE cust_id = @memvar...

JacekO (3/19/2009)

---

From my point of view they are not nested but maybe I could call them chained. To explain how I understand the term nested I provided an example...

Ah. I forgot local help could be disabled.

But shouldn't he still be getting something from the online stuff, assuming he has a network connection?

Wow. That's a new one.

You say it was working before?

Has anything changed since then? Any programs removed from your box? Anything added (service packs,etc.)?

Check Windows Explorer and see if you...

Nesting is a broad term. You can nest triggers, stored procedures, transactions, IF..Else statements and loops.

Basically, a "nest" is when you embed one thing inside of another and the internal...

I should also clarify that I don't advocate nested stored procedures (which is different from nested transactions).

I've never had any reason to use them, though, and I know of at...