question

shridhar avatar image
shridhar asked

Sql Server 2016 stop windows services

I have TCP/UDP listener Windows service which insert incoming records into a table (Rawtable). I have another windows service which split data and store records into three tables (Daytable, Weektable,Monthtable (ReportJantable ,ReportFebtable etc.) using Rawtable. Currently data get stored into Daytable, Weektable and ReportSeptable. Now ReportsMaytable have data which inserted in may-2017 months which is not rarely use but when I run below query:- select * into temp from ReportsMaytable where datetime between '1 May 2017' and '10 May 2017' then above services get paused. also when we try backup my database still services get paused
c#sql-server-2016windows-server-2012
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

0 Answers

· Write an Answer

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.