April 3, 2016 at 11:59 pm
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.
April 4, 2016 at 12:48 pm
Hope you can find some helpful here:
http://sqlity.net/en/1868/identify-sql-server-service-account-in-t-sql/
April 4, 2016 at 2:52 pm
If you have couple servers, you can execute "cliconfg.exe" from servers and go to Alias tab.
Thanks,
Jeegs
April 5, 2016 at 4:07 pm
I think you can use the (old) view "sysusers", "WHERE isaliased = 1" to find any aliases.
SQL DBA,SQL Server MVP(07, 08, 09) "Money can't buy you happiness." Maybe so, but it can make your unhappiness a LOT more comfortable!
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply