November 24, 2002 at 9:22 pm
If I run this query
select db_name() select name from master..sysdatabases where
has_dbaccess(name)=1
I get this below error...but this occurs on one server and not on the
other...why it happens so ??
ODBC: Msg 0, Level 19, State 1
SqlDumpExceptionHandler: Process 74 generated fatal exception c0000005 EXCEPTION_ACCESS_VIOLATION. SQL Server is terminating this process.
but this does't occur when I login as SA and run this query
November 25, 2002 at 5:44 am
Could be a permissions thing. Was this a clean install or a resotre or attach from an old install? What type of account were you logged into when it happened. Did you try this from another location or application? Check the SQL Logs and Event Viewer logs for any possible answers. If is consistent try dropping the account that runs into the issue and recreate. If same problem continues try reapplying the last SP.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply