Thanks,

we haven't spoktted anything exceptional in the logs.

Although there are far too many potential areas for security breeches here, we don't appear to have been victom to anything.  The data...

The end specified in my example relates to the case statement:

begin

 declare @AnswerText varchar(30),

  @i int,

  @email varchar(20),

  @hearaboutus varchar(20)

 select @i = 2,

  @email = 'an.email@anaddress.com',

  @hearaboutus = 'From a place'

 SELECT AnswerText = CASE @i

   when...

Hi,

there are 2 flavours of the CASE Syntax, I your example, i think this should do the trick:

SELECT AnswerText = CASE @i

   when 1 then @email

   when 2 then @hearaboutus.....

      end

Hope this...

this should do the trick

declare @exec varchar(500),

           @user varchar(200)

set @user =  'mymachine\vishal'

select @exec = GRANT  EXECUTE  ON mytest_sp TO  ' + @user

exec (@exec)

thanks very much.

That was very helpful.

cheers

S

Thanks Norene,

I assume that the folder "c:\Backups" needs to exist on the computer that SQL Server is running on?

When this goes into production I will be using a network drive...

try

insert into <table 1)

select * from <table 2>

where <condition>

Hope that helps