No one has voted on any posts yet. Votes from other community members are used to determine a member's reputation amongst their peers.
3 Posted Topics
[QUOTE=veasnamuch;784705]My server configuration are . SQL Server in Marchine1 - is setting in Mix Mode(SQL Server and Windows Authentication) . IIS Server in Marchine2 - is setting as following Directory Security - > Authentication and access control .Unchecked "Enable anonymous access" .Checked "Intergrated Windows authentication" .Checked "Disest authentication for Windos …
Use the "inserted" keyword in the trigger. if you use inside the trigger code: SELECT * FROM inserted only the updated rows will be returned.
There are few ways to do that, the simple one i think is by adding an index column, and than delete all records which has identical records with smaller index value: [code] ALTER TABLE MyTable ADD i int IDENTITY; DELETE FROM MyTable WHERE i IN ( SELECT T1.i FROM MyTable …
The End.