I had this same problem recently and the article that Jonathan linked to is where I found the best solution. A collegue had shown me a solution, but after I...

Whoops... I messed up the RIGHT function. Use the following code instead.

SELECT 'EXEC(''sp_rename @objname = '''''+LTRIM(u.name)+'.'+LTRIM(s.name)+''''''+', @newname = '''''+LTRIM(u.name)+'.proc_'+LTRIM(RIGHT(s.name,LEN(s.name)-3))+''''''+''')'

FROM sysobjects s, sysusers u

WHERE s.uid = u.uid

AND s.name LIKE 'sp%'

AND xtype...

Chris,

Paste this into QA (Query Analyzer) and run it against your database. It will return a list of EXEC commands. Copy the EXEC commands into QA and run them. It...

Have you tried adding a StatusID (Bit or Int) field to the Customer table (0 = Unlocked, 1 = Locked)?

Perhaps you could run a select from the Customer table where...

Since TRUNCATE resets the identity column (either with a reseed, or setting an autoincrement back to 0) it should only be used if there is currently no data in other...