SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


All Link servers working status check and failure alert over E-mail


All Link servers working status check and failure alert over E-mail

Author
Message
Subhash Chadra
Subhash Chadra
Grasshopper
Grasshopper (16 reputation)Grasshopper (16 reputation)Grasshopper (16 reputation)Grasshopper (16 reputation)Grasshopper (16 reputation)Grasshopper (16 reputation)Grasshopper (16 reputation)Grasshopper (16 reputation)

Group: General Forum Members
Points: 16 Visits: 86
Comments posted to this topic are about the item All Link servers working status check and failure alert over E-mail
Jeroen Hilgers
Jeroen Hilgers
Grasshopper
Grasshopper (14 reputation)Grasshopper (14 reputation)Grasshopper (14 reputation)Grasshopper (14 reputation)Grasshopper (14 reputation)Grasshopper (14 reputation)Grasshopper (14 reputation)Grasshopper (14 reputation)

Group: General Forum Members
Points: 14 Visits: 86
The script works fine for SQL2012 . But does not for SQL2008 and 2008R2.
Error:

Msg 102, Level 15, State 1, Procedure proc_check_linked_servers, Line 37 [Batch Start Line 0]

Incorrect syntax near ' '.

Msg 102, Level 15, State 1, Procedure proc_check_linked_servers, Line 39 [Batch Start Line 0]

Incorrect syntax near ' '.

Msg 102, Level 15, State 1, Procedure proc_check_linked_servers, Line 40 [Batch Start Line 0]

Incorrect syntax near ' '.

Msg 102, Level 15, State 1, Procedure proc_check_linked_servers, Line 42 [Batch Start Line 0]

Incorrect syntax near ' '.

Msg 102, Level 15, State 1, Procedure proc_check_linked_servers, Line 43 [Batch Start Line 0]

Incorrect syntax near ' '.

Msg 137, Level 15, State 2, Procedure proc_check_linked_servers, Line 43 [Batch Start Line 0]

Must declare the scalar variable "@emailSubject".

Msg 102, Level 15, State 1, Procedure proc_check_linked_servers, Line 46 [Batch Start Line 0]

Incorrect syntax near ' '.

Msg 137, Level 15, State 2, Procedure proc_check_linked_servers, Line 53 [Batch Start Line 0]

Must declare the scalar variable "@emailSubject".

Msg 319, Level 15, State 1, Procedure proc_check_linked_servers, Line 53 [Batch Start Line 0]

Incorrect syntax near the keyword 'with'. If this statement is a common table expression, an xmlnamespaces clause or a change tracking context clause, the previous statement must be terminated with a semicolon.


Subhash Chadra
Subhash Chadra
Grasshopper
Grasshopper (16 reputation)Grasshopper (16 reputation)Grasshopper (16 reputation)Grasshopper (16 reputation)Grasshopper (16 reputation)Grasshopper (16 reputation)Grasshopper (16 reputation)Grasshopper (16 reputation)

Group: General Forum Members
Points: 16 Visits: 86
j.hilgers - Thursday, February 8, 2018 2:52 AM
The script works fine for SQL2012 . But does not for SQL2008 and 2008R2.
Error:

Msg 102, Level 15, State 1, Procedure proc_check_linked_servers, Line 37 [Batch Start Line 0]

Incorrect syntax near ' '.

Msg 102, Level 15, State 1, Procedure proc_check_linked_servers, Line 39 [Batch Start Line 0]

Incorrect syntax near ' '.

Msg 102, Level 15, State 1, Procedure proc_check_linked_servers, Line 40 [Batch Start Line 0]

Incorrect syntax near ' '.

Msg 102, Level 15, State 1, Procedure proc_check_linked_servers, Line 42 [Batch Start Line 0]

Incorrect syntax near ' '.

Msg 102, Level 15, State 1, Procedure proc_check_linked_servers, Line 43 [Batch Start Line 0]

Incorrect syntax near ' '.

Msg 137, Level 15, State 2, Procedure proc_check_linked_servers, Line 43 [Batch Start Line 0]

Must declare the scalar variable "@emailSubject".

Msg 102, Level 15, State 1, Procedure proc_check_linked_servers, Line 46 [Batch Start Line 0]

Incorrect syntax near ' '.

Msg 137, Level 15, State 2, Procedure proc_check_linked_servers, Line 53 [Batch Start Line 0]

Must declare the scalar variable "@emailSubject".

Msg 319, Level 15, State 1, Procedure proc_check_linked_servers, Line 53 [Batch Start Line 0]

Incorrect syntax near the keyword 'with'. If this statement is a common table expression, an xmlnamespaces clause or a change tracking context clause, the previous statement must be terminated with a semicolon.


Hi Jeroen Hilgers,
Thanks for your inputs.

I had not tested it on 2008R2 and older versions, So agree with your words, If possible will try on old versions as well and let you know.

thanks
Subhash

Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum








































































































































































SQLServerCentral


Search