I agree with Jeff, scoping is an issue, but also, why the temporary table?

It's not clear how you are using service broker here. If you have an insert in db X on Server A, does this insert (direct or through trigger) put a...

Where are you unsubscribing? If you click the "Control Panel" link above, just below your account name, it should take you to a forum menu. Then scroll down and you...

If we get a code for 2011, it won't take effect until the early bird rates expire. Likely in Feb time frame.

Not sure what we'll do for a party next...

It would be good to have an SSIS and non/SSIS version

BTW, no idea what's happening in this thread, and not about to go through a few hundred posts over the last week. If there's something I should know, let me...

Celko is Celko. He has written a lot, and very well, on SQL and standards. However he's an anachronism, a throwback to the past when there were few online resources,...

Interesting thoughts, and thanks for the comments. I still think it's important to get an idea of range early on. Then you can factor that in to deciding how far...

As far as making me more productive, accessing and working with email, checking things on the web, getting pictures and notes done when I'm not at my desk are all...

I didn't look at Blackberry, though I should have. I think BB is on the way down, but I could be wrong. The big thing keeping RIM going is the...

Tobar (11/19/2010)

---

I agree that the phones can make you more efficient. My question is do they need to? If you are more efficient does that mean you will go home...

SSMS uses a couple logins. Likely either your query windows or object explorer took the connection. Use SQLCMD to get the only connection and run queries.

Jack Corbett (11/18/2010)

---

1. PASS already holds and disperses funds for SQLSaturday's, if the local event chooses to do that. PASS did hold some funds for Orlando this year,...

few ideas here: http://social.msdn.microsoft.com/forums/en-US/sqlgetstarted/thread/812b8eec-5b77-42a2-bd23-965558ece5b9/

Note that if you moved and mdf/ldf files, you'll get errors when you restore master.

How to restore the master: http://msdn.microsoft.com/en-us/library/ms190679%28v=SQL.90%29.aspx