Couldn't agree more with Andy's post.

Anyway one should plan and take the time to organize himself. It's part of professional behavior.

Update tasklist and review the priorities, plan the...

Setting the autogrowth to % can have a severe impact on your log file size. Imagine the following scenario: Your database is in full recovery mode and is heavely used....

I like the article as I'm always want to learn something new! But I cannot say that I have understood everything and I certainly need to print this out...

Thanks to you for sharing this script! 😀

Great script but gives me an error.

Msg 102, Level 15, State 1, Line 12

Incorrect syntax near '?'.

I pasted the whole query into my Notepad++ and there I could see what...

To my knowledge this isn't possible anymore. You have to check each individual publication if you are interested in the details or you have to create a report or a...

I can only confirm what all others have said already. I had a similar situation where the relations between the tables not even could be guessed by the field names....

I don't get it! Talking about relational models, where data is supposed to be denormalized, and not defining a primary key on a table? Of course on paper you don't...

Thanks for this contribution. Space on servers is something I try to manage pro actively and I definitely will try out your script.

Cheers

I believe that you can ask the things on that wish list and you might get some of them if your future employer is desperate enough and cannot find anybody...

Fully agree with the post and recommendation from Gail.

A general comment to posts where somebody is asking for help: It would also be nice if the solution to the...

My favorite is sqlservercentral.com or the SQL Server site of Microsoft / MSDN

Keep up the good work 🙂

You can run everything on the 2K0 server and 2K5 is just a subscriber. This is...

Is there any error message you can post? Can you see any message on the remote server? Check the event log. Is the distribution agent allowed to access the 2K5...

Read this article about "Using Multiple Versions of SQL Server in a Replication Topology":

http://msdn.microsoft.com/en-us/library/ms143241(SQL.90).aspx

There are scenarios where it works but it will not work for merge replication.

I made this experience...