Try this:

SUBSTRING(xmlMessage,FINDSTRING(xmlMessage,"<dateTime>",1) + LEN("<dateTime>"),FINDSTRING(xmlMessage,"</dateTime",1) - (FINDSTRING(xmlMessage,"<dateTime>",1) + LEN("<dateTime>")))

Steve Jones - SSC Editor (6/23/2015)

---

This is exactly what DLM Dashboard was designed to do. Catch changes in schema. It works well for me in small projects here.

Disclosure: I work...

cphite (6/23/2015)

---

I've been running Red Gate's DLM Dashboard for a while now on one of my dev servers, and it does a good job of tracking any DLM changes. ...

I'd suggest investigating Event Notifications or using a DDL trigger. Event Notifications will probably have less impact on your server.

In addition to what Gail has said, I always recommend setting MAXDOP at the server level to something other than 0. I point people to this KB article, https://support.microsoft.com/en-us/kb/2806535,...

I wouldn't say it is a good thing. SQL Server is probably doing a clean shut down, but if the reboot is happening when users are trying to work...

amit_pjoshi 52509 (6/16/2015)

---

H Jack,

Thank you so much for your response, here are answers on your questions might be it would help:

1) Number of customer getting from query= 84610

2) Yes we...

winston Smith (6/12/2015)

---

Little background is necessary.

The infrastructure guys were doing some work a week or two ago and accidentally disconnected all VM's from the SAN.

Aside from the unplanned, horrible nature...

How many customers are being returned?

Are you connecting to the same SQL Server from BIDS and the Report Server?

Are you connecting as the same user or with the same permissions...

You can't implement a Windows Cluster using Windows 7, you need a sever OS.

The db_datareader role is for granting users select access to user objects that have a SELECT permission. If you want users to be able to execute stored procedures you...

Good advice thus far. Also, I've yet to meet a recruiter who isn't happy to help a talented person. It is how they make their money, and the...

No one can answer that question for you. You have determine what you like to do. As a DBA you are most likely, especially as a junior dba,...

You might get an advantage by having an index on both columns, but I think that you might be better of with a composite index on both Key values, especially...

What are the settings for Max Degree of Parallelism and Cost Threshold for Parallelism?

Did you do an update statistics after migrating the database to the new server?