Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
msr976
Starting Member
2 Posts |
 Posted - 2008-03-25 : 10:01:10
|
| Does anyone know how to run a script to get the log size and log space?When I run the following command it does not work and I don't know why.DBCC SQLPERF (logspace)USE [master]GO SELECT * FROM sysfilesWHERE name LIKE '%LOG%' GOEXEC sp_spaceusedIf I run this command on a different server I get the ouput that I need. Any help would be greatly appreciated.msr976 |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-03-25 : 15:11:04
|
| you got any error? |
 |
|
|
jackv
Master Smack Fu Yak Hacker
2179 Posts |
Posted - 2008-03-26 : 09:00:57
|
| I've run it on my sql 2000 and it looks OK.Do you have the right permissions on the server where you are getting no results?Jack Vamvas--------------------Search IT jobs from multiple sources- http://www.ITjobfeed.com |
|
|
|
NeilG
Aged Yak Warrior
530 Posts |
Posted - 2008-03-26 : 09:19:07
|
| That has got to be a security error, I can't see any ohter reason |
|
|
|
jackv
Master Smack Fu Yak Hacker
2179 Posts |
Posted - 2008-03-27 : 08:32:32
|
| msr976: could you send through the permissions of the user who you are logged on as , when running the code?Jack Vamvas--------------------Search IT jobs from multiple sources- http://www.ITjobfeed.com |
|
|
|
|
|
|
SQL 2000 running scripts in query analyzer