Correct. Instead of ORDER BY empid DESC you should use ORDER BY empwage DESC.

Thanks anyway.

-Lk

Could you run those three commands in your database and send us the result?

-Lk

Hey Matt Wilhoite,

You could do this because you know the row number. Take a scenario where we have a lot of data and we don't know which row number we...

Go ahead and drop us following information:

SELECT * FROM sys.certificates

SELECT * FROM sys.symmetric_keys

SELECTis_master_key_encrypted_by_server

FROMsys.databases

WHEREdatabase_id=DB_ID('')

-Lucky

Thanks to one and all.

-LK

You have really been a great help Mike. Thanks for a great help once again.

-LK

My question is whether this can be used if the master database is corrupted.

((Anyway we don't need to shut down the sql server and copy files. Simply create a...

I didn't find any convincing posts on google and so pinged here. I understand this is a database that is helpful when we upgrade the sql server, patching etc.

Following...

Thanks Adi.

-LK

Hello Mike,

Thanks for your help.

When I use following command as per Sarab's response, I get following information:

RESTORE SERVICE MASTER KEY FROM FILE = 'D:\Database Backup\smk.dat'

DECRYPTION BY PASSWORD = '#56$$#jo'

FORCE

--The...

Mike, Plz go through my post once or drop me a mail at luckysql.kinda@gmail.com

That would be helpful.

Regards,

LK

Vow Suresh!!

I am able to copy this but one extra character () is also introduced here by using copy command. How to get rid of this?

Lucky

-LK

Long back I did that. I created one batch file to do this. This batch file consists of the location of all the .sql files. This is just a hint....

Its ok Sarab. Thanks for your comments and input as well.

BUT my problem remained unsoved :(. I think there is some contention because of SERVICE MASTER KEY. M I missing...

Thanks suresh. Can you also tell me where I can find the service master key and database master key?

-LK