I have not seen any performance impact on having one publication for multiple articles. The only thing you try to do is make it manageable and not have way too...

Hey Lynn, Good news regarding your daughter. You should brag about this... 🙂

Steve, Good luck...

And Jack, what...

My advise would be to run the profiler on the DB and find out which Query is taking that much time and then do a performance tuning on the query....

The Dixie Flatline (7/27/2010)

---

Don't get me wrong, Roy. There was an abundance of stunts, fights, explosions, high-speed chases, and automatic weapons fire. But that...

A-Team and Cute? Those two should not go together.... 😉

Did you run the select statement on the same query window or on a different SID?

Is this user a member of a group that has permission for a certain role?

Now I can tell everyone, "Hey..I know a real Spy" 😉

You have a trigger that is not allowing you to do any modification. That trigger is TRG_LOGINCHANGELOG. Maybe you should take at the trigger and see what is the rule...

UDP port 1434 is needed if you want to use SSMS to connect to the remote DB.

CTE is common Table expression. It works like a temptable

http://msdn.microsoft.com/en-us/library/ms190766.aspx

A 711 MB database hanging? That is just strange. Did you see any error in the SQL Server Error logs? There is one thing you can try. Try to set...

I am not sure about this but I read somewhere that the distributopr should be the highest or the same version of your publisher and subscriber.

You are using a 2008 distributor?