Thanks for your reply i have check it it's disabled

Dear Friends

Any help will be appreciated.

Regards,

Nasser

I ran code on Query Analyzer and I got theses messages

Messages:

Deleted trace queue 4.

The trace output file name is: F:\Microsoft SQL Server\MSSQL\Audit\Login Creation on SQL-Server1 20081220233000503.trc.

No active traces named Login...

Sorry for late

Copy it and paste it in query analyzer

Query Analyzer Script:

====================================

You Should create this table :

USE [master]

GO

/****** Object: Table [dbo].[USP_trace_Queue] Script Date: 12/04/2008 13:41:38 ******/

SET...

Any One help me to solve this issues

The strange thing i have another scheduled job running on same drive F:\Microsoft SQL Server\MSSQL\Audit\ and it's succussed

Job Name:Manage Trace

Job body:

((EXEC USP_TRACE_INFO 'OFF',@tracename='SQL-Server1 SQL Trace'

EXEC USP_TRACE_INFO 'ON',@file_name...

Any one can help.

I am trying to open files before two days which already created and stoped.

I don't know why i can't open it i am not talking with current one.

Trace_id Property Value

112

12C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\LOG\log_22.trc

1320

14NULL

151

212

22F:\Microsoft SQL Server\MSSQL\Audit\SQL-Server1 SQLTrace20080421000000790.trc

23500

24NULL

251

Actually i am creating from sql server 2005 and trying to open it from sql server profile.

What do you mean...

Dear Friends

I finaly found the solution :

The one that seems to trip up most users is

that the service account used by the sql agent service has to be...

Thanks for your reply.

But I already have the provider script and it's there as ADSI linked server still the problem there.

script for creation:

EXEC master.dbo.sp_addlinkedserver @server = N'ADSI',...