Data file size used space

In the SQL EM, we are able to get the data file size with
used space and free space details. Similarly for the log
file also.
We have the dbcc sqlperf command to find out the log file
used space details. Is there any way to find out the
data file size? sp_helpfile just gives the total size of
the data file wherein sp_spaceused is also not
distinguishing between used and free space.
Could anyone help me out in this?Do a google search on DBCC SHOWFILESTATS. This is what EM is using. Not documented, so all usual
warnings apply.
--
Tibor Karaszi, SQL Server MVP
Archive at: http://groups.google.com/groups?oi=djq&as_ugroup=microsoft.public.sqlserver
"Mangai" <anonymous@.discussions.microsoft.com> wrote in message
news:08fc01c3ad95$4cf28380$a301280a@.phx.gbl...
> In the SQL EM, we are able to get the data file size with
> used space and free space details. Similarly for the log
> file also.
> We have the dbcc sqlperf command to find out the log file
> used space details. Is there any way to find out the
> data file size? sp_helpfile just gives the total size of
> the data file wherein sp_spaceused is also not
> distinguishing between used and free space.
> Could anyone help me out in this?

data encryption

Hello there
I have database with some details that i don't no one can read it. including
programmers who have access directly to sql server.
How can i do that ?Roy, shalom
I assume , you are using SQL Server 2000 , right?
Take a look at this article
http://vyaskn.tripod.com/ row_level...as
es.htm
"Roy Goldhammer" <roy@.hotmail.com> wrote in message
news:u3IMJblMHHA.2456@.TK2MSFTNGP06.phx.gbl...
> Hello there
> I have database with some details that i don't no one can read it.
> including programmers who have access directly to sql server.
> How can i do that ?
>|||what's the datatypes of that columns? if it looks like the binary datea,
then try to convert it as varchar(8000) column
SELECt cast(urVarbinaryColumn as varchar(8000) )
from urTable
"Roy Goldhammer" <roy@.hotmail.com> wrote in message
news:u3IMJblMHHA.2456@.TK2MSFTNGP06.phx.gbl...
> Hello there
> I have database with some details that i don't no one can read it.
> including programmers who have access directly to sql server.
> How can i do that ?
>|||"Roy Goldhammer" <roy@.hotmail.com> wrote in message
news:u3IMJblMHHA.2456@.TK2MSFTNGP06.phx.gbl...
> Hello there
> I have database with some details that i don't no one can read it.
> including programmers who have access directly to sql server.
> How can i do that ?
In addition, if SQL 2005, look here:
http://www.sqlservercentral.com/col...oolkitpart1.aspsql