How can I check..
From: Peter The Spate (anonymous_at_discussions.microsoft.com)
Date: 10/29/04
- Next message: Dooza: "DSDE to SQL7"
- Previous message: Leila: "Statistics Time"
- In reply to: MK: "How can I check.."
- Next in thread: Wayne Snyder: "Re: How can I check.."
- Messages sorted by: [ date ] [ thread ]
Date: Fri, 29 Oct 2004 02:50:33 -0700
The easiest way is to do into Enterprise Manager, select
the table, right click and go to properties.
If you have a lot of tables then you can script them out
by selecting the database, all tasks, generate sql script,
then open it up in QA and do a search for the filegroup
you want to remove.
Peter
"I favor the Civil Rights Act of 1964 and it must be
enforced at gunpoint if necessary."
Ronald Reagan
>-----Original Message-----
>I have one database file in separate filegroup. I can't
delete this file
>because it is not empty.
>How can I check which table is a part of this database
file ?
>.
>
- Next message: Dooza: "DSDE to SQL7"
- Previous message: Leila: "Statistics Time"
- In reply to: MK: "How can I check.."
- Next in thread: Wayne Snyder: "Re: How can I check.."
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
