'The only way to do this in SQL 2005 is by running a trace. '

I'm not sure, but I recall having read somewhere, that Profiler does not catch every SQL-Statements,...

This thread is very educational, and it puts me into trouble: I'm busy looking at all the loops used and trying to make them SET-based. Challencing, but there is more...

It could be you have to qualify the object if schema is NOT dbo.

Supposing you have the Adventureworks db attached, you should get results with this:

exec sp_depends 'person.contact'

If not, then...

You use sp_depends 'ObjectName'. This will get you all dependancies

If you wish to tailor the output to your specific needs place it in a (temporary) table.

Mind, there are other ways...

This how you get the tables with identical columns into a temporary table:

/****** Object: Table [dbo].[Table_1] Script Date: 06/10/2009 11:58:22 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

CREATE TABLE...

Jeff,

I tried to run your query. You join with a table PatientProfile, but there is no such table. Could you provide this table with some data? Are there other missing...

I'm flabbergasted: many respondents give advice on SQL2005=>SQL2008 upgrade; another 1 gives advice on a Cluster installation... The discussion is about SQL2005SE to SQL2005EE, are we?!?

I really wonder what finally...

Hi Mike,

These things are indeed going to be looked into, but not on a ad-hoc basis. The configuration of the SQL Servers leaves a lot to be desired.

Tnx for answering, it's clear now. Very instructive, both your posts.

Tnx for answering Steve. I think I got the info, tho I am still more happy with actual numbers.

Tnx again.

Villersk, but do you set autogrow per FILE or FILEGROUP? It's clear what you say, but I still have the impression FILEGROUP is a convenience, not a neccessity.

Tnx for answering...

Tnx for answering all, this is instructive.

Nilmov, this doc was the first I downloaded, it left a lot of questions with me...;-)

Jonathan, I will follow your BLog with interest; the...

Hi Gila, Paul,

I am not at work(obviously!) so I have to do this from memory:

First of all, a quick(&dirty)solution was needed. A correction: there is a primkey defined, so it's...

I have no time now to go into this, but you might wish to take a look at the function ROW_NUMBER(). Here is an excellent article on the subject:

I know, I have ordered his book?

Manager:'Why do we need it?'

DBA: 'Because we lack the knowledge'

M:'But...isn't that why we hired you?'

DBA:'As you recall you hired me for these specified tasks...