Viewing 15 posts - 61 through 75 (of 309 total)
That path doesn't exist on the server. We normally don't create any packages on the server. We use some network location where all the packages are. I was thinking about...
November 5, 2018 at 12:17 pm
Got it.select top 10
xevents.event_data.value('(event/action[@name="sql_text"]/value)[1]', 'nvarchar(max)') AS [sql_text],
xevents.event_data.value('(event/action[@name="username"]/value)[1]', 'nvarchar(max)') AS [UserName],
xevents.event_data.value('(event/action[@name="database_id"]/value)[1]', 'nvarchar(max)') AS [DBName],
xevents.event_data.value('(event/action[@name="client_hostname"]/value)[1]', 'nvarchar(max)') AS [client_hostname],
xevents.event_data
from sys.fn_xe_file_target_read_file
('D:\ExtendedEvents\Query.xet',
'D:\
November 5, 2018 at 12:07 pm
So I found something useful on MSSQLTIPS.com but I am wondering if we can insert the result from this event into a SQL table?
November 5, 2018 at 10:01 am
November 2, 2018 at 6:27 am
October 25, 2018 at 5:22 am
goher2000 - Wednesday, October 24, 2018 2:07 PMb4 u begin, make sure apps are not using depreciated features.
Ah ha, didn't think about...
October 25, 2018 at 5:11 am
October 25, 2018 at 5:10 am
October 25, 2018 at 5:06 am
Thanks for the reply but the problem is (and trust me, its a really strange situation) that the connection string doesn't have the server name. I think all I saw...
October 19, 2018 at 11:51 am
GilaMonster - Tuesday, October 16, 2018 11:31 AMSELECT * FROM sys.traces (fn_trace_getinfo has been deprecated for years)
Thanks!
October 16, 2018 at 11:40 am
October 16, 2018 at 11:28 am
Note that you don't have to run sp_trace_setstatus separately. It's part...
October 16, 2018 at 9:14 am
October 16, 2018 at 9:09 am
Attitude of some developers:
/*I don't delete data, but when I do, I do it in prod with no Begin tran and no where clause. I mean who needs where clause? SQL Server...
October 16, 2018 at 6:32 am
This did work. However, I have a question. Can someone explain why the @@ROWCOUNT = 0 statement was causing the problem with the trigger. I'm assuming since I have two...
January 4, 2017 at 1:08 pm
Viewing 15 posts - 61 through 75 (of 309 total)