Yes, it should now go back to a more normal size when that job is complete. Don't be surprised if you see blocking occurring while the job is running. You...

Do you have a job to delete the replicated transactions? There should be a job that runs the distribution cleanup procedure sp_MSdistribution_cleanup. If it is there, make sure it is...

If you are loading all your data into the one table then you will want to update your data first (so you don't update the new records you just inserted...

Rian, Not trying to avoid your question. I don't know the answer to that. I would have to walk through it and work out the kinks. My guess is that...

I guess I wouldn't see replication as a development role. There are far too many things associated with replication, i.e. the jobs, configuring of the agent and the agent profiles,...

Have you tried to find out what that client is that is referenced in the error? Seems like you should be able to get back to the machine that is...

Rian et all - I don't believe anyone is saything that developers can't or shouldn't have permissions in development but that the permissions should be limited to a NEED basis....

Glad to hear. That should work fine and soon you will be looking for a way to weed through all the volumes of information. 🙂

Have a great weekend!

When I click on help for that section in the maint plan wizard I get the following as the start of the help topic;

"Use the Select Report Options page...

At the end of the wizard you should have the option to have the report sent to you as well.

If you already have the plan created you can open...

Inside the Maintenance Plan Design Window there is a button on the toolbar called "Reporting and Logging". You can define your output there.

Quite welcome. I am in a "new" environment as well which is huge and people are always coming up and talking about some table or index like I should know...

I keep seeing posts like this. There is an MS article about this here - http://support.microsoft.com/kb/918483

Unfortunately the only workaround that is given is for Enterprise version of SS2005. I...

Another limitation of having multiple databases is not being able to create an indexed view across databases. Big, ugly hindrance but due to schemabinding I can understand why. Don't like...

If you add a use ? into the one example you will be able to search all db's as well. So, example;

sp_MSForeachdb @command1 = 'use ? select ''?'', name...