This script loads from a formatted text file (E.g. tab delimited) with variable number of columns using BULK INSERT. For instance, the file may have any number of columns and next load (seconds later) the same file may have a different number of columns. This script reads the first line (column names) extracting the names […]
2005-03-01 (first published: 2003-06-30)
994 reads
This article by James Travis details the differences between IS NULL and = NULL. He also discusses the ANSI_NULLS setting.
2008-02-22 (first published: 2003-06-17)
143,713 reads
This procedure displays all user-defined datatypes in all databases on a server. Another example of the power of dynamic T-SQL, this procedure dynamically generates SELECT statements for the systypes tables in each database and UNIONs them together so that they display in one recordset.
2003-05-30
176 reads
A lot of table pivoting scripts use cursors to reach the desired results, but SQL scripting was developed to be utilized in a data set environment rather than sequential step-thru scripting.Normally, there are 3 types of Table Pivoting - 1) column explicit 2) column implicit and 3)single column. COLUMN EXPLICIT will place the row value […]
2003-05-29
437 reads
Use SQL's own method to get the current DBName, no function needed.
2003-05-27
1,107 reads
We're pleased to announce that Robert will be writing for us each month - generally on stored procedures, but occasionally on a different topic. This article discusses how nesting stored procedures works and how to use @@NextLevel. Good reading! If there is a stored procedure topic you'd like to see covered, add a comment to the article or email us at articles@sqlservercentral.com
2007-05-18 (first published: 2003-05-23)
53,637 reads
If you have environment where you restrict access to database objects based on user roles and if you have a lot of databases on different servers in the same domain. The following script can generate roles from a given database in a format that can be used to create roles on different servers where the […]
2003-05-14
205 reads
Very frequently I used to use sp_help to find column names, datatypes and length of datatypes. Sp_help outputs a lot of data which i really don't require to see. so I devised this script
2003-04-30
106 reads
If you ever have been put in a situation where your database has a lot of objects and some of those do not have primary keys, trying to find feels like needle in the haystack. I have modified the script contributed by Mr.Tandrei and Mr.Rahul sharma. The following script gives all the tables that do […]
2003-04-17
148 reads
Copies the permissions from an existing database user to a new database user.Usage:exec copy_permissions_for_database 'From_User', 'To_User'* From_User must exist in the database.* To_User must not exist in the database.* To_User must exist as a login on the server.I used http://www.sqlservercentral.com/columnists/awarren/sqlpermissionspublicrole_2.asp as a starting point.
2003-04-14
1,890 reads
Introducing azsql-migration-test, a small open-source CLI that validates your Azure SQL Database migrations against...
By DataOnWheels
I have been asked many times about how the name “Data on Wheels” came...
Fabric inbound network protection involves two tenant-level controls: Private Link and Block Public Internet...
WA CS (08218154392) Kawasan Pusat Niaga Terpadu Blok A No. 8 F, Jl. Daan...
WA CS (08218154392) Jl. Imam Bonjol No.18, RT.001/RW.003, Karawaci, Kec. Karawaci, Kota Tangerang, Banten...
Comments posted to this topic are about the item AI Observability Challenges in FinOps...
Where do I check for the existence of a Database Master Key (DMK) in SQL Server 2025?
See possible answers