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




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


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,