The Wayward Programmer

Information on .Net, SSRS, SQL, SharePoint, SSAS, SSIS, etc.

December 24, 2010

Display all SQL Server's on a Network

cd C:\Program Files\Microsoft SQL Server\90\Tools\Binn
sqlcmd -L

Posted by: Wayward Programmer at 11:15 AM

Email This BlogThis!Share to Twitter Share to Facebook Share to Pinterest

No comments:

Post a Comment

Newer Post Older Post Home

Subscribe to: Post Comments (Atom)

About this blog

Labels

.Net AD LDS BDC Conversion CROSS APPLY Row Color SEO SharePoint 2007 SQL SQL Server 2005 SSRS T-SQL Types WCF Ria Services WCF Services Web Services Windows 2008

Blogroll

MSDN Code Gallery
MSDN ASP.Net

Pages

Home

December 24, 2010

Display all SQL Server's on a Network

cd C:\Program Files\Microsoft SQL Server\90\Tools\Binn
sqlcmd -L

Posted by Wayward Programmer at 11:15 AM

No comments:

Post a Comment

Newer Post Older Post Home

Subscribe to: Post Comments (Atom)

Popular Posts

Cross Apply and Outer Apply

The APPLY operator allows you to return values from an outer table much like JOIN, however I find it's easier to read, and allows joinin...
TSQL Max and Over Clause

You can use the MIN, MAX, AVG and COUNT functions with the OVER clause to provide aggregated values on multiple rows. For instance: SE...
Motivation

This is a brief departure from my usual cut and dried format, but I thought I'd post about something a bit different today. This past ...
SQL Try Catch

What is TRY… CATCH? The TRY... Catch construct was designed to improve the functionality in processing errors. With it comes a cleaner and...
Search Engine Optimization

Use precise Keywords. i.e. Load - Bank Loan, Student Loan, Equity Loan, etc. Order and placement of Keywords matters The relative distanc...
Bulk Import into AD LDS Using cvsde command line utiltiy

Discovered how to bulk import users into AD LDS by using cvsde command line utiltiy. Example: cd C:\Windows\System32 csvde -i -f c:\impo...
SSRS Row and Group Background Formatting

For Visual Stuido 2005: Select the whole row, open the "Properties" pane. In the Background property click the drop down box and...
BDC Security Overview

Security options available when using BDC: Authentication - verify a user is who he/she claims to be. Authorization - Determine if user i...
SSRS Issues attaching Reports to Email subscriptions

I was attempting to set up an email subscription on our production server the other day but kept getting errors when the subscription ran. ...
WCF Ria Services vs WCF Services

WCF RIA Services Pro’s: Service can be consumed easily from Silverlight, AJAX, and WebForms. (Not winforms(??)) Non-discoverable. Riche...

About Me

Wayward Programmer: Competed through Third Level Dressage. Microsoft Certified Technology Specialist in: SQL Server 2005 Business Intelligence, and Application Development and SharePoint 2007 Configuration.

View my complete profile

Blogger Templates

Subscribe

Posts

Posts

Comments

Comments

Travel theme. Powered by Blogger.