Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
Author |
Topic |
PatDeV
Posting Yak Master
197 Posts |
Posted - 2006-02-07 : 17:45:22
|
declare @sCmd varchar(500)set @sCmd ='copy /Y \\testserver\Karen C\testmodel.mdb \\testserver\Karen C\test.mdb'exec master..xp_cmdshell @sCmdwhere is am doing wrong |
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2006-02-07 : 17:55:43
|
Is Karen C the share name? Are you receiving an error?Tara Kizeraka tduggan |
|
|
PatDeV
Posting Yak Master
197 Posts |
Posted - 2006-02-07 : 17:58:09
|
yes! |
|
|
PatDeV
Posting Yak Master
197 Posts |
Posted - 2006-02-07 : 17:58:41
|
it says The syntax of the command is incorrect.On QA!! |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2006-02-07 : 18:03:22
|
Change the share name so that there isn't a space in it. Otherwise, you'll have to refer to it via its MS-DOS 8.3 name (or whatever it's called).Tara Kizeraka tduggan |
|
|
X002548
Not Just a Number
15586 Posts |
Posted - 2006-02-07 : 21:02:24
|
quote: Originally posted by tkizer Change the share name so that there isn't a space in it. Otherwise, you'll have to refer to it via its MS-DOS 8.3 name (or whatever it's called).Tara Kizeraka tduggan
Nahset @sCmd ='copy /Y "\\testserver\Karen C\testmodel.mdb \\testserver\Karen C\test.mdb"'Should do itBrett8-)Hint: Want your questions answered fast? Follow the direction in this linkhttp://weblogs.sqlteam.com/brettk/archive/2005/05/25/5276.aspxAdd yourself!http://www.frappr.com/sqlteam |
|
|
|
|
|