same issues remain...run and test your code, don't just change one thing and re-post it..

test test test!

Lowell (4/4/2013)

---

ok then, here's two hints:

1. your final SELECT belongs outside of the loop,...

vivekkannan.k (4/4/2013)

---

thx Lowell 🙂

yes u r correct, users have Sysadmin permission .

Is there any way to Audit the Changes (delete , disable) on DDL Triggers .

The sys.triggers table has...

there's a VALUES command hanging out there, and the column names should not be in single quotes;

create table PendingIO (

[database] varchar (100),

Physical_name varchar (100),

io_pending int,

io_pending_ms_ticks int,

io_type varchar (20),

num_of_reads int,

num_of_writes int,...

ok then, here's two hints:

1. your final SELECt belongs outside of the loop, not inside.

2. your final SELECT command with the Department and SUM() should not reference any @variables whatsoever.

if...

looks like an incomplete paste from your actual source? can you edit and put the whole command that is failing?

only a sysadmin can disable the triggers, so as long as only you have sysadmin permissions, it's not a problem.

if other people have sysadmin,and you want to prevent them from...

you are grouping by a variable instead of the column from the temp table.

this is not allowed:

GROUP BY @Department

there is no need for a cursor in the operation you...

posts like this make me want to cry.

you offer training, but seem to be asking...

also, the If Not Exists is a scripting option.

you can set it yourself, so that from whenenver you change the setting, it scripts the objects out as dynamic sql with...

the mere existence of linked servers will not affect anything; it's the same as your phone having my number, and my phone having yours; they are independent.

now if you try...

how are you determining it doesn't display right on some servers but not other servers?

the data will have the control characters no matter what in them, but...

I believe he means a single query, getting all the max lens in one query:

SELECt

Max(len(col1)) As m1,

Max(len(col2)) As m2,

Max(len(col3)) As m3

FROM yourTable

i missed the truncating the table part.

there's a lot of script contributions, it looks like, that do exactly that.

some of them are scripts that ASSUME your foreign key is on...

i would consider disabling and re-enabling them instead; either way it's effectively the same thing:

select

'ALTER TABLE '

+ QUOTENAME(schema_name(schema_id))

+ '.'

+ quotename(name)

+ ' NOCHECK CONSTRAINT ALL' as...

from the way it sounds, a trigger sounds like the solution, especially if you need to know WHAT was changed by the stray process/program.

Since the Application Name and the Whostname...