Raul Garcia - MS


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





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

Jack richins


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







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

Satya SKJ

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 .





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

Raul Garcia - MS

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






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

Satya SKJ

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.





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

Satya SKJ

Raul

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






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

Rob Walters - MSFT

We have not recieved any additional comments with regard to the removal of aliases.




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

Michael Hotek

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.




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

aNiall8

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.





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

Sue Hoegemeier

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


-Sue





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

Satya SKJ

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




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

Raul Garcia - MS

They will be removed on the next release.

-Raul Garcia

SDE/T

SQL Server Engine






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

schelack

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





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

phe

I am fine with the change



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

Joe Webb

Agreed. No issues here with removing them from Katmai.