Question, did you try to attach the mdf with ATTACH_REBUILD_LOG?

😎

Quick suggestion, use wildcard for the namespaces

😎

USE TEEST;

GO

SET NOCOUNT ON;

IF OBJECT_ID(N'tempdb..#Data') IS NOT NULL DROP TABLE #Data;

SELECT

CONVERT(XML,'<PropertyList xmlns="urn:schemas-microsoft-com:xml-analysis" xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/">

<Catalog>My_CAT</Catalog>

<Cube>My_Cube</Cube>

<DbpropMsmdOptimizeResponse>1</DbpropMsmdOptimizeResponse>

...

torrid.inundate (10/28/2016)

---

Still i failed to get desire result.

/*

The following example displays the current date and time, uses CAST to change the current date and time to a character data...

Quick suggestion, use the CONVERT (link to BOL) function to explicitly convert the string values to the datetime data type rather than depending on any implicit conversion

😎

SQLSalas (10/28/2016)

---

Yeps, that was it. I have to flip it and flip it back.

Although it says it was enabled in the configuration, there were 2 traces with...

SQLSalas (10/27/2016)

---

It looks like the default trace is no longer running for SQL 2016. Trace is scheduled to be deprecated but i thought it still is usable for SQL...

hegdesuchi (10/25/2016)

---

I have a scenario where I have to create a replication of a target table along with source Id field.

If I have Target Table with columns :

Target_ID,

name,

createdate which is...

Thanks for the correction Luis!

😎

albanamino09 (10/27/2016)

---

Hello,

I need to round some values in a column, with a step of 30.

For example,

every value from 0.1 to 29.9 to be rounded to 30,

every value from 30,1...

arto.ojala (10/27/2016)

---

There are some CONVERT_IMPLICIT-statements in execution plan when login is Finnish.

I guess this has got something to do by conversions, when having numbers in char or varchar-column, and using...

Brandie Tarvin (10/27/2016)

---

Eirikur Eiriksson (10/27/2016)

---

Brandie Tarvin (10/27/2016)

---

I foresee that question being asked again in the very near...

Do you see anything...

david.jack (10/27/2016)

---

Hmmmm... it doesn't work in my scenario but, as per your assessment, the formula does seem to be correct, so my results must be the product of joins/grouping I...

david.jack (10/27/2016)

---

Hi,

I'm very grateful for any light that can be shed on this. My code was per the following:

SUM( ISNULL( NULLIF(VAL1,0), VAL2) )

My understanding is that this should return the...

You are very welcome.

😎