Viewing 15 posts - 6,196 through 6,210 (of 7,484 total)
I don't think it's good practise on this site (where almost all users are USAmerican, and very few can read Simplified Chinese) to refer in a QOTD explanation to the...
February 10, 2011 at 11:12 am
My view is that this question is too confusing.
(A) sql 7.0 had log shipping provided the resource pack was installed.
(B) sql 7.0 also had log shipping to a sql 2000...
February 10, 2011 at 10:02 am
crookj (2/10/2011)
OR even better -the "9 Planes of Hell"
Joe
Or the 31 planes of existence (I guess Theravada Buddhists are more optimistic than Christians: only 1 of the 31 is hell...
February 10, 2011 at 8:52 am
I recognised some of the names, was slightly suspicious of the one including 2005 but reckoned that maybe the 2005 stuff just got an upgrade to interface to the 2010...
February 10, 2011 at 8:30 am
DHeath (2/9/2011)
EXEC sp_MSforeachdb 'USE ?; EXEC sp_changedbowner ''sa'''
and running that on the master database but it errors out with...
February 10, 2011 at 8:06 am
Brandie Tarvin (2/10/2011)
porcelain
cowrie shell
February 10, 2011 at 7:34 am
Dave Ballantyne (2/10/2011)
Is the SSC party at sqlbits going to be just me again, or is anyone else going ?
I would come if I were in the UK at the...
February 10, 2011 at 7:25 am
Robert klimes (2/9/2011)
You could try creating a central management server(http://msdn.microsoft.com/en-us/library/bb934126.aspx) an then usesp_msforeachdb 'USE [?]; EXEC dbo.sp_changedbowner @loginame = ''sa'', @map = false'
As sp_changedbowner is deprecated in SQL 2008,...
February 9, 2011 at 12:35 pm
Krasavita (2/9/2011)
SELECT *
FROM...
February 9, 2011 at 12:14 pm
Jack Corbett (2/9/2011)
February 9, 2011 at 11:51 am
CirquedeSQLeil (2/9/2011)
Brandie Tarvin (2/9/2011)
CirquedeSQLeil (2/9/2011)
HistogramDiagram
pentogram
epigram
February 9, 2011 at 11:46 am
GSquared (2/9/2011)
If...
February 9, 2011 at 10:41 am
Grant Fritchey (2/9/2011)
Blech!Sorry guys, I'm not going into that one. It smacks of "Someone is wrong on the internet" I'm sure I can spend my time elsewhere more productively.
Probably...
February 9, 2011 at 10:23 am
Gianluca Sartori (2/9/2011)
You're looking for the MERGE statement, I guess.EDIT: clicked the wrong button.
As the two inserts and the update are on three different tables, and when the target of...
February 9, 2011 at 6:34 am
Peter Trast (2/8/2011)
CirquedeSQLeil (2/8/2011)
Brandie Tarvin (1/27/2011)
Peter Trast (1/27/2011)
Inconceivable!(yes, I know what it means 😉 )
And yet, I cannot resist the temptation...
"That word. I do not think it means what...
February 9, 2011 at 5:56 am
Viewing 15 posts - 6,196 through 6,210 (of 7,484 total)