josephptran2002 (5/18/2009)

---

I tried to copy your codes and run it, somehow it works...but it gives me a small error. Do you know why?

OLE DB provider "Microsoft.Jet.OLEDB.4.0" for linked server "(null)"...

DBA (5/18/2009)

---

Select distributorid, distributorname, distributorstatus,distributorcargo

from Dist_Main M inner join Dist_Details D on

M.DistPK = D.DistFK

where distribuborcargo = @cargo

and distributorstatus in ('9', '7','5','1')

my issue is creating a variable...

josephptran2002 (5/18/2009)

---

Hi All,

it gives me a syntax error:

"Msg 15281, Level 16, State 1, Line 1

SQL Server blocked access to STATEMENT 'OpenRowset/OpenDatasource' of component 'Ad Hoc Distributed Queries' because this component...

Lynn Pettis (5/15/2009)

---

Oh? When did you move to Virginia? You look like you...

Now I see why you're running off to the desert all the time.

Well, I'm...

Paul White (5/14/2009)

---

Bob Hovious (5/14/2009)

---

Hey Bruce and Paul... how is life in New Zealand? Where do you each live again? Bruce, you're on the North Island...

Ramesh (5/14/2009)

---

How are you setting the named range in excel destination connection?

I think it should be set to "Command" and the command text should set to "SELECT *...

Phil Parkin (5/13/2009)

---

Your signature contains a link to posting best practices, yet your post does not follow them!

Are you referring to Excel when you talk about 'sheets'?

Is any data involved,...

Anjana (5/13/2009)

---

I would like to insert all these other records into other tables at same time or if possible can loop through and insert these records in?

Insert Into tPM_Cmptc_Cat_Skill_Codes (compcatidno,...

The stronger a password is, the more resistant it is to being hacked.

A good mix of numbers, lowercase letters, uppercase letters and special characters would make it extremely difficult for...

Have you tried using IMEX=1 in your driver?

see http://support.microsoft.com/kb/194124

Dave Coats (5/13/2009)

---

Thanks Ken - I had the same question too. Your post confirmed my suspicion. But to me, this makes no sense. Log Shipping should set...

GilaMonster (5/12/2009)

---

Index scans always read the whole index....

With the...

Here are other issues that I've run into, and I haven't been able to figure out a solution for. Any help is appreciated.

I can probably do all of this with...