Schadenfreude-Mei (7/29/2010)

---

Havent tried it but would assume that you would pipe to an output file. something like:

sqlcmd -S . -d master -Q "select name from sys.databases" -o "c:\output.csv"

But obviously inside...

Havent tried it but would assume that you would pipe to an output file. something like:

sqlcmd -S . -d master -Q "select name from sys.databases" -o "c:\output.csv"

But obviously inside a...

You dont need permissions to see the linked server but you need permissions on the destination.

So may your dev's have had the destination rights scrubed?

🙂

How big is the database in question?

Is there a reason you have gone for L-shipping over mirror?

Is space/time an issue that prevents full backups each day?

I have a similar issue.

I have a SQL 2005 Standard 32-bit server and our Idera DM reports that disk C:, E: (user db logs) and T: (temdb) are more or...

It really depends what the selects do. If a select * from is used, chances are this is not your problem. But if they are running stored procs that create...

Might be worth setting the 3GB switch anyway and the cap SQL max memory to 2.5GB to allow the OS 1.5GB but afford SQL as much as possible.

OH disallowed 🙁

TWO FOR ENGLAND!!! 🙂

Much better then last Friday's sh*t!

I really wish i hadnt bothered 😉

Just wait. Be patient.

How large is your database? Transaction level? If you have a low usage small db, then SQL wont use the available memory until it needs it. Do...

Henrico Bekker (6/23/2010)

---

Schadenfreude-Mei (6/23/2010)

---

CirquedeSQLeil (6/22/2010)

---

GilaMonster (6/22/2010)

---

What a surprise. Not.

At least we didn't lose...

You have to be patient. As SQL works and needs more, it will take more!

We have a cluster with 128GB and SQL max set to 96GB! However when the server...

OldMan,

I can second Gails and others comments, you should NOT set the min and max to the same. In your case you should set the max to 13500 (and to...