Re: How can I check..

From: Wayne Snyder (wayne.nospam.snyder_at_mariner-usa.com)
Date: 10/29/04 

Date: Fri, 29 Oct 2004 07:49:08 -0400

select id, object_name(id) as 'Object', indid, name, s.groupid, fg.groupname
  from sysindexes s inner join sysfilegroups fg
   on s.groupid = fg.groupid

you can also put a where fg.groupname = 'myfilegroup'
to see only the objects on a particular FG 

-- 
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"MK" <MK@discussions.microsoft.com> wrote in message
news:FEC364E9-20CE-468B-A961-E56D70508032@microsoft.com...
> 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 ?

Relevant Pages

  • Re: Local datastore for visual basic .net aplication on a pda
    ... In other words, if you don't need to sync your datastore with the desktop, ... SqlServerCe is what you want. ... >> database file as an local datastore without the SQL server running? ...
    (microsoft.public.dotnet.framework.compactframework)
  • Re: Upgraded to Visual C# Express 2005 SP1, can no longer persist data in SQL Server Express
    ... none of my apps will persist data to ... SQL Server Express (have not yet applied the Service ... Just off the top of my head, could it be that your database file is copied to the bin directory each time you build/run, so that you always start with the same version? ...
    (microsoft.public.dotnet.languages.csharp)
  • Re: Email unkown when trying to add user in AD mode
    ... The problem is that I can't add them as a user in Active Directory mode. ... Wayne Snyder, MCDBA, SQL Server MVP ... > SharePoint Services). ... >> community of SQL Server professionals. ...
    (microsoft.public.sharepoint.windowsservices)
  • RE: Getting 5105 error when I try to attach database
    ... check SQL Server does to detect if I'm accessing a database file through a ... database file over a network share anyway. ... >> activation error), it gives the same path that I gave it, and says that the ...
    (microsoft.public.sqlserver.server)
  • Re: which datatype do use for this?
    ... Wayne Snyder, MCDBA, SQL Server MVP ... I support the Professional Association of SQL Server and it's ... >> consider the image data type. ... >> community of SQL Server professionals. ...
    (microsoft.public.sqlserver.server)
Loading