I would have a look at using robocopy utility

This should work: select

DB_NAME(DB_ID())

The recovery model of master is simple, you will not be able to backup the trans logs.

I would insist that you are given the right to make these decisions as as a prerequisite of accepting the position. When I started at a new company, two of...

has ssis been installed, without it on the box where you are creating the plans it will fail to save the plan. The wizard will get to the last step...

Stumped me, tried to see definition of xp_fileexist to see what the code was doing security wise, but the sp calls a a dll xpstar90.dll so no go.

it is in the sys schema, the call would be master.sys.xp_fileexist. It still has permissions for the public rol to execute.

Choose the from device option EM in the backup dialogue, navigate to where the latest backup is and you should be fine.

you could use ssis (dts) it has a task to do this.

select distinct will give you this

Presumably if the data is not changing much then the auto update statiistics will not be invoked much. I know the algorithym ms uses cannot be predicted easily but it...

I belive you could use scptxfr.exe to script out the procs to a folder and then use dir via xp_cmdshell to insert details into table.

Thanks for the reply, I can find nothing better to give me a boost in my day than have someone flame me when I offer asistance that is both free and...

thats stuff the function

look up stuff in bol