Home > SSIS Best Practices > All About SQL Server

All About SQL Server

— AllAboutSQLServer.sql

select @@version

or:

–1.
select * from master.sys.sysservers where srvid=0

–2.
SELECT SERVERPROPERTY(‘InstanceName’)

–3.
SELECT SERVERPROPERTY(‘productversion’), SERVERPROPERTY (‘productlevel’), SERVERPROPERTY (‘edition’)

–4.
sp_helpserver

–5.
select @@SERVERNAME

–6.
SELECT * FROM SYS.SYSSERVERS

–7.
SELECT * FROM SYS.SERVERS

–8. Assuming the default isntance is MSSQLSERVER
EXECUTE xp_regread @rootkey=’HKEY_LOCAL_MACHINE’,
@key=’SOFTWARE\Microsoft\Microsoft SQL Server\Instance Names\SQL’,
@value_name=’MSSQLSERVER’

Categories: SSIS Best Practices
  1. No comments yet.
  1. No trackbacks yet.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: