Alternatives
Members may post updates or alternatives to this current article in order to show different
approaches or add new features.
24 Mar 2010kiran dangar 2 alternatives
Understrading sys.objectsSys.objects is a system VIEW in SQL Server 2005, for each SQL database there is a separate sys.object view which gets stored within databse itself.Using Sys.objects returns list of all database objects and its types, type can be either of given below:DB OBJECT...
For Ravi LVS,The way you have suggested to Empty the database by just deleting and recreating it, is not at all smarter way when you are about to empty a remote database located on live database server, There are times when you don't hold such rights of deleting database on Live...
This member has not yet provided a Biography. Assume it's interesting and varied, and probably something to do with programming.