data space used by a table in MSSQL Server 2005

How can I query (using TSQL) the data space used by a table in SQL Server 2005?

This is possible using SQL Serve Management studio. I can right click on table name and check the proeprties. But I want to write a TSQL script to check disk space used by all the individual tables in the database. How can I do that?

EXECUTE sp_spaceused 'MyTable'

|||

Thanks Arnie... sp_spaceused is what I was looking for.

sql

Data replication from MSSQL to MYSQL

Hi all.
I need to set a oneway replication of some data from MSSQL (running under
Windows 2000 server) to MYSQL (running under Linux).
Do you have some ideas to solve the problem?
Thank you
Luca"Luca" <NOSPAMprong2k@.hotmail.com> wrote in message
news:co4mja$df9$1@.atlantis.cu.mi.it...
> Hi all.
> I need to set a oneway replication of some data from MSSQL (running under
> Windows 2000 server) to MYSQL (running under Linux).
> Do you have some ideas to solve the problem?

You can probably do this via DTS

> Thank you
> Luca

Data not being displayed.

Hi,
I have just installed MS SQL in my computer and I am trying to run MSSQL and Visual studio for the first time. However I have run into aproblem that I can't solve. Basically the problem is that the data Ifetch from the database is not being displayed/bound to the ddl I haveon the page.
I have used VS to configure the sqlDataAdapter, DataSet, sqlConnection,and the sqlCommands. Basically the data is being fetched from theNorthwind sample database. From the preview option on thesqlDataAdapter I am able to preview the information from the database.So it seems to work. I have also configured the ddl settings so thatthe Categories table is the datasource. I have also set the ddl.DataTextField = "CategoryName"; ddl.DataValueField = "CategoryID";
When I compiled and run the page, no error messages are generated, butthe ddl is still completely blank and I can't understand why.
Does anybody know how I can solve this?? :s

Om Sri Sai Ram

Did you callDataBind method.

Thanks,

Ram

|||Hi,
I have just double-checked that I had called DataBind, and itturns out that I had. However, I had forgotten to fill the DataSet:
this.sqlDataAdapter1.Fill(this.dataSet11);
Now I get an error message:
Login failed for user 'DISABLED\ASPNET'|||Om Sri Sai Ram

Are u using windows authentication? If yes, check whether ASPNET account has pemission to access the table.
If you still have problems, post the code.
Thanks,
Ram