home
quiet PC
xml
DotNet
coding
Internet
audio/visual
the rest
delphi
SQL
asp
other stuff
SQL Server Scripts
The following scripts can be used with SQL server.
SQL Scripts
top
Make the dbo the owner of all user objects
- SQL_Script1.xf
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
- SQL_Script2.xf
Script to allow the PUBLIC group to have unlimited access to all user objects in the database
Calcluate table sizes
- SQL_Script3.xf
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.