here is my script as stored procedure

CREATE PROCEDURE sp_mon_default_trace(@starttime datetime = null, @LoginName varchar(100) = null, @eventid int = null)

AS

SET NOCOUNT ON;

-- source http://www.sqlservercentral.com/scripts/SQL+Trace/65790/

-- details

I think you only getting it from current active trace file, but there are more trace files, might have useful info.

check this post on how to get all the trace...

very nice post. i was trying to write something similar to yours but was stuck on how to get the archived trace file locations.

I have few suggestions. i don't...

not sure which version of sql server you are running, but if you get that error

please try to run the script in 2 steps.

creating the table as step one...

one suggestion to improve the result set.

if the database is backup to more than one physical file, your result set is displaying in multiple lines for same db. probably you...

Hi

you can actually automate this process, i mean when a failover happens we can trigger to failover rest of the mirrored dbs in the group.

try to modify little bit...

Hi

yes i am running my script on the same machine.

actually i found the solution for my problem. my script missing the sp_addpublication_snapshot part. I thought sp_addpublication will automatically create the...

I am disabling replication thru Enterprise manager --> Replication --> Disable publishing and distribution.

I restarted the server last night.

Its working now. I am getting the correct servername.

Thank you.

No I did not restarted the server. I will restart the server and check again

Thank you

but i still want to take the test. the problem is we know that real experience is much better than a MCDBA with out real exp. But the problem is...