ADO.NET and SQLDMO

[tyreejp]

I've used the SQLDMO library in the past in a .NET program to scan the network for available SQL Servers running. I'm not the biggest fan of mixing .NET and COM. Does anyone know if there's anything built into the 2.0 Framework that has similar functionality?

tia

James

--
James

http://www.microsoftjr.com

 

[ThatRickGuy]

I don't know of any new solutions, but I wouldn't be that worried about mixing COM into .Net (going the other way can be a bit tedious though). A lot of the .Net library is just wrappers over the traditional COM layer anyways.

-Rick

VB.Net Forum forum796 forum855 ASP.NET Forum
I believe in killer coding ninja monkeys.

 

[BrianB]

Is it SQL 2K or 2K5?

Brian Begy
BugSentry - Automatic error reporting

http://www.bugsentry.com

 

[ThatRickGuy]

I've only used it from SQL 2K. I'm not sure if it's still avaible with 2k5 though. I had heard that there was some new solution in 2k5, but I have not used it to verify that.

-Rick

VB.Net Forum forum796 forum855 ASP.NET Forum
I believe in killer coding ninja monkeys.

 

[BrianB]

What about just scanning for servers open on 1433 to find your SQL boxes? Guaranteed to catch your network admin's attention.

Brian Begy
BugSentry - Automatic error reporting

http://www.bugsentry.com

 

[ThatRickGuy]

/shrug

Matters on the NA. Some might notice, many wouldn't. You can do the same thing from SQL Server Enterprise Manager, so it's not that big of a deal.

-Rick

VB.Net Forum forum796 forum855 ASP.NET Forum
I believe in killer coding ninja monkeys.