CHI - Life Beyond Technology

Hey guys today i wanted to export my all schema and data from a database to a script file. While i was searching on the net i found the following command that we can you. Hope this will be helpful to you guys too. Command to run which will create schema and database: C:\Program Files\Microsoft SQL Server\90\Tools\Publishing\1.4\sqlpubwiz script -d AdventureWorks “C:\AdventureWorks.sql” Command to run which will create schema: C:\Program Files\Microsoft SQL Server\90\Tools\Publishing\1.4\sqlpubwiz script -d AdventureWorks “C:\AdventureWorks.sql” -schemaonly Command to run which will create data: C:C:\Program Files\Microsoft SQL Server\90\Tools\Publishing\1.4\sqlpubwiz script -d AdventureWorks “C:\AdventureWorks.sql” -dataonly http://blog.sqlauthority.com/2007/11/16/sql-server-2005-generate-script-with-data-from-database-database-publishing-wizard/

Refer the following msdn link for more information. This will really useful to you. http://msdn.microsoft.com/en-us/library/dd193258.aspx

I got some good URLs regarding SQL Server 2005 Reporting Services. Following are the URLs i found. Deploying Reporting Services - http://msdn.microsoft.com/en-us/library/ms159868(SQL.90).aspx Installing and Configuring SQL Server 2005 Reporting Services - http://weblogs.asp.net/akjoshi/archive/2008/06/06/Installing-and-configuring-sql-server-2005-reporting-services.aspx Service Account Configuration for Reporting Service - http://blogs.msdn.com/williaml/archive/2006/10/21/service-account-configuration-for-reporting-service.aspx I hope these will help u one day.

Do you want to get the extract version of the SQL server you have installed in your machine with the service packs? Try this on query window. SELECT @ @VERSION or for SQL Server 2000 and above the following is easier to parse SELECT SERVERPROPERTY ( 'productversion' ), SERVERPROPERTY ( 'productlevel' ), SERVERPROPERTY ( 'edition' ) Cheers.