--Excel 2003

SELECT [Folder names],[Names] FROM OPENDATASOURCE('Microsoft.Jet.OLEDB.4.0',

'Data Source=D:\Office\RFP tables outside of RFP.xls;Extended Properties=Excel 8.0')...[sheet$]

--Excel 2007

SELECT * FROM OPENDATASOURCE('Microsoft.ACE.OLEDB.12.0',

'Data Source=D:\Office\RFP.xls;Extended Properties=Excel 8.0')...[sheet1$]

See this is happening because you have placed your excel in C: drive "C:\testing.xls" , put it in folder and then...

have you tried them ? did you get any error ?

refer these links also

http://sql-server-performance.com/Community/forums/t/10004.aspx

http://social.msdn.microsoft.com/Forums/en-US/transactsql/thread/77b86d4e-5322-4611-97f6-49e5e2013ee9

chandrasekaran.ganapathy (4/5/2010)

---

I am getting this error.

Msg 7314, Level 16, State 1, Line 1

The OLE DB provider "Microsoft.Jet.OLEDB.4.0" for linked server "(null)" does not contain the table "Table1$". The table either...

Jeff Moden (4/5/2010)

---

Bhuvnesh,

I'm not taking a jab at you... I have to ask, though... how often do you find it necessary to split something longer than 8K bytes? There's...

But i still didnt understand why zenoss taking heavy RAM usage because i always heard that these type of third party monitoring tools take less resources.

Did you catch the culprit ?

What kind of chages support team do ?

if...

The Stored Procedure (SP), "sp_MSforeachtable," allows you to easily process some code against every table in a single database....

Another approach

CREATE FUNCTION [dbo].[uf_utl_SplitNString]

(

@InStr nvarchar(max) = null ,

@token nvarchar(4000) = ','

)

RETURNS @RtnElement TABLE ( item nvarchar(4000))

AS

BEGIN

declare @pos int, @tokenlen int,...

1.You can use the SQL Server integration services ( sql 2005 ) or DTS ( sql 2000) to import Excel data into SQL Server tables.

2.Use Distributed QueriesIf you do...

@paul-2 : Still can we expect ANSI_WARNINGS OFF ?

Refer this http://sqlserverpedia.com/wiki/Db_Config_-_Emergency_Mode_Option

i dont think you can recover it u need to restore it

where dbo.fnGetDateDiff(m.id) <= case when @day = 0 then 365 else @day end

it will force the optimizer NOT to use seek operation.