Simple Object and String Search within Objects
This Simple script will help to do a Server wide search for an object name or usage of a String in Object Code like Function, Procedure, Views
2016-09-26 (first published: 2016-08-25)
447 reads
Object Search
Object Search
Procedure to search any database (or a combination of databases, including all) for a specific string found in column names, object names, and / or object definitions.
2019-04-15 (first published: 2009-04-29)
4,945 reads
Object Search for Sql Server 2005
This script will search databases, tables, columns, stored procedures for text.
2010-01-28 (first published: 2008-12-21)
1,280 reads
RE: Populating @Variables dynamically
Someone said;"Keep us posted on your code, there isn't enough in these forums on dynamic sql......."I beg to disagree - it's way way too many questions on dynamic sql in these forums. Why? Simply put because dynamic sql should not be the first choice in how to solve a problem, and secondly because it carries with it very far-reaching consequences […]
2004-11-10
RE: Multiple Backups from multiple instances
You're a legend. Server had set up permissions on the security section but not the actual permission for the SQL login.Thanks, it works perfectly now
2004-09-05
How is implement a replicated flag
No one has responded to this topic yet. Even if you don't have a complete answer, the original poster will appreciate any thoughts you have!
2004-09-03
RE: xp_md5: "Cannot load DLL" Problem
I'd bet the on the 64bit issue. If you can't recompile, I'm not sure what you can do. Did you register this on the server adn in SQL?
2004-04-08
RE: data types change through T-SQL
I would first think about the actual need to change everything. VARCHAR(n) makes sense when you expect significant differences in the length of the information to store. If that is not the case, the use of CHAR(n) might make sense.
2004-03-12
RE: Using functions in Procedures
Are we saying that in these circumstances funtions are OK. It's only against very large tables there is a problem? No. A Function procedure gets optimized the same as any other procedure or query. What matter inoarticular with functions is "How many times is it called?"This is because the performance overhead that you incur with […]
2004-02-25
RE: "Starting up database xxxxxxxxxxxxxxx"
What do you mean by: It should not be caused by Auto Close That IS the message seen when Auto Close is set to ON for a database. If Auto Close is set for off, check your SQL Server error logs and the Windows Event logs. You might find other indications of problems. Something might […]
2003-08-26
2 reads
Blogs
Small Data SF 2024
By Steve Jones
I can’t remember how I heard about Small Data SF 2024, but it caught...
A New Word: Moledro
By Steve Jones
moledro – n. a feeling of resonant connection with an author or artist you’ll...
Snowflake + Azure blob
By Arun Sirpal
Let’s go back to data platforms today and I want to talk about a...
Forums
7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, scheduled book
7 sept, schedlued article
Comments posted to this topic are about the item 7 sept, schedlued article
6 sept, published book
Comments posted to this topic are about the item 6 sept, published book
Question of the Day
Azure Data Lake Storage Gen 2
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers