Just specify the named instance when installing your databases and they will be on the 2005 instance. Now if you have an application that does not support named instances, that...

If the copy of the database is not going to have any of its own original data, then you have a couple of options.

- You could copy over a backup...

What do the windows logs say? Are there any logs around the times before the server shuts down that can shed any light as to why the server could be...

Error 2812 refers to the subscriber not being able to find and run a particular stored procedure. This error could occur for a few reasons. Security, not referring to the...

The best way to do it is to have your AD administrators have an AD site created (if there is not one already) for the IP range your server is...

If it was authenticating against the domain that the server was a member of, then there is a preferred dc key that you can set in the registry I believe....

As Lowell stated, service packs are cumulative. Question though, why not upgrade to service pack 3? It is the current service pack for 2005?

I would try and verify if it is a problem with your server or the smtp server that you are trying to send mail through. Can other servers send mail...

Is the server listening on TCP/IP for the 2005 instance?

Are you letting it grow by itself with autogrow? If it is causing performance issues you are probably better off growing the database yourself during authorized down-time when there is...

Are you letting it grow by itself with autogrow? If it is causing performance issues you are probably better off growing the database yourself during authorized down-time when there is...

You could create something like a database with a table for tracking the information and put a DML trigger against the syslogins table in master that inserts a record into...

Well, you can spread out your backup schedule so it is not running during the normal duty hours and won't be a factor. Also, when it happens again, try turning...

You should be able to look at the history of the merge agent job and see why the merge agent failed. You can also look at the status of the...

Okay, a couple of things:

First, the line using -match is incorrect. You are evaluating the elements in the array, but you are not comparing them to a value, so the...