cannot debug stored procedure msg - db not setip or permission prob ?

[scott]

Hi,

I followed everything this article suggests:

http://support.microsoft.com/default...b;EN-US;836734

Yet I still get the following message when stepping into a SP:

"Cannot debug stored procedures because the SQL server database is not setup
correctly or the user does not have permission to execute
master.sp_sdidebug. Run SQL server setup of contact database administrator"

Im using:
- windows xp
- vs .net 2003
- 2003 domain
- sql 2000 running on 2003 member server

Also domain users added to SQL server USERS, REMOTE DESKTOP USER, DEBUGGER
USERS, VS DEVELOPER USER groups + CREATE GLOBAL OBJECT policy (server also
reboot).

Many thanks for any help
Scott

cannot debug stored procedure msg - db not setip or permission prob ?

[scott]

in addition i have,

1. component services, my comp, properties, default com security - allowed
access for domain users

2. create global object local policy allowed by domain users.

3. sql startup service account is a local admin

reboot.

Scott

[scott]

way hey !!!

FIX: SQL debugging does not work in Visual Studio .NET after you install
Windows XP Service Pack 2

sql 2000 standard
..net 2003 enterprise architect
xp sp4

install SP4 for SQL sorted it.

Cheers
Scott