What about the Summit recordings that we paid for and were promised access to for a year?  Are they lumped in with "all free access"?

For my part, do not mind...

Hugo - I appreciate your comments, and probably agree with most of them. 🙂

If this generated some thinking, some head scratching, some friendly debate, and even a...

My newsletter has not even rolled in yet, but thought I would say Hi! Glad to see people found it interesting. It just popped into my head while...

Nice use of XML for data manipulation. I have not tried anything like that yet. My next task is to try an XML-type column to hold a variable...

Everything executes correctly at SQL server. But the rows affected message seems to confuse ADO when trying to return a record set. The server-level set nocount switch inhibits...

I discovered that the problem can be solved if I set the global database user options to 512 = set nocount on. Upon furthur research, I discovered that the...

FYI. The problem is that SQL 2005 seems to be sending back the "# of rows affected" message to ADO which then gets confused, SQL 7 did not do...

Further clarification: the command does not return a result set if the Select command is preceeded by any Insert, Update, or Delete command. If preceeded by other T-SQL (DECLARE,...