Following are the System level stored Procedures which are helpfull in day to day life in Microsoft SQL Server
SP_HELP <<Object_Name >> -- Displays object structure
SP_HELPSORT -- Displays database sort order based on the installation
SP_SPACEUSED -- Displays space used by the database. If passed the table name, displays space used by that table
No comments:
Post a Comment