okay....I have figured out what I asked before through extensive reasearch and reading. One thing i'm not sure abuot though is, if an extent gets near its max size,...

ok i see what is going on...but I have another question, this may sound like a stupid question but i am pretty new to this.

I was wondering the showfilestats is...

Steve,

Thank you very much I over looked the double ">".

Rich

RICHARD KIRMSS

ok i've figured out the problem I wasn't specifiying the full server name. Thank you for your help. I have one more question however. I was noticing...

I've tried it both ways using the -E and the -U/-P options. I also have administrative rights so this should not be a problem. Through all this I...

ok i've checked the permissions on the file that i'm trying to write to, and I'm still coming up with the same error. Any idea on what I might...

yeah i have all the permissions to the file. and I still get the error message

RICHARD KIRMSS

I'm sorry i gave the query it is suppost to be select * from master..sysobjects.

i'm still getting the same error however.

rich

RICHARD KIRMSS

i'm trying to run this simple test script using the osql utility

exec master..xp_cmdshell 'osql -Q"select * from %syslogins..master%" -oH:\testfile\stats.txt'

and i'm getting this error message

...

Thank you very much for helping me out. I didn't realize that the master database contains all information about other databases. I really appriciate the time you took...

ok....that seemed to work, which is great

but now it's not going through all the databases. do I need to use the '?' character so the SP will run in...

My stored procedure is dynamic, it creates a table with a series of select grant or select revoke depending on what is passed to it. It then goes and...

ok... I tried that and I still got an error.

Server: Msg 4606, Level 16, State 1, Line 1

Granted or revoked privilege SELECT is not compatible with object.

revoke...

Ok I looked at both sites and i'm still having trouble. This is what i'm trying to do. My stored procedure has 3 parameters that I pass in...

Thanks guys, I tried both ways and they both worked. Thank you again.

RICHARD KIRMSS