MetaData should be MS SQL Server 2005 or Later because SQL Server 2000 is not a schema base database

and use this new JDBC driver 2.0 by Microsoft

http://www.microsoft.com/sqlserver/2005/en/us/java-database-connectivity.aspx#performance

Regards,

Syed Jahanzaib...

I didnt deny the installation of binaries,I was talking about Native Client only,How many Native client drive on your windows System

Regards,

Syed Jahanzaib Bin Hassan

MCTS | MCITP | OCA | OCP...

You cant think Albert as just showing his name in your signature

Regards,

Syed Jahanzaib Bin Hassan

MCTS | MCITP | OCA | OCP | OCE | SCJP | IBMCDBA

My Blog

http://www.aureus-salah.com

Take it easy man,we are here to provide solution ,dont take it personal,if I am wrong then leave me on my way.If you dont have any qualification thats not my...

DBCC SHRINKDATABASE(N'TEST', 5 )

GO

TEST is a database name

5 is a percentage

Check attachments

Regards,

Syed Jahanzaib Bin Hassan

MCTS | MCITP | OCA | OCP | OCE | SCJP | IBMCDBA

My Blog

There is no 32bit Native client install on the 64bit OS and 64bit SQL Server installation,There is only 1 Native client available in the DSN window...

Regards,

Syed Jahanzaib Bin Hassan

MCTS...

check the SQL Server service account should have rights to do this and if you are using SQL Server agent job to taking a backup then you should check the...

Yes thats why , if this OS 64bit then it will install the 64bit client otherwise 32bit,It will not install both NATIVE client

Regards,

Syed Jahanzaib Bin Hassan

MCTS | MCITP |...

USE [master]

GO

EXEC master.dbo.sp_addlinkedserver @server = N'TEST', @srvproduct=N'SQL Server'

GO

EXEC master.dbo.sp_serveroption @server=N'TEST', @optname=N'collation compatible', @optvalue=N'false'

GO

EXEC master.dbo.sp_serveroption @server=N'TEST', @optname=N'data access', @optvalue=N'true'

GO

EXEC master.dbo.sp_serveroption @server=N'TEST', @optname=N'rpc', @optvalue=N'true'

GO

EXEC...

Is your OS 32-Bit,Installation of SQL Server 2008 is same for both bits,it will automatically check the OS then install the required version,Its depend on the OS

x86

x64

xI64

Regards,

Syed Jahanzaib Bin Hassan

MCTS...

Check windows recent updates and check user have rights to run setup,send your SERVER specification

Regards,

Syed Jahanzaib Bin Hassan

MCTS | MCITP | OCA | OCP | OCE | SCJP | IBMCDBA

My...

Modify a report and check the DSN path is the same as you deploy on the SSRS

Regards,

Syed Jahanzaib Bin Hassan

MCTS | MCITP | OCA | OCP | OCE | SCJP...

http://www.sqlcoffee.com/Troubleshooting007.htm

Regards,

Syed Jahanzaib Bin Hassan

MCTS | MCITP | OCA | OCP | OCE | SCJP | IBMCDBA

My Blog

http://www.aureus-salah.com

Set only Max Server Memory on both Server and dont set minimum memory and install the Service pack for SQL Server 2008 also if not

There is no need to set...

Windows allow you but there is no need to make multiple resource group of the same MSDTC resource

Regards,

Syed Jahanzaib Bin Hassan

MCTS | MCITP | OCA | OCP | OCE |...