March 14, 2008 at 7:44 am
Hi,
Plz tell me that in sql 2000 we use osql .And i just use this query to see all servers with this query ''osql -L''
but i m thinking can we make one script which retrieve database name ,and size from all servers .if we make that query thn there is no need to go to all servers and check database name and size of database .
so plz tell me if there is any query like that
thaxxxxxx
regards
jagpal singh
March 14, 2008 at 8:47 am
jagpalsingh4 (3/14/2008)
Hi,Plz tell me that in sql 2000 we use osql .And i just use this query to see all servers with this query ''osql -L''
but i m thinking can we make one script which retrieve database name ,and size from all servers .if we make that query thn there is no need to go to all servers and check database name and size of database .
so plz tell me if there is any query like that
thaxxxxxx
regards
jagpal singh
osql -L only queries the browser service and lists the servers that have the browser service enabled. If you want to retrieve extra information, like information about individual databases, you will need to connect to these servers, and execute the relevant queries.
Regards,
Andras
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply