I hope you are aware that Excel 2007 is based on XML ... so far this is the only documentation I was able to find that appears to have a...

Kinda of late to get into this subject but from various SSC contributors (whom I thank) patched together this procedure to tell you more than you wanted to know about...

This one darn near drove me nuts - what with 3 possibilities 2K, 5K, with 2 compatibility levels - so my answer was more of a pseudo psychological analysis which...

First off let me say I function as a developer not as a DBA. I found this site when using google in an attempt to answer a specific SQL...

BEGIN TRAN

INSERT INTO T_CONFIRMED_ORDERS VALUES(@orderNumber,GETDATE(),'SETConnector',GETDATE(),null,null,null);

COMMIT TRAN;...

Thanks - an...

I just read Saturdays news letter and it may have an idea for you

http://pragmaticworks.com/community/blogs/brianknight/archive/2008/03/12/ssis-lab-runtime-performance-differences-between-dts-and-ssis.aspx

When you upgrade to SSIS, you can see a dramatic improvement in performance. For example, I took...

TRACEY,

Thanks copied your posting and it works in 2000 and Express 2005.

dileep_ratnayake (3/15/2008)

---

im using access as the back end and vb6 forms as the backends.

i think i sorted the slow problem out. but do u think vb6 and sql 2005 may...

For further discussion see the blog post by

Il-Sung Lee Program Manager, SQL Server Protocols

at http://blogs.msdn.com/sql_protocols/archive/2006/02/21/536201.aspx

I owe this to a person or persons unknown but it worked for me.

Run sp_who or sp_who2 to obtain the process id (spid) then

DECLARE @Handle binary(20)

SELECT @Handle =...

From: SQL Server 2005 Books Online (September 2007)

http://msdn2.microsoft.com/en-us/library/ms187072.aspx

Cut and pasted from the reference supplied by the question:

SQL Server 2005 distributed queries have been tested with several OLE...

the database is a mess and the web programmers put in all embedded SQL in the web programs so I have no idea what is going on when something goes...

Not a guru but a thought, since you have the column ID (assuming it is the column with the error) use this column Id as a parameter in a T-SQL...

Adding to the ideas of WillyWonka. Try this site

http://msdn.microsoft.com/msdntv/episode.aspx?xml=episodes/en/20050512SQLServerDF/manifest.xml

Extract from the site page:

"Data quality is a critical issue in data integration. Donald Farmer introduces the...