Could be a case of missing schema qualified reference. Don't rely on the default schema and add the schema name to the table name in the query.

Technically, there is nothing...

Simple solution, use the ForEach File to move the files to an "unzip" directory and unzip from there to the Fileprocess directory.

😎

This article might help

Configuring the Integration Services Service (SSIS Service)

😎

mister.magoo (5/17/2014)

---

I forgot to mention that you cannot have an xml version declaration in an XML datatype in SQL Server, so once you have the xml how you want it,...

For this I use either vi/vim...

A hunch, if the catalogs are set to "do not track changes", I believe the upgrade will not rebuild them.

Whether you HAVE to, I don't know, last time I upgraded...

A quick thought, build an alter catalog sql string and run in each db?

😎

SELECT

CONCAT('ALTER FULLTEXT CATALOG ',FTC.name,' REBUILD;')

FROM sys.fulltext_catalogs FTC

You might want to correct the problem at schema...

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) &...