Yes, the same problem occurs in QA and EM.

In EM we double click a table, which opens up the properties page. In QA we run a select count() command.

My user tells me that the first time this...

The server has been patched a long time ago, but the client has not been.

I restored the database this weekend and this seems to be the only thing...

In EM.

Well, I ran into a problem, even with starting the service manually. My backup software is Veritas Backup Exec 8.6. It sitting on our backup server. For...

Yes it is. Simon, thank you.

I think I should be running this:

net stop mssqlserver

and then

sqlservr.exe -m

And then restore, correct?

Simon, I am confused about your instruction below:

"Don't use cursor do a SELECT TOP 1 where you do the fetch."

Why do a select top 1?

Also, what is a set based...

Those don't apply, I have Win 2000 Server. The last link come up empty.

What should I look for in spids 1-5? Also, if tempdb is growing and taking up the whole drive space, can't I just look at the free space remaining...

Just rebooted and it still doesn't show :o( And that particular server has this big issue that I am working on and really could have used those counters.

I did...

For some reason this didn't work. I tried it twice. Do I need to reboot the computer?????

have you tried attaching to another sql server instance?

Thank you. However, I have a dilema.

I have some tables with clustered index and they are created on my index filegroup. I want to move them to my...

Thank you for your help everyone.

I have one more question. Lets say I have all of my tables on one filegroup and I back that filegroup and restore it...

But I don't want to back up everything. I only want the tables.

I have another question, if I back up everything (full backup) and restore to another...