Showing posts with label sql2000. Show all posts
Showing posts with label sql2000. Show all posts

Friday, March 9, 2012

How do I find out what tables belong to a filegroup?

Is there anyway to find out what tables are in a particular filegroup in SQL2000 apart from running sp_help {tblnm}?You could use undocumented stored procedure...

declare @.id int
set @.i = object_id('mytb')
exec sp_objectfilegroup @.i

Sunday, February 19, 2012

How do i disable access to Enterprise Mananger for a sql2000 serve

i need to prevent developers accidently starting a passive sql2000 server
when they see it down in EM (right click-start). Is there a way i can do
this, but still allow the developers to work with the dbs?
thankssimon
As far as I know you cannot
"simon.yeats" <simonyeats@.hotmaildotcom(donotspam)> wrote in message
news:5481A9A0-D3F5-457A-B127-383ED74A7BF9@.microsoft.com...
>i need to prevent developers accidently starting a passive sql2000 server
> when they see it down in EM (right click-start). Is there a way i can do
> this, but still allow the developers to work with the dbs?
> thanks