Simple Security String
Copy and paste this script into Query Analyzer and run it.Use this script to generate a simple security string of 0's and 1's.
2002-07-19
415 reads
Scripts
sp_dir - Procedure to list database objects
Lists objects from database. Similar to 'dir' command from DOS 🙂Typical usage sp_dir 't' 'order*', 1 - returns list of all tables whose name start with 'order' plus their columns and data typessp_dir 'p' 'custom*_sp' - returns list of all stored procedures whose name start with 'custom' and end up with '_sp'For list of […]
2002-07-19
521 reads
Example of How ti Use UpdateText and TextPrt
a Basic Example of how to use TEXTPTR and updatetext in T-SQL to MANIPULATE text columns
2002-07-18
962 reads
Example of How to use set IDENTITY_INSERT
a Basic example of how to manipulate an IDENTITY COLUMN AN HOW TO STOP the automatic counting using SET IDETNTITY_INSERT
2002-07-18
748 reads
Get computer Net Name in T-SQL
procedure is an extended xp called xp_getNetName to get the computer network identifcation name
2002-07-18
798 reads
Get session id by Login Name
a Procedure to get the SQL sid for a Login either SQL standard or WINDOWS authenticated
2002-07-18
1,050 reads
Get the entire directory structure in T-SQL
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
956 reads
Getting Information if a file exists in SQL
THERE is an extended sp called xp_fileexists given a full path to a file Name information is a 3 Bit vector 0/1 if a file doesn't/does exist0/1 is given name is a directory0/1 if the parent directory exists
2002-07-18
1,113 reads
How to Encrypt a password in T-SQL
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,118 reads
Mark DTS Task As Complete
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
264 reads
Blogs
A Pursuit of Lifelong Learning
By Brian Kelley
The following came across my YouTube feed today. It’s an interview with General James...
Advice I Like: Time and Focus
By Steve Jones
“You don’t need more time because you already have all the time that you...
Book Review: Microsoft 365 Copilot and Agent Administration Fundamentals
I don’t currently manage Microsoft 365 Copilot in an enterprise environment, but it is...
Forums
Alamat BCA KCP BSD Sektor I Telp:0821°8200°233
Telp/Wa 628218200233 Komp, BSD City, Ruko Barcelona, Blk. E9 No.30 RK No. 28, 29,...
Alamat BCA KCP Cikupa Telp:0821°8200°203
Telp/Wa 628218200203 Jl. Raya Pemda Blok R-1 No.07, dan No.08, Bojong, Kec. Cikupa, Kabupaten...
Alamat BCA KCP Borobudur Telp:0821°7555°651
Telp/Wa 628217555651 Jl. Borobudur Raya Blok M No. 36-37, Bencongan Indah, Kecamatan Kelapa Dua,...
Question of the Day
DML Trigger Types
How many types of DML triggers are there?
See possible answers