N_Muller (7/23/2014)

---

I have a table with with several XML columns stored as VARCHAR(MAX) because they some of the XMLs may not be valid XMLs. The table is quite large...

pmscorca (7/23/2014)

---

I explain better my question.

I need to install SQL Server 2012 on a new database server.

SQL Server 2012 isn't more sold and so I'm constrained to buy SQL Server...

Lynn Pettis (7/23/2014)

---

Eirikur Eiriksson (7/23/2014)

---

First suggestion would be to install the SQL...

Crystal ball in the repair shop, ESP network down, what can one do?😛

😎

Mark Harley (7/23/2014)

---

I think this is a matter of necessity. ...

Quick thought, you are using GEOMETRY ( Cartesian / planar ) for geographic operations, must be careful here!

😎

First suggestion would be to install the SQL 2012 alongside the SQL...

All things being equal between the two query executions, the difference would be pages loaded in cache. Hence a quick question, what happens if you flush the cache DBCC FREEPROCCACHE...

The best scripts around are Ola Hallengren's, http://ola.hallengren.com.

😎

This is normally the kind of thing I do in such situation, that is using a snip to create the search code, paste the results into a new query and...

koolme_85 (7/22/2014)

---

Also Tried

DECLARE @TBLXML TABLE (COL1 XML NOT NULL);

INSERT INTO @TBLXML(COL1)

EXEC [dbo].[bofa_sp_esb_sel_acc]

@SearchType = N'A',

@SearchInputList = N'57575757',

@FAsInputList = null

Error :-

Msg 6819, Level 16, State 5, Procedure rj_sp_esb_sel_acc, Line...

Quick thought, look for the value "Actual" in any column of the tables and track it from there.

😎

That is the flawed/bugged version.

😎

You can query the table directly instead of using a variable, straight forward;-) Here is the same code as before with the difference of using an XML column in a...

mark26parks (7/22/2014)

---

I am using MS Access 2010 and one of my databases on our shared network does not open for any user. Shows "Unrecognized Database Format." error message.

I can't even...