Well I had the same problem and got rid of it by changing the account that runs the MSSQLServer Service.

Everything was running just fine.

I then tried to create a certificate...

This might help:

select name, collation from syscolumns where id in (select id from sysobjects where name = '<yourtablename>')

Run the script on your database and change <yourtablename> to the name of...

I don't think the DDL for an 80 columns table would be very interesting. I know myself that it's a freaky table.

Thanks anyway.

I've done the ADMIN courses for MS-SQL and...

Just what the doctor ordered.

Cheers!

I am now running the script like this:

SELECT * FROM TABLE1

WHERE LEN(isnull(COLUMN1,''))+LEN(isnull(COLUMN2,''))+LEN(isnull(COLUMN3,'')) in (

SELECT MAX(LEN(isnull(COLUMN1,''))+LEN(isnull(COLUMN2,''))+LEN(isnull(COLUMN3,''))) FROM TABLE1

)

Hi Journeyman

Thanks for the feedback.

Regards

Well I'm not sure if I'm doing it right, but I always thought that if you do a restore to a point in time that you had to set the option NORECOVERY....

@alzdba: Thanks for the tip. I had a look around.

@athugar: Where would I find the system statistical indexes?

I'm still having the same problem. Strange thing is, if I run the...

It helps me if I just close EM and restart again. But hey, that's only with my installation. I'm using SQL 2k with SP3a.

Not a...

A big "hip, hip, 'ray.....!!!!!" for Steve.

Ta mate

@all

That's true, what Mike just stated.

But how would you really go about tackling the task. Would you use EM or the SQL QA equivalent?

Me personaly, I'd use EM first and...

Yeah, I think they got something mixed up.

I don't think the orders database would change one thing, with answer c)

Regs

hot2use

And adding a short inputbox for the server is cool if your centrally managing multiple servers.

[...]

Dim i

Dim srvname

srvname = InputBox ( "Enter the Server Name", "Server", "xxxxxx")

' making the connection...

Hiyas

This is my favourite article from MS

http://support.microsoft.com/default.aspx?scid=kb;en-us;224071

You can modify the parameters in the registry, before starting up the SQL Server service. This can be used if you manually copy...

Sounds pretty interesting. Does require a stand-alone server though.

Major drawback #1: If you have to flatten a member server, then you have to de-enlist and re-enlist the server. Tell that...

Idera's SQL Diagnostic Manager formerly belonged to netIQ, but was sold off to Idera before Microsoft bought netIQ.

netIQ...