SQLServerCentral.com Articles tagged T-SQL, Administrationhttp://www.sqlservercentral.com/Articles tagged T-SQL, Administration posted on SQLServerCentral.comen-us360sjones@sqlservercentral.com (Steve Jones)Just For Fun: An Impossible DeleteHow can you delete only some duplicates? Without Identity's, Temp tables, Cursors, loops or ROW_NUMBER()? Would you believe, go back to the 70's?http://www.sqlservercentral.com/articles/T-SQL/63578/2008/08/05http://www.sqlservercentral.com/articles/T-SQL/63578/Finding and Listing ALL Procedures, Functions, and Views in SQL Server 2005James Rea brings us another great article that shows you how to keep on top of the code that's stored in each of your databases.http://www.sqlservercentral.com/articles/T-SQL/63471/2008/07/28http://www.sqlservercentral.com/articles/T-SQL/63471/Return Query Text Along With sp_who2 Using SQL 2000This is a follow up to the article "Return Query Text Along With sp_who2 Using Dynamic Management Views".http://www.sqlservercentral.com/articles/SQL+Server+2000/63542/2008/07/18http://www.sqlservercentral.com/articles/SQL+Server+2000/63542/Using the OUTPUT Clause to Capture Identity Values on Multi-Row InsertSQL Server 2005 introducted the OUTPUT clause which we can use to capture values from the inserted and deleted virtual tables.http://www.sqlservercentral.com/redirect/articles/2555/2006/08/25http://www.sqlservercentral.com/redirect/articles/2555/