What about SSIS?

😎

Take a look at the XML forum, the answer is there.

BTW, it is more work to create a sample data than actually write the answer.

😎

Promptly confirmed!

.....then.....:sick:

First thing to run

SELECT

*

into dbo.myAudittable

FROM sys.dm_exec_connections c

cross apply sys.dm_exec_sql_text(c.most_recent_sql_handle)

If you are lucky, you'll have the culprit there.

😎

Prefixing the output column alias with the @ (ascii 64) sign does the trick

😎

amela.ajanovic90 (5/16/2014)

---

Thanks to everyone who filled out the questionnaire! I have posted on non technical sites as well, we have around 70 responses so far, but of course, the more...

mianirfan786 81909 (5/16/2014)

---

Dear All,

I have a VB based desktop application with back end MS SQL server 2000 database with server machine ibmx5650 with specs intel xeon 2.7GHz (24 CPU's) &...

Is there any error handling in SP_LogProc?

😎

You could wrap the executions in a try/catch and/or check the @@ERROR to catch the error when and where it happens.

😎

The problem in your attempt is that sql server interprets queries like

[font="Courier New"]select * from x left outer join y where y = z[/font]

to

[font="Courier New"]select * from x inner...

This is a simple solution that uses the row_number function with a case statement to hide/null part of the output.

😎

USE tempdb

go

IF EXISTS (SELECT * FROM INFORMATION_SCHEMA.TABLES

...

Question for Gail, on a 2005 platform, which solution of these two would you prefer and why? The question of course is a simplification of course, more like penny for...

Lynn Pettis (5/14/2014)

---

< horse riding in ... clop, clop, clop, clop, clop > Everyone else is wrong!! My way is the only way!! < clop, clop, clop, clop, clop...

Finding this slightly amusing, attached a 2012 database to a 2014 instance, checked the Cardinality Estimator version and it reported 70. Changed the compatibility level to 2014, and 😀 surprise,...

PearlJammer1 (5/15/2014)

---

Hi We use sql2008r2

The other day a collegeue asked for a copy of dataload package that we use in SSIS. I right clicked the package and selected 'EXPORT' and...