March 25, 2008 at 5:46 am
Hello ,
use master
GO
select getdate () as Date,@@servername as servername, name ,size*8/1024 as size_MB
from sys.master_files;
plz tell me what the mistake in this wuery bcause in sql 2005 it runs nicely but when i try to run in 2000 it can't .
thaxx
March 25, 2008 at 6:03 am
'sys.master_files' does not exist in SQL Server 2000.
If it was easy, everybody would be doing it!;)
March 25, 2008 at 6:10 am
hi ,
thn will u plz tell me which i can use for this query
thaxxx
March 25, 2008 at 6:11 am
Try sysdevices in SQL 2000.
If it was easy, everybody would be doing it!;)
March 25, 2008 at 6:28 am
hi ,
sorry its not working
command run succesfully but there is no output comes out.
but i have done it now
its is in ''dbo.sysaltfiles''
March 25, 2008 at 6:34 am
Excellent! And you found the answer!
If it was easy, everybody would be doing it!;)
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply