Thanks Sarus and thanks James... that's exactly why I have this difference in terms of resultsets!!!

Life is good again

The strange thing I notice is that both the script and my stored procedure are run against the same server and they show me different results. I'm using the same...

As usual, great article James, Good Job!

I finished reading it and it let me so intrigued that I decided to give it an additional twist to the code and try to port it...

Great Article Joseph!

This is even more interesting when you consider the new features in the "soon to be revamped" DTS in Yukon. I read that you will be able to...

 Weird behavior...

Good to know it Brian... thanks for the info!

Hi lakusha!

I reproduce your "error" in my onw evironment and I got the same results... the only difference is that ALL Information Schema Views are unavailable through any database that is...

Before you issue a command like

"select * from server.database.information_schema.columns"

Have you configured "server" as a linked server?

To qualify a column in the form of "server.database.table.column" is OK as long as you...

Hi David:

Use SP:Completed Event in the SQL Profiler... this should be enough for you needs.

I'm very pleased to see a book review that doesn't fall into the %100 category of "this is the all in all, greatest, king of books" reviews. I don't know...

Great article Dinesh!

I agree with you that accessing registry keys from SQL Server scripts/stored procedures is not something that you will do often, but is great to know that you...

The problem with some of this weird functions is... you use it so sparingly that when you need it you forget the syntax and their meaning...

I've never developed a...

I want to ask apologize in advance if my eyes are out of focus but as much as I have seen, the listings do not appear (not directly in the...