On Sep 12, 7:37*am, Erland Sommarskog <esq...@sommarskog.se> wrote:
> ph3ng (jth...@gmail.com) writes:
> > I was executing sp_help on a server (ran against master database) and
> > i get the following message:
>
> > [Microsoft][ODBC SQL Server Driver]Associated statement is not
> > prepared(HY007)
>
> Where did you run it? Which version of SQL Server? And what did you
> run? sp_help or sp_helpdb? Any parameters?
>
> --
> Erland Sommarskog, SQL Server MVP, esq...@sommarskog.se
>
> Links for SQL Server Books Online:
> SQL 2008:http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx
> SQL 2005:http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx
> SQL 2000:http://www.microsoft.com/sql/prodinf...ons/books.mspx

My bad. Hadn't realised I've accidentally given some inaccurate info.

I've used sp_helpdb. I am using MSSQL 2000. No parameters - just
sp_helpdb.

I've ran it in via DBArtisan's ISQL window against the master database
of a MSSQL server.

Hope this provides a clearer picture. Thank you and my apologies for
that.

Justin