Object_Id 1

Encrypt All Stored procedures at once

this code encrypts all stored procedures that meet a certain format. this code is easy to change to suit your particular needs, but be sure to back up your stored procs first.

RE: Comments and Bugs on New Design

Thanks for the suggestions again. I modified the homepage slightly and the order of display to reflect a bit of what you're saying. Can't move search to the upper bar because it makes it huge. Brian Knight bknight@sqlservercentral.com http://qa.sqlservercentral.com/columnists/bknight

RE: SSWUG and PASS

Not sure about SSWUG (biased as well). PASS conference is a good place to learn and meet people, not sure about the added value of the association. Steve Jones sjones@sqlservercentral.com http://qa.sqlservercentral.com/columnists/sjones www.dkranch.net

RE: DELETE DUPLICATE ROWS

satish, Take a closer look at my earlier query. The DELETE FROM Orders FROM Orders was actually not a typo, although I admit that the SQL syntax in this situation is extremely confusing. Here's your query: DELETE FROM WTRDET FROM WTRDET INNER JOIN ( SELECT Order_NBR ,Line_NBR, MAX(Ship_Date) as MaxShipDate FROM WTRDET GROUP BY Order_NBR […]