Thanks for all

Thanks..it is working when I restart the service..

but if My server only stopped then how should i configure get alerts

i found that my server time has been changed to prior to actual time.. i have reset it now the problem is clear

After my search i found the solution for that...

and modified my procedure as below.lll

alter procedure limitedupdate(@i nvarchar(max),@j int)

WITH EXECUTE AS OWNER

as

begin

set rowcount @j-2 ;

execute sp_executesql @i

set...

are u aksing me to execute like

exec as limitedupdate 'update Child set pid=10 where id=101',1

hi,

i need the text like "TOTAL" ...rollup wont give it...

Please advice

thansk...for yuur reply

I logged with different user in my compputer..

the start and stop buttons are in deactive state

hi,

here i am not able to trust it is updated with 'A'

supose in cte last select statement can be changed to 'AA' it is not showing last updated record that...

hi,

any single statement to complete this task

Koen,

Yes , i agree with you but i don't know its possible..i was not replied any thing when he raised that question becuase i thought that by using any...

hi,

one of the interviewer asked the question about updating...so i have added test table like below...

USE [Practice]

GO

/****** Object: Table [dbo].[mytable] Script Date: 09/25/2013 13:10:59 ******/

SET ANSI_NULLS...

hi,

The below query only updating the city value from A to B not B to A

Please advice.

Thanks,

Dastagiri

Thanks lot

The procedre limit the records based on sending query.

Suppose if we need to update 10 records ,we need to pass the update query and limit value so it will be...

The object still exist in under tempdb