FIX: You receive an error message if you use the sp_addalias or sp_dropalias procedures when the IMPLICIT_TRANSACTIONS option is set to ON in SQL Server 2000 SP4

Consider the following scenario. In Microsoft SQL Server 2000 Service Pack 4 (SP4), you perform one of the following tasks: • You use the sp_addalias procedure to add an alias in the user database. • You use the sp_dropalias procedure to remove an alias from the user database.

Read More - Register for Free Membership