Comments
Sort by recent activity
I have had 3 occasions today where I have take the script of an object (hover over name and Copy script from popup window) and pasted it into a new SSMS query and the formatting has been all left justified.
Ctrl K, Y only keeps it there,
Ctrl B,L indents it as 'normal'.
Subsequent Ctrl K,Y left justifies everything / comments
I have had 3 occasions today where I have take the script of an object (hover over name and Copy script from popup window) and pasted it into a new SSMS query and the formatting has been all left ...
I have noticed the above scenario but had put it down to something I had done previously. Will look for it again and give more precise details.
v3 used to do something similar - something like, if you didnt use the autofill in one place in the script and then type 'SELECT ... FROM Orders ' the alias autofill would complete the line with 'AS wher'
Has anyone else noticed that the syntax checker is more strict? The red wavy lines are taking over!
Jonathan / comments
I have noticed the above scenario but had put it down to something I had done previously. Will look for it again and give more precise details.
v3 used to do something similar - something like, if ...
Just to add my vote to this: I will be very pleased to see the app for transferring the snippets. / comments
Just to add my vote to this: I will be very pleased to see the app for transferring the snippets.
Got it moved and the custom snippets are available on new PC.
Many thanks.
Jonathan / comments
Got it moved and the custom snippets are available on new PC.
Many thanks.
Jonathan
Hi Emma,
Unfortunately I will have to wait until a 3-way deadlock occurs again before I can provide the screenshot.
kind regards
Jonathan / comments
Hi Emma,
Unfortunately I will have to wait until a 3-way deadlock occurs again before I can provide the screenshot.
kind regards
Jonathan
Deadlock occurred and screen shots sent as requested.
Jonathan / comments
Deadlock occurred and screen shots sent as requested.
Jonathan
Hi Emma,
Apologies for the delayed response - I have been on leave.
Just to pick the first at hand in SQL Response currently:
The alert type is Long running query.
I have no value for the Detail column.
the SQL process details has one row in it. this gives the process name as ".Net SQLClient Data Provider"
the Start Time is shown as 23/04/09 15:03:28 (it is currently 15:26)
there is no SQL query fragment displayed
From the details I know a slow query was executed but I have no way of knowing what the query was or what database it was running against ...
Would a screen shot help?
regards
Jonathan / comments
Hi Emma,
Apologies for the delayed response - I have been on leave.
Just to pick the first at hand in SQL Response currently:
The alert type is Long running query.
I have no value for the Detail co...
Hi David,
I was using Vista at the time of the application upgrade, although I am now in the process of moving to a new XP PC.
regards
Jonathan / comments
Hi David,
I was using Vista at the time of the application upgrade, although I am now in the process of moving to a new XP PC.
regards
Jonathan
Hi,
I have already posted on something along these lines but it may be worth adding my thoughts here too (that and I can t find the other post to cross refer!)
We have replication working here 24/7. Most of the replication jobs run hourly but our main data updating is done M-F 9-5. This means that replication jobs that run during the day take much longer that those over night. We get alerts, predictably, in waves as we go from one cycle to the other until the average of the previous 10 executions levels.
Unfortunately Mike's suggestion of a target 'time to complete' wont work for this situation unless we can link it in some way to a schedule
ie: overnight/w-end execution 1min +-20%
weekday execution 5min +-20%
Possibly a more flexible alternative would be to class the severity of the difference from the norm (and possibly the faster or slower indicator too) and also allow for a selection of how many executions to use for the average value calculation?
For me, ideally, I would like to set a schedule for the alert to be active - I dont really mind if the 02:00 replication ran or not (probably only 3 or 4 rows were updated) but if the alert was monitoring the 08:00 - 18:00 period ... much more relevant and important and so deserving of an alert. / comments
Hi,
I have already posted on something along these lines but it may be worth adding my thoughts here too (that and I can t find the other post to cross refer!)
We have replication working here 24/7...
OK, a little later in the day and the red cross is back...
the error message is :
A connection was successfully established with the server, but then an error occurred during the pre-login handshake. (provider: SSL Provider, error: 0 - The certificate chain was issued by an authority that is not trusted.)
I look forward to further advice.
Jonathan / comments
OK, a little later in the day and the red cross is back...
the error message is :
A connection was successfully established with the server, but then an error occurred during the pre-login handsh...