Neil,

I went to the site and they have posted a workaround for your problem. Have you tried the workaround and did it work?

Another thing, I just ran the query in the master database and the results shows that the BUILTIN user does not have a NULL name or loginname. Is this...

Yes, I looked in that database in EM and didn't see the syslogins table either. Also, what is a domain group?

I don't see a syslogins table in any of my databases and the query you posted returns an Invalid Object Name error. Any idea why? I am running...

I am really not sure, I just downloaded a SQL Server HotFix and they say the following:

"If you install this hotfix on a server that is running SQL Server 2000...

Thanks everyone.

Wow, that works, thanks a million! I will study your scripts and figure out why my query did not return the user indexes. Thanks again!

Because no one has responded, I am beginning to think that SQL Server is unable to provide such information. Is that correct? Thanks in advance.

There is got to be someone out there who could help me with this...please...

I have written the following sql statement, but it doesn't return the user indexes. If I take out the "b.name NOT LIKE 'sys%' " part, I get all the...

How do you run the INFORMATION_SCHEMA command?

As a side-question, what command do I use to move an index to another filegroup?

We are running 2000.

I want to run a sql statement that will give me the name of index, which table it belongs to, and which filegroup it is stored in....

Sorry, I have no idea how this topic was posted twice, please ignore the other thread and reply to this one only. Thank you.

Its version 2000. The data files grew, I guess someone loaded some data while shrinking? It could be. I'll ask everyone to see what they have done...