isa (6/3/2008)

---

Hello everyone, i m suing SQLServer 2005, my server works fine, but now when i trying to logi to my web

application, it gives me error, when i opend the...

Konrad Kubiak (6/3/2008)

---

Hello,

is it possible to use mulitple pivot (to aggregate many columns) over the same header column?

I mean sth like:

PIVOT ( Sum(MaxCapacity) FOR Actual1 IN ( [0] ,[1] )...

You should explore the "ACCESS PROJECT" option ... is very customized to use this kind of things.

Rog Saber (6/3/2008)

---

I have a scales table. Below is an example of data which may be in the table. A truck comes in with a trailer (or 2 trailers). I...

Yes!

There was this time in my early DBA days that I swore by the the % on the exec plans ... I then modified a very complex set of queries...

It goes like this:

Exec dbo.sp_dropsubscription @publication='publication_name', @article='object_to_drop', @subscriber='SUBSCRIBER_SERVER_NAME'

Exec dbo.sp_droparticle @publication='publication_name', @article='object_to_drop',

@force_invalidate_snapshot=1

Exec dbo.sp_refreshsubscriptions 'publication_name'

65 .... wow... if it is not a record it must be really close 😀

Index_id = 0 implies a HEAP...

Check Configuring Linked Servers for Delegation

You should consider the use of SYNONYMS of your 'code' DB in your 'data' DBs.

Those trace flags are definitely undocumented and a google search reveal that they are used for capturing "sql dump info". You should use one of the ones I posted.

Replication normally does NOTworks with ALIASES for named pull subscriptions.

You must use anonymous subscribers or Push subscription.

The main problem with those percentages come up fairly frequent when UDFs are used.... be really careful. But I do agree that it is a good "starting" point.

Which Trace flag did you use 1222 or 1204 ?