irena.bulatovic (10/28/2009)

---

Animal Magic (10/28/2009)

---

irena.bulatovic (10/28/2009)

---

when you copy file you are accessing remote location with credentials you are logged in with and when you use cmdshell you are accessing remote location...

what do you mean it doesnt work??

i assume you replaced the MyTable with your tablename?

irena.bulatovic (10/28/2009)

---

when you copy file you are accessing remote location with credentials you are logged in with and when you use cmdshell you are accessing remote location with account that...

umm thats fairly generic...

create procedure USP_DeleteMyData

@date datetime

as

Delete from MyTable where MyDate = @date

go

access is denied to cmdshell or the drive location? are you still using the mapped drive or the UNC path?

ps, note that xp_cmdshell will run under the sql server...

Nero-1119276 (10/28/2009)

---

declare @logid as int

declare @backup_file as varchar(200)

declare @neerav as varchar(200)

--Select media_set_id of last backup

set @logid=(select max(media_set_id) from

msdb..backupmediafamily

where physical_device_name like

'D:\Testdatabase%')

--Select exact backup device name if you create...

try using the proper UNC path and not a mapped drive

ok, its not permissions then.

paste your copy syntax here that your using

as mentioned earlier it will either be permissions or your UNC path is wrong. try typing your path into a start - run command and see if the...

David Benoit (10/27/2009)

---

GilaMonster (10/27/2009)

---

<shrug> Two points

SQL is designed to drive the disk queue up. It's not...

im just up to the point in the audio which talks about the average queue legnth 🙂

whats your disk layout? The disk queue legnth may/may not be an issue depending on how many disks you have

you can, however

a) its a security risk and most systems have it disabled

b)...

is there any code that sets identity_insert on and then specifies a key value?

Do you have any replication running on the table?

When you say you...