I will agree with Gabor. Reduce the degree of parallelism. We have seen this issue quite often and it has pretty much triggered post SP3 and probably seems to be...

Hi,

If you are renaming the server to a different name, you might want to update probably sysdtspackages and sysjobs tables with the name of the new server. You also will...

That is what is confusing me. BOL says that output is in following order,.

DBID, Fileid,CurrentSize,MinimumSize, UsedPages,EstimatedPages. and definitions are as under.

CurrentSize : The number of 8-KB pages the file currently...

I have seen this errors also in the event log. What i understand is that with the linked servers, somehow the session being created does not terminate on its own....

Trun. log on checkpoint will change your recovery mode to simple and you will not be able to take transaction log backups any more.

You can take the resources offline and then stop the services. The status of the node is checked every 0.5 secs and it responds within 0.2 secs. If it is...

you can execute the below.

declare cur_temp cursor for select spid from sysprocesses where dbid = db_id('database_name')

declare @spid varchar(10)

open cur_temp

fetch next from cur_temp into @spid

while @@fetch_status = 0

begin

declare @sql varchar(50)

set @sql...

Thanks a lot everybody. This makes me understand that for a view the execution plan is being cached in the cache. With this understanding, I was just wondering whether a...

Have you tried changing the account under which SQL server Agent runs and then re-start the Agent services ?

ians,

thanks for your reply. I will check that out.

mtmingus:

Check the value for protocolorder under supersocketnetlib key. It would should tcp np

Steve,

Having said that, if i have two tables with say 100,000 rows each and i have a view which joins the two tables. And later on if i query the...

ians,

Did you check the failover capability after removing named pipes.We had a simillar problem and from what i understood from microsoft was that you do need named pipes for failover....

Antares,

Thanks a lot. Didn't think about that.

I had issues connecting to remote server with openrowset function while using trusted connection. It did start happening after installing SP3, i.e. MDAC 2.7 SP1. I didn't check from...

If you can't attach the database you might try doing the below steps.

Create a new database with the name of your original database.

Detach the data file.

Rename the old data file...