Deprecated Features starting from R....!
Feature
| READTEXT | Description The READTEXT syntax was encountered. Rewrite applications to use the varchar(max) data type and removed text data type syntax. Occurs once per query. |
| REMSERVER | Replace remote servers by using linked servers. |
| RESTORE DATABASE or LOG WITH DBO_ONLY | The RESTORE ... WITH DBO_ONLY syntax was encountered. Use RESTORE ... RESTRICTED_USER instead. |
| RESTORE DATABASE or LOG WITH MEDIAPASSWORD | The RESTORE ... WITH MEDIAPASSWORD syntax was encountered. WITH MEDIAPASSWORD provides weak security and should be removed. |
| RESTORE DATABASE or LOG WITH PASSWORD | The RESTORE ... WITH PASSWORD syntax was encountered. WITH PASSWORD provides weak security and should be removed. |
| Returning results from trigger | This event occurs once per trigger invocation. Rewrite the trigger so that it does not return result sets. |
| ROWGUIDCOL Source Link:- https://learn.microsoft.com/en-us/sql/relational-databases/performance-monitor/sql-server-deprecated-features-object?view=sql-server-ver16 Best Regards T. Amit Vaid S. | The ROWGUIDCOL syntax was encountered. Rewrite statements to use the $rowguid syntax. Occurs once per compilation. |
No comments:
Post a Comment