what is "DEPENDENCIES" folder in sqlserver table mean please.

[Dooston]

Hi Foilks , I know it s easy question. I know databases but not SQL dbase. Please explain if you can.
what is "DEPENDENCIES" folder in sqlserver table mean please?

Dosston

[rmiao]

Which tool do you use? In enterprise manager?

[skhanal]

Most probably it means all other database objects that reference this table.

[rmiao]

Yes in query analyzer's object browser.

[skhanal]

I would not trust sql server's dependency information. It queries sysdepends table and since SQL server allows you to create stored procedure referencing non existent table the information in not always correct.

Also if one stored procedure references another procedure then sysdepends is not good at tracking when one procedure is dropped and recreated

[Dooston]

Thanks guys I know now what the dependencies is in the query analyzer. 2 more questions:

1- what does the prefix "sp_pop" and "sp_sel" mean in a
dbo.sp_pop_NAME1 & dbo.sp_sel_NAME2
2- I need to learn sql server asap. Is there any site or
reference that you can recommend (free/not free) that can
expedite my learing process with SQl Server (only as a
user/developer, not a DBA)

Thanks

[skhanal]

Where do you see these procedures?. Are they in system databases or user databases?

Databasejournal has a SQL tutorial forum.

http://forums.databasejournal.com/forumdisplay.php?f=15

[rmiao]

No specific meaning, your developers just name stored procedure that way. By the way, sql books online has lot of good stuffs.

[Dooston]

Thanks guys.
By the way they are in user databases.

Dooston