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

http://www.aureus-salah.com

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 master.dbo.sp_serveroption @server=N'TEST', @optname=N'rpc out', @optvalue=N'true'

GO

EXEC master.dbo.sp_serveroption @server=N'TEST', @optname=N'connect...

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 |...

Tune the Instance PARAMETER first

===========================

Give Maximum RAM to SQL Server 12 GB

Set Maximum Worker Thread to 574 (Recommanded by Microsoft)

Set Boost SQL Server Priority

Set Network Packet size increase from 4096...

Install Oracle Instant Client for windows server 2008 64bit on the Server where SQL Server 2008 installed then create the DSN and then create the linked Server with OLE with...