This script will dump most of the structure of a DTS package to a text file. This includes connections strings (note SQL Server connections have their passwords encrypted so the won't dump), tasks, steps, global veriables, etc.) The script is command line drive and should allow for the use of trusted or SQL logins. I […]
2006-02-07 (first published: 2006-01-30)
414 reads
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)
146 reads
2006-02-01 (first published: 2006-01-27)
1,896 reads
2006-01-31 (first published: 2006-01-27)
165 reads
2006-01-30 (first published: 2006-01-27)
808 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)
321 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)
489 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,488 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)
630 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,786 reads
By James Serra
If you are migrating a data warehouse, there is a question worth asking before...
By Steve Jones
I’m back from a great vacation. I had the chance to visit two new...
Introduction I was experimenting with vector search in SQL Server 2025 using approximately 3.8...
Comments posted to this topic are about the item DML Trigger Types
Comments posted to this topic are about the item PostgreSQL in action with Opensearch
Comments posted to this topic are about the item Choose the Second One
How many types of DML triggers are there?
See possible answers