In some cases, you may have to be able to quickly disable all the constraints and triggers in a database. This article shows you how to do this with a few lines of T-SQL.
2001-05-24
10,071 reads
This article will show you how to use the FileSystemObject to determine the existence of a file inside DTS.
2001-05-23
8,357 reads
Is there such a thing as a task where you would not need a cursor? Hidden in the depths of the master database are a series of stored procedures that can replace some cursors with these one-liners.
2001-05-22
14,252 reads
The case where one has to send the results of a query to a text file comes up quite often. This quick tip will show you how to output the results of a query to a text file.
2001-05-21
11,946 reads
An interesting database option which is hidden from Enterprise Manager in SQL Server 7.0 is offline.
2001-05-21
9,736 reads
In SQL Server 7.0 Data Transformation Services (DTS), dynamically configuring packages was difficult. With the aid of a new Dynamic Properties task in SQL Server 2000, this assignment is easy.
2001-05-18
12,266 reads
Global variables are a little known solution in Data Transformation Services (DTS). Often packages become "stale", where you must develop a package for each client.
2001-05-16
14,842 reads
In this article, we get you started with the core knowledge you'll need to transform your data using DTS.
2001-05-15
11,289 reads
In the latest release of SQL Server, Microsoft has added a number of new data types to expand the functionality of SQL Server.
2001-05-14
6,838 reads
Poorly managed SQL Server Security can not only leave your SQL Server vulnerable, but also leave your NT Server and network open to attacks.
2001-05-14
6,545 reads
By Steve Jones
I wrote about learning today for the editorial: I Can’t Make You Learn. I...
By ReviewMyDB
Fabric has CI/CD built in, but if you've tried to use it for database...
By Steve Jones
attriage – n. the state of having lost all control over how you feel...
WA:08218154393 Jl. Brawijaya No.8, Pocanan, Kec. Kota, Kota Kediri, Jawa Timur 64123
WA:08218154393 Jl. Jenderal Basuki Rahmat No.70-74, Klojen, Kec. Klojen, Kota Malang, Jawa Timur 65111
Comments posted to this topic are about the item SSRS Reminded Me of the...
In SQL Server 2025, I have a table (dbo.UserPermission) that contains this data:
UserID UserPermissions 15 23 37 4 NULLWhat is returned when I run this code:
select bit_count(UserPermissions) as PermissionCount from dbo.UserPermission where UserID = 4;See possible answers