This project is read-only.

Error in Selection Process Sys.databases

Oct 30, 2009 at 10:10 PM

I am getting error once i click on Database DropDownList

Once I fill up the relavant information and Authentication When I click on Datbase it gives me error ["invalid object name 'sys.databases'"]

I am using SQL Server 2005.

Pls. Help me out in this issue..

 

Thanks.

Jigar.

Nov 1, 2009 at 12:52 AM

2 options:

1) It's not a SQL Server 2005/2008. Check execution this command en SQL Analyzer: EXEC xp_msver @optname='ProductVersion'

2) The user that you put doesn't have permission to see sys.database

Esteban

Nov 2, 2009 at 5:25 PM
Edited Nov 2, 2009 at 7:47 PM

Hi. Esteban,

Thanks for the reply.

Well I have executed the query EXEC xp_msver @optname='ProductVersion'

It is showing the version as shown below.

2    ProductVersion    524288    8.00.194

so what can be the issue pls. let me know. and how can i solve it.

 

One more thing for your information is :

In Master Database where i am connecting , In System Tables I found the table called dbo.sysdatabases where as in code file it's trying to connecting sys.databases

 

------------------------

Do you have any solution for the 2000 database then also let me know or else pls. guide me that how can get any guide or information.

-----------------------

 

So What should i do now  ? to make it workable...

Pls. let me Know,

Thanks Again,

 

Jigar.