I am greatly concerned that creating ANY tables PER member is even on the table. I would be very wary of any design that has to have tables per...

Not sure how much I can help but it sounds like the machine is I/O bound, meaning the I/O subsystem is at capacity, this is often experienced as low cpu...

You are very welcome.. No need to re-invent the wheel..

CEWII

I think this may already cover what you are talking about:

http://www.sqlservercentral.com/articles/SQL+Server/67215/

CEWII

Then perhaps I don't understand what you are doing..

Are you openning a table or a view for edit or for viewing?

Please describe what you did to get the data up...

How many records does it usually insert?

As Grant asked, which part is slow, the query or the insert?

CEWII

roy.b (12/14/2010)

---

Hello,

Is there a way to find the product key after I installed sql2008?

We have several servers with several licenses, we want to make sure, no license has been installed...

Thanks Lowell.

CEWII

Ok, SQL Sever must be using an either local account (created on the machine) or a domain account to login. This account is what the services use. You...

By autonumber I assume you mean identity column. Unless you have a compelling reason to want to control the increment yourself I see no reason to do it in...

I tend to like to use the "I believe you are mistaken" route, and here is a URL clearing it up?

I also have to agree that every post and every...

If you are using something like localsystem, network service, or something like that you are already done. That is not a supported configuration. SQL MUST login as a...

Give this a go:

EXEC sp_configure 'show advanced options', 1

RECONFIGURE

GO

EXEC sp_configure 'Agent XPs', 1

RECONFIGURE

GO

CEWII

Look for a button that looks like an Exclamation point.. Try that.. It re-runs the query that populates the window.

CEWII

Login with the same account that SQL uses to login. Create the mail profile. Restart SQL and agent. Then it will be in the list..

CEWII