So far as I know, you either need to transfer all jobs, or list out the ones you want.

You might be able to loop through a list of jobs, perhaps...

First, you can't use "IF" in a Where clause, or, for that matter, anywhere inside of a query. It's a flow-control item, not a query-logic item.

Gail Shaw (Gila Monster)...

Try this, see if it helps:

CREATE TABLE #T (

DB sysname,

LogSize FLOAT,

SpaceUsed FLOAT,

Stat BIT);

INSERT INTO #T (DB, LogSize, SpaceUsed, Stat)

EXEC ('DBCC SQLPERF (LOGSPACE)');

SELECT * FROM #T;

Oh, and no, it's not going online behind your back to check on XML namespaces. Try using them while you're not online, in a local copy of Dev Edition...

It's more about the consumption of the XML being documented than about anything else.

It's not like an XSD, that actually allows server-level validation of your XML data, it's just a...

GilaMonster (8/4/2011)

---

GSquared (8/4/2011)

---

GilaMonster (8/3/2011)

---

Tom.Thomson (8/3/2011)

---

which stopped happening 11 years ago) because US immigration control has deteriorated to the point where no-one in his right mind wants to travel to the...

If it's a locking issue (and it could be), you might want to look into TABLOCKX. (Details on table hints are here: http://msdn.microsoft.com/en-us/library/ms187373.aspx)

That will take an exclusive lock on...

SQL 2008 can do backup compression. Are you using that?

Stefan Krzywicki (8/4/2011)

---

GSquared (8/4/2011)

---

GilaMonster (8/3/2011)

---

Tom.Thomson (8/3/2011)

---

which stopped happening 11 years ago) because US immigration control has deteriorated to the point where no-one in his right mind wants to travel to...

GilaMonster (8/3/2011)

---

Tell...

Nevyn (8/4/2011)

---

GSquared (8/4/2011)

---

Nevyn (8/4/2011)

---

Freddie-304292 (8/4/2011)

---

The form of government created by the founders of the United States and defined by its Constitution is a Representative Republic, not a Democracy. The...

Nevyn (8/4/2011)

---

Freddie-304292 (8/4/2011)

---

The form of government created by the founders of the United States and defined by its Constitution is a Representative Republic, not a Democracy. The founders were...

Freddie-304292 (8/4/2011)

---

Hard to say for definite, but it sounds like I'm paying about the same as someone in the states for my health care, and I'm covered if something were...

$400/month is pretty usual for a medium-level plan. It varies a lot depending on where...

Freddie-304292 (8/3/2011)

---

cengland0 (8/3/2011)

---

GSquared (8/3/2011)

---

Government's role in human civilization is application of force. So, the moment it moves outside of defense against force, it turns into a problem, not a...