mister magoo has a good solution in this thread which I have used before.

http://www.sqlservercentral.com/Forums/Topic1724454-150-1.aspx

Gmail is port 587 or 465 try both.

So Email address should be your gmail address.

Server name should be smtp.gmail.com

Check the SSL check box

Under authentication click basic and then enter...

I was confused as well so tested it quickly - only Date and January are returned see attachment.

Also using the default settings nothing is returned. The frequency threshold needs to...

Is the user the Agent job is running under a member of the DatabaseMailUser role in the msdb database?

The user will be the job owner - or if the job...

13.0.1500.00

See below. This has hardcoded columns, if you want to make it dynamic have a look at the linked article.

https://www.mssqltips.com/sqlservertip/2783/script-to-create-dynamic-pivot-queries-in-sql-server/

SELECT *

FROM

(SELECT PatientStatus, Location, PatientVisits, YearMonth

FROM #TEST)...

Vijaya Kadiyala (6/27/2008)

You can use some tools to compare the tables/schemas/databases but how would you compare the data in those tables? If databases are really then !!..

But first of all...

In SQL. See links below for the permissions required and the syntax.

https://msdn.microsoft.com/en-us/library/ms178640.aspx

https://msdn.microsoft.com/en-us/library/ms173848.aspx

You can impersonate another user or login but you need to have been granted impersonate permissions on the user or login first.

EXECUTE AS USER = 'Domain\User'

EXECUTE AS LOGIN= ...

you can use the following view to see all the foreign keys in a database and the created/modified dates.

select * from sys.foreign_keys

These other views are useful for looking at...

If the data is being reported on then is it not more important to ensure it is correct? Can the data be consolidated during the load process which would reduce...

You could use a cte and Row_Number and insert all rows which have a row number less than 1,000,000.

WITH x AS (SELECT MyValue

...

If you have run checkdb manually and no issues then I think you'll be OK. checkdb uses an alternate ntfs filestream to create a "copy" of the database when running....

True, the poster mentioned special characters which I assumed to mean Unicode

Looks like you lost some information when pasting the sql. You don't have any '' around the statement you are trying to assign to @QRY and looks as if there...