This is probably because you have both the Distributor and Publisher in the same Server. It is fighting for resource since it does not have much and has to share....

One thing you can do is to set up SnapShot Isolation. (Row Level version) This means that the select queries (Stored procs) from your website will be able to read...

If I am not mistaken, you will need to install SSMS Client from your SQL Server 2008 Installtion CD.

Like ClusterJunkie said.. Read jimmy Mays Blog. He is a brilliant guy. You will get quite a bit of Info. Here is one of the blogs he has written about...

I have some experience with HP EVA SAN but not the good kind. Our DB was clustered on a HP EVA SAN. We lost the SAN and the HP people...

Eugoogley (3/1/2010)

---

Thanks Vinay and Roy

This is (one way) transactional replication. We do not know why the subscribers continually get replication errors which can only be solved through reinitialization. We...

USA has a world cup winning team? I did not expect that for the next 5 yrs because they are so new to the world cup.

I will be...

I assume you are talking about Snapshot replication. If that is the case you will need to recreate all indexes. Maybe you can have a batch file that does it...

You were twitting pretty fast the last couple of days... 🙂

Alvin is having Withdrawal symptoms of Winter...

The Thread is very quite today.. Either the Posted questions are getting better or the Answers are getting better. I wonder which...

Hi Igor,

Can you check and confirm if the Database owners User name still exists in the domain. I have seen this error happen when let us say that the UserA...

Actually Table partitioning is available from SQL 2005 onwards. Before SQL 2005, there was Partitioned views. Take a look at this white paper regarding Table Partitioning in SQL 2005.

http://msdn.microsoft.com/en-us/library/ms345146%28SQL.90%29.aspx

If this...

Glad to know that things have been sorted out..

Once you create a new user like Lowell pointed out and change the service account using the SQL Server Configuration manager, it will give the appropriate right to all the...