Yes Steve, my most sincere congratulations for the Mark!

Dynamic query construction should be left to the Client Side. As long as you do that you won't loose flexibility and with the use os sp_execusql some of those could...

I believe in my case it is an SQL Server Bug because it never happens unless there is a big tracsaction coliding with index manipulations.

you must ensure that the Subscriber SQL Agent Account has the necessary permissions on the Yoda Shared drive.

Reinitizialization happens when there is something forcing the snapshot to happen or when the delivery of it Fails! You will have to look at the agent history for Errors to...

This ssssssooooooooo dangerous that "Bankers Rounding" could be in threatened. Apparently we are all in the same boat this time :D:D:D:

Happy to Help 😀

restore database can use a DIFFERENT target database name. Just make sure you also change the physical filenames using the "move" option.

Cheers,

that's text mode 😉

SQL Server Handles each QUERY by default as a SINGLE transaction. INSERT...SELECT is a SINGLE unit of work so either all commit or all rollback. That is because of the...

The problem with these kind of scripts is that a little mistake is paid hard BIG time. So I just wanted to warn the poster 😉

sql trace does not add too much overhead .... depending on what are you catching and what are you filtering. My Servers get sometimes over 5000 batch/sec rates and if...

Make sure that the CHECK CONSTRAINTS are replicated too.

http://blogs.digineer.com/blogs/larar/archive/2006/08/16/smart-index-defrag-reindex-for-a-consolidated-sql-server-2005-environment.aspx

Rich (9/27/2007)

---

Okay, here's the deal ....

C2 auditing produces reams of unnecessary info. Flip side is there isn't a SELECT trigger on a table. Does anybody out there know of a...