List registered assemblies

Hi,

It's possible to register an assembly in SqlServer 2005 using the

CREATE ASSEMBLY

syntax.

How can I get a list of assemblies that have been registered?

Thanks

Herbj?rn

Select * from sys.assemblies ?

HTH, Jens Suessmeyer.

http://www.sqlserver2005.de

List of IP Address

Hi, all Gurus
I want to get list of IP address of all servers registered in my server
group
How can I get this
Thanks
AM wrote:
> Hi, all Gurus
> I want to get list of IP address of all servers registered in my
> server group
> How can I get this
> Thanks
You can ping each server from the console and see the IP address (the
server will have to be listening on TCP-IP). From console:
ping <server_name>
David Gugick
Imceda Software
www.imceda.com

List of IP Address

Hi, all Gurus
I want to get list of IP address of all servers registered in my server
group
How can I get this
ThanksAM wrote:
> Hi, all Gurus
> I want to get list of IP address of all servers registered in my
> server group
> How can I get this
> Thanks
You can ping each server from the console and see the IP address (the
server will have to be listening on TCP-IP). From console:
ping <server_name>
David Gugick
Imceda Software
www.imceda.com

List of IP Address

Hi, all Gurus
I want to get list of IP address of all servers registered in my server
group
How can I get this
ThanksAM wrote:
> Hi, all Gurus
> I want to get list of IP address of all servers registered in my
> server group
> How can I get this
> Thanks
You can ping each server from the console and see the IP address (the
server will have to be listening on TCP-IP). From console:
ping <server_name>
David Gugick
Imceda Software
www.imceda.com

List both SQL2000&2005 instance using SQLDMO

I have C++ application which can list all registered SQL Server in your local machine. The problem is this app can't list SQL server 2005 instance.

How can I list both SQL2000 and 2005 server instance using SQLDMO?

Thanks

Have you installed the SQL 2005 workstation components? There is an updated version of SQLDMO which supports SQL Server 2005. The DMO dll's that came with SQL Server 2000 won't be able to read SQL 2005 server information, but the 2005 DMO dll's should solve your problem.