Can you show me the command you are using to run the procedure? Friday, April 08, 2016 - 2: I'm asking because in the procedure posted I also needed look for the numeric values and then I understood that for this, just add the "int, numeric etc... As there is no out-of-the-box solution in SQL Server management Studio, nor Visual Studio, here are a couple of options that can be used:.
Wednesday, March 16, 2016 - 2: Though, I have an issue I know that I dont actually NEED to do it this way, but im asking if its posible, because I've looking many alternatives and couldnt work it out:.
Search all string columns in all SQL Server databa... Hy, I am having a problem trying to get this working from my c app I modified your proc a little bit and moved shema out from it. The sample scripts are provided AS IS without warranty of any kind. Because a few days ago, I needed of a procedure that find a string in all the tables of my database, but I found just a procedure that find a string inside one, just one table of my database...
The query checks for a specific text in the text column, which contains the object DDL:. That'd work wonderful, except for the fact that you cant: This is a good idea about dropping the unnecessary stats after the search.
SQL Server security best practices. Actually, I tried the solution in your blog post it has a minor error , but it somehow always returns the same result. I want to see if I can duplicate the error you are getting.
Wednesday, September 20, 2017 - 9: Excuse my English, I'm still learning... And now, I want share with you my way of obtain this same result, but using cursor, ok? To provide feedback or report bugs in sample scripts, please start a new discussion on the Discussions tab for this script. Use the sys.
Create this procedure in the required database and here is how you run it: Mike Wednesday, April 15, 2009 - 3: SQL Server 7. Evaluation of federated database servers. I did a similar non-sproc script as well posted here: