RegzP | SQLServerCentral

RegzP

Forum Replies Created

Viewing 4 posts - 1 through 4 (of 4 total)

Reply To: How to include newly system generated tables to SQL replication?

Thank you Michael - sorry for not responding sooner.
Yes it will be really helpful if I could have a trigger or a stored procedure to check every time a new...

November 28, 2023 at 2:53 am

#4335663
Reply To: SQL Server replication not able to see AG listener at subscriber
One thing that might be a factor is the SQL server version as it is a difference in the current set up I am attempting compared to other ones I...
- This reply was modified 1 year, 8 months ago by RegzP.
- This reply was modified 1 year, 8 months ago by RegzP.
August 10, 2023 at 11:16 pm

#4258174
Reply To: SSRS - getdate

Thank you @AntGreen and Jeffrey.
OK, I just want to ask, how is the best way to set this up? I tried doing it as an SQL job and then SSRS...

July 19, 2023 at 5:54 am

#4238851
Reply To: SSRS - How to configure date in report

Thank you for trying to help. OK so this is what the query in the report looks like;
SELECT [ID]
,[MessageTypeID]
,[EventID]
,[Source]
,[Destination]
,[Subject]
,[MessageText]
,[MessagePlainText]
,[CreatedOn]
,[UpdatedOn]
,[Provider]
,[LanguageCode]
,[SmscMessageID]
,[SmscStatus]
,[SendRetryCount]
,[MessageStatusID]
FROM [UT_XXX_Core_XXX].[messaging].[MessageQueue]
WHERE Source = '277' AND (DATEADD(month, 1, UpdatedOn) >= GETDATE())...

March 4, 2022 at 3:27 am

#3992793

Viewing 4 posts - 1 through 4 (of 4 total)