Hi Lowell,

Thanks again for responding...

From what I was told from a colleague of mine, the items mentionned are indeed good points but I am confirming that the last 3 have...

Since the trace will never be closed and it will be started via command line , how would I go upon this if at all possible in validating which events...

K thanks !

I've launched a profiler trace and piped it towards a directory and a file...

I see 2 ID's within sys.traces but with the one I launched has a path...

Just to clarify ... if I am starting a custom trace ( not server default ) from profiler and would like to confirm the events that I am tracing .

Would...

Awesome... thx for your help.

Indeed i just wanted to get an output and make sure that the SETEVENTS that were set when the trace was created are in fact being...

damn google 🙂

thx a bunch

Thank you ! now the output is as I wanted.

Actually i don't need @@version. need something like this

abc master1NULL0x01

abc tempdb2NULL0x01

abc model3NULL0x01

abc msdb4NULL0x01

select * from openquery([abc],'SELECT...

I need more help with another query towards a linked server ... pardon my ignorance with the syntax 🙂

I'm trying to merge these two queries to get the linkedserver along...

Thanks ... that's works 🙂

I was trying to separate both queries.

Thanks for your help! It seems I have mistakingly not given a linked server within the job a connection string....

Although the error was misleading 🙁

Does anyone have any idea ? I still cannot seem to run the jobs as it ends with the above error

Thanks for that and it does indeed work on a sole database at a time.

I would need it to run from master and get all databases

Actually it doesn't work as it lists back all linked servers on the specific server 🙁

I just need the server where i'm receiving the info from...

thanks

This will work I guess , although I would like the column at the beginning...

SELECT

distinct A.login_name Login, A.host_name 'Originating HostName',

DB_NAME(B.Database_ID) DBName, B.command,

A.program_name,

data_source as 'Linked Server Name'

FROM [linked].master.sys.dm_exec_sessions A

...