spdhiva, you need visual basic, or another compiler to compile that code into a dll, if you want I can comile that code into a dll for you and email...

Let me know what you find out Antares, this is a sticky point for me as well as my friend. We do NOT like to do upgrades. IMHO that would...

LMAO, that kinda stinks when you just want to install 2K3 base without upgrading. Usually given a choice - base or upgrade, I always opt for the base install. Thanks...

Why are you running it as a user? MAIL, or access to the network? If running as

a normal service it would have god rights on the local machine. Last...

Then you could still use dj_meier's suggestion. Try this :

EXEC sp_MSForEachDB "IF EXISTS(SELECT * FROM MYDB..MYDBTABLE WHERE dbname = '?') BEGIN exec myProc '?' END"

But...

1) Are you looking to grant them "sa" privileges?

A) Assign the login the "System Administrators" server role. They now have "sa" rights.

2) Just give them db_owner rights to just those...

Nice test Antares, was very interesting to see that the results come back as one would expect on SQL7.

Tim C //Will code for food

I have never used SNMP to monitor SQL Server in the past, but I have used Whats Up. IMHO, it as awesome product, and if configured right you won't need...

I am unsure of the ColdFusion analogy, but in ADO with COM you would use the ADO.Stream to stream the xml into a complete stream. That sounds like what you...

Ian, thanks for explaining to me what I have already pointed out. My wife

typically does this to me, but it is refreshing to have it done in a forum...

Ian, I understand what is going on, what I am questioning is WHY? I can find no

documentation that states that TOP will perform a sort, yet it clearly does,...

You are not missing anything Ian. The column may or may not have sort

able data, it is basically a user-definable sort, and without them defining the

values the sorted...

I did provide an ORDER BY Andy. The only thing I changed was I added a TOP

clause to the second query. If you run the queries I posted below...

WOW, why would you even do such a thing on a server? They are both highly resource intensive, processor, memory, NIC, etc.. They would always be in contention. I know...

Crispin, have you looked into the WinHTTP object? I used to use the ServerXMLHTTP like you show, but have since started to look at using WinHttp.

http://msdn.microsoft.com/library/en-us/winhttp/http/capturing_data_vb.asp

Tim C //Will code for...