<< Using Command Line Arguments in VB6 | Using T-SQL to get database name >>

Getting the SQL server instance name using T-SQL

by Joe Hunter 18. February 2010 17:47

Handy @@ function for getting the SQL server instance name using T-SQL:

SELECT @@servername

Tags: t-sql

Related posts

How to transfer the logins and the passwords between instances of SQL Server 2005 and SQL Server 2008Reference is here Now...how to put this into a stored procedure? T-SQL to drop all non-system databases in SQL server instance EXEC sp_MSforeachdb 'IF DB_ID(''?'') > 4BEGINALTER DATABASE ? SET SINGLE_USER WITH ROLLBACK IM...Exporting data from SQL Server to Access using a Linked ServerSo I found out the hard way that to export data from SQL Server to Microsoft Access requires that th...

Powered by BlogEngine.NET 1.5.0.7
Theme by Mads Kristensen