This question, and its "correct" answer really makes no sense. What is the snapshot replication was on 1 article with 100 rows, and the profiler was capturing every event known to...

Be aware that you can not attach a 05 to 00.

Terry

Thank you Kirk. That worked out well. I really appreciate the help.

Terry

Good article on SED. But could you not just specify LF as the Row Delimiter in the properties of the Text File source within the package? 

This may not have solved...

I am running multiple instances of 2000, and one instance of 2005, and both sets of client tools on my laptop with no issues.

Though 2005 client tools are mostly backwards...

How can you state "Usage of DBCC commands is not supported in SQL Server 2005"? This is just not true.

Some DBCC commands are deprecated (e.g. DBCC PINTABLE), but such...

Bogus question. BOL clearly states

User_ID: This feature will be removed in a future version of Microsoft SQL Server. Avoid using this feature in new development work, and plan to...

I've installed SP4 on about 60 SQL servers with no ill-effects. You need to be carefull about the order of installing if you have replication (publishers/distributors first).

Pat Mong

I am...

Resistance is futile. You will be upgraded!

Bill Gates

Yes I'm being picky but doesn't this belong in Scripts rather than articles?

Terry

Nice article. You inspired me to add a few counters (to my cluttered mess!)  that I was missing.

Three Points

1.I believe the "System Object : Avg. Disk Queue Length" actually belongs...

Rudy,

We do follow with recompile.

Dora,

You confirm my findings. So far nightly 100% is not feasible. We are leaning towards less frequent 100% with norecompute.

Thank you both.

Terry

661 words on cursing! Give me a f------ break.

One more thing. If you choose not to hack the system procedure (and many ppl frown on this), your role will not be able to see the current status of...

In addition to changing the stored procedure msdb.dbo.sp_get_composite_job_info  as shown in my first post, the below permissions are needed. There are only three changes to the base role permissions.

Be...