I cannot wait for this!!!!!!!!!!!!!!!!!

SQL Saturday in my own town. It's going to be amazing!

"You can also paypal $30 to sjones@sqlservercentral.com for a ticket as well."

Hahahaha, brilliant!

This has been, by far, the best video from JumpstartTV that I have seen. You packed a good amount of data on a topic in 3 minutes and gave...

You can use a cursor and step through each table searching for the users and store the found information in a temp table.

Make sure to place a GO statement after each SP you are modifying. 

If this isn't the problem, could you post some example code so we can see exactly what...

To suppress the # rows affected message just include this before your query.

SET NOCOUNT ON

This will take care of the trailing message from the query results.

I would agree with George, you should look at DTS first.  If BCP is required, you can use the queryout option with BCP.  It would be a little bit of...

Not to sound like a smart$%% or anything, but did you have a question about this or were you just posting what you did?

Can you post DDL and example data of the tables you are referencing and sample XML that is being used in the query?

SELECT TOP 1 cust_id FROM nums ORDER BY sys_create_dt DESC ?

I would manually determine if that directory is called scripts or scipts.  I have a feeling that this is a type also.

Try running : Xp_cmdshell 'dir E:\Scripts\FULLBACKUP.BAK' and see what...

My first guess would be that the GUI is using the user credentials of the service to perform that backup and your user does not have permissions to restore from...

Wow...beat me to it and beat the #%^% out of my answer.  Nice explanation

I can't wait to get home and install it on my lab at home!

Because I am curious as to why ORDER BY is unacceptable to use in this case.  It is intersting to me.  I am not sure why you would question curiosity.