This stored procedure loops through each view and performs an action on that view, like counting or printing the records. Please install this stored procedure in the MASTER database. For full usage instructions and advanced parameters please see the article about it at http://www.sqlservercentral.com/columnists/bknight/sp_msforeachworker.asp. Shortened version of the usage (there are a lot more parameters […]
2002-06-14
2,090 reads
This script captures the current system lock in a temp table, then builds a temp translation table for database and object id by iterating through all of the databases. It then produces a report by joining the two tables.For better performance, you could make the translation table perminante and only update it when you are […]
2002-06-14
589 reads
I was looking over internet trying to find a SP or UDFto replace string accourences in the Text fields, I didn'tfind any so I created ths trigger, may be it will be usefull as example. Be aware on the big documents it can be time consuming.All it does is replacing < and > substrings of […]
2002-06-14
554 reads
Returns a single row with a single column containing a comma-separated list of the field names for a specified table. I find this very useful when doing INSERT statements where I have to list out each field being inserted. I simply bind this proc to a hotkey and use the hotkey to get the comma-separated […]
2002-06-12
1,301 reads
This is a stored procedure for viewing details of trigger. It accepts trigger name as a optional parameter. When specified, it shows details of only that trigger. If no trigger name is specified shows the details of all the triggers in that database. this SP is created in master database but can be called from […]
2002-06-12
344 reads
Perfect for finding developers that are changing your database accouts. This procedure can check the sysusers table for each database and\or the master..syslogins table for account changes. Gives the option of email notification, logging to a table or both. Update the set statements at the begining of the procedure to configure it however you like. […]
2002-06-07
533 reads
If select into clause is used into transactions till the transaction commits sysobjects table can not acceses directly.It can be accessed only with 'nolock' hint.
2002-06-07
1,093 reads
TSQL:Procedure to Lookup JobsJack Donnell,jack@JackDonnell.com Have you ever kept altering the same query to look for different items in you database?I took a hint from MS with all the sp_help and other system stored procedures and made a two scripts this one to query for databases scheduled tasks or jobs as they are now called.The […]
2002-06-07
2,298 reads
TSQL:Procedure to Query for Dependent ObjectsJack Donnell,jack@JackDonnell.com Have you ever kept altering the same query to look for different items in you database?I took a hint from MS with all the sp_help and other system stored procedures and made a two scripts this one to query for databases dependednt objects or references.I also created another […]
2002-06-07
710 reads
Monitor the long term growth of Many databases on Server-Create the table DbSizeTracking on database of choice-Create a job to run the script on weekly intervals-Query the table with section at end of script
2002-06-06
914 reads
A RAG pipeline that answers questions in the demo is not the same thing...
By Steve Jones
“A multitude of bad ideas is necessary for one good idea” – from Excellent...
Yesterday I gave a talk for MSSQLTips called “Building a DBA Agent for Your...
Telp/WA 62 821-8200-203 Menara Bidakara, Jl. Gatot Subroto No.Kav.71-73 Lt. Lobby dan Lt. 1,...
Telp/WA 62 821-8200-233 Jl. Melawai Raya No.Blok B, RT.7/RW.5, Kramat Pela, Kec. Kby. Baru,...
Telp/WA 62 821-8200-174 Wisma BCA Pd. Indah, Jl. Metro Pondok Indah No.10, RT.3/RW.17, Pd....
What types of secondary replicas are available for the Azure SQL Database Hyperscale edition?
See possible answers