sp_rename and stored procedures

sp_rename and the procedure definition

Find all Procedures, Views, Functions that have been renamed

Find all Procedures, Views, Functions that have been renamed with sp_rename where syscomments does not match.

RE: Need trigger to split 1 filed to 4

My last post relates specifically to Judith solution, but in hind sight Farrells solution falls foul of the same problem since the @location and @message variables to not take account of multiple records.

RE: First and last record

Sorry, that I did not mention: The first and last record for each day for each person

RE: Copy Jobs between servers

If there's a lot of jobs to be scripted, right-click on JOBS in the EM tree and then 'All Tasks' then Generate SQL Scripts. You can manually edit out unwanted jobs from the script before executing it. Note: I also uncheck "Replace job if it exists" in most cases. This saves my hide if I […]