Run Policies /Surface Area Configuration - Bug

Hi!

I've created the "Off By Default Policy" as described in BOL (ms-help://MS.SQLCC.v10/MS.SQLSVR.v10.en/s10de_4deptrbl/html/41c3022d-ab13-443e-ac64-ba1d64584f79.htm) for SQL Mail and Database Mail.

When I then activate SQL Mail and Database Mail through Surface Area Configuration (without closing it!) and then run the policy and configure it (so that SQL Mail and Database Mail) is then off, these changes are not reflected by Surface Area Configuration.

You must restart Surface Area Configuration, so that you can see the changes.

HTH

Klaus Aschenbrenner

http://www.csharp.at

http://www.csharp.at/blog

The SAC doesn't auto refresh but that seems quite normal to me.

Maybe a refresh button would be nice since restarting is not an intuitive way to refresh of course :-)

WesleyB

Visit my SQL Server weblog @. http://dis4ea.blogspot.com

|||

The Surface Area Configuration tool will most likely be pulled in a later CTP; probably as soon as we can support all of the server types (DB Engine, Analysis Services, and Reporting Services) in Management Studio using policies. For now you'll need to close and re-open the Surface Area Configuration tool to see the changes.

Cheers,

Dan

Run dynamic SQL in debugger, get sql dump

If memory serves there was a bug with the debugger where
if you run it from the client machine it would either not
work, or result in an error (sorry can't find the
Microsoft Page).
How I solved this is to run the debugger on the server.
One of the Great Ones, Uri, Narayana, Wayne, Dejan, Tibor,
Dan, Andrew or Adam could probably tell you the reason and
the fix.
Peter
"I favor the Civil Rights Act of 1964 and it must be
enforced at gunpoint if necessary."
Ronald Reagan

>--Original Message--
>
>Hi,
>One of our developer runs a stored procedure containing
dynamic SQL in
>T-SQL Debugger. She consistently gets error ( see below ):
>SqlDumpExceptionHandler: Process 73 generated fatal
exception c0000005
>EXCEPTION_ACCESS_VIOLATION. SQL Server is terminating
this process.
>If she runs it without debugger, it runs fine. She checks
the code many
>times and can't find anything wrong in the code. We have
no idea what's
>wrong.
>The server is a SQL Server 2000 (SP3) on a Window 2000
with service pack
>4.
>Thank you.
>
>*** Sent via Developersdex http://www.codecomments.com
***
>Don't just participate in USENET...get rewarded for it!
>.
>
Thanx for the response.
She ran it on the server and got the same error.
*** Sent via Developersdex http://www.codecomments.com ***
Don't just participate in USENET...get rewarded for it!

Run dynamic SQL in debugger, get sql dump

If memory serves there was a bug with the debugger where
if you run it from the client machine it would either not
work, or result in an error (sorry can't find the
Microsoft Page).
How I solved this is to run the debugger on the server.
One of the Great Ones, Uri, Narayana, Wayne, Dejan, Tibor,
Dan, Andrew or Adam could probably tell you the reason and
the fix.
Peter
"I favor the Civil Rights Act of 1964 and it must be
enforced at gunpoint if necessary."
Ronald Reagan

>--Original Message--
>
>Hi,
>One of our developer runs a stored procedure containing
dynamic SQL in
>T-SQL Debugger. She consistently gets error ( see below ):
>SqlDumpExceptionHandler: Process 73 generated fatal
exception c0000005
>EXCEPTION_ACCESS_VIOLATION. SQL Server is terminating
this process.
>If she runs it without debugger, it runs fine. She checks
the code many
>times and can't find anything wrong in the code. We have
no idea what's
>wrong.
>The server is a SQL Server 2000 (SP3) on a Window 2000
with service pack
>4.
>Thank you.
>
>*** Sent via Developersdex http://www.codecomments.com
***
>Don't just participate in USENET...get rewarded for it!
>.
>Thanx for the response.
She ran it on the server and got the same error.
*** Sent via Developersdex http://www.codecomments.com ***
Don't just participate in USENET...get rewarded for it!