Simple way to connect to SQL Server when you can't find server name

-
sometime you will get a window like above when you try to connect to the SQL Server 08 (didn't check it on server 05. I think this will work on that on as well.) and you have no idea what is the name of the server. Then you can press a ". "(dot without double quotes) and press connect then you will be able to connect to the server. Simple right. Hope This will help you.


  





Comments

Post a Comment

Popular posts from this blog

Deep dive into OpenXML Part 1

-
Image
Okay guys today I'm going to say about the Excel manipulation using the OpenXML. you can do various things using OpenXML and here I'm going to explain most important things you should know about OpenXML when comes to the Excel programming. okay then let's start. First of all go to visual studio and create a console Application. To work with OpenXML you need to add several Dlls to your project. so after you create the project then go to project reference and add following dlls.        1. DocumentFormat.OpenXml. you can download this dll from here .        2. WindowsBase okay now we are half there. now our project is ready to welcome the OpenXML. so let start coding and make some application.       so now we need to add a class called ExcelUtilities to put our common method which we are going to  use every time. so let's go and create that class and add those common methods and don't forget to add these namespaces t...
Read more

Deep dive into OpenXML Part 2

-
Image
So In the Deep dive in to OpenXML part 1 I showed you the common methods which we can use to generate an excel file. but most of you are not aware to use those methods so today i'm going to show you the way to use those method and generate an excel file.  for this exercise use a Console application project. Excel File Generator Class /// <summary> /// File Generator Class /// </summary> class FileGenerator { #region Variable Declaration /// <summary> /// Column Span for Grouping /// </summary> private const string ColSpanLine = "1:4"; private const string SheetName = "Sample"; #endregion #region Public Methods /// <summary> /// Generates the report. /// </summary> /// <param name="reportList">The report list.</param> /// <param name="fileLocation">Th...
Read more

Convert XML data to dynamic (ExpandoObject) Object

-
Image
public static IEnumerable<dynamic> GetExpandoFromXml(string file, string descendantid) { var expandoFromXml = new List<dynamic>(); var doc = XDocument.Load(file); var nodes = doc.Root.Descendants(descendantid); foreach (var element in doc.Root.Descendants(descendantid)) { dynamic expandoObject = new ExpandoObject(); var dictionary = expandoObject as IDictionary<string, object>; foreach (var child in element.Descendants()) { if (child.Name.Namespace == "") dictionary[child.Name.ToString()] = child.Value.Trim(); } yield return expandoObject; } }
Read more