Did you check the error log to see what is the error message?

Merge or transactional, both will have issues if your latency is high. There is not much performance impact by having any kind of replication if you have the distributor on...

The users you created, what rights have you given? Give the User just Public right to the DB. Create a DB Role. Give rights for Select to just the views...

I have seen this issue before. Have you ever renamed the SA account? The Upgrade looks for SA account. If it cant find it, it will throw the error.

So when is Steve's Interview? And if it has already happened, where can we read about it? 😀

Steve, Wish you the best with the Interview. I do not think you need it. I am sure you will do good.

Lynn, Wish you the very best at your new...

When this Stored proc is run, it might be doing a count by checking on the sys.sysindexes. This sys.sysindexes does not update the count immediately as soon as the rows...

This OP wonders why he has performance issue when inserting data.

Steve Jones - Editor (8/3/2010)

---

Alvin Ramard (8/3/2010)

---

Roy Ernest (8/3/2010)

---

You should see the looks I get from the Security at all airport when I am flying... 🙂 They take my passport,...

You should see the looks I get from the Security at all airport when I am flying... 🙂 They take my passport, and come back after 15 minutes saying, "Yep,...

There are quite a bit of DMVs that you can use to monitor and trouble shoot the TempDB growth.

Usually tempDB is used when you have Row Level version set...

There is setting that can be done using sp_reconfigure to mitigate this issue.

USE master

EXEC sp_configure 'show advanced options', 1

GO

RECONFIGURE WITH OVERRIDE

GO

EXEC sp_configure 'locks', '0'

GO

RECONFIGURE WITH OVERRIDE

GO

Check this out and let...

Five heads are better than two... Or so they think.. 🙂 That is why they prefer to take 5 not so good personnel (that comes cheap) over two competitive personnel...

The @profile_id is the ID of the profile from the msagent_profiles table in MSDB.

The @profile_id specifies if it is a SnapShot Agent (1), Log Reader Agent (2), Distribution Agent (3),...

Yes, You are right..... But if I had given the answer that "It Depends", I do not think it would have been that helpful.. 🙂 Thus I gave the long...