glad i could help!

that's what i was hoping....that there was an Id, in your case, PersonId in the table. your modification looks good.

you can easily test it with this, which would insert 4...

well, I'm pretty sure you are running out of connections. it may have run without a problem previously, but breaking now because you are finally looping/creating more than 32767 connections.

since...

i've seen this before, but in a vb6 application; are you using .NET?

opening and closing a connection takes resources, and time, since the server has to answer back with a...

i think this is more like what you want:

CREATE TRIGGER tgrDefaultValue ON tblPerson

FOR INSERT

AS

UPDATE tblPerson

SET LastName = FirstName

FROM INSERTED

WHERE tblPerson.ID...

to take advantage of an index, you can't use any functions on the column in the WHERE statement; the isnull(name, '') = '' doesnt allow a Sargable search, so...

by changing, do you mean schema changes, ie new columns, defaults,constraints, datatype changes, etc, or do you mean data changes, like new rows of data,others updated/deleted

PavanKK (11/26/2009)

---

Hi All,

I am new to adminstration. can you help me with following.....

My application contains 300 tables & 1000procedures. Now am adding additional column to some tables ( say 180...

I agree with Steve; a well written trigger would have no problem copying data to another table, so if you can show us your trigger code you tried, as well...

i wish (sigh)

there is no access/no control...

Rodney i was able to recreate the error for tables that contain a default value, you are right.

a bandaid i found that works was to go to master and run...

wierd Rodney; I tried to duplicate your steps,but I AM able to use the script as function in SSMS when i login as my test user. i wonder why it...

ok here's another idea...besides the planned filtering, what if the application started a transaction, ran the script, and then rolled back the transaction?

if it was a valid SELECT statement, no...

with regex, i can use word boundaries, so UPDATE would be a match, but UPDATEDDT would not. same with EXEC/EXECUTE vs a word that contains the keyword.

I'm going to play...

Thanks Gsquared, your idea would work if i had control of the database.

imagine if i gave you an application: you download it, put in your connection info at your...