We have same configuration: SQL Server 2005 64 bit Sp2. And the memory options are not greyed out, yes they are greyed if you click on running values instead of...

Thanks it worked.

Ajay

Alright guys found the problem. The problem was with missing guest user in the newly restored databases. Here is the kb article from Microsoft. The article also mentions on how...

Error: 0, Severity: 19, State: 0

SqlDumpExceptionHandler: Process 68 generated fatal exception c0000005 EXCEPTION_ACCESS_VIOLATION. SQL Server is terminating this process.

I was getting this error in eventlog. Looks like the...

Tom,

The users are having permissions. They can query those dbs in query analyzer.

Thanks

Ajay

This thing worked Thanks for your help.

whats the exact command to do that ?

Thanks

Ajay

Rebuilding a index which is a primary key with a different fill factor involves dropping and recreating the primary key and since replication needs primary key i guess its not...

thanks a lot It worked

Ajay

Is there a notification sent at the end of job. we had several jobs in hang state as our SMTP service which sends the email notification hanged. So SQL jobs...

Guys.. I finally tried by making it a local admin account for MSSQLServer service and it worked. Well we will remove it from admin group after verifying that all neccessary...

Thanks for the reply. I configured the client n/w utility with the virtualservername\instance name as mentioned in the article on both the nodes. Still the error does not go away....

Thanks Santosh, I tried creating Alias using Client Network utility. Tried Named pipes as well as TCP/IP on both nodes without any luck. There are more messages on the Event...

yes we are giving a name SQLA to the instance and not going with a default (local machine name) name.

Ajay

sorry wrong thread moving it into SQL 2000 thread