Sunday, March 25, 2012

Deprecation: What does it mean?????????

(-)CREATE DATABASE with FOR LOAD
I get this exemption with this rule:
Rule: CREATE DATABASE with FOR LOAD
Category
Deprecation
Description
This rule checks stored procedures, functions, views and triggers for use of
CREATE DATABASE statement specifying the FOR LOAD clause.
FOR LOAD clause has been deprecated and will not be supported in a future
release of SQL Server. RESTORE statement provides option to recreate a
database.
This rule:
?Only scans databases specified in the Database List of a registered SQL
Server instance.
?Scans trace files associated with a registered SQL Server instance.
?Does not check databases that are not online.
Parameters
Deprecated features are those that are slated to be unsupported in a future
release.
Tom
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Columnist, SQL Server Professional
Toronto, ON Canada
www.pinnaclepublishing.com
"Garry D" <GarryD@.discussions.microsoft.com> wrote in message
news:CF76BC86-FAA8-4EAA-B60E-C215BF7675E7@.microsoft.com...
(-)CREATE DATABASE with FOR LOAD
I get this exemption with this rule:
Rule: CREATE DATABASE with FOR LOAD
Category
Deprecation
Description
This rule checks stored procedures, functions, views and triggers for use of
CREATE DATABASE statement specifying the FOR LOAD clause.
FOR LOAD clause has been deprecated and will not be supported in a future
release of SQL Server. RESTORE statement provides option to recreate a
database.
This rule:
? Only scans databases specified in the Database List of a registered SQL
Server instance.
? Scans trace files associated with a registered SQL Server instance.
? Does not check databases that are not online.
Parameters

No comments:

Post a Comment