Reputation
379
Top tag
Next privilege 500 Rep.
Access review queues
Badges
2 14
Newest
 Caucus
Impact
~23k people reached

  • 0 posts edited
  • 0 helpful flags
  • 29 votes cast
2d
awarded  Caucus
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.