Get List of .NET Assemlies

Question

Get List of .NET Assemlies

osama-240238

SSC Veteran

Points: 282
More actions
August 28, 2005 at 7:28 am

#187238

How to get List of all .NET Assemplies in SQL server 2005
I mean By All Assemplies ,the assemplies which I create before
ex: create assemly xxx from ''

thanks

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply

Srinivas Sampath SSChasing Mays Points: 606 More actions · Answer 1

All assembly information is stored in the following system tables: sys.assemblies and sys.assembly_files. You can get information about the various files uploaded, security permissions etc.

HTH,

Srinivas Sampath

HTH,
Srinivas Sampath
Blog: http://blogs.sqlxml.org/srinivassampath

Chris Hedgate One Orange Chip Points: 25041 More actions · Answer 2

All assembly information is stored in the following system tables: sys.assemblies and sys.assembly_files

Just a small remark: system catalog views, not tables. SQL2K users should not confuse them with the system tables found there.

--
Chris Hedgate http://www.hedgate.net/
Contributor to the Best of SQL Server Central volumes
Articles: http://www.sqlservercentral.com/columnists/chedgate/

Srinivas Sampath SSChasing Mays Points: 606 More actions · Answer 3

Thanks for the correction. Yes, they are system catalog views, not tables.

HTH,

Srinivas Sampath

HTH,
Srinivas Sampath
Blog: http://blogs.sqlxml.org/srinivassampath

osama-240238 SSC Veteran Points: 282 More actions · Answer 4

Thanks all_

It is very nice from you to help me.

can any one tell me the best way to study sql server 2005 ,I'm a sql server 2000 user and I develop my work using C#,,,,, any books , articles ,any suggestion. (i just as a start want to know how to do what i was doing with sql server 2000 and then i want to know the new features)

Great thanks to you all

Chris Hedgate One Orange Chip Points: 25041 More actions · Answer 5

There is not really anything out covering the product as a whole (will there ever be?). Kalen Delaney will of course have an Inside SQL Server 2005 (three volumes actually), but it will not be out until RTM and later. Depending on what work you do and what features you are looking for there are some good books out already though. "A First Look at Microsoft SQL Server 2005 for Developers" by Bob Beauchemin et. al. is very good, although it is written for Beta 2 so it is somewhat old now.

The best thing you can do is to simply play around with the product for yourself. Work through the tutorials in BOL if you do not know where to start.

--
Chris Hedgate http://www.hedgate.net/
Contributor to the Best of SQL Server Central volumes
Articles: http://www.sqlservercentral.com/columnists/chedgate/