Tables referenced by a stored proc (2000)
This should find all tables referenced by an sp. It uses syscomments and hence has a wrap 'issue'.
2008-12-30 (first published: 2008-12-05)
1,065 reads
Scripts
How to Change all Table owner one in to another in sql server 2000?
we need change all user table db owners For selected database using T SQL we can easily use this method.
2008-12-29 (first published: 2008-11-30)
1,249 reads
Finding Execution Time of a SQL Statement
Capturing the execution time for rebuilding an index for set of tables.
2008-12-26 (first published: 2008-11-27)
1,740 reads
Deleting Duplicate Records
This article explains a simple solution for the common problem in MSSQL 7.0/2000, finding & deleting duplicate records from a table.
2008-12-24 (first published: 2008-11-26)
2,843 reads
2008-12-23 (first published: 2008-11-10)
2,970 reads
search every database on server from a single sp
i have recently had the need to search the every database on the server for a particular string.
i came up with this... it has lots of room for improvement but it works
2008-12-19 (first published: 2008-11-11)
1,035 reads
Generate CREATE DATABASE FOR ATTACH for all databases on server
I couldn't find a solid script for this so I put this together. It creates the database EXACTLY as it was with growth and proper file groups.
2008-12-18 (first published: 2008-11-14)
1,296 reads
2008-12-17 (first published: 2008-11-10)
2,717 reads
2008-12-17
123 reads
Backup and Truncate Transaction Logs
Save the transaction log and truncate the file to prevent Tlogs FULL Error
2008-12-16 (first published: 2008-11-17)
2,717 reads
Blogs
The Book of Redgate: Fun with Images
By Steve Jones
We’ve celebrated our birthday many times at Redgate. In the Book of Redgate –...
Why companies use Palantir and how we help implement it in the Czech Republic
Discover how Palantir connects enterprise data, supports AI-driven decision-making and helps companies turn insights...
Why companies use Palantir and how we help implement it in the Czech Republic
Palantir is an American software platform that brings together business data from different sources...
Forums
Pay for Performance
Comments posted to this topic are about the item Pay for Performance, which is...
Alamat BCA KCP Lumajang Hub/Wa. 0817-819-444
WhatsApp:0817819444 Jl. Panglima Besar Sudirman No.27, Tompokersan, Kec. Lumajang, Kabupaten Lumajang, Jawa Timur 67311
Alamat Telp BCA KCP Banjar Hub/Wa. 0817-819-444
WhatsApp:0817819444 Jl. Letjen Suwarto No.1A B-C, Hegarsari, Kec. Pataruman, Kota Banjar, Jawa Barat 46322
Question of the Day
SQL Server Audit Failures
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