No one has voted on any posts yet. Votes from other community members are used to determine a member's reputation amongst their peers.
|
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 …
|
|
hi i want to create a trigger for update in mssql. in my trigger i want to know which row was updated how can i achieve this info ?
|
|
|
I have a table in MS SQL DB, the data was recorded with redundancy, is there an easy way to remove all but keep only one, for example: [ICODE]id name age dept --------------------------- 1 alan 20 A 2 william 23 B 2 william 23 B 3 mike 30 C 3 …
|