In a situation like this, I would have a separate copy of the database on the server, if disk space allows, and point your test environment to this for your...

Have you tried setting up the views and SP's as separate publications? Should be able to then control the initialization schedule to ensure the objects get created in the proper...

Hey Scott, you will NOT need two extra nodes to mirror a clustered instance in SQL server. We actually mirror several dbs from separate 3 - 6 node clusters to...

I had a similar issue in the past, and it was caused by my SSMS not being at the same version of the server. I ran the SP2 install on...

I wish you the best David. We had a third- party application that had considerable memory leaks and it took nearly a full year for them to fix the problem....

If it's a 32bit server, you have to use AWE to use anything over 4GB, and to use AWE the lock pages in memory has to be turned on. One...