[dba-SQLServer] Properties window

Check the properties of the database itself as opposed to the table.

Martin


----- Original Message ----- 
From: "Dan Waters" <dwaters at usinternet.com>
To: <dba-sqlserver at databaseadvisors.com>
Sent: Tuesday, January 17, 2006 4:41 PM
Subject: Re: [dba-SQLServer] Properties window


> Well - I'm so new to SQL Server that I don't know what a filegroup is for!
>
> Dan
>
> -----Original Message-----
> From: dba-sqlserver-bounces at databaseadvisors.com
> [mailto:dba-sqlserver-bounces at databaseadvisors.com] On Behalf Of Susan
> Harkins
> Sent: Tuesday, January 17, 2006 9:56 AM
> To: dba-sqlserver at databaseadvisors.com
> Subject: Re: [dba-SQLServer] Properties window
>
> I'm trying to change the filegroup for a table, I should be able to do 
> that
> -- but that window's the only place I can find the Filegroup property.
>
> Susan H.
>
> Hi Susan,
>
> Yes - mine are grayed out as well.  But I looked at those properties and
> realized that the ones on this list are 'stable' properties anyway - not
> stuff that needs changing.
>
> In the left pane of the properties window you can select Extended
> Properties.  Those can be changed, and are probably what you're looking 
> for.
>
> And, it looks as though you can add properties that you want.
>
>
> _______________________________________________
> dba-SQLServer mailing list
> dba-SQLServer at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
> http://www.databaseadvisors.com
>
> _______________________________________________
> dba-SQLServer mailing list
> dba-SQLServer at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
> http://www.databaseadvisors.com
>
>