Thanks strick9. I'll pass the appreciation on to Steve as well. When I said

we did not do a true performance test, Steve made a minor...

If using ADODB to query the stored proc using a ADODB.Command object with the ADODB.Stream object, use the command.properties("xml root") to add the root for the xml. EX:

K, I am going to add this into a article I plan to write, but there is a way to

do what you want to do with XML AUTO. IMHO...

Well, I am not sure it can do wild cards, but given that you know the format of

the extra portions of the file name you could use this function...

Well, I tested a proc out without marking it, and it worked fine, yet in the past I have had to mark them. Weirdness. Does anyone know the answer to...

You create a stored proc in master with sp_ and call it from a different db and it works fine? Really? What version of Sql Server are you using?

Tim C.

//Will...

Also you must use the sp_MS_marksystemobject, else the proc will not run.

Tim C.

//Will write code for food

deselles, hmmmm, I am not running the server on my machine, and I have SP3 on the server as well as my machine, and I can debug. Maybe you changed...

To debug, I do this :

A) Right-click a stored proc in the QA object browser

B) Click "Debug"

C) Fill in the parameters with values and click "Execute"

D) After waiting a second...

Please also note the warning on Microsoft's website regarding this patch. Certain Ntoskrnl.exe versions are not compatible with the patch as it was released on the web. Precautions should...

Thanks Chris, has some good articles there. Just finished going over most of them. I am finding that this is a VERY biased subject, and it makes it hard to...

Wow, light bulb just kicked in after re-reading your post a second time. By

using 's' only I was asking for only statement permissions. And since your DB

does not...

David, Microsoft as a rule uses RAISERROR to ouput progress data, and errors, even where there are no errors. As the sp_helprotect uses this method it will raise an error...

Prat, when you start the debugger it automatically starts the procedure you wish to debug. To step through it , you have to use the F10, F11 keys. Once it...

Why did you change the where clause on the stored proc to use an IF? The OR gave

you the exact same results as the if you changed it to,...