Uses sp_ob by Saket Mittal to search all databases for objects of a like name. Examples: To search for a table named 'customer' : exec master..usp_SearchObjectsAllDBs @searchname = 'customer', @type = 'U' To search for a procedure named 'customer' : exec master..usp_SearchObjectsAllDBs @searchname = 'customer', @type = 'P'
2006-02-02 (first published: 2006-01-18)
136 reads
2006-02-01 (first published: 2006-01-27)
1,884 reads
2006-01-31 (first published: 2006-01-27)
149 reads
2006-01-30 (first published: 2006-01-27)
796 reads
I have been wonder how to get info (by query NOT EM) of all the Maintenance Plans and it's by effect jobs plus schedule. I also see people asking the same questions in different forums. Finally, I start exploring myself (with helps from others of course), here's the result.You can run it as a ad-hoc […]
2006-01-27 (first published: 2006-01-12)
313 reads
Updated for Permission assignment change 1/11/1006. Ok, I'll bet that you are asking, What is a Global System UDF, right? By Global I mean that the UDF is available from any database on the server. By System I mean that the two part naming rule does not apply to this scalar function. The UDF conversion […]
2006-01-26 (first published: 2005-06-10)
473 reads
Returns User Tables by SIZE in DESCENDING ORDERAdd TOP n clause in SELECT to get selective results (i.e. TOP 10 TABLES)
2006-01-25 (first published: 2003-06-07)
2,470 reads
Script Table Data to Insert Statements - Handles Unicode datatypes (nchar, nvarchar, ntext). This script works with SQL 2000 and has been improved to handle properly the nchar, nvarchar, and ntext data types for Unicode, as well as handle apostrophes in data correctly. Usage is to run the script to create the stored proc in […]
2006-01-24 (first published: 2006-01-11)
616 reads
Post data as coming from an HTML FORM with METHOD=POST to an url and retrieve the result. The procedure uses WinHttp.WinHttpRequest.5.1
2006-01-24 (first published: 2005-01-27)
1,774 reads
This is BASE64 Encoding/Decoding in a T-SQL procedure. This code is provided as is, and is free to use and modify. Version 2 June 2005
2006-01-23 (first published: 2004-11-17)
4,910 reads
By SQLPals
SQL Server Transaction Log Forensics: Preserving Evidence During an Incident SQL...
By James Serra
Making Data AI-Ready, Part 1 (This is the first article in a three-part series...
By Steve Jones
Thanks for attending my sessions. Resources below: Slides: Using Data API Builder GitHub repo: ...
Comments posted to this topic are about the item Hyperscale Replicas II
Comments posted to this topic are about the item Practical Reporting Queries with CROSS...
Comments posted to this topic are about the item Your Favorite Quotes
How many Azure SQL DB Hyperscale HA replicas can be configured as of Sept 2026?
See possible answers