Get All Foreign Key names and Tables referenced
This script lists all the foreign keys ,the referenced and the referencing tables , along with the column information.
2007-07-09 (first published: 2006-10-04)
312 reads
This script lists all the foreign keys ,the referenced and the referencing tables , along with the column information.
2007-07-09 (first published: 2006-10-04)
312 reads
to figure out space used by tables. I have seen different versions of them .. here is a very simple effective one!!!
2003-04-28
90 reads
It is a painful experience for all us administrators to truncate logs regularly. I just created a job to executesp_msforeachdb "use ?; backup log ? with truncate_only ; dbcc shrinkfile(2,5)"on all the servers at frequent intervals. It has saved me a lot of time. hope it helps you too.n.b: I assume that file id 2 […]
2003-04-18
314 reads
By Steve Jones
As I’ve been working with SQL Saturday and managing changes to events, I’ve accumulated...
By James Serra
Starting last week is a rollout of the public preview of a new and...
Let's get one thing straight: database administration isn't the most glamorous tech job out...
I am working on a data warehouse project for a bakery. For the most...
I am working on a data warehouse project for a bakery. For the most...
Hi I want to create a copy of a DB on the same server....
How can I restore a version of the Resource Database in SQL Server 2022?
See possible answers