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
123 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
227 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,090 reads
a Basic Example of how to use TEXTPTR and updatetext in T-SQL to MANIPULATE text columns
2002-07-18
900 reads
a Procedure to get the SQL sid for a Login either SQL standard or WINDOWS authenticated
2002-07-18
992 reads
Uses the system relatively Undocumented sp sp_MSguidtostr to do the conversion from a GUID to a string
2002-07-18
321 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
871 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,300 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,093 reads
Here's a script that will read a text file from the Windows system into SQL Server
2002-07-11
1,108 reads
By Steve Jones
One of the neat enhancements made to Flyway was the addition of state-based workflows...
I did a couple of posts previously on dumping/restoring Azure PostgreSQL databases and also...
By Brian Kelley
Most of us know that spending a lot of time on social media and...
our client wants to implement Third Party SQL Monitoring tool to monitor SQL server...
I have a powerQuery that reads and transforms a table in a PDF. Works...
Good Afternoon. I have a Table where each Record: 1) Represents an Appointment. 2)...