List SQL Server Jobs
This script list all SQL Server Jobs with schedule details. One will not need to go to the enterprise manager and verify each job properties just to get the scheduled frequency for each job.
2003-01-31
1,159 reads
Maintenance and Management
#sp_shrinkdata
Unlike shrinking transaction log, shrinking a data file seems to be tough. A lot of people complained about the "shrink database" option in EM not working, or DBCC SHRINKDATABASE not working, or DBCC SHRINKFILE not working. I have found that a data file will eventually shrink given enough try, time and patience. I've put everything […]
2003-01-14
414 reads
Inherriting objects from an updated MODEL database
If new objects are created in the model database then these new objects only get created for new databases.Similarly, if objects are removed from user databases then getting them back into the database can be a pain.The following two stored procs copy objects from model to the current database if they do not already exist.
2003-01-10
43 reads
Generate "insert" script
You can use it when you want to generate a script which can insert data row by row.
2002-12-31
418 reads
Copying Backups using XP_CMDSHELL
This script is designed to backup the database, and copy it over the network to our backup server. The requirement for this particular database is 7 days of data kept on the LAN. The share on the backup server is mapped to the Y:\ drive. The datename function is used over the datepart function for […]
2002-12-08
368 reads
Setting permissions (Updated: UDF's now set)
Here is a script I wrote to automate updating of permission on a database. Often running as sa I forget to set the rights for objects when distributing db objects. It provides the capability to process only certain object types, and whether or not to print and execute the persmissions change or just print out […]
2002-11-22
453 reads
Grant/Revoke EXEC permissions for all procs in DB
Useful in dev environments when you need to periodically assign execute permissions on all procs in a db (drop/create scripts may have been run without re-assigning permissions)Accepts DB name, ProcLike for matching 'starts with' pattern against proc names in DB, revoke (optional - defaults to 0/True) specifies wheter to GRANT or REVOKE permissions
2002-11-21
401 reads
DBA_EverywhereRun
Runs a SQL statement against each database based on a LIKE pattern for the name of the database.Features:* IsLike and IsNotLike parameters let you specify both a matching pattern and an exclusion pattern for the database name.* Script_Only mode generates the script of what the stored proc executes. Especially useful for DDL statements.* List_Only mode […]
2002-11-14
399 reads
sp_kill
This stored proc has helped me a lot when I needed to restore db, reconfigure replication, and do other database jobs. SQL server KILL command can only act on a single spid. This sp compiles KILL commands in a cursor to kill a group of spids based on database name, login name, host machine name […]
2002-11-11
6,138 reads
Extract Images from SQL Database
This is a VBS script that will extract images from a Microsoft SQL database and create a individual file for each image. The script utilizes two important utilities: isqlw and textcopy (both standard executables that come with Microsoft SQL Server).
2002-11-07
1,733 reads
Blogs
Upgrading SQL Server Containers on the Laptop
By Steve Jones
I don’t have SQL Server installed on my laptop. In an effort to keep...
How to Find Expensive Queries in Amazon Redshift
Slow-running queries can degrade your Redshift cluster’s performance and lead to increased costs. Identifying...
The Notification Trap: How Input Fatigue Is Killing Deep Work in Tech
By gbargsley
If you've been here before, you know this blog is usually about SQL Server,...
Forums
Layanan wa cs Qlola bri
Segera hubungi WhatsApp 08136035412 untuk bantuan QLola BRI. Dapatkan solusi cepat tanpa harus menunggu...
Nomor qlola bri
QLola BRI Anda bermasalah? Hubungi WhatsApp 08136035412 untuk mendapatkan bantuan profesional dengan proses yang...
Nomor cs qlola bri berapa
Untuk bantuan QLola BRI, silakan hubungi WhatsApp 08136035412. Melayani kendala akun, transaksi, dan informasi...
Question of the Day
How Long is a Long I/O?
In SQL Server 2025, a long I/O is recorded in the error log with message 833. How long much an I/O request be outstanding before this message is written to the log?
See possible answers