SQL Server Scripts
The following scripts can be used with SQL server.
Make the dbo the owner of all user objects
This script changes all the user objects that are not owned by the dbo, to be owned by the dbo.
Allow PUBLIC access to all objects
Script to allow the PUBLIC group to have unlimited access to all user objects in the database
Calcluate table sizes
Calcuates how much spaces is used by the user tables, inlcuding avergae row size if known.
view the RawXml for this page
© Woric Faithfull 2002-2004.