FreeHansje (1/21/2008)

---

A database has been created with a logical name hansjestest-0_Log. Note the line, NOT underscorde between ..test and 0. This name is accepted, seems to be correct. Now I...

Did you run DBCC CHECKDB?

Could you provide your scripts?

I may need to run sp_addlinkedserver before uring your query command.

I am not sure I fully understand your question. To apply service pack or hot fixes on a cluster, sometimes, we only need to apply it on an active node....

Before applying the last log file, we need to have the clause, WITH NORECOVERY clause.

RESTORE LOG MyNwind FROM MyNwind_log1 WITH NORECOVERY

While applying the last log, we may have,

RESTORE LOG MyNwind...

sysaltfiles has a little bit more information, createlsn and droplsn, which are related to the data allocation.

Did you apply your hot fix from the active node?

Here are some links for you.

http://support.microsoft.com/kb/316005

http://www.sswug.org/see/17269

Are there referenced columns in these two tables?

It should be included. Did you search it on your PC? It should be in the folder, \SQL Server 2000 Personal Edition\x86\bin, by default.

Many people have the same problem as...

What percentage of this difference? Is it because of rounding up?

You may try this.

SELECT OBJECT_NAME(rkeyid) ReferencedTable FROM sysreferences WHERE fkeyid = OBJECT_ID('ORDER DETAILS')

Here is a link discussing your issue. May it help.

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1978072&SiteID=1

If you are talking about index fragmentation, you can use

DBCC REINDEX

DBCC INDEXDEFRAG

If you you are talking about the disk fragmentation, you need to do it on OS level using defrag,...