Error with retrieving data

[Tjoppie]

Hi all,

I'm getting an error when filling a dataset, but I can't figure out why. code is:

TreeAdapter.Fill(TreeData.Qry_Admin_TreeMenu_VBNET)

And the error I get is:

An unhandled exception of type 'System.data.sqlclient.sqlexception' occurred in system.data.dll

Additional Information: System Error

How can I resolve this error? I think it might be sql server is giving the error, how can I get the application to give me the error in a messagebox?

Thanks

Rudi

[techgnome]

DO this:

Try
  TreeAdapter.Fill(TreeData.Qry_Admin_TreeMenu_VBNET)
Catch ex As System.data.sqlclient.sqlexception
  MEssageBox ex.ToString
End Try

That will tell you what SQL Server is returning as the error.

Tg

[Tjoppie]

Ok I got the error, it's sql errors... but not one that I like....

Execute permission denied on 'sp_sdidebug' on the master database.

What does that sp do?
I don't really want to give my users access to my master database..... Will it harm my server?

Regards,

Rudi