You can try with Import / Export wizard for table & data, and manually compile other scripts.

In SSRS, shared databse means: a datasource can be used in many reports.

otherwise you can create different datasource for each report.

Use the following string:

Driver={SQL Server};Server=myServerAddress;Database=myDataBase;Uid=myUsername;Pwd=myPassword;

If still have problem to connect, try the following way:

* Install SQL 2000 client tools in any one of Windows XP machine and then...

search "Using XML in SQL Server" in SQL BOL.

ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/udb9/html/a699d976-8099-4af1-a2f8-cd0e2bd57a83.htm

search "Using XML in SQL Server" in SQL BOL.

check in google.com.

Links:

http://www.google.com/search?q=how+to+use+cache+in+sql+server+2005&rls=com.microsoft:en-us&ie=UTF-8&oe=UTF-8&startIndex=&startPage=1

http://www.microsoft.com/technet/prodtechnol/sql/2005/recomp.mspx

http://decipherinfosys.wordpress.com/2007/09/19/procedure-cache-in-sql-server-2005/

http://www.mssqltips.com/tip.asp?tip=1563

you can find with sp_who2, try it once.

use IsNull, COALESCE functions, for more information, see SQL BOL.

After installing SQL 2005, goto SQL Server Surface Area Configuration and change the configuration settings.

You need permission on backup folder. check with your administrator.

above links helps to install unattended sql server installation.

🙂

if SQL 2000 and below version, check the "Client Network Utility" and configure it.

SQL 2005 and above version, go through the "SQL Server configuration Manager" and configure it.

you play with "information_schema.columns", based on this you can generate dynamic sql statement.

run the following DBCC commands:

DBCC CHECKDB

DBCC CHECKTABLE

DBCC CHECKCATALOG

DBCC UPDATEUSAGE

try it, may solve your problem.

Check the "Installing SQL Server" on BOL.

Link: http://msdn.microsoft.com/en-us/library/ms143516.aspx