Mipo,

I have had cause to use rebuildm.exe twice, for exactly this same reason: SQLServer installed with the wrong collation. I followed the guidelines shown but it failed both times, and...

Hi Chris

sp_detach_db

Detaches a database from a server and, optionally, runs UPDATE STATISTICS on all tables before detaching.

As far as SQLServer is concerned the database does not exist after running this

sp_attach_db

Attaches...

Paolo,

Thanks for the reply-

To clarify the Redgate software found no differences between the two databases; '=' signs all over the place.

The amount of used space in the file was less...

A quick update...

Earlier this week - I made a copy of the database using DTS - compared the two databases with RedGate SQLCompare and DataCompare. Detached both databases, and...

Thanks Guys,

The server was rebooted following the install of SP4 - twice.

But I'll schedule more down time for the server - and see if this helps.

Watch this space!

Tim

Brian,

I just gave that a go --

DbId FileId CurrentSize MinimumSize UsedPages EstimatedPages

------ ------ ----------- ----------- ----------- --------------

7 1 ...

Andy,

Thanks for that -

But in this case it is not the transaction log that is the problem - its the data file

Tim

I feel like Billy no mates by replying to my own thread!

I have just found out that this database was upgraded to SQL7 from 6.5 - could this be why...

Andy,

Dont know if this is the cause but Q.13 and Q.14 of this article were the cause of a simelar issue I had recently

Tim

http://support.microsoft.com/default.aspx?scid=kb;[LN];Q315886

Hi,

I've been off looking for more info - I knew had seen this somewhere!

This link "Planing to install SQL2000" has a section on Setting up Windows Services Accounts. The requirements...

Adding the user to the Local Administrators group, will by default make them a SQL System administrator

Couple of things to try:

Change the service startup account back to the default Local System Account and see if the service will start.

If that works - add the user account...

Check that the account you are using has the "log on as a service"local security policy setting enabled.

Hope this helps

Tim

Check that the account you are using has the "log on as a service"local security policy setting enabled.

Hope this helps

Tim

Is it a stand-alone server or in a domain?

http://support.microsoft.com/default.aspx?scid=KB;EN-US;Q307288&

Tim