Viewing 15 posts - 46 through 60 (of 625 total)
Yes. I get all CUs 1,2,3, 4 and 5.
Thanks for updates, I can update latest CU5 only and no need to apply all CUs 1,2,3 and 4 of SP3.
September 23, 2016 at 2:16 pm
Update statistics configured thru Maintenance plan with FULL SCAN on weekly basis, so it would completed around 57 min.
As suggested Mr. Grant, I have configured Extent Event with help...
September 23, 2016 at 1:36 pm
Hi Andrew LAckenby.
Your script is very useful for finding missing index details in database. I executed one of the busy OLTP database and outputs are 45 create index statements in...
September 23, 2016 at 12:31 am
Dropped Existing Linked server. then view has been created & working as per Mr. ChrisM suggested and scripts.
Thank you all..
September 15, 2016 at 1:44 am
Yes. it is there..
I checked - select * from sys.sysservers,
servername and datasource as below name
targetserver,96361
September 14, 2016 at 7:05 am
Yes, that view is correct SQL statement.. I have created many views with CTE Select statement in non custom port just like only Linked server name.
also SELECT query...
September 14, 2016 at 6:49 am
Remoteserver_Name -> target server which is created linked server
Port Number-> 96361 - this is custom port number was mentioned in target server at SQL 2012
SELECT *
FROM OPENQUERY (
[Remoteserver_Name,96361],
September 14, 2016 at 5:45 am
I have changed in second table as below..
SET @body1 ='<html><body></table><H3>ROAD Users</H3>
Thanks a lot Ed Wagner .. Perfectly working as you suggested.. Thank you.
August 27, 2016 at 2:34 pm
Thanks Ed Wagner.. As per your suggestion results are coming email body two different table format after changed as below coding.
But second table heading joined with last row of...
August 27, 2016 at 1:01 pm
Pl. find the attached email which is receiving in Email body.. there are two different query that two query output display in email body with line brake separately with heading.
August 26, 2016 at 9:23 am
as per above script both heading are merged in single HTML report.
I want two different HTML report in same email body. Pl give some example HTML script.
Thanks
August 26, 2016 at 7:59 am
HTML Heading not coming separately in same email report... both heading merged with in single report.
Thanks
August 26, 2016 at 7:12 am
First and Second query Result set merged with in single HTML report format. but it is not display separately in email body...
August 26, 2016 at 1:17 am
Hi Jeff.. Thanks as per your suggestion after adding as below line multiple Query result comes in Email body as desired but second set of results not comes is separately.
SET...
August 26, 2016 at 12:38 am
I have received users report in email with respective data in column order in one database.
The following include two different query in different database for fetching data. but i received...
August 24, 2016 at 8:00 am
Viewing 15 posts - 46 through 60 (of 625 total)