What Andras says is spot on. To simplify a little - if you are already backing up the database, and don't know or care about the logs, change the Recovery...

Completely agree, manually changing the credentials a Job runs under is almost always necessary. And a standard gotcha.

With regards the Owner/Creator of a Maintenance Plan - if the existing name...

I think the cleanup is working as planned. Whether you (we) agree with the design is another matter! Having tripped over this before, I now think of the cleanup task...

If the owner is in reality the creator, then no, I do not need to change it. And I could understand why it cannot be changed.

Are there any implications? For...

Thanks for the response. I can successfully add the Maintenance Plan to an existing Visual Studio project, just as you described.

Sorry to quiz you further, but if the (production) server...

I think everyone who follows the Microsoft product cycles knows how useless Microsoft's own dates are. The fact that the Marketing Dept is not aware of what the Developers are...

Tricky balance between a nice perk and a perk which just forces you to work more. Good, fresh, espresso coffee counts as a great perk, even better when served by...

Just wanted to add my thanks - we had two MSSQL 2000 servers, and on trying to set up a new replication, I got the same error message. Existing replications...

Land use is, in itself, a massive problem. Huge tracts of pristine forest are still being cut down every year - and not necessarily for the trees. The main driving...

It would have been fairer, and made more sense, if the question used consistent terminology. A "root node" is also known as a "root element" (in my book, much more...

Check that the Subscriber can connect to the Distributor (eg. open Ent.Man on the subscriber and try to open a connection to the distributor). Check that your security is set...

Have a look at the conflict tables, they might give you a clue. The tables are normally called:

conflict_(database-name)_(table-name)

ah, got it now. Slowly getting my mind into gear for the new year. Strangely, I've never noticed that the default Collation of Latin1_General_CI_AS is case insensitive when using LIKE...

Fortunately I didn't have to think about this on Christmas Day!

From this example, it seems that [^a] is case-insensitive, as it matches both Apple and ant. Why is this, and...

I know this thread is quite old, but I had the same problem today, and after some head scratching, and Google searching, came up with a better solution and the...