Viewing 6 posts - 1 through 6 (of 6 total)
you shouldn't shrink Production server just to get data to test server. Do you need everything from Prod server to be in Test server?
September 5, 2008 at 11:03 am
You can run sp_who2 active .
September 5, 2008 at 10:58 am
Looks like memory issues. Which edition and SP level is it? What else do you see in app log?
May 15, 2008 at 11:34 am
Try setting up security with sql login on both server.
May 13, 2008 at 11:10 am
You have to restart service to take effect.
May 13, 2008 at 11:06 am
If you are in SQL 2005, You can take advantage of table partitioning but only in Enterprise edition.
May 11, 2008 at 11:27 am
Viewing 6 posts - 1 through 6 (of 6 total)