Thanks, it worked for new. However, I have some other cases for which I tried to make changes in your given query to get desired results. I have placing my...

CREATE TABLE [dbo].[tblEvent](
[eventId] [varchar](50) NULL,
[netobjectid] [varchar](50) NULL,
[EventTime] [datetime] NULL,
[EventType] [int] NULL
) ON [PRIMARY]
GO
INSERT [dbo].[tblEvent] ([eventId], [netobjectid], [EventTime], [EventType]) VALUES (N'33995300', N'6', CAST(N'2019-06-12T01:32:00.000' AS DateTime), 1)
GO
INSERT [dbo].[tblEvent] ([eventId],...

It is my local system, I am on same machine, its running SQL Server 2019 SP2 with no issue.

Tried several options for date, "2019-02-28" with and without quotes, tried other different formats like 20180228, "28-Feb-2018" etc. and also tried advanced editor to provide DT_DBDATE all tried when frustrated...

I am facing same issue and have installed SQL Server 2012 SP4, both the report server A and database Server B have same installation and SP versions, but reports do...

Assuming the browser service is running, because it is started by default when SQL Server is installed normally on any machine. If any one else know how to bring the...

Two servers (windows server 2016/SQL Server 2016) can see each others, mirroring was working too. Both machines can access each other using management studio. However the old machine having the...

TSV = Tab separated, CSV is comma separated, is this what you mean? It is just a matter of giving extension to a data file.
I have given a different...

As mentioned earlier, I have to provide a solution in c# application which can accept any source db and can Export data in files format. Then those files can be...

Your response drive me to other direction, we used SSIS too. But it is somehow requirement as I asked earlier.
We need to create a separate process as OFFLINE, for...

I need to implement some event like this one: wmi
it should be working but it won't 
Please see someone has implemented and working, please share it here.

Following help worked but I still need more activity alerts, like someone granted sysadmin rights, granted db_owner on a database etc.:
https://www.sqlservercentral.com/Forums/1385562/Alerting-when-a-login-is-created?PageIndex=1

Do I need to run any update on the database server running SQL Server 2008 R2?

You will need to apply the necessary client component fixes on the...