It's hanging up because it's waiting for output.

Try:

exec xp_cmdshell 'start c:\windows\system32\eventvwr.msc'

The above should return.

Then check in Task Manager, you will see MMC.EXE process running.

You will not be able to...

khushbu (5/21/2012)

---

Eugene Elutin (5/21/2012)

---

khushbu (5/21/2012)

---

I already tried this .. strangely nothing happens and query keep on...

khushbu (5/21/2012)

---

I already tried this .. strangely nothing happens and query keep on executing .. and...

I don't think there is any in-build way. You will need to use "instead of" triggers when inserting and updating data. Check this one, it has some good samples to...

k.subramanyam1017 (5/21/2012)

---

Hi friends,

could u please any one tell me the these questions

1) what is your company file architecture and how much data u r handle.

2) how...

michael vessey (5/21/2012)

---

are you taking the mick ? i think you ned to buy a new watch...

Tried this, also failed:

EXEC sp_executesql

@query = @sql,

@params = N'@subTotal VARCHAR OUTPUT',

@subTotal = @subTotal OUTPUT

Error:

Msg 214, Level 16, State 2, Procedure sp_executesql, Line 1

Procedure expects parameter '@statement'...

Jeff Moden (5/16/2012)

---

You know me... I don't go into these things blind. I always have test data. Helps me keep my alligator mouth from overloading my humming bird...

Brandie Tarvin (5/17/2012)

---

Eugene, I appreciate what you're saying, but please watch how you word it. Your tone in your last post came across very harsh and .. well, there's another...

You again provided insufficient sample of data, so people will advise you to use dens_rank and it's not what you need. If you could confirm the following:

001 20100403...

Yes, it is possible. You can declare variable of a table type (known as table variable).

You will be able to insert all results into this "variable".

OP wanted to start IDENTITY from the position calculated/given in variable. The only way to do this is to INSERT with INSERT_IDENTITY ON. It's impossible to do it with ALTER...

Daxesh Patel (5/17/2012)

---

Probably you want to reduce IO cost.

Following may help if you have enough sql memory available. if not, this may dump the intermediate resultset in tempdb and eventually...

Could you please...

You should declare your @sql variable as NVARCHAR (not varchar)