only documents sys db's and not user db's on sql2000 server!
VoiceOfRock
Posts: 15
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!
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!
Comments
Please see this article which explains minimum database permissions required for the user running SQL Doc.
http://www.red-gate.com/supportcenter/c ... 0812000331
Product Support
Red Gate Software
i have sysadmin rights on all our SQL servers so permission shouldnt be the problem.
Can you send screenshots of any error messages and the log file generated
http://www.red-gate.com/supportcenter/c ... _log_files
to support@red-gate.com
Plesae put F0066614 in the subject.
Product Support
Red Gate Software
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