only documents sys db's and not user db's on sql2000 server!

[VoiceOfRock]

Hi,

I have a mixture of 2000, 2005 & 2008 sql servers.

SQL Doc 2.1.2.1 works fine against 2005 & 2008 but against 2000 servers it only produces info on the system databases despite listing all the db on the server in the "databases and objects to document" window with everything ticked.
if i click on Master it shows the details but if i click on a user db i get a blank page with "(show database contents)" below the db name but nothing happens when i click it.

please tell me there's something simple to do to get this working!

[Manfred.Castro]

Your issue could be permissions related.
Please see this article which explains minimum database permissions required for the user running SQL Doc.
http://www.red-gate.com/supportcenter/content/knowledgebase/SQL_Doc/KB200812000331
_________________
Manfred Castro
Product Support
Red Gate Software

[VoiceOfRock]

Hi Manfred,

i have sysadmin rights on all our SQL servers so permission shouldnt be the problem.

[Manfred.Castro]

Do you recieve an error message at all?
Can you send screenshots of any error messages and the log file generated
http://www.red-gate.com/supportcenter/content/SQL_Data_Compare/knowledgebase/logging_and_log_files

to support@red-gate.com

Plesae put F0066614 in the subject.
_________________
Manfred Castro
Product Support
Red Gate Software

[VoiceOfRock]

Hi Manfred,

no errors messages, it just doesnt work.

i emailed support with log file attached on 19th November but not had a reply of any kind