How to find out if any user aliases are being used on SQL Server instance?

Question

Post reply

How to find out if any user aliases are being used on SQL Server instance?

Roust_m

SSCoach

Points: 17410
More actions
April 3, 2016 at 11:59 pm

#312908

Hi,
I am planning to upgrade from SQL 2008 R2 to SQL 2014. User aliases have been discontinued in SQL 2012.
Is there a query to find out if any aliases are being used?
Thanks.

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

devontarkan SSC Journeyman Points: 96 More actions · Answer 1

Hope you can find some helpful here:

http://sqlity.net/en/1868/identify-sql-server-service-account-in-t-sql/

Managed VPS India :: Dedicated Server :: Windows VPS India

Jeegsjaan Grasshopper Points: 13 More actions · Answer 2

If you have couple servers, you can execute "cliconfg.exe" from servers and go to Alias tab.

Thanks,

Jeegs

ScottPletcher SSC Guru Points: 101105 More actions · Answer 3

I think you can use the (old) view "sysusers", "WHERE isaliased = 1" to find any aliases.

SQL DBA,SQL Server MVP(07, 08, 09) "It's a dog-eat-dog world, and I'm wearing Milk-Bone underwear." "Norm", on "Cheers". Also from "Cheers", from "Carla": "You need to know 3 things about Tortelli men: Tortelli men draw women like flies; Tortelli men treat women like flies; Tortelli men's brains are in their flies".