Ah, my bad.  You wanted to know about trace flags, not a SQL trace via profier.  Sounds like you've found what you need.  Have a good one....

Run sp_who2 and look in the programname column.  If SQL Profiler exists, someone is running a trace.  You can then track it down by using hostname and login.

The no lock hint is equivalent to running in read uncommitted isolation level.  This means that you could have dirty reads.  I would guess that the nulls came from...

With as simple as your stored procedures are, your problem may be that the data pages are dropping out of cache.  You may also look at pinned tables in BOL. ...

The first time a stored procedure runs, it is compiled and the execution plan is stored in cache.  Execution plans are aged out of cache based on the frequency of...

Look up 'deleted tables' in BOL.  You need to select firmfile, system_user(), getdate() from DELETED. 

DTS will not meet your needs if you need real time syncronization like you've said.  You must use replication or triggers.

Any process that creates a resource bottleneck could be the problem.  You should be running your backups either during a maintenance period, or in non-peak hours to minimize the performance...

I do not mind paying taxes.  Sometimes it seems like we pay alot in taxes, but we pay much less than people in other countries.  I had an opportunity...

I feel that the sole purpose of a job is to generate money for lifestyle.  While it is good to feel like you are making a contribution and experiencing some...

If you are dealing with a large database that has constant pressure, I would not recommend using DTS as it will add overhead to your database and could impact performance. ...

I usually start out at a high level with perfmon.  Monitoring disk, memory, and cpu at a high level should tell you if you need to drill down more into any...

It sounds like you are not very familiar with SQL Profiler, so if you are, please do not take offense as I am writing this from the standpoint that you...

If you have an index on vendor_name, a 'where vendor_name like 'a%' should result in an index seek.  If you don't have an index on this column, consider adding one.

There isn't a canned script that will do what you are asking for.  You must create one using the syntax that karthik suggested.  Depending on what types of constraints you...