Request for feedback - Aliases have been deprecated for some time and will be removed soon

As documented in SQL Server BOL, aliases have been deprecated for some time and we are planning to remove them from the product in the next release.

We will greatly appreciate any feedback or comments regarding this change. We would like to know how our customers will be affected by this change and analyze if there is anything we can do to help you to make the transition easier.

Thanks a lot,

-Raul Garcia

SDE/T

SQL Server Engine

We are also planning on removing the following stored procedures in the next release:

sp_addgroup, sp_dropgroup, sp_changegroup, sp_helpgroup

Thanks,
Jack Richins
SDE
SQL Server Engine

|||Removing entirely from the SQL server may not be an option, will there be any documentation or MS article released to enable the new users to understand the 'new' concept in addition to BOL .|||

Alias were superseded by roles in SQL Server 2000, for more information you can visit the following BOL pages:

· Deprecated Database Engine Features in SQL Server 2005 (under “Features Not Supported in the Next Version of SQL Server” ): http://msdn2.microsoft.com/en-us/library/ms143729.aspx

· Create User (TSQL): http://msdn2.microsoft.com/en-us/library/ms173463.aspx

· Create role (TSQL): http://msdn2.microsoft.com/en-us/library/ms187936.aspx

Hopefully these links will help on the migration process to use roles, and it will also help to clarify the nature of the planned change in the next release of SQL Server.Thanks a lot, for your feedback.

-Raul Garcia

SDE/T

SQL Server Engine

|||Raul
Appreciate your links in this case, I will ask my users to understand to have more information and post back if any further details are required.

Thanks.|||

Raul

Have you had any feedback in this regard, would like to know more about it.

|||We have not recieved any additional comments with regard to the removal of aliases.|||I haven't run across a customer using aliases for a VERY long time. I don't see any issues with removing them as far as any of my customers are concerned.|||

I have not seen aliases in a very long time - I would have to go back to my SQL Server 6.5 days. I look after 70+ production SQL Server (6.5,7, 2000, & 2005) and will lose no sleep on this.

|||

I haven't seen them at any site in the past few years at least.

-Sue

|||So they will be removed in next release of SQL or service pack?|||

They will be removed on the next release.

-Raul Garcia

SDE/T

SQL Server Engine

|||

Removal would be a good thing as I get too many questions from junior developers about what I should and should not be using.

|||I am fine with the change|||Agreed. No issues here with removing them from Katmai.