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,088 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,103 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
242 reads
Uses the system relatively Undocumented sp sp_MSguidtostr to do the conversion from a GUID to a string
2002-07-18
348 reads
this procedure gets a tableName,X axis column, Y axis column and a Value and draw a Pivot table from the Original Table Script also include an How to Use section
2002-07-15
1,360 reads
This script creates a stored procedure to shrink the transaction log in the database it is created in. The stored procedure shrinks each transaction log file in the database, to the size specified.
2002-07-14
681 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,103 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,317 reads
This script will do a full backup and transaction log backup of all the user database on the primary server and restore it over to the secondary server. The full backup/restore runs once every day and the transaction log backup/restore runs every minutes. Just provide the name of the primary and the secondary server and […]
2002-07-12
508 reads
Hello,Here is a (another one, but improved) stored procedure that returns rowcounts for all tables in the current database, or only for @tablename, if provided. Output can be ordered by name or by number of rows.Improvement : Rowcount is right aligned and formatted with thousand separator.To use it : - open a connection on your […]
2002-07-11
317 reads
By Steve Jones
dolorblindness – n. the frustration that you’ll never be able to understand another person’s...
By Steve Jones
I had a customer ask about analyzing their Test Data Manager (TDM) usage to...
By Steve Jones
I had an idea for an animated view of a sales tool, and started...
Comments posted to this topic are about the item Optimism Without Illusion or Why...
Hi all, I'm trying to do classic scenario for loading multiple Excel files into...
Hi So the case statement is slowing this down - but for the life...
In SQL Server 2025, what is returned by this code:
SELECT EDIT_DISTANCE('tim', 'tom')
Assume preview features are enabled. See possible answers