Just a question, why would you run multiple snapshots when you are running transactional replication? A single snapshot should be all that you need (unless you get some major problem).

Are you running any perf counters that are showing disk queuing or cpu spikes?

You could run a select against the sysprocesses table to find out all connections to your server and then check for those that are active and how long they have...

Is there any way that you can increase the amount of memory allocated to the new instance? You could be coming up against a bottleneck there.

In order to move the Model database you need to enable Trace Flag 3608 on SQL startup. Full details on moving the system databases can be found at http://support.microsoft.com/default.aspx?scid=kb;EN-US;224071

Try changing ROLLBACK WORK and COMMIT WORK to ROLLBACK TRANSACTION and COMMIT TRANSACTION

Just guessing here, but is it the image that says that SQL Server 2000 is not supported below Service Pack 3? If so, don't worry, just click the button to...

Again, interestingly, in a few short minutes you've answered something SQLBill that I could not get figured out in weeks. That's exactly what was going on with the proc that...

Try opening the Service Manager and manually typing the server and instance name that you want to connect to.

You could use...

INSERT INTO TableX

SELECT Col1, Col2

FROM TableY

WHERE Col1+Col2 NOT IN (SELECT Col1+Col2 FROM TableX)

Interestingly I used to get that with a procedure that called child procs and was executed through a job. Although the job never failed I could never find out the...

The other option that you have is to use a computed column and place an index on it.

Say for example you have the desire to create an index on the...

They are the same. The maintenance plan just provides the interface for ease of use.

It's a trade off between ease of use and advanced functionality.

Nice one

Never thought of that

If you are attempting to insert data into a table with a clustered index you have to bear in mind that the data has to be moved about a lot...