My guess is that it's the second field in the temp table which is created as an identity column - as the table from which it was created had the...

sharath.chalamgari (6/18/2010)

---

i tried with "ma-516002" query in the 2005 version the results are same i am able to get the records from both the tables. when i tried something simila...

ma-516002 (6/17/2010)

---

declare @myothertab table (

col2 varchar(20),

col3 varchar(20)

)

insert into @myothertab

select 'A','B' union all

SELECT 'W','Q'

;

declare @myanothertab table (

col2 varchar(20),

col3 varchar(20)

)

insert into @myothertab

select 'A','B' union all

SELECT 'W','Q';

select 1 as col1, col2, col3 into...

Wow ralf,

Sounds like the place you work is as dodgy as where I'm at!

Thanks for the tip.

James Stover (6/4/2010)

---

James Stover McDBA - is that like an Irish DBA?

I remember trialling the XMLSpy home edition (no longer available). It had the very basics, but on each day one of the 'power features' was available (and the next...

This ssc article[/url] contains a similar - but much shorter - list and refers to the Transact SQL Reference Guide - but the associated site is, indeed, offline.

Your list...

Thanks...looks like a very comprehensive list.

To avoid any misunderstanding, it would be good if you acknowledged your sources, when compiling your master list.

Regards,

David.

I must say I think these cartoons are consistently awesome!

Thank you, thank you!

Thanks for updating! Good tip!

Thanks Welsh Corgi,

The connection is OK. SSIS uses the connection to create the config table and initial entries.

The named instance thing may in fact be a red herring, as...

I didn't mean to suggest you were lying..and apologise if that's what you understood.

What I meant was that the 'solution' you posted has no apparent link to the problem you...

I very much doubt it...but pleased you (think you) have found a solution. 🙂

replace (local)\XXXXX with what "select @@servername" returns

This is your connection string from Delphi to the first sql server, right?

And you've also got a second sql server, which...