Script to remove all extended properties?

Hi
Does anyone know of a way / script to remove all extended properties from
objects within a certain database?
Tia
James
tglThe documented way is to use sp_dropextendedproperty for each property
of each object (which can be found using fn_listextendedproperty).
An undocumented way would be:
DELETE sysproperties
(this may not work in later versions of SQL Server)
Razvan

Script out server properties and configurations

Does anyone know how to script out the properties and configuraiton settings
for a 2005 instance to compare with another instance? Thanks in advance if
you do...
Message posted via http://www.droptable.com
just run 'exec xp_msver' on the instance to get the basic settings.
-oj
"g8r via droptable.com" <u16034@.uwe> wrote in message
news:5dbf66b66bd7d@.uwe...
> Does anyone know how to script out the properties and configuraiton
> settings
> for a 2005 instance to compare with another instance? Thanks in advance if
> you do...
> --
> Message posted via http://www.droptable.com
|||You can execute sp_configure to list all the configuration
settings. Enable show advanced option first. You can find
examples how to do this in books online under sp_configure.
-Sue
On Fri, 24 Mar 2006 19:50:31 GMT, "g8r via droptable.com"
<u16034@.uwe> wrote:

>Does anyone know how to script out the properties and configuraiton settings
>for a 2005 instance to compare with another instance? Thanks in advance if
>you do...

Script out server properties and configurations

Does anyone know how to script out the properties and configuraiton settings
for a 2005 instance to compare with another instance? Thanks in advance if
you do...
--
Message posted via http://www.sqlmonster.comjust run 'exec xp_msver' on the instance to get the basic settings.
-oj
"g8r via SQLMonster.com" <u16034@.uwe> wrote in message
news:5dbf66b66bd7d@.uwe...
> Does anyone know how to script out the properties and configuraiton
> settings
> for a 2005 instance to compare with another instance? Thanks in advance if
> you do...
> --
> Message posted via http://www.sqlmonster.com|||You can execute sp_configure to list all the configuration
settings. Enable show advanced option first. You can find
examples how to do this in books online under sp_configure.
-Sue
On Fri, 24 Mar 2006 19:50:31 GMT, "g8r via SQLMonster.com"
<u16034@.uwe> wrote:
>Does anyone know how to script out the properties and configuraiton settings
>for a 2005 instance to compare with another instance? Thanks in advance if
>you do...

Script out server properties and configurations

Does anyone know how to script out the properties and configuraiton settings
for a 2005 instance to compare with another instance? Thanks in advance if
you do...
Message posted via http://www.droptable.comjust run 'exec xp_msver' on the instance to get the basic settings.
-oj
"g8r via droptable.com" <u16034@.uwe> wrote in message
news:5dbf66b66bd7d@.uwe...
> Does anyone know how to script out the properties and configuraiton
> settings
> for a 2005 instance to compare with another instance? Thanks in advance if
> you do...
> --
> Message posted via http://www.droptable.com|||You can execute sp_configure to list all the configuration
settings. Enable show advanced option first. You can find
examples how to do this in books online under sp_configure.
-Sue
On Fri, 24 Mar 2006 19:50:31 GMT, "g8r via droptable.com"
<u16034@.uwe> wrote:

>Does anyone know how to script out the properties and configuraiton setting
s
>for a 2005 instance to compare with another instance? Thanks in advance if
>you do...

Script or Stored Procedure that Collects Information from a Database

Information such as:
1. Database Name
2. Users
3. Database Properties (e.g., size, number of tables, etc.)
4. Other information of interest to a DBA (e.g., Maintenance Plan and
if the last job ran successfully)
I know there are umteen utilities out there that can derive this
information. I would like the product to derive its own information
using scripts or stored procs.
Thanks for any suggestions!
RBollinger
If you run profiler while you look through the GUI's for this info, you can
see the tsql they are generating. This can help you build your own tools.
Jason Massie
www: http://statisticsio.com
rss: http://feeds.feedburner.com/statisticsio
"robboll" <robboll@.hotmail.com> wrote in message
news:3ffe6464-ae36-47f9-94c4-14fb02266d23@.60g2000hsy.googlegroups.com...
> Information such as:
> 1. Database Name
> 2. Users
> 3. Database Properties (e.g., size, number of tables, etc.)
> 4. Other information of interest to a DBA (e.g., Maintenance Plan and
> if the last job ran successfully)
> I know there are umteen utilities out there that can derive this
> information. I would like the product to derive its own information
> using scripts or stored procs.
>
> Thanks for any suggestions!
> RBollinger

Script or Stored Procedure that Collects Information from a Database

Information such as:
1. Database Name
2. Users
3. Database Properties (e.g., size, number of tables, etc.)
4. Other information of interest to a DBA (e.g., Maintenance Plan and
if the last job ran successfully)
I know there are umteen utilities out there that can derive this
information. I would like the product to derive its own information
using scripts or stored procs.
Thanks for any suggestions!
RBollingerIf you run profiler while you look through the GUI's for this info, you can
see the tsql they are generating. This can help you build your own tools.
--
Jason Massie
www: http://statisticsio.com
rss: http://feeds.feedburner.com/statisticsio
"robboll" <robboll@.hotmail.com> wrote in message
news:3ffe6464-ae36-47f9-94c4-14fb02266d23@.60g2000hsy.googlegroups.com...
> Information such as:
> 1. Database Name
> 2. Users
> 3. Database Properties (e.g., size, number of tables, etc.)
> 4. Other information of interest to a DBA (e.g., Maintenance Plan and
> if the last job ran successfully)
> I know there are umteen utilities out there that can derive this
> information. I would like the product to derive its own information
> using scripts or stored procs.
>
> Thanks for any suggestions!
> RBollinger