That was my thinking as well, but then I thought that the select is waiting on the insert so shouldnt I optimise the insert first.

Pretty sure will find out once...

Thanks Ian, we would have to look at a plan guide as the app is a 3rd party content management system and cannot be changed.

Now this is all new to...

chetanr.jain (4/5/2012)

---

Nope..

It allowes me to user STOP AT command in Full database restore.

However, it allowes me to specify the time between only when full backup started and completed.

THis does not...

yes its a free tool

you could try modifing the scripts it generates for system and item level roles, but these will only be deployed when you deploy the script, its...

take a look for a tool called RSScriptor that will do the job for you

best way is to restore the backup to a new database name and then copy the data from the backup to the live DB, you wont be able to use...

couple of things and sorry if you cant do this either but you only detail no changes to the current databases.

could you not create a secondary version of the DB,...

what happens if you tell it that the remote path is not a variable and then set the expression on the remotepath property of the actual FTP task

Very true, but I wouldnt know what to do with myself for the two days...

yeah, looks right, just make sure you wrap stings with " " then hit evaluate expression to see if it does what you want it to do

"/pub/Cell_Availability/" + (DT_WSTR, 4)...

no it wont work as you are not adding in the "-" inbetween the date parts

the below will only give you /pub/Cell_Availability/20120404

2DayWeekNextWeek 🙂

again please do not cross post

all replies here please

Thanks for the clarification Gail, much appreciated as always

Sorry Gail, maybe my terminology is a bit off.

Please correct me if I'm wrong, but when there is a column which is required in the result set which is not...