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

Documents SQL Server 2005 and 2008 databases.

Moderators: JonathanWatts, David Atkinson, Michelle Taylor

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

Postby VoiceOfRock » Thu Nov 08, 2012 4:24 pm

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. :o

please tell me there's something simple to do to get this working!
VoiceOfRock
 
Posts: 3
Joined: Thu Nov 08, 2012 3:56 pm

Postby Manfred.Castro » Fri Nov 09, 2012 6:47 pm

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/c ... 0812000331
Manfred Castro
Product Support
Red Gate Software
Manfred.Castro
 
Posts: 209
Joined: Mon Apr 23, 2012 2:49 pm

Postby VoiceOfRock » Thu Nov 15, 2012 10:56 am

Hi Manfred,

i have sysadmin rights on all our SQL servers so permission shouldnt be the problem.
VoiceOfRock
 
Posts: 3
Joined: Thu Nov 08, 2012 3:56 pm

Postby Manfred.Castro » Thu Nov 15, 2012 5:25 pm

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/c ... _log_files

to support@red-gate.com

Plesae put F0066614 in the subject.
Manfred Castro
Product Support
Red Gate Software
Manfred.Castro
 
Posts: 209
Joined: Mon Apr 23, 2012 2:49 pm

Re:

Postby VoiceOfRock » Mon Nov 26, 2012 4:43 pm

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
VoiceOfRock
 
Posts: 3
Joined: Thu Nov 08, 2012 3:56 pm


Return to SQL Doc 2

Who is online

Users browsing this forum: No registered users and 1 guest