Execute at source, and will generate an output with TSQL commands to create temp tables filled with top 50 long lasting queries from all databases.
Then execute output at destination and will do the same and show comparison of matching queries!!
2016-12-19 (first published: 2016-12-06)
917 reads
This script exports to a text file the creation text of the stored procedures of your database. If you want, you can change the script to export the text of views or functions.
2004-03-29
561 reads
With this function you can recover from your table all the password save encripted with another function posted before (check this site to find the script). The function recieves an encripted password and changes every character to return the right password.
2004-03-18
604 reads
If you need to save password for you application in tables, with this function you can save them encripted. And with another published function (check the page to find the script) you can desencript it. The function receives the password, modifies every character and returns the encripted password.
2004-03-18
654 reads
Like sp_who2 but this one let's you specify to filter by spid, login, hostname and dbname.Like any system procedure, can be executed from any database.
2004-03-18
9,713 reads
This function allows you to capture the next valid error number to use in the sp_addmessage sp. No matter hoy much user errors you have define, you will always get the next available error number.
2004-02-27
162 reads
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
757 reads
This sp translate all the numeric info from sysindexes and translate it into text. Also, can generate a log file to later view.Is like the one I posted before, but this one is for SQL 2000.
2002-09-17
885 reads
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 it current state. I didn't […]
2002-09-16
673 reads
Similar to the script posted before, but this one is for system tables with indexes, not for user tables.
2002-09-13
771 reads
By Steve Jones
We’ve celebrated our birthday many times at Redgate. In the Book of Redgate –...
Discover how Palantir connects enterprise data, supports AI-driven decision-making and helps companies turn insights...
Palantir is an American software platform that brings together business data from different sources...
Comments posted to this topic are about the item Pay for Performance, which is...
WhatsApp:0817819444 Jl. Kalimantan No.76 Kavling, Blok RV 55B, Wonorejo, Yosowilangun, Kec. Manyar, Kabupaten Gresik,...
WhatsApp:0817819444 Jl. Panglima Sudirman No.35, Baturetno, Kec. Tuban, Kabupaten Tuban, Jawa Timur 62314
If I have a SQL Server Server Audit setup, what are my options for configuring the instance in the event it can't write to the audit log?
See possible answers