Thanks, William. I was going to post a fix for string sort on reserved, but you caught it.

And thank you ngreene for posting your solution.

Nice coverage. Thank you for taking the time to spell out the steps and issues when working with charindex in this manner. We do something similar for handling...

magarity kerns (2/25/2010)

Thanks, great script. And yes, SQL 2005 or higher. I am one of those dinosaurs that still defaults to SQL2000 to keep customer backward compatibility.

As for the formatting,...

"The Ultimate Object Searcher for SQL 2005 and Higher"

Hello Andy, thanks for a great overview using SSIS. I especially like the detailed explanation with screenshots. We currently use a stored procedure to handle our comparisons and...

Thanks for the article as this does come up, especially when dealing with others' legacy databases. I would be interested in seeing this expanded to include text fields, as...

You could try a sp_refreshview. Below is a script to loop thru all your views:

http://www.sqlservercentral.com/scripts/Maintenance+and+Management/31902

Just to be sure, sp_recompile is for stored procedures and triggers. From...

Thanks Pedro, this is a handy little piece of code. Previously, I would check the error log for the port number that my instance is listening on, which was...

I perform a check for the database required to process the operations after it (e.g. updating objects, adding new...

Thanks for the quick feedback. RETURN will not stop the processing of the script, and only RAISERROR..WITH LOG seems to break the connection to prevent further execution of the...

Permissions for SQL2K can still be edited in SSMS, just have to go one level deeper.  Right-click on the object, select Properties, then select Permissions.  It is more of a...

>> A couple things I wish they would have carried over from EM:

>> OBJECT SEARCH

The only replacement I have found equivalent to the Object Search in EM is by using...