GilaMonster (6/18/2010)

---

Lynn Pettis (6/17/2010)

---

Don't you love it when some one PM's you for help? Just deciding if I should help, post it for others as well, or just ignore...

Great.

Glad I could help.

You're welcome.

Let me know if this worked for you.

You're welcome.

Glad I could help.

If you just want to update table Client, you must use an UPDATE statement:

UPDATE DB1.dbo.Client

SET Notes = DB2.dbo.AllNotes.notes

FROM DB1.dbo.Client

INNER JOIN DB2.dbo.AllNotes

ON cid=UserID

If you also want to insert...

I know for sure of SAVE TRANSACTION, but I've never heard of BACKUP TRANSACTION.

It doesn't look like a message you can get from that statement.

Are you sure there's no trigger on the table?

Oh, don't be too picky, Gail! You know what I mean.

BTW, they can be equivalent. Just change your...

This should help:

SELECT * into #tmp_table from

(

SELECT 1 AS ID, 'ProductA' AS Code, 5 AS Quantity

UNION ALL

SELECT 2 AS ID, 'ProductA' AS Code, 5 AS Quantity

UNION ALL

SELECT 3 AS ID,...

I'm sorry, but I don't see how.

I don't understand that code. What language is it?

It's quite...

Just a guess, but maybe the providers are loaded in process and you won't get them back working without restarting SQL Server.

It's something I experienced in the past with a...

So, it's not a valid date.

Probably that field has concatenated data inside. You will have to find out how data is represented in that column. Where does this data...

I think you confused server and database. Does this work?

CREATE SYNONYM [dbo].[Product] FOR [06WEBSQL\WEBSQL].[06dw].[dbo].[Product]

Datetime is represented internally by a float value, where the integer part is the date value and the fractional part is the time value.

You could try casting with something like:

select...