Some points to look out for when creating the SP or just executing the OpenRowset command shown below.

1. Be sure the text file being accessed does exist on the...

Have run into this problem a few times when using VB in the application and found it to be due to:

1. On some path such as

...

Using SSMS (SQL Server Management Studio)

Expand databases

1. Right click on database name

2. On drop down menu select Tasks

3. On next drop down menu select Generate Scripts

The Script...

Here we go again with a poorly worded question:

From:

http://msdn2.microsoft.com/en-us/library/ms175490(SQL.100).aspx

"Hot Add Memory requires SQL Server Enterprise Edition and is only available for 64-bit SQL Server,

and for...

In response to Joe Clifford's comment "the business of delivering ice cream, nothing fancy and they have very little control over what their clients will order from day to day...

Wasn't the possible answer rather abbreviated: I suggest what is really required is:

A 64-bit system that supports hot-add CPU

...

This might be of use to you

CREATE PROCEDURE Dbo.Parse_Charfieldforavalue_02

@HayStack VARCHAR(200),

@Find VARCHAR(50)

AS

DECLARE @Here Int

DECLARE @There Int

DECLARE @TheNeedle VARCHAR(200)

SET @Here = 0

SET @There = LEN(RTRIM(@HayStack))

SET @Here...

Roy,

Thanks for waking most of us up, and getting us to think and review the habits we have fallen into .. not only with the use...

Referring to BOL OPENROWSET

INSERT INTO OPENROWSET('Microsoft.Jet.OLEDB.4.0','Text;Database=D:\MSSQL\','SELECT * FROM Test.txt')

SELECT column01,column02, FROM yourtablename -- this is your select statement

Note: The file you want to write to must be located on...

Congratulations Steve - you have worked hard for all of us, and now Microsoft is recognizing your efforts.

Congratulations on...

Use Excel itself to import the data as:

Open EXCEL

In main menu click "Data"

In drop down menu click "Import External Data"

In next drop down menu click "Import Data"

Select data source window...

More than I expected, and more than we deserve, no matter let me say thank you.

Now what are you...

Agree with the fact that the question is not properly phrased for what it considered the correct answer.

NOW WILL SOME ONE BE NICE AND TAKE THE FLAG OFF...

I will turn 76 in the second quarter of 2008 and my work resolution is to keep on learning.

My personal resolution is to live healthy and make it to the...

This will retrieve a bit more info about SP parameters

select 'SP name' = o.name, ParamName= c.name, DataType = t.name,

c.Length, Direction = case c.isoutparam

...