Introduction:SQL Server 7.0 introduced a new class of functions that return a wide range of property information that isn't readily available in SQL Server 6.5 and earlier versions. These functions have three general classes: TypeProperty, which returns information about a data type; ObjectProperty, which returns information about objects in the current database; and ColumnProperty, which […]
2002-07-19
163 reads
This is a VBScript that can be placed in an ActiveX Script Task. The purpose of this script is to mark other tasks in the DTS package as complete before they execute. In this way you can ensure a task does not execute.The Dim and Set lines give you access to the objects in the […]
2002-07-18
259 reads
A function to enctypt a string good for hiding passwords in the database comparing password is done via the PWDCOMPARE function
2002-07-18
1,114 reads
a Basic Example of how to use TEXTPTR and updatetext in T-SQL to MANIPULATE text columns
2002-07-18
948 reads
a Procedure to get the SQL sid for a Login either SQL standard or WINDOWS authenticated
2002-07-18
1,040 reads
Uses the system relatively Undocumented sp sp_MSguidtostr to do the conversion from a GUID to a string
2002-07-18
374 reads
there are 2 extended STORED PROCEDURES xp_dirtree will get the directory name and nesting level from a given parameter root directory xp_subdirs will get the directories list in the first sub level from a given parameter root directory
2002-07-18
941 reads
This script will list all columns, their datatypes, and sizes from any database. It can be very useful for contractor DBAs who need to quickly scan all tables, and very helpful for developers, or when you just need a quick list of fields for a meeting.
2002-07-12
1,333 reads
This script kills all the processes using a given database. It is useful for removing users from a database so it can be restored.To use this script change the server variable and the database variable at the top of the script. Notifications are written to the windows application eventlog.Use this script at your own risk. […]
2002-07-12
1,129 reads
Here's a script that will read a text file from the Windows system into SQL Server
2002-07-11
1,136 reads
By Steve Jones
dorgone– adj. wondering if you could slip away from an event or group conversation...
By ReviewMyDB
Many of us use AI the same way every single day. Open a tab....
By SQLPals
SQL Server Transaction Log Forensics: Preserving Evidence During an Incident SQL...
Comments posted to this topic are about the item Make It Routine
Comments posted to this topic are about the item Finding Gaps in Sequential Data...
Comments posted to this topic are about the item Negative and Positive Numbers
If I want to know whether a number of negative, positive, or zero, what is the easiest way to get this in T-SQL?
See possible answers