I assume its SQL Server 2008 R2. Please install SQL Server 2008 R2 SP1, to resolve this issue.

It fixed for me!!

http://www.microsoft.com/download/en/details.aspx?displaylang=en&id=26727.

Hi Jerry,

All the secondary datafiles of Tempdb are located in the same T:\ drive. Do we really require those 8 secondary tempdb files, while the database is created with...

Hi Dave,

I followed all the steps as mentioned in the PDF, but everytime, it returns the local system disk space details to data table, and not the remote servers listed...

Thanks a lot.. thanks for the detailed PDF with screenshots.

Could you please guide me on how to run this query against an specific server through SSRS. Ie., I need...

Hi,

I am unable to procced further with the WMI_Conn properties. I receive the below error while setting the connection string for WMI_Conn.

-----------------------------------

The variable "user::ServerConnString" was not found in the...

Hi.. appreciate your immediate reply...

But my intent is not to print th getdate()....

select * from openquery([linked server], '

set nocount on ;

...

select * from OPENQUERY([system2-PC\sqlserver2005],'select getdate()')

&

select * from OPENQUERY([system2-PC\sqlserver2005],'select * from sysobjects')

Both Works fine..

I have create the linked server on the default instance as [system2-PC\sqlserver2005]

and I want to run a adhoc...