Sorry i could not get to this yesterday.

How we solved it was with MSFT on the phone but not the SQL division but the OS support. Apparently the problem...

Before continuing, please let me thank you for your help so far.

After your previous posting I went ahead and tried the following in the new server:

DECLARE @plaintext nvarchar(2000), @cyphertext nvarchar(2000)

SET...

And the certificate was encrypted by the database master key and not a password?

Yes it was encrypted by the DBMK because it was not encrypted with a password.

If you...

Thanks for your help.

>>>What is the symmetric key encrypted with?

>>>If it's a certificate or asymmetric key, are you able to open that key explicitly?

The symmetric key...

Thanks so much. I had always heard about SQLLiteSpeed but never considered it. The reallity is that we have been able to do this restore until last week. Suddenly it...

Because you are going to a different server, have you thought about remapping users to logins in the new server?

Your Scan Density [Best Count:Actual Count].......: 99.32% [1348824:1358003] is not bad.

Try to run DBCC INDEXDEFRAG on the indexes of the table and see if you get an improvement. The adavantage...

Have you checked the SQL Server Network Utiliity?

I am having similar problem. I am updating 2000 from 2005 and I get the following error

OLE DB provider "SQLNCLI" for linked server "ServerName" returned message "Multiple-step OLE DB...

Thank you.

I finally played with the security in Mgt Studio.

We are encrypting the SYMMETRIC KEY with a CERTIFICATE.

So...how I made it work was by creating a database role to...

Thank you very much for the idea. REVOKE did not do it. I even had to go the further step of DENY. Now the [User] cannot create objects (procedures, tables)...

Well, I have checked the server roles and the user is member of none of these roles. The same thing for database roles, as I said when checking the sysuser...

Thank you both. David Poole's was a very good start but the CHAR(10) was still there. I then combined the input from both David A Long and David Poole and...

Thanks. Yes that is what we are shrinking the log after the back up. But now I am able to shrink it and hence recover the space from the unactive...

Thank you very much for your reply.

It was saying (LOADING) in Enterprise Manager. The restore script from VERITAS indicated WITH RECOVERY. What I did was to run the following statement...