SQL Server also creates a row in the sysobjects table, as it does for most database objects. The problem arises when you rename the object in Enterprise Manager or with the sp_rename stored procedure.

In addition to StretchDB and AlwaysEncrypted, there are two more exciting features in the works for SQL Server 2016: dynamic data masking and row-level security. In the case of these two features, ...

8) Don't Rename Script-Based Objects You'll often create a script-based object, such as a view, a stored procedure, or a user-defined function. SQL Server then stores the script that created the ...

8) Don't Rename Script-Based Objects You'll often create a script-based object, such as a view, a stored procedure, or a user-defined function. SQL Server then stores the script that created the ...

In-Depth Top 7 Features Coming to SQL Server 2016 SQL 2016 has a number of major enhancements which will help whether or not you are implementing on-prem, in Azure or in a hybrid model. By Joey D ...

Using the CLR Function Once deployed to the SQL Server, the CLR function appears in the Programmability, Functions, Scalar-valued Functions folder of the database, much like a T-SQL user-defined ...

Ok, I'm having this wierd issue where I'm editing a row in the SQL manager, doing some text entry and I hit Shift and then Space (the reason being that if I am typing along and about to type a ...