I would push a bit harder with the vendor. Theoretically (I would not do this) you can run the OS on SAN storage so, if they are accepting this as...

Have you disabled that server from being a distributor yet? Right click on replication folder, "Disable Publishing and Distribution"

You should start looking at the execution plans (from SSMS Query>Display Estimated Execution Plan - or - CONTROL L) and the DISK IO (SET STATISTICS IO ON / OFF). Additionally,...

There are many questions to be answer prior to coming up with a solution so, any input you can provide to the following will greatly aid those in providing recommendations....

sultankahut (7/15/2008)

---

The sql server I am working with stops every night since last Friday. Whenever I try to connect it in the morning it gives me following error:

Cannot connect to...

Just to make sure the horse is dead...

You should also be able to see the trace start / stop in the SQL Server Log.

Sounds like your SQL Server instance is part of a cluster and the service broker service is one of the clustered resources. If so, then that would be pretty standard...

As with anything related to business, it has to be about the bettering the company. I don't say that with any malice, that is just economics. No business is in...

You really shouldn't have any issues changing the model. I haven't had to go from 65 to 80 but I have gone from 70 and have had no issues.

It...

Agree Jeff. That would definitely keep me sharp... Just might have to try that soon. :w00t:

Well, testing revealed that you can't do this. I was unable to add columns to the subscriber table. Sorry, new to merge replication.... : )

I guess it is a...

If you can post the code that would help a lot in providing an answer. Thanks in advance.

Yes, you will have to walk through the Windows feature install to get IIS installed but then you should be all set. When you go through the reporting services install...

There are a few things unclear from your post so, a few questions along with a few inputs;

It appears that you are able to present storage from your new...

You can use sp_who2 to get all processes and any that are blocking will be in there. There are several variations of how to handle that output to get the...