One other point, it looks like you are referencing numbers with string values. This means that sql has to make an implicit conversion over and over. You should remove the...

That looks interesting. If you try that please post back...

GuruGPrasad (3/22/2012)

---

Yes Sean Lange

Each and every action . Exactly what we get in CDC.

Delete Statement

Insert Statement

...

Eugene Elutin (3/22/2012)

---

GuruGPrasad (3/22/2012)

---

Hi Sean Lange,

I think i can't use Triggers. Because, The values of Master table will be updated every time a record is inserted / updated / deleted...

Please don't cross post. Direct all replies to the original thread here. http://www.sqlservercentral.com/Forums/Topic1270724-8-1.aspx

If you roll your own with triggers make sure you do some research about how to avoid the common mistake of assuming there is only 1 row being modified at...

This should help. http://msdn.microsoft.com/en-us/library/aa933299%28v=sql.80%29.aspx

This should help. http://msdn.microsoft.com/en-us/library/aa933299%28v=sql.80%29.aspx

Or better than triggers look into Change Data Capture (CDC).

http://msdn.microsoft.com/en-us/library/bb522489.aspx

Well that would certainly point out the queries that use select * then. 😀

Didn't think about that Lowell. Maybe even rename the original base table so the new view can have the name of the base table currently so that no code has...

You could create a view that does not include the column you want to hide. Grant select to the view to the users role. Then deny select to the base...

Depending on your split function you might take a look at the string splitter link in...

30 seconds for dropping and creating over 200 procs does not sound unreasonable. It starts to get crazy when you have to run this on 1,000 db's. Suddenly you are...

Easiest solution is to stop using the text datatype. It is deprecated and will no longer be supported in the future. Instead you should use (n)varchar(MAX).