As a DBA/Developer, I have developed my own applications like Data Scripter, SQL-Compare Pro. If anyone need these let me know. I can give it to u guys @ now...

Hi,

though the method I'am going to suggest is CRUDE but it can work correct for u

rename the SP's with some fixed character, so when name is changed surely somethings...

Thanks a lot to all for your helpfull tips. . .

cheers.

one more way is use

Format(date,"dd-mmm-yyyy") (function in VB)

one more example....

Format(form1.dtpSDate.Value, "dd-mmm-yyyy")

Thank U dear friends......I transfered data to new database and recreated all those users as well. Its fine now..

Thanks a lot..

I checked all the system tables to find this kind of username or id, I was unable to find something like that......I'am really getting strange about this..........Shell I try to...

Hi,

Try to script the table structure changes when U change the table structure in enterprise mangager using the "save change script" then run this script in query analyser U will...

Encrypt function in T-SQL is fine what about Decryption of encrytion columns.

kindly tell us how to do it!