Please see if this helps..

http://dbathings.com/get-access-sql-server-dont-sa-password-sysadmin-access/

Yep - I did the restart and infact i moved the tempdb to local drive. Still I see the issue. I am really out of ideas.

When trying connecting to SQL server using Management Studio.

When it pops up to enter SQL server instance name, hit the CANCEL

Now, make sure you are not connected to SQL server...

This works!!

Thanks.. :w00t: :w00t: :w00t:

When I run any DBCC command, as I said, I got this error:

------------------------------------------SQL ERROR1------------------------------------

Msg 824, Level 24, State 2, Line 1

SQL Server detected a logical consistency-based I/O error: incorrect pageid...

no dbcc running...

set @exec_sql = 'sp_serveroption '''+@server_name+''', ''query timeout '',2147483647'

I made a change in my code and it working fine now. I am assuming that no backup will run for such a...

I will try this out. Thanks, will update you...

I cant use sp_configure because it will change the server setting which I dont want. Though I can use it and I have full sysadmin access on all servers. Any...

yes thats true.. this is the cause.. but I dont know the solution of it..

-----------

OLE DB provider "SQLNCLI" for linked server "server\instance" returned message "Query timeout expired".

-----------

When I run my SP from QA/Studio Mgt. I get the above error. Now I am sure its...

Thanks Guys for replying..

Here are the answers..

Why are you using a Linked Server?

---because, I have all SPs/Litespeed installed on target server. So, I just call them and it works...

Why not...