Script All Object Permissions
Quick and dirty script to generate the required SQL to reinstate permissions on each user object. This can be saved off for DR purposes.
2002-09-24
458 reads
Scripts
Set All databases to DBO only and Single User Mode
Every want an easy way to set all database to DBO only and single user mode? Well here is a script to do that for you. This script is useful when you want to keep users out of the all the databases.
2002-09-23
1,328 reads
Turn off DBO and Single User mode for all DB's
Here is a companion script to "Set All databases to DBO only and Single User Mode" that will turn off dbo and single user mode for all databases.
2002-09-23
519 reads
Script To shrinking log file
for both 7.0 and 2000. It generates log table and triggers for main table.Its avaliable for all dbs on current server.
2002-09-21
686 reads
Script Database Objects
Others have asked for this throught the disussion threads so I thought others might benefit as well.This SQL-DMO script will create multiple files for server logins (SIDs & encrypted passwords), database users, tables, procedures and views.1. Alter the script to reflect your server and path for output files.2. Create the job (ActiveX Script).Be great!Michael
2002-09-20
1,209 reads
Script to gain capacity information
Recently at my site we had a need to gather current capcatiy of all databases as well as table obejcts on our servers. although there are some out of the box stored proceudres to assist in this effort as well as some schema objects, they mostly would return information on one database at a time. […]
2002-09-20
285 reads
DTS package to read status of all jobs
This DTS package reads a list of servers from an XML configuration file, connects to each server, and writes a list of all failed jobs to a web page on the web server. Each morning, I just need to open my browser and I can see the status of all 42 of our servers.
2002-09-19
695 reads
Script All Jobs
We utilize this to script our jobs on a scheduled basis. The main advantage is that it is automated and really comes in handy when there is a large number of jobs.1. Create a job; ActiveX Script.2. Paste the code; change the server/path to your desired values.
2002-09-19
907 reads
Sp to enable, disable or list all Triggers in DB
This one is For SQL 2000.This SP enable,disable or list all the Triggers in the given database.If enable or disable are specified, finds all the triggers of all the tablesand enable or disable them, After that, it list all the triggers with it´s current state.If List is specified, then it only list the triggers with […]
2002-09-19
700 reads
SP to get Trigger and Table info
It is a very simple but useful SP to get Trigger and related table info especially on databases having large number of tables.
2002-09-19
344 reads
Blogs
Building AgentDBA’s Slack Escalation
By Arun Sirpal
Until now, a CRITICAL finding did the right internal routing, but the last mile...
Changing the Owner Removes Permissions: #SQLNewBlogger
By Steve Jones
This is actually inspired by an article SQL Server Central, which taught me something...
T-SQL Tuesday #200 - I Bet It's Bad if I See...
By alevyinroc
T-SQL Tuesday is a monthly blog party hosted by a different community member each...
Forums
Developer edition cannot connect from other computers
I installed a new SQL server 2025 Enterprise developer edition for our development environment....
ALAMAT BCA KCU PONTIANAK TLP/WA 08218200174
Telp Cs:(0821)8200174 Jl. Jenderal Ahmad Yani No.1, Benua Melayu Darat, Kec. Pontianak Sel., Kota...
ALAMAT BCA KCU TANJUNG PANDAN TLP/WA 08218200174
Telp Cs: (0821)8200174 Jl. Jend. Sudirman No.17, RT.008/RW.04, Pangkal Lalang, Kec. Tj. Pandan, Kabupaten...
Question of the Day
Moving the Error Log
How can I change the location in which the SQL Server error log is written in SQL Server 2025?
See possible answers