thanks for all your suggestions. Now off to find a valid MS email address that will server questions like this. Will let you know if I can get any definitive...

Hi, thanks for your replies. I agree, certified DBA figures will not really paint the accurate picture for the reason you state. But I'm guessing that's the only tangible figure....

I am aware of all the features that SQL Server offers out of the box but I specifically need a Third Party Tool.

money is not an issue, but time is...

nice article. one question?

in your backup TLog statement did you mean to say....

BACKUP DATABASE AdventureWorks TO DISK = '\\hanode1\backup\AdventureWorks_createnewfile.trn' WITH INIT

?

GilaMonster (1/18/2011)

---

It needs to sort because it's dealing with two sets of data, from the two queries, based on two different tables in the union. Also the query probably won't...

The order by matches the Index definition. Its clustered on local_ts. So it shouldnt need to sort no?

Yep as stated I have tried that but the order by at the end still causes a SORT to carried out for each query either side of the UNION ALL

as happycat says this is just a warning message and the data should be replicating away in the background

Run the following on the distributionDB to see how much data is...

Many thanks for all your help on this and pointing me in the right direction. I finally got round to getting the time to complete the solution and add other...

Thanks for you responses so far. Heres my response to some of the queries.

Why would hide a data element inside a string, then have to pull it out? A...

Did this get resolved by reinstalling the SNAC? I am having the same problems querying a linked server using a Windows Domain account that has SA on both servers. When...

all I was doing was reading from sys.database_pricipals and other permission related tables from each database so all I needed to go was grant read permission on every database to...

yep this was indeed Policy Based Management. This is a test server and one of my team had enabled it to have a play. Disabling it removed the icon and...

I'm not using policy manager anywhere in our estate. But I will check

I agree with Hans, this original post was about updating SQL 2005 Standard Edition to SQL 2005 Enterprise edition. Its nothing to do with Upgrading a whole SQL Server version...