Reputation
391
Top tag
Next privilege 500 Rep.
Access review queues
Badges
3 15
Impact
~24k people reached

  • 0 posts edited
  • 0 helpful flags
  • 31 votes cast
Aug
7
accepted Read GPS Coordinates into LineString from Table
Aug
6
asked Read GPS Coordinates into LineString from Table
Aug
5
awarded  Popular Question
Aug
3
awarded  Notable Question
Jul
28
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