Viewing 15 posts - 10,291 through 10,305 (of 13,469 total)
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...
November 30, 2009 at 8:37 am
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...
November 30, 2009 at 8:31 am
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...
November 30, 2009 at 7:43 am
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...
November 30, 2009 at 7:33 am
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...
November 29, 2009 at 5:33 pm
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
November 26, 2009 at 6:59 am
PavanKK (11/26/2009)
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...
November 26, 2009 at 6:19 am
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...
November 25, 2009 at 4:42 pm
Jeff Moden (11/25/2009)
dba_pkashyap (11/25/2009)
How about DDL triggers at database level!!!I'm liking that but can't you just set the users up with "data reader" only?
i wish (sigh)
there is no access/no control...
November 25, 2009 at 3:10 pm
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...
November 25, 2009 at 10:07 am
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...
November 25, 2009 at 8:48 am
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...
November 24, 2009 at 4:01 pm
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...
November 24, 2009 at 3:48 pm
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...
November 24, 2009 at 11:10 am
Viewing 15 posts - 10,291 through 10,305 (of 13,469 total)