Hi Gial,

i had worked as per your suggestions, can please see below code any thing wrong please correct me because i m new to developing side

Requrement was below

1. Trace...

Hi Lowell,

as per your suggestion it is not working

any of team please Drive me on good direction its really helpful to me .

Tx

Hi Team,

I m Executing the above script

in MASTER DB

but i m getting below Error can you please suggest me.

Msg 2812, Level 16, State 62, Line 1

Could not find stored...

Hi Team,

My Requrement was changed. here

Right now i m tracing the new things Errorlog, Exceptions, User Error Messages

Can you people plz suggest me with good script. For Tracing and This...

Hi Team,

Thank you for your support

I have given wrong path it is completed.

🙂

Try Using REgistered Server. You Need To Register All You Instances and Run Query It Will Create User In All The Instances.

IF Not Exists(Select Name From Syslogins where name='Dummy')

CREATE...

WITH Users AS (

SELECT 'Master' [DBName]a, [name] b COLLATE Latin1_General_CS_AS FROM Master.sys.database_principals where type <> 'R' UNION ALL

SELECT 'Model' [DBName] a, [name]b COLLATE Latin1_General_CS_AS FROM Model.sys.database_principals where type <>...

Hi Team

In this way right

SELECT 'xx' [DBName]COLLATE Latin1_General_CS_AS, [name] COLLATE Latin1_General_CS_AS FROM xx.sys.database_principals

or

WITH Users AS (

SELECT 'master' [DBName], [name] COLLATE Latin1_General_CS_AS FROM Master.sys.database_principals where type <> 'R'...

Hi John

Sorry for my reply..actully im oracle guy please help me

Again i m getting bleow error

No column name was specified for column 2 of 'Users'.

Hi John,

Sorry my reply..

as per your suggestion i have changed my dbname

but i m getting below error :

Msg 451, Level 16, State 1, Line 1

Cannot resolve collation conflict for column...

hi Lowell/John,

1st is working but it will not display all the database please suggest me.

it is missing some database and i want only two cols it wil displaying one...

Hi John,

Yes your correct in the events

i have select Error Log and Login failed option it is correct right.

tx

Hi John

each Error and User login failure and how many times it occurred for this only

i have to select all errors..but in sql profiler i should not find out...

Hi John

You are correct i have select it

and for ALL ERRORS Which option i have to check.

Tx

Hi Team,

Thank you for your suggestion

Next time i could not do this type of mistakes

Really i dont know that the reason only i have posted because it is...