TNX Gail,

It's good idea. Can u please provide the needable

steps for performing logging (inserting to table) from profiler, and also catch only so:recompile event, cause i'm newbie in DB

Thanks...

TNX Gail,

But i'm looking something to run and get results.

There are some new views in sql 2005, however i can't find any

stuff.

In my opinion , the better resolution for the as u called "The Hard Way", is to use trigger if type INSTEAD OF DELETE,UPDATE,INSERT and put a Raiserror with some...

Probably u don't need to add GUID column for each table to get random sets.

u a can achieve it by adding NEWID() in the ORDER clause.

what data type of your variable???

i experiance the same problem in the past i set to my variable type Int, however i changed the type to integer or decimal and...

Try to post it in sqlmonster.com