reboot the workstation?

Does this happen everytime? I might uninstall, reinstall the client tools. And patch tem.

I like Yelena's solution, simple and easy. The adduser/drop user gets complicated, as you'll see in EM if you restore a db. Sometimes things don't synch right.

Phil is right. This is what you get when SQL Server has problems communicating. Hiccups in comm that a file transfer or other type of RPC use tend to blow...

Great questions!!! Awesome!!!!! Very tricky and caused me to run over to my copy of SQL Server 2005 to check it out and build a test package, only to realize...

The code has been announced in numerous newsletters and articles on the site (http://www.sqlservercentral.com/columnists/pressrelease/sscsourcecodeforthepass2005summit.asp, http://www.sqlservercentral.com/columnists/pressrelease/thelastdaytosave.asp, http://www.sqlservercentral.com/newsletter/view_newsletter.asp?dt=5/31/2005, etc). Unless you registered before early June when we started the messaging, there isn't...

If this is to be one call from the client, you'd need to insert into Header, then get the identity value from the row using scope_identity() and use that in...

There's no great "secure" option on the db server. I'd look at a third party product as they have dealt with this before and made lots of mistakes.

Not sure what that would get you, but I think some sort of varbinary or perhaps varchar would store it. You should be able to access it in a session...

Thanks for the update.

I think rating yourself is a fair exercise. I'd rate myself a 9 in some areas of SQL Server, a 4 or 5 in others. Overall, probably an 8 and...

Never been threatened, but I have been argued with more than I'd feel comfortable doing.

I had someone take issue with the "Happy Hour" comment and I can understand that. Not...

Sorry, poor choice of words. I meant that < id> might change to , not that would be changed to .

XLM does typically optmize, removing...

Easy Phil, new server en route

Correct. This was tested on the June CTP (IDW15?) and it removes the line breaks. Perhaps preserving whitespace internally in the tags, but removing them between tags.

It's ALWAYS the users' fault

New server ordered, got ship notice today. Hopefully be up before PASS.