Cannot View Master.sysdatabase Names in Webpage | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Cannot View Master.sysdatabase Names in Webpage

I have a webpage that should display the database names from the master.sysdatabases. The code for the stored procedure works fine in Query Analyzer and returns the list of all database names under that instance of SQL-Server 2000. The code: select name from master.dbo.sysdatabases
order by 1 doesn’t return the sysdatabase names to the ASP.NET webpage when executing the stored procedure. It returns: System.Data.DataRowView Why does it do this and how can I fix it? Tx
Duplicate POST.
Refer this post….
Please avoid asking the same question in multiple fora here. —
Frank Kalis
Microsoft SQL Server MVP
Heute schon gebloggt?