This is really a good thing. It could help you find easier the most valuable answer in posts with more answers.

Supporting it.

Regards,

Igor

This can be helpful

SELECT st.[text], *

FROM sys.dm_exec_query_stats qs

CROSS APPLY sys.dm_exec_sql_text(qs.plan_handle) st

INNER JOIN sys.dm_exec_cached_plans cp ON qs.plan_handle = cp.plan_handle

Regards,

Igor

Lowell (2/10/2014)

---

exactly why i said...

Be careful. What if the first INSERT extends the ConditionB set?!

sku370870 (2/10/2014)

---

Thank you for your reply.

May I ask what is, no doubt, a stupid question. When you say it is the 'version of the instance' ... what does that mean?

If...

Nice question. It's by design.

Thanks.

Regards,

Igor

Hi Both,

I'd like to share with you the experience I got regarding this question. Maybe I didn't present it well. The idea was to use versioning only for the session...

It's the version of the instance.

Here are steps how to change the compatibility level (http://technet.microsoft.com/en-us/library/bb510680(v=sql.105).aspx).

Take a look of the "Differences Between Compatibility Level 80 and Level 90" section.

The practice...

Deploy the package to SSIS.

Configure a job to execute it.

From ssms you can call:

USE msdb ;

GO

EXEC dbo.sp_start_job N'Job_calling_ssis_package' ;

GO

You can put that code in a SP and execute it.

From...

SQLRNNR (2/4/2014)

---

Igor Micev (2/4/2014)

---

Hi,

Heavy load.

My approach would be like:

You can change your package to use the Foreach loop container, put a data flow task in the loop container and...

Hi,

Heavy load.

My approach would be like:

You can change your package to use the Foreach loop container, put a data flow task in the loop container and then in the...

I think your approach is not good. Even if you manage to resolve it now, you'll have issues later if going this way.

My suggestion is to re-create your table a...

Grant Fritchey (2/4/2014)

---

I'm not aware of hitting issues with ms_foreachdb skipping databases. But, you're right, it's technically unsupported by Microsoft, so could go away at any time. It's just a...

lisa.randles (2/4/2014)

---

Hi, all. No ideas on how to view the full error? Bummer. 😉

Grant, I'll see what I could do with the brackets, although I'm pretty green...

helmi (2/4/2014)

---

Yes I tried not to select NULL-values, but I think I explained the problem wrong. The column ProdStatusLog.LastUpdatedOn doesn't contain NULL values, but when I execute the statement, all...