Many thanks to all of you..

I was wrong, but now i understand..

Ii have created the procedure :

CREATE PROC Test

WITH ENCRYPTION

AS

SELECT *from tbl_Test

Now this procedure is encrypted, but in SQL 2008 we can see it's execution plan too.

I have...

Good Question !!..

We can see the Execution Plan of Encrypted Procedure.

I have tested it..

Hi;

hope this could help you

DECLARE @cmd sysname, @var sysname

SET @var = 'Hello world'

SET @cmd = 'echo ' + @var + ' > c:\\var_out.txt'

EXEC master..xp_cmdshell @cmd

Hi;

Actually I have a customer record table in Access (incliudes image field),

and now i want to move database from access to sql server.

i have done all the things except image...

Hi David;

I am using the same to send Mail from SQL Server 2000

But i am getting this error message: xp_sendmail: failed with mail error 0x80040111

Could you please help...