I am not sure what kind of hardware are you using but In the past My network admins have "tunneled" SQL server trafic for me bewtween the two offices making...

U (12/3/2007)

---

I don't mind running Profiler in a Dev environment but when there is a problem in Production environment I would rather prefer a tool that will quickly capture and...

I have been in situations in which if I would have not known about some inner workings of the SAN serplication the company was using I would not have been...

Profiler is *very* easy I don't understand why are you saying that you need something "easier"

This is actually very useful for BACKUPs that you may want to make accross the network!!

I Second the ROLLUP sugesstion

In addition COMPUTE and COMPUTE BY clauses are provided for backward compatibility only.

Cheers,

That is when I would go for coffee 😀

And one more thing that people have not mentioned about clustering is not the individual parts but the "entire" system what should be cluster-certified!!!

After the objects are created on the publisher you need to use sp_addarticle an run the snapshot agent.

the distributor will pick those up an apply them.

First: Make sure you take a look at the execution plan and you are seen no table scans...

Second: Check that you are actually retrieving what you need and no more.

......

declare @cmd_str varchar(2000)

declare @result int

create table #t1 (info varchar(255) )

set @cmd_str = 'bcp "...." queryout ....'

insert into #t1

exec @result = master..xp_cmdshell @cmd_str

select replace(info,' rows copied.','')

from #t1

where info like '%rows...

From BOL:

The order of precedence for the logical operators is NOT (highest), followed by AND, followed by OR. Parentheses can be used to override this precedence in a search condition....

Or if you are really hard pressed take a look at "openrowset"/"opendatasource"

I also think this was a tricky question because you can use ANY credentials with OPENROWSET 🙁

My experience has been similar to Josh's

addarticle in Transactional replication "creates" the storeprocedures for me on the subscribers. I have not found the name truncation issue that Josh mention though.

Cheers,