How to see database details in 2000 with sql cmd ???

• jagpalsingh4

  Ten Centuries

  Points: 1311

  More actions

  March 13, 2008 at 6:40 am

  #187418

  hi,

  I have this query to see database details this work properly in 2005 with sql cmd .But we r dealing with some sql server 2000 customers as well and there is no sql cmd works so plz tell me how can we work on sql server 2000

  query is

  use master

  GO

  select getdate () as Date,@@servername as servername, name ,size*8/1024 as size_MB

  from sys.master_files;

  and this is sql cmd command which run nicely in 2005 but plz tell me how can we work in 2000 with this query is there any parameters to use this query in 2000.

  sqlcmd -S (local) -E -d master -i f:\jagpal\sql.sql -o f:\jagpal\sqlsql.txt

  copy /y dbastats.txt temp.txt

  copy /Y temp.txt + sqlsql.txt dbastats.txt

  thaxxx

  jagpal singh

• Steve Jones - SSC Editor

  SSC Guru

  Points: 736162

  More actions

  March 13, 2008 at 8:08 am

  #789072

  Use OSQL for SQL Server 2000. Similar parameters, osql /? will help.

• jagpalsingh4

  Ten Centuries

  Points: 1311

  More actions

  March 13, 2008 at 8:19 am

  #789086

  Hi,

  Steve how can we use osql i have never use sql 2000 thats the problem sorry .

  tell me they way to use osql .

  thaxxx