this post from microsoft says

http://msdn.microsoft.com/en-us/library/ms189799.aspx

Because SQL Server does not support user-defined triggers on system tables,

we recommend that you do not create user-defined triggers on system tables.

I have created this trigger but its still not what i want. i guess its hard to achieve this.

ALTER TRIGGER [check_column_names]

ON DATABASE

for CREATE_TABLE

AS

BEGIN

DECLARE @data...

Well thanks but i need to create a DDL trigger means i need to prevent user from creating table if he is not

creating it according to my standard.

--this...

I didnt get that. but here is the question.I have one select statement in my environment

running since last 6 months with 100 different parameters for 100 times in the morning

say...

Now if i try the same thing with select statement and supply 100 different parameters then wht will be the result?

sql will create 100 different execution...

I have 8 GB RAM on windows 2003 server Enterprise Edition with SP2 and AWE is enabled on sql server.

I can see this after running sp_configure

name ...

Thanks all for yr replies...

dbcc traceon(1204,3605,-1)

dbcc traceon(1205,-1)

dbcc traceon(3604,-1)

All of above...

Thanks a lot thats reallly helpful

Thanks for ur feedback

But its a kind of small environment and not large traffic so may be

they are doing it since long back to avoid more memory,I/o and resources...

Well I should not kill processes and it can create a mess.I agree.

But if i am doing it then I am also taking care of innocent processes

and i...

Thats a good option to use scripts.

But is there any possible solution for this situation..?

Like if I start taking my trn log backup job for every 15 minutes for that...

Wow that’s a nice description. I will correct all things but

If u consider my scenario(I know its not good) but it used to work fine until now.

The question is...

Well thanks for ur replies but

Books online says

MaximumErrorCount The maximum number of errors that can occur before a package stops running. The default value of this property is 1.

In...

I can see these settings

Fail Package on Failure =False (package fails on step-1 and 2 but still goes to next step)

Max ErrorCount =1

So according to u I need...