Viewing 15 posts - 1,936 through 1,950 (of 2,462 total)
chandrasekaran.ganapathy (4/6/2010)
SELECT * INTO XLImport3 FROM OPENDATASOURCE('Microsoft.Jet.OLEDB.4.0','Data Source=C:\testing.xls;Extended Properties=Excel 8.0')...[Table1$]
See this is happening because you have placed your excel in C: drive "C:\testing.xls" , put it in folder and then...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
April 6, 2010 at 1:49 am
have you tried them ? did you get any error ?
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
April 6, 2010 at 12:27 am
refer these links also
http://sql-server-performance.com/Community/forums/t/10004.aspx
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
April 6, 2010 at 12:09 am
chandrasekaran.ganapathy (4/5/2010)
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...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
April 6, 2010 at 12:08 am
Jeff Moden (4/5/2010)
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...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
April 6, 2010 at 12:04 am
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.
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
April 5, 2010 at 11:45 pm
CirquedeSQLeil (4/3/2010)
I'm glad you guys suggested this. I think this is the most probable candidate.
Did you catch the culprit ?
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
April 5, 2010 at 8:09 am
dallas13 (4/2/2010)
But support team is adding/modifying these jobs on server-A.We have to make sure that jobs on both servers are identical all
the time.
What kind of chages support team do ?
if...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
April 5, 2010 at 7:50 am
jsb12 (4/4/2010)
Does the 'sp_msforeachdb' just return results run against each database?
The Stored Procedure (SP), "sp_MSforeachtable," allows you to easily process some code against every table in a single database....
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
April 5, 2010 at 7:20 am
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,...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
April 5, 2010 at 7:12 am
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...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
April 5, 2010 at 6:45 am
Mike Levan (4/3/2010)
SET ANSI_WARNINGS ON
@paul-2 : Still can we expect ANSI_WARNINGS OFF ?
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
April 3, 2010 at 6:33 am
Refer this http://sqlserverpedia.com/wiki/Db_Config_-_Emergency_Mode_Option
i dont think you can recover it u need to restore it
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
April 2, 2010 at 7:30 am
where dbo.fnGetDateDiff(m.id) <= case when @day = 0 then 365 else @day end
it will force the optimizer NOT to use seek operation.
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
April 2, 2010 at 7:10 am
Paul White NZ (4/2/2010)
mike 11318 (3/31/2010)
I need to copy (or duplicate) a set of records for CompanyA and create a set of records for CompanyB
One simple approach is to script...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
April 2, 2010 at 5:38 am
Viewing 15 posts - 1,936 through 1,950 (of 2,462 total)