Thanks for the replies, I've scripted out all the seperate parts before and just really wondered if there was a better way of doing it without restoring msdb or if...

Unfortunately it's all onto one instance hence my dilema.

Is there a way of either scripting out the SSIS packages or backing up just the SSIS packages?

Thanks

Have you set up an operator to use that email address?

The email addresses you select in the drop down from the job alerts are only a list of operators.

You have...

I totally understand what you mean, sometimes it's best not to say anything.

It's always a problem when you think your manager isn't up to scratch, what are you supposed to...

Maybe I should make a list like Earl 😀

My problem is sometimes I'm too nice to people or too trusting, the job I had that I was made redundant from...

After only changing jobs 8 months ago I'm about to change again, the current employer turned out not to be what they said they were from a benefits point of...

LOL, even at the time the bands I was into were not mainstream (Although Sonic Youth are still going and are sort of famous now), most people I come accross...

I was in a band first for five years tyring to be a musician, it didn't work out but everyone in the band bar one now work in IT and...

It's just a straight SP2 with no hotfixes, I'll run the checkdb today and post it later, it takes a while as the DB is 80Gb.

Thanks

How did you solve this issue?

Chandrachurh Ghosh (4/30/2008)

---

First of all did you use sp_dropserver to remove the server and then add the new server?

Secondly, if you are trying the operation for the local server, there...

I can't locate systasks in msdb, is it in 2005?

No, it's been restarted, all users can connect except for these two databases where they can connect but only via sysadmin.

The main problem is that if I run a trace...

Yes, when you rename you drop the server which removes the entry from sys.servers and then add the server as 'local' which puts it back in sys.databases as the local...

If anyone has any ideas or knows where I could look any help would be very welcome, I need to sort this out soon.

Thanks

Buxton69