Not without dynamic sql which you dont want to do for several reasons.

It seemed MS were going to make the pivot function inherently dynamic for 2005 which shouldn’t have...

--Note your initial post is unclear my solution assumes that you always want the last day of each month to appear in the row even if that day does not...

------------------------------------------------------------------------

---CREATE TEST DATA-----------------------------------------------------

------------------------------------------------------------------------

IF OBJECT_ID('employeeTEST') IS NOT NULL

DROP TABLE employeeTEST

CREATE TABLE employeeTEST

(

...

Nope changed that. I need to register the dll corresponding to the custom task on the new server. ANy ideas how i do this.

thanks,

Jules

for custom dts tasks were is the custom dll put and what is it likely to be called?

Thanks,

Jules

there is no table called syspackages there is one called sysdtspackages but that doesn't contain a server column?

Thanks for your help.

Any ideas?

try the script i provided above. Should demonstrate what i mean.

Doesnt use temp table just demonstrates two jobs running at same time using the same spid.

Obviously the ...

no one has any ideas about this then? Must be a common problem with a stored proc that use temp tables called at the same time from two different jobs...

yes it errors after the backup are successfully taken. Without the option to delete old backups selected it completes successfully.

where is that set? Think thats whats happening but cant find the place to toggle that on and off.

I want a separate file for each backup.

Cheers,

its a complete backup and the db recovery mode is simple. there isnt must activity in the db either so the log files are small.

It was set to remove...

full

also when i backup the dn manually rather then with the maint plan the db size is normal?? Only the maint plan causes it to be massive

why do you think i shouldnt put the tran log on c? is raid 1 very slow?

d is currently made up of 3 disks  i can order more...

what shoud i...

so i should order more disks smaller physical disks rather than 1 extra large one? to put in the raid 5. we currently have 3.

will it use the extra disks/spindles to search...

Thanks, the collation and tempdb is certainly an issue.

regarding the other points you makes do you have any actual example where having multiple instances would lead to less down...