An easy way to created a quick record count of all the tables within a sql server database.
USE DATABASENAME
select
tb.name as TableName
,max (p.rows) as RecordCount
from sys.tables tb
inner join sys.indexes i
on tb.object_id = i.object_id
and tb.type = 'U'
inner join sys.partitions p
on p.object_id = i.object_id
and p.index_id= i.index_id
group by tb.name
order by RecordCount 
usp_ToggleDatabases is a simple procedure that will switch the names of two databases.One of the main problems with using sp_renamedb to switch databases is that the procedure will wait until the database is free before the rename can be completed. If the new live database is also in use then there is a likelyhood that […]
2005-08-04 (first published: 2005-07-28)
491 reads
We were experiencing significant issues with Cross Domain Log Shipping, even after getting help from Microsoft. The main reason was that in SQL Server 2000 you cannot access the Log Shipping Wizard from a scripting interface. This set of stored Procedures is all you need to setup a good log shipping framework in your organization […]
2005-08-01 (first published: 2005-07-18)
3,019 reads
Have you tried using DTS to load a database and those pesky foreign keys mess you up? This is actually two scripts, one to generate the SQL needed to drop all the Foreign Keys in a database and another to Add the Foreign Keys back when you are done. I've thrown in Disabling and Enabling […]
2005-07-13 (first published: 2005-06-22)
3,061 reads
2004-11-05 (first published: 2004-08-08)
1,697 reads
This procedure will execute, taking two parameters, (the 2 db names, and will then list out the major object and schema changes for you. It is pretty sraight forward and suggestions are appreciated. It's a good utility for a DBA to track changes after upgrades, etc.. Each portion is easily convertable to a stand alone […]
2004-08-02 (first published: 2004-07-16)
1,107 reads