Don, Reading your excellent and crisp article on Data Encryption in 'Stairway to SQL Server Security Level 8: Data Encryption' series. Have a quick question. Into the article you made...

It works as follows: In the result pane of the query analyzer, it will show 0 rows affected but at the same time, it does it work in the registry....

Hi Shashi,

It seems that you are having the problem of MDAC.

Once i got the same error like this. At that point i install the MDAC and it works fine....

Hi Shashi,

There may be the installatioon problem on your server. Have u tried on reinstalling that SQL Server Evaluated version ?

Regards.

Yes, basically, SQL Server doesn't show the TASKS in itsa tasklist.

and it doesn't give any error message.

Pls help

Thanks a lot fhanlon

Regards

Hi !

I send my CV to the mail-id mentioned above.

Pls see and tell , if i am suiatble for this job.

Regards,

Prashant Thakwani

NO,

U can use the Stored procedure for this purpose.

Basically, I coudn't get where u want to use the views with params, and cann't u use the SPs in that...

I think u can Backup the entire DB and then make the Restore on the separate location.

This u can do through the script also.

Regards,

You an these also,

xp_regdeletekey

This extended stored procedure will delete an entire key from the registry. You should use it very carefully.

Syntax:

EXECUTE xp_regdeletekey [@rootkey=]'rootkey',     ...

Considering of having the column that shows the Session when the user logs in/out.

So if u have to make a little change in your design, by adding a column "Session"...

you cann't get the four return values from a SP. U have to use the select statement for this.

I don't think the certified person will get the benefit. I just see that, the person, who has a knowledge will be get the earlier priority than other.

Prashant Thakwani

thakwani@rediffmail.com

Because, U cannot specify the ORDER BY Clause, until the TOP clause is also applied in the SELECT Clause. Remeber this, Always.

Prashant Thakwani

thakwani@rediffmail.com

It is a good article for the startup DB Programmmers. Keep it up.

Prashant Thakwani

thakwani@rediffmail.com