How would you get data from deleted table in case of INSERT trigger. there will be...

Try with DBCC shrinkdatabase ...and if it still doesnt work ..take a full backup and then try shrinkdatabase

Anyways ,,if you still want to shrink data file ..you can use the TRUNCATE_ONLY option in DBCC shrinkfile

Why are you trying to shrink data file ..it can leads to fragmentation i.e poor index selection.

instead you can go for log shrinking

What kind of lock ? Do you mean different transactional locks like shared, update locks etc ??

yes .. but size should work according to select len('10_samjack') which is 10 which...

i also caught the same as chris , varchar(10) is playing the trick , but why ? , dont know:unsure:

ColdCoffee (9/6/2010)

---

Now if u see, the first and third uses @s1, which is VARCHAR(10) , but the first one truncates the result to only one values 10_jack, while the third...

ColdCoffee (9/6/2010)

---

Still nothing.

this is bad from performance perspective , never use function with where caluse column , it will force sql...

can you elaborate it ? i saw the exec plan but didnt get anything bad there

refer these links

http://www.sql-server-performance.com/articles/audit/ddl_triggers_p1.aspx

http://www.sqlteam.com/article/using-ddl-triggers-in-sql-server-2005-to-capture-schema-changes

Chris Howarth-536003 (9/6/2010)

---

Turn the auto stats update off and perform an UPDATE STATISTICS...WITH FULLSCAN after the load, assuming that you have time in your maintenance window to perform a full...

is your non-clustered index UNIQUE ? i dont think so

try two things .

try to login with sa and then look for it

and see whether that is running or not ?

and last restart the sql server