Hi everyone,
Happy New Year ! Another year of fun ahead, solving sql server problems. I c
an hardly wait !
We have Sql Server 2000 installed on a server called taggart. On the client
p.c. we have Enterprise Manager and Query Analyser installed.
Using query analyser I can connect to taggart and can see all it's databases
no problem.
Using enterprise manager I can connect to taggart ok but can't see it's data
base. It says 'no items' ! I tried to delete the sql server registration an
d re-created it but it still can't see them. I can connect to other servers
using enterprise manager an
d can see their databases ok, just not this server.
We tried re-booting the server but that had no effect.
Eileen.Can you connect using Query Analyser and run the folllowing query?
select * from master..sysdatabases
Thanks,
Kevin McDonnell
Microsoft Corporation
This posting is provided AS IS with no warranties, and confers no rights.|||yes i can|||I get an entry for each database in the following
d:\MSSQL\data\msdbdata.mdf
d:\MSSQL\data\northwnd.mdf
d:\MSSQL\data\pubs.mdf
d:\MSSQL\data\tempdb.mdf|||log-files on two of the databases had filled up their log partitions. shrink
ing this allowed us to see the databases.
Showing posts with label fun. Show all posts
Showing posts with label fun. Show all posts
Subscribe to:
Posts (Atom)