Reputation
374
Top tag
Next privilege 500 Rep.
Access review queues
Badges
2 13
Impact
~20k people reached

  • 0 posts edited
  • 0 helpful flags
  • 29 votes cast
Apr
15
accepted Log Shipping -Monitor Server Down - Copying happening but not restoring on secondary
Apr
15
comment Log Shipping -Monitor Server Down - Copying happening but not restoring on secondary
Hi, OK so I'm just confirming please : because the Monitor Server : Log_Shipping_Primaries isn't updated - thats why the secondary server is failing? This is a standard feature of Log Shipping and cannot be changed via a setting? Thanks
Apr
13
revised Log Shipping -Monitor Server Down - Copying happening but not restoring on secondary
edited title
Apr
13
asked Log Shipping -Monitor Server Down - Copying happening but not restoring on secondary
Apr
7
awarded  Popular Question
Feb
14
awarded  Popular Question
Nov
5
awarded  Popular Question
Sep
28
awarded  Popular Question
Sep
18
accepted SQL Server 2008 R2 - remove line below heading (which has ----,----) - dont have SSIS
Sep
17
comment SQLCMD - add date to CSV. When run inside Command Prompt it works, when in Job then %date
You just saved me from having to enable xp_cmdShell. Thank you so much!
Sep
17
accepted SQLCMD - add date to CSV. When run inside Command Prompt it works, when in Job then %date
Sep
16
asked SQLCMD - add date to CSV. When run inside Command Prompt it works, when in Job then %date
Sep
15
asked SQL Server 2008 R2 - remove line below heading (which has ----,----) - dont have SSIS
Sep
5
accepted Operand type clash: my first User Defined Type with list of Integers, how to test via SSMS
Sep
5
comment Operand type clash: my first User Defined Type with list of Integers, how to test via SSMS
I still dont understand the jist of this please. I can create a table, insert the values, but how to execute please, this still gives error .declare ATlist as table(l nvarchar(max)) insert Into ATlist(l)values('1,2,3,4,5') exec sp_UseStringList ATlist
Sep
5
asked Operand type clash: my first User Defined Type with list of Integers, how to test via SSMS
Jul
23
comment SQL Server - constraint to prevent overlapping dates
Thanks Paul, I will reword with an example on what the differences are.
Jul
23
revised SQL Server - constraint to prevent overlapping dates
added 251 characters in body
Jul
23
comment SQL Server - constraint to prevent overlapping dates
As I mentioned, if you take the effort (which you wont now that were having this discussion), you'll see that the link provided is not related to this question at all.
Jul
23
comment SQL Server - constraint to prevent overlapping dates
This is already on the first page of google when you search for "sql prevent overlapping dates". I think has a higher likelihood to be found than the other links.