If you script your jobs out, and script your DTS packages as Structured Storage files, then there might not be any reason to restore the msdb. Your DTS packages will...

Its too late the event has passed. You could add an alert to tell you of a deadlock, which you possibly should anyway, this will allow you to get the...

Its a bit late in the day after this was posted, but I had the same problem and found this post. I subsequently ound the solution which is to clear the...

In place of using the date range if you had an identity key on the table that was indexed as the clustered index you could use getdate()-7 to find the...

It will depend on size of database, size, capacity and power of server, number of reads v number of writes, there is no hard and fast rule.

I would add to...

Looks like SQL Server can't see the disks, if you try to create a new database can you see the F Drive?

I've had a db show as suspect because it...

You could trigger locally to a table with a schema the same as the table that you want to publish to, then replicate from that table. A bit convoluted but...

I've had similar problems in the past, I like to use either a Pipe as a seperator or if I am likely to have a file with lots of horrible text...

I don't think reposting will help as I can see the image in my browser, I have scripted below. Report Problem is a job I have set up that fires...

This can depend somewhat on your application, for example if you have a poor application with loads of deadlocks, you might what an alert on these. If you are worried...

Andreas has just given you a method for that just script it all out and use the script to create a new database.

Regards

Carolyn

Personally I would create an interim table, on your subscriber server, identical to the source table, you can replicate the source data into this new table, you can then use...

Try sp_removedbreplication [ @dbname = ] 'dbname'

You need to give each table a way to be linked to the other table, use a new field called say ContactRef, then you can create a view based on...

When the jobs were created they would have been given the same owner as the user that registered the server in Enterprise Manager, check that the owner of the jobs...