freaky. I think the SQL 2000 compat level might have something to do with it.

The only thing I can think of is to allow system catalog updates and insert...

I thought it was pretty amazing and failed over very quickly.

I did encounter one big issues with its virtualized disk subsystem and the locking it does on the physical disk.

I...

to solve the problem maybe change the delete *'s to TRUNCATE TABLE

which only logs page deallocations and not each page's changes.

just in case you missed it in the earlier post, a server side trace incurs little to no impact on performance.

Still, it's a big project with lots of moving parts...

create a table in master with a guid? ?

create table dbo.whoami (

sqlserverid uniqueidentifier

,location varchar(100)

,servername varchar(128)

,instancename varchar(128)

)

insert dbo.whoami

select newid()

,'boston'

,cast(serverproperty('machinename') as varchar(128))

,COALESCE(cast(serverproperty('instancename')as varchar(128)),'Default')

sgambale (2/10/2010)

---

tracing doesn't do it because I need to constantly count # of queries of certain users, not for one day, but always.

It's used to report on trends of #...

Only do what GT says if you like running the snapshot agent and doing table locks on the publisher.

If you just wait it will all catch up when the...

what an odd problem.

what's your DB's compatibility level ?

also what does this tell you

select * from sys.schemas

select schema_id, * from sys.objects

where name = 'GRSA0000002H5'

be very careful about having a profiler trace write to a table... especially if it's a busy production server. Writing to a table or outputting to Profiler uses the...

Work of art.

it appears to work better than the profiler's script trace definition.

you're one smart dog, Lowell!

Nice work, Lowell.

post it back here if you ever finish it up to write the trace start script.

It's more useful the way it is, though. You can acually see...

that's brutal.

If it's a big concern, I'd not hesitate to robocopy the files to a fileserver and let them back it up from there.

Cheers!

I believe the subscription will build up and wait for the subscriber to come online.

That means that a bunch of bcp files that never get pushed/pulled could fill up the...

all the default trace's settings can be gleaned from these:

select * from :: fn_trace_getinfo(1)

select * from ::fn_trace_geteventinfo(1)

even still, the only way you can change it is to turn...

My number one reccommendation is to make sure the index doesn't already exist (almost).

many times I end up adding or including 1 column to an existing index to cover whatever...