You cannot limit by CALs. CALs are an administrative thing only; there's no setting in SQL to track this. Many applications might open more than one connection (like SSMS), so...

The results aren't showing. Perhaps you could summarize what the throughput was?

So the SQL Agent service and the SQL Server database service are running under "LocalSystem" or a local account? If the passwords are the same, it's possible that there is...

Both of the suggestions above are what I'd recommend, but I'd also have "obfuscation scripts" ready and running when you need to update test or dev from production as well.

I wouldn't necessarily move to maintenance plans. That's up to you, and they work fine, but there are limitations and great scripts here on the site that can help you...

you can profile this and see the command being run, along with the dates passed in for removing files.

Often someone expects 2 days to mean 2 backups and they might...

As mentioned, the Agent account, and the SQL service accounts, are used to often run things from the server. when you submit something from SSMS, it's running under the service...

What do you mean "real tables"

Are these created with a VFP application?

David,

thanks,

Andrew,

glad you found it.

skjoldtc (2/12/2009)

---

Hi Steve,

No. you can never reconcile your concern for the environment for your "need" to drive a Porsche. Me, I don't give a hoot about the environment so my...

Andy Lennon (2/12/2009)

---

Our analysis of the data warehouse has revealed the following compelling trends:

currently, an astonishing 100% of Porsche owners living in Colorado and named Steve Jones are happy with...

Ferks (2/12/2009)

---

We could debate and argue about Global Warming for an eternity, or until either side is proven correct, but the question still remains..

Steve, are you going to keep your...

I get a Porsche magazine and I read about the RUF last month, and then another editorial this month that complained about it.

I wouldn't mind electric, I just want my...

Wow, once again things have gone sideways on my quite a bit.

The global warming debate inspired this, precisely because there is a debate. It got me thinking that we perhaps...

I thought when I talked with someone on the SQLCAT team last year they mentioned they'd worked with someone that had 120TB or 150TB in a warehouse. lost of challenges...