How to know the server name of SQL Server? -


is SQL Server 2008 R2 on my machine. I want to connect with Windows authentication mode I do not remember the server name .... I have also tested in SQL Server Configuration Manager but if no instance is running, how do I know the service name of SQL Server?

have you tried

  SELECT @@ SERVERNAME    

Comments

Popular posts from this blog

Pass DB Connection parameters to a Kettle a.k.a PDI table Input step dynamically from Excel -

multithreading - PhantomJS-Node in a for Loop -

c++ - MATLAB .m file to .mex file using Matlab Compiler -