if your source has multiple lat/long for a postal code, you'd get the error;

you need to limit to a single "missing" postal code

WITH MySource

AS

(SELECT ROW_NUMBER() OVER (Partition By PostImp.ZipCode ORDER...

yes, with a data driven subscription(if you have enterprise) ; more info is needed obviously, but if the report has a parameter for UserId or email to generate an...

there are two specific, separate free downloads called SQL Server Data Tools(SSDT /SSDT-BI) that are related to SQL server 2014, so that you can do Data related projects or...

martin 48305 (12/4/2015)

---

I am having the same problem with an even simpler UPDATE statement: UPDATE ... SET ... WHERE. Even though the fields that are updated already exists with the...

Michelle-138172 (1/11/2016)

---

Thanks for the input.

I checked the SQL Server Agent and the mail profile is enabled for the Alert System.

There is no error message in the mail tables either.

The...

SQL server cannot connect to a POP3/IMAP a server to pull down the mail natively.

you can do it in a programming language like c#/VB.net, which also means you can create...

you are sure they were REALLY sent, right?

first check and make sure they were not receiving errors from the mailserver:

SELECT top 100

mail.send_request_date As SentDate,

sent_status As Reason,

err.[description],

...

hope that helps;

in the article a mentioned, search for DATABASE_OBJECT_CHANGE_GROUP , as i think that is the audit spec you are looking for;

I think that section, complete with screenshots, can...

michael.k.choffy (1/11/2016)

---

Hi Jeff,

Thanks for the quick response! There are three that I have been struggling with, V-41403, V-41404, V-41406. They all have to do with "SQL Server must...

it is an extremely robust solution. it has half a dozen...

it literally scans the entire network for all types of devices; it just happens to have a checkbox for...

also, if you run the Microsoft Assessment and Planning Toolkit, instead of letting it create a default (localdb)\maptoolkit, you could have it create databases in your CMS server; it create...

this thread seems to have the same issue:

DNS

http://dba.stackexchange.com/questions/104378/sql-server-management-studio-slow-connection-or-timeout-when-using-windows-authe

Certificates?

http://superuser.com/questions/7247/why-does-it-take-so-long-for-sql-management-studio-to-connect

Nice contribution, but a little too brief of an article for me ; i'd hope to see something like what the purpose of the script is and how it would...

you could also use a simple ForEach Loop Container, and have the Files us a pattern -"In-force for Sales and Client Services*.txt"

inside the loop you could have something conditional to...