I found the easiest solution was to just (1.) run the sql to detach via .Net (I was executing this via an intranet admin web page) and then (2.) use...

Yeah - I definitely over-complicated it.  After thinking more, the query is just "where combination scenario 1 is never true plus where either scenario 2 or scenario 3 are true" so...

Thanks everyone for the quick reply.  Phil, your method will likely work, but I have a question for you still...  I currently have the SQL below:

<code>

SELECT ... , 

   'DNPISIMPORT' =

    CASE

     WHEN...

Antares686,

Thanks - that works great!  Where can I find more information about these Case statements?  I need to beef up on my...

bbychkov,

The information I get is in the 'output' column / field, and contains 3 rows for each xp_cmdshell command.  They are the...

bbychkov, 

I am using the sa user to connect to QA.  When I run

EXEC master.dbo.xp_sqlagent_proxy_account N'GET'

(from BOL) I get no rows returned. ...

I see that the account running SQL Server Agent (<myDomain>\ClusterAccount) has full control on the folder I wish to copy from, and the Everyone group has full control on the folder...

That doesn't seem to be working for me either - I know I could just use c# and move the files that way, but I'd rather have this wrapped up...

Thanks for your help already guys - this really helps!  Here is my updated script:

USE master EXEC xp_cmdshell 'xcopy "\\server1\....\ASPState.mdf" "\\server2...\MSSQL\data2" /y'

I decided to only use the y switch because...

I am attempting to create a script to move db's from one server to another.  I have run into this problem as well. 

Steve,

Thank you for replying.  I added my login to the sysadmin list and this still didn't solve the problem.  I also added that login dbowner permissions on the master db...

Thanks guys, this will certainly help me! 

I think I agree with Frank on the numeric PK performance enhancements.  I think it just seems most obvious to visualize the rows...

ok, so a Primary Key could be something like 'bmw' or 'ford' in a 'mfr_name' column in a table called 'vehicle_mfr' as long as the manufacturer was only in the...

noeld,

thanks!  I'll take a look at this and see if I can use it.

Brett

Here's some more information, if this helps:  I am searching for questions related to the current glossary term, for a registered student.  The glossary terms are referenced via a foreign...