Searches SysComments for occurances of entered keywords and returns a list of procedures that contain the keywords. eg1) To find all procedures with 'nMyColumn' in EXEC utl_ProcSearch 'nMyColumn' eg2) To find all procedures with 'nMyColumn' in and 'nMyColumn2' in EXEC utl_ProcSearch 'nMyColumn', 'nMyColumn2' eg3) To find all procedures with temporary tables in... EXEC utl_ProcSearch '#' […]
2002-02-04
213 reads
The procedure looks at the table you want to be audited and writes the INS, UPD, and DEL triggers automatically required for the auditing to work. The auditing requires a table called Progress to hold the audit information in so have provided the DDL for this as well. Typically you would write a cursor to […]
2002-02-04
497 reads
It calculates log free space in mb and in percent for all databases, and also show the quantity of different objects for one databases.
2002-02-02
2,779 reads
I wanted to be able to use info about an operating system file in TSQL. So I wrote this stored procedure that uses the special stored procedures xp_fileexist and xp_getfiledetails. This can tell if a file or folder exists, and if it is a file what is its size, created date and time, last written […]
2002-02-01
1,277 reads
This stored procedure reads the file names from a directory and stores just the names in a given table. It returns also the number of files present. The sp uses xp_cmdshell and so permissions are restricted to sysadmins and SQLAgentCmdExec. You can test with the following: Create Table ##tmp2 ( fldx nvarchar(255) ) Declare @FilePath […]
2002-02-01
1,989 reads
XML support in SQL Server lives up to the hype that's always surrounded XML. Using SQL Server 2000, you can send queries over HTTP, save XML records to the database, and retrieve records via XML. This article shows how you can take advantage of these features in SQL Server 2000 by building a database entry system that keeps track of sales and customer information.
2002-01-28
1,740 reads
It is used to show information from a database. It shows the creation date, it calculates the time in days, months and hours since its creation and it shows all the users with rights in that database.
2002-01-27
2,192 reads
Script that executes DBCC Checkdb in all databases, creates a log file in c:\Checkdb\ in a folder with the current date, and a file with the format: DB_Date.log Also sends each log in an attachment by Email.
2002-01-27
6,257 reads
If you are like most DBAs, you have probably implemented some type of hash function for some of your tables at one time or another. This article takes a look behind the scenes as to how the Identity property works.
2002-01-17
6,521 reads
Displays the hit ratio of the buffer, procedure and log caches. Does not check for div by zero as I am lazy. Tested on SS2k (any SP).
2002-01-15
913 reads
By Vinay Thakur
As Open Source – PostgreSQL and AI is a growing and powerful DB system,...
By gbargsley
A New Chapter: Why I Made the Move from Dayforce to ESO Over the...
By Vinay Thakur
When you have a project or system, it has to be optimized, tuned, and...
Hub Cs:0817825533 Jl. Jendral Sudirman No.106, Imopuro, Metro, Kota Metro, Lampung 34111
Hub Cs:0817825533 Jl. Yos Sudarso No.100, Bumi Waras, Kec. Bumi Waras, Kota Bandar Lampung,...
Hub Cs:0817825533 Jl. Dokter Sutomo No.50-50A, Ps. Jambi, Kec. Ps. Jambi, Kota Jambi, Jambi...
I have a SQL Server 2025 database that I want to check for corruption every night. One of the things we do is disable indexes used for ETL loads during the weekend and re-enable them on Monday morning. If we run DBCC over the weekend, are our disabled indexes checked for consistency?
See possible answers