no. you can remove any post, either you can edit it and remove the post's text

nadersam (10/7/2010)

---

can u pls tell me whats wrong in this syntax, i am trying to use table valued functions instead

Thanks

Create function [GetTableData] (@TableName varchar(50),@RowID integer)

returns table

AS

Declare @MySQL varchar(100);

Set @Mysql=...

Post the...

Nader ,

I will still stick to avoid the syscolumns/sysobjects/sysindexes kind if sys tables in your logic , they will force for unnecessary locking in TempDb.

really GOOD question..i really got my eye-brow raised while see the answer.:-D

Bhuvnesh (10/5/2010)

---

Did you try this ?

nadersam (10/5/2010)

---

Already done that, and i see the following lock when i try to open tempdb properties

also i checked the Activity Monitor tool and i see the following wait

Wait Type:LCK_M_S

Resource...

its time to set profiler trace

Did you see some improvement with it ?

vinothr 33504 (10/4/2010)

---

Hi all,

When the recovery model is changed from full recovery to simple recovery will the transaction be logged?

If yes where it will...

Are you sure these SP exist?

Two things you can try here

1) Don't create # table on fly use create approach.

2) SELECT @Field_Position = MIN(ORDINAL_POSITION) FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = @Table_Name AND ORDINAL_POSITION > @Field_Position;

SELECT...

I would like to see the trigger definition now

I think this article can help you.

http://support.microsoft.com/kb/308518/en-us

the derived table which contains

Surely...