Get a Tables Row Count from system tables

Anyone knows how to get a Table's Row Count from system tables?

Thanks.select count(*) from sysobjects

sysobjects is a system table name. Replace this with the system table name which you want to get the row count.

Get a SQL Backup Folder Path in asp.net

Hi

Anyone knows , get a SQL Backup Folder Path in asp.net.Some Systems it displayed like D:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Backup and some Systems like E:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Backup and etc. i need to get a path for backup programmatically.Please help me.

Tamil

You can back up the databse to any location you'd like. You specify the path when you back up the DB.

sql

Generate table layout script

Hi,
Anyone knows that if I need generate a table layout without the EM right
click table All Tasks Generate SQL Script. I knew that bcp only export/input
the data but not generate script of the table without data.
Regards!
Chen
http://www.karaszi.com/SQLServer/inf...ate_script.asp
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"Chen" <Chen@.discussions.microsoft.com> wrote in message
news:F75EF23A-F12D-46F4-AFA2-993335C92C05@.microsoft.com...
> Hi,
> Anyone knows that if I need generate a table layout without the EM right
> click table All Tasks Generate SQL Script. I knew that bcp only export/input
> the data but not generate script of the table without data.
> Regards!
> Chen

Generate table layout script

Hi,
Anyone knows that if I need generate a table layout without the EM right
click table All Tasks Generate SQL Script. I knew that bcp only export/input
the data but not generate script of the table without data.
Regards!
Chenhttp://www.karaszi.com/SQLServer/info_generate_script.asp
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"Chen" <Chen@.discussions.microsoft.com> wrote in message
news:F75EF23A-F12D-46F4-AFA2-993335C92C05@.microsoft.com...
> Hi,
> Anyone knows that if I need generate a table layout without the EM right
> click table All Tasks Generate SQL Script. I knew that bcp only export/input
> the data but not generate script of the table without data.
> Regards!
> Chen

Generate table layout script

Hi,
Anyone knows that if I need generate a table layout without the EM right
click table All Tasks Generate SQL Script. I knew that bcp only export/input
the data but not generate script of the table without data.
Regards!
Chenhttp://www.karaszi.com/SQLServer/in...rate_script.asp
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"Chen" <Chen@.discussions.microsoft.com> wrote in message
news:F75EF23A-F12D-46F4-AFA2-993335C92C05@.microsoft.com...
> Hi,
> Anyone knows that if I need generate a table layout without the EM right
> click table All Tasks Generate SQL Script. I knew that bcp only export/inp
ut
> the data but not generate script of the table without data.
> Regards!
> Chen

Generate SQL Server tables from an XSD

Hi, I need to generate tables from an XSD document. Does anyone knows about
a way to do this? ThanksHi,
You can use Xml Bulkload component to generate the tables from a supplied
annotated schema file.You have to set SchemaGen property to True.
Check out paragraph E from the below link for an example on how to do it:
http://msdn.microsoft.com/library/d...>
h_SQLXML.asp
Best regards,
Monica Frintu
"Daniele Romagnoli" wrote:

> Hi, I need to generate tables from an XSD document. Does anyone knows abou
t
> a way to do this? Thanks
>
>