Object Dependencies

Technical Article

Object dependencies in xml format

  • Script

Most of the people know about the right-click option 'View Dependencies' in the SQL Management Studio.
It will diplay expandable tree off all dependencies each way. Correct me if I'm wrong, but I couldn't find any other way to save this othere than taking a screenshot of the window.

You rated this post out of 5. Change rating

2014-07-21 (first published: )

903 reads

Technical Article

RE: What is for Unused space for MDF and LDF?

  • Reply

Hi,First check your log file with the command in Query Analizer in your database:DBCC LOGFILE If the last record in column "STATUS" have the value 0 than pass the command:DBCC SHRINKFILE('DATABASELOGNAME',100) where'DATABASELOGNAME' is the logical name of your log file 100 - is the space that you want to have your LOG file in MB.If […]

You rated this post out of 5. Change rating

2004-04-13

Blogs

Small Data SF 2024

By

I can’t remember how I heard about Small Data SF 2024, but it caught...

A New Word: Moledro

By

moledro – n. a feeling of resonant connection with an author or artist you’ll...

Snowflake + Azure blob

By

Let’s go back to data platforms today and I want to talk about a...

Read the latest Blogs

Forums

7 sept, scheduled book

By philip.scott

Comments posted to this topic are about the item 7 sept, scheduled book

7 sept, schedlued article

By philip.scott

Comments posted to this topic are about the item 7 sept, schedlued article

6 sept, published book

By philip.scott

Comments posted to this topic are about the item 6 sept, published book

Visit the forum

Question of the Day

Azure Data Lake Storage Gen 2

Azure Data Lake Storage Gen 2 is built on ...?

See possible answers