Thanks for this. It was a wood for the trees moment. I had thought of this during the night - this sorts my issue...Cheers for the pointer.
Hi All, Not sure how to word this so here goes: I have a SQL Agent Job with a Try/Catch block within it. Part of the Try block is to execute a...
Hi, Although I dont use any compression utility I've played with that and Quest Litespeed too. In our environment; they had a compression ratio of...
Hi Satya, Your statement's confused me slightly...I would have thought that as long as you install under an account which has local admin privs...
For the ability to Rollback; I would not use Replication or triggers of any kind; as during testing; you dont know what impact this will have on...
I've applied it and I did see the same behaviour now I come to think of it. Rebooting the server is something I didnt include in the testing phase;...
I didnt expect any security changes either; but just wanted to check. The job fails; the server is still operational. I use it as an alert that SQL...
Hi All, Just wanted to check if I'm going mad. As part of my standard SQL Build; I enable Database Mail XPs, so that when a server falls over; SQL...
Hi Satya, Thanks for this. Had already looked at that one; Not really what I was looking for. Was looking to use SQL Partitions as a way to migrate...
Hi All, Taking a stab in the dark here...Has anyone played with setting up table partitioning on SharePoint / MOSS Content Databases? I'm looking...
<P mce_keep="true">Hi All, </P><P mce_keep="true">We have a MOSS 2007 and a number of distributed WSS3 Installations and I'm trying to track how the...
Separate names with a comma.