Viewing 15 posts - 3,571 through 3,585 (of 14,953 total)
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...
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
August 4, 2011 at 11:27 am
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)...
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
August 4, 2011 at 11:22 am
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;
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
August 4, 2011 at 11:19 am
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...
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
August 4, 2011 at 11:14 am
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...
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
August 4, 2011 at 11:13 am
GilaMonster (8/4/2011)
GSquared (8/4/2011)
GilaMonster (8/3/2011)
Tom.Thomson (8/3/2011)
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
August 4, 2011 at 10:51 am
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...
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
August 4, 2011 at 10:48 am
SQL 2008 can do backup compression. Are you using that?
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
August 4, 2011 at 10:42 am
Stefan Krzywicki (8/4/2011)
GSquared (8/4/2011)
GilaMonster (8/3/2011)
Tom.Thomson (8/3/2011)
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
August 4, 2011 at 10:40 am
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 USA anyway
Tell...
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
August 4, 2011 at 10:29 am
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...
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
August 4, 2011 at 10:24 am
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...
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
August 4, 2011 at 10:20 am
Freddie-304292 (8/4/2011)
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
August 4, 2011 at 10:14 am
Freddie-304292 (8/4/2011)
Just out of interest, what do people pay for health insurance in the States?
$400/month is pretty usual for a medium-level plan. It varies a lot depending on where...
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
August 4, 2011 at 8:21 am
Freddie-304292 (8/3/2011)
cengland0 (8/3/2011)
GSquared (8/3/2011)
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
August 4, 2011 at 6:49 am
Viewing 15 posts - 3,571 through 3,585 (of 14,953 total)