Take some help from http://vyaskn.tripod.com/server_side_tracing_in_sql_server.htm

MJ

Have you tried "sp_get_sqlagent_properties" stored procedure residing under msdb database. Execute it and you will see one column named "auto_start". Make use of it if useful.

MJ

To name a few- Default trace, C2 Level Auditing etc. Read abt. them at http://www.sqlmag.com/Articles/ArticleID/98709/98709.html?Ad=1

MJ

You have to use 'lock pages in mmory' privilege on 32-bit operating systems.

MJ

Gila,

Why you said that "no index on leading field" for a primary key having two columns?

TIA,

MJ

Have you granted lock pages in memory privilege to sql service account? Was sql restarted after enabling AWE?

MJ

Please look thru sql logs to find the port DAC is listening to and mention that port number wth the server name while taking DAC connection.

MJ

You can't backup the tempdb database.

MJ

select spid, status, loginame, hostname, blocked, db_name(dbid), cmd from master..sysprocesses where db_name(dbid) = 'EnterDBName Here'.

HTH!

MJ

Hope you find help at:http://www.sqlservercentral.com/Forums/Topic649456-146-2.aspx#bm652385

MJ

In management studio under object explorer details pane double-click on Jobs and then select all jobs. After tht right click and ....here you go with create script option.

MJ

It captures the estimated execution plan in XML format with full compile-time details in the TextData data column of the trace.

Showplan Statistics Profile:

Occurs during run time. It displays the...

I read somewhere that this is how its been confgured in SQL Server 2005, an enhancement to 2k...

MJ

It is completely possible provided the owner of stored procedures and the tables refrenced in it are same.

MJ

I don't think this report is a part of standard reports.

MJ