The answer ..... it depends

You can install an instance on the passive cluster, but as long as it's passive, it can't see the data from the active cluster. So you'll...

AFAIK, It doesn't make sense to have multiple transaction logfiles (and this is what I noticed in a log transaction)

Unlike the multifile TempDB advantage, this seems not the case for...

SOLUTION

It's seems the only way to resolve this issue, was to restart SQL. I created a shrinkjob, which ran after a restart and that solved this issue.

There are several items on the internet about this error. It's a timing issue, mostly caused by power-saving settings in your server.

I know there's a hotfix fot this, which...

The dynamic part in sp_msforeachdb and ms_foreachtable is not a variable, but a questionmark. In the actual statement, MSSQL will replace the questionmark in your code by the databasename

hi,

You can define alerts for a severity or for an error number.

If you define an alert for severity 23, all errors with that severity will trigger the alert. If you...

WOW :w00t: , that's a big opportunity!

To my opinion, I don't think a forum is a good location for such a big migration. Most of the items you describe are...

You can also use this method, which creates the table

select *

into {new tablename}

from {old tablename}

found this link: http://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx?FeedbackID=127177

Could you post the table definition (and function)?

Is there a computed column in this table?

You mean, not updated by users?

If that's the case, check if there are tables in your database with columnnames like 'modified' (or variants) and select the max() value from this...

Was the behaviour of spreading a rebuilded index over multiple files also working in SQL 2000?

We had the same issue with our previous production server. If your application is not causing this issue, try adding more memory.

Do you also have a lot of blocking locks?...

If you rebuild your indexes, and don't have the option SORT_IN_TEMPDB, SQL will build the new index in the same filegroup of the original index in these steps:

1) say you...

Sorry, my german is not that good (and I'm lazy to seach for the English translation 😛 )

First: If you have a database with DBCC reported problems, make a backup...