"BOL suggests that TOP should be used:"

"It is recommended that DELETE, INSERT, and UPDATE statements currently using SET ROWCOUNT be rewritten to use the TOP syntax. For...

Bill,

From what you described i get the impression that it maybe possible to use the sqlweb release features of sql2k to handle xml over http. If that were possible you...

Thank you very much for your leg work it is something difficult to spot and definitely will go into my bag of "check before release"

Can you be a little more specific? What do you mean by ten times consecutively?

1. That it went  10 in the same date

2. That the region is visited 10 times...

I don't see what's the problem with using the newid() function in your procedure. The real cool thing about the uniqueidentifier  column type is that you can know in the...

Being a consultant I really dislike questions like this. From  my point of view you are waisting my time. With any answer that I could give you won't know if I will...

Let me add one more thing when the complexity of the operations are high there is NOTHING like a stored procedure. With stored procedure you can ENFORCE Filters (parameters). You...

the above will give you the space USED but if you need the space ALLOATED (os size) then try

sp_helpdb

HTH

I am here all 100% with rockmoose I try A LOT to use sp as much as I can. Why? The indirection level that it provides (Isolation from data structure)...

Just to make the point clear sysproceses will give you a snapshot of tha activity at the time you run the query against it  (as profiler does) but if you...

I suggest you run a Profiler trace to find out what is really going on. I have scheduled very complex stored procedures with no problems at all. The only difference...

My Opinion though, is that adding a column to a table might cause fragmentation. If your pages are full enough you will need to fit the data on the page...

You are going to be able to grab it only if it uses integrated security or if the app grabs it form client and logs it somewhere on the server

HTH

Eventhough creatting a trigger for that is not a difficult thing if you are allowed to use all the capabilities of sql server 2000 you have another choice:  Indexed views...

or:

select CustomerId

from customers

group by CustomerID

having

 Sum(case when storetype ='Mall' then 1 else o end) > =1

 and

 Sum(case when storetype ='Boutique' then 1 else o end) > =1