Hours of research and posts yielded nothing.

No responses even to my threads even from MSDN.

The solution:

It seemed the problem was that the install didn't finish the registry entries for the...

I have resolved this issue.

Thank you.

I am having a registry issue also.

Different in that when I install SQL 2000 to new nodes added to the cluster,

The HKey_local_machine\software\microsoft\microsoft SQL Server\instancename\MSSQLSERVER

is not being set up completely and...

Update: I did some more investigation and found that the registry keys are quite different between the working nodes and non working nodes.

The key I am looking at is:

HKey_local_machine\software\microsoft\microsoft sql...

Thank you Gail.

The physical location of the server changed?

Is the server still in the same domain?

In my case it was a one time query that caused the tempdb files to grow so I did want to reclaim the 19GB that they were holding. I restarted...

use [tempdb]

go

select * from sys.database_files

select * from sys.master_files where database_id = 2

go

Produces two different "sizes" in pages

select * from sys.database_files

gives me "size" on disk. (free +used)

select * from...

I am having the same trouble. My tempdb files will not shrink despite the fact that only a small portion is actually in use. There are no open transactions.

tempdev10006.94 ...

scratch my last post....I just realized I misunderstood your goal.

The way I read it:

The key is : idstatus and iditem

and you want to delete duplicate records and records that...

This one will do the trick.

delete from #History where id in (

select h1.id from #history h1 inner join #history h2 on

h1.idstatus=h2.idstatus

and h1.iditem=h2.iditem

and h1.datecreated=h2.datecreated

where h1.id <h2.id)

This will end up leaving...

If there is a good, reason how is this? You can use cursor but I prefer using identity field which I added to table. If the extra...

I have just experienced the same problem last night.

My mail notifications work fine in "test" and set up from the "job" level BUT

when I tried "Send Report to an...

Good one SS!

might want to modify it slightly to include starting month?

;with Numbers (Number) as

(select row_number() over (order by object_id)

...

Do the dates always fall within the same year?

or

Can they be for example 10-20-2008 and 01-23-2009?