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
Showing posts with label sql2000. Show all posts
Showing posts with label sql2000. Show all posts
Friday, March 9, 2012
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
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
Labels:
access,
accidently,
click-start,
database,
developers,
disable,
enterprise,
mananger,
microsoft,
mysql,
oracle,
passive,
prevent,
serve,
server,
serverwhen,
sql,
sql2000
Subscribe to:
Posts (Atom)