you could try proclarity, they're an ms partner.

Unless theres a good reason to split into two databases, for example some data being read only to majority of users, a database being owned by a seperate accounting system...

Looks like I've managed to solve the problem with the help of regmon a great free utility that tells you when & which registry entries are being checked for so...

sorry its a different redgate tool to do content, sql compare does structure!

redgate sql compare will do the job and theres a 14 day trial.

Ok its been resolved, the issue was caused by an upgrade to windows 2003 server which presumably they did around the same time as the domain server going down! Apparently...

No - new sql users. Apparently when right clicking on a table and selecting return all rows returns garbage on the server & clients. Using SQL Query Analyser it seemed...

I'm not actually on site, although one of our consultants happened to be on site doing a data transfer & is now saddled with the problem (we're a software company)....

The strange thing is it doesnt matter what type of login sql or windows, I managed to partially fix one login by opening the login in enterprise manager and saving...

The domain server was taken out by a power surge, caused by lightening strike, the server with SQL Server on was Ok apparently. This was in a london local government...

Thanks, this is definately the case, once restarted all was well.

Phil

The more I use this site the better it gets! I'm more of a developer than dba, actually more of a hacker by the sound of it! Thanks for your...

Thanks, didnt know there was a way of changing the local name of the server via sps.

Thanks thats a very handy article describing how the memory threshold works & the repurcussions of not having enough memory. I'd be interested if anyone out there knows of an...

I found the best way of learning was to create packages in EM and save them as vb script files. I dont think any books will go beyond what is...