October 12, 2017 at 12:08 pm
Yes, still WS2003/SQL2008. Causes some issues. Upgrade in discussion now.
October 13, 2017 at 12:56 am
Thom A - Thursday, October 12, 2017 6:24 AMThat's a handy little node Microsoft have added to SSMS (17.3). They've put "XE profiler" at the bottom of the objects for a serve. Effectively does the job of profiler via Extended Events (but, obviously isn't using profiler). A nice little feature, and much easier to use than having to create an Extended Events for something you don't already have set up (and don't need long term so remove afterwards).
It is nice but there are a few bugs, which is a pity because I don't believe it was a major technical challenge to add it.
October 13, 2017 at 1:48 am
BrainDonor - Friday, October 13, 2017 12:56 AMThom A - Thursday, October 12, 2017 6:24 AMThat's a handy little node Microsoft have added to SSMS (17.3). They've put "XE profiler" at the bottom of the objects for a serve. Effectively does the job of profiler via Extended Events (but, obviously isn't using profiler). A nice little feature, and much easier to use than having to create an Extended Events for something you don't already have set up (and don't need long term so remove afterwards).It is nice but there are a few bugs, which is a pity because I don't believe it was a major technical challenge to add it.
Mmm, after a bit more investigation, noticed that there is no option to filter on Username, only nt_username. As we have SQL Authentication enabled, not that helpful... D'oh!
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
October 13, 2017 at 1:50 am
Thom A - Thursday, October 12, 2017 6:24 AMThat's a handy little node Microsoft have added to SSMS (17.3). They've put "XE profiler" at the bottom of the objects for a serve. Effectively does the job of profiler via Extended Events (but, obviously isn't using profiler). A nice little feature, and much easier to use than having to create an Extended Events for something you don't already have set up (and don't need long term so remove afterwards).
Very interesting - thanks Thom!
For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden
October 13, 2017 at 2:27 am
BrainDonor - Friday, October 13, 2017 12:56 AMThom A - Thursday, October 12, 2017 6:24 AMThat's a handy little node Microsoft have added to SSMS (17.3). They've put "XE profiler" at the bottom of the objects for a serve. Effectively does the job of profiler via Extended Events (but, obviously isn't using profiler). A nice little feature, and much easier to use than having to create an Extended Events for something you don't already have set up (and don't need long term so remove afterwards).It is nice but there are a few bugs, which is a pity because I don't believe it was a major technical challenge to add it.
There are a few other gotchas with SSMS 17.3 - particularly with its now-non-support of SQL2005's Agent tasks (I know, I know...) So don't get rid of SSMS2014 just yet!
Thomas Rushton
blog: https://thelonedba.wordpress.com
October 13, 2017 at 4:42 am
ThomasRushton - Friday, October 13, 2017 2:27 AMThere are a few other gotchas with SSMS 17.3 - particularly with its now-non-support of SQL2005's Agent tasks (I know, I know...) So don't get rid of SSMS2014 just yet!
True, but at least the product does say it only supports currently supported versions of SQL Server (2008-2017) 😉
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
October 13, 2017 at 5:22 am
Thom A - Friday, October 13, 2017 4:42 AMThomasRushton - Friday, October 13, 2017 2:27 AMThere are a few other gotchas with SSMS 17.3 - particularly with its now-non-support of SQL2005's Agent tasks (I know, I know...) So don't get rid of SSMS2014 just yet!True, but at least the product does say it only supports currently supported versions of SQL Server (2008-2017) 😉
Also true, and I knew that before I went in. "But it was working before"... :laugh:
Thomas Rushton
blog: https://thelonedba.wordpress.com
October 13, 2017 at 6:48 am
ThomasRushton - Friday, October 13, 2017 2:27 AMBrainDonor - Friday, October 13, 2017 12:56 AMThom A - Thursday, October 12, 2017 6:24 AMThat's a handy little node Microsoft have added to SSMS (17.3). They've put "XE profiler" at the bottom of the objects for a serve. Effectively does the job of profiler via Extended Events (but, obviously isn't using profiler). A nice little feature, and much easier to use than having to create an Extended Events for something you don't already have set up (and don't need long term so remove afterwards).It is nice but there are a few bugs, which is a pity because I don't believe it was a major technical challenge to add it.
There are a few other gotchas with SSMS 17.3 - particularly with its now-non-support of SQL2005's Agent tasks (I know, I know...) So don't get rid of SSMS2014 just yet!
AFAIK SSMS 2016 works with 2005, I don't have any 2005 servers around to check though, so...
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
October 13, 2017 at 6:50 am
ThomasRushton - Friday, October 13, 2017 5:22 AMThom A - Friday, October 13, 2017 4:42 AMThomasRushton - Friday, October 13, 2017 2:27 AMThere are a few other gotchas with SSMS 17.3 - particularly with its now-non-support of SQL2005's Agent tasks (I know, I know...) So don't get rid of SSMS2014 just yet!True, but at least the product does say it only supports currently supported versions of SQL Server (2008-2017) 😉
Also true, and I knew that before I went in. "But it was working before"... :laugh:
If anyone knows, I'm curious if SQL 2017 will restore a SQL 2005 database from backup.
October 13, 2017 at 6:56 am
Jack Corbett - Friday, October 13, 2017 6:48 AMThomasRushton - Friday, October 13, 2017 2:27 AMBrainDonor - Friday, October 13, 2017 12:56 AMThom A - Thursday, October 12, 2017 6:24 AMThat's a handy little node Microsoft have added to SSMS (17.3). They've put "XE profiler" at the bottom of the objects for a serve. Effectively does the job of profiler via Extended Events (but, obviously isn't using profiler). A nice little feature, and much easier to use than having to create an Extended Events for something you don't already have set up (and don't need long term so remove afterwards).It is nice but there are a few bugs, which is a pity because I don't believe it was a major technical challenge to add it.
There are a few other gotchas with SSMS 17.3 - particularly with its now-non-support of SQL2005's Agent tasks (I know, I know...) So don't get rid of SSMS2014 just yet!
AFAIK SSMS 2016 works with 2005, I don't have any 2005 servers around to check though, so...
SSMS 2016 does work with SQL 2005. I still have one I have to support.
October 13, 2017 at 8:56 am
Ed Wagner - Friday, October 13, 2017 6:56 AMJack Corbett - Friday, October 13, 2017 6:48 AMThomasRushton - Friday, October 13, 2017 2:27 AMBrainDonor - Friday, October 13, 2017 12:56 AMThom A - Thursday, October 12, 2017 6:24 AMThat's a handy little node Microsoft have added to SSMS (17.3). They've put "XE profiler" at the bottom of the objects for a serve. Effectively does the job of profiler via Extended Events (but, obviously isn't using profiler). A nice little feature, and much easier to use than having to create an Extended Events for something you don't already have set up (and don't need long term so remove afterwards).It is nice but there are a few bugs, which is a pity because I don't believe it was a major technical challenge to add it.
There are a few other gotchas with SSMS 17.3 - particularly with its now-non-support of SQL2005's Agent tasks (I know, I know...) So don't get rid of SSMS2014 just yet!
AFAIK SSMS 2016 works with 2005, I don't have any 2005 servers around to check though, so...
SSMS 2016 does work with SQL 2005. I still have one I have to support.
SSMS 2017 is working fine with 2005, 2008, 2008 R2, 2012, 2014, and 20126. Yes, I still have to support all of them!
Michael L John
If you assassinate a DBA, would you pull a trigger?
To properly post on a forum:
http://www.sqlservercentral.com/articles/61537/
October 13, 2017 at 9:10 am
Michael L John - Friday, October 13, 2017 8:56 AMSSMS 2017 is working fine with 2005, 2008, 2008 R2, 2012, 2014, and 20126. Yes, I still have to support all of them!
Timewarp again?
And lucky you, having all of those to support :ermm:
The absence of evidence is not evidence of absence
- Martin Rees
The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
- Phil Parkin
October 13, 2017 at 9:16 am
Michael L John - Friday, October 13, 2017 8:56 AMSSMS 2017 is working fine with 2005, 2008, 2008 R2, 2012, 2014, and 2016. Yes, I still have to support all of them!
and 2017 coming soon, I'm sure
October 13, 2017 at 9:20 am
Phil Parkin - Friday, October 13, 2017 9:10 AMMichael L John - Friday, October 13, 2017 8:56 AMSSMS 2017 is working fine with 2005, 2008, 2008 R2, 2012, 2014, and 20126. Yes, I still have to support all of them!Timewarp again?
And lucky you, having all of those to support :ermm:
Times like this I'm glad it's just 2012 and 2008 here. 😀
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
October 13, 2017 at 9:28 am
Thom A - Friday, October 13, 2017 9:20 AMPhil Parkin - Friday, October 13, 2017 9:10 AMMichael L John - Friday, October 13, 2017 8:56 AMSSMS 2017 is working fine with 2005, 2008, 2008 R2, 2012, 2014, and 20126. Yes, I still have to support all of them!Timewarp again?
And lucky you, having all of those to support :ermm:Times like this I'm glad it's just 2012 and 2008 here. 😀
Even that would frustrate me. SSIS changed so much in 2012, I'd hate to have to deal with it in 2008 again.
The absence of evidence is not evidence of absence
- Martin Rees
The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
- Phil Parkin
Viewing 15 posts - 60,106 through 60,120 (of 66,712 total)
You must be logged in to reply to this topic. Login to reply