Viewing 15 posts - 4,696 through 4,710 (of 8,755 total)
Here is one way of doing this, maybe not the most efficient but it works.
The method is almost identical to what Chris posted before and works with the sample...
August 15, 2015 at 1:57 am
Jeff Moden (8/14/2015)
Eirikur Eiriksson (8/14/2015)
Jeff Moden (8/14/2015)
Heh... since it's for XML...
Trying to put my finger on this, just cannot find which kind of XML phobia is plaguing you Jeff:Whistling:, so...
August 14, 2015 at 6:46 pm
Gail, thank you for the correctio back there, makes me feel kind of sheepish
😎
August 14, 2015 at 4:30 pm
GilaMonster (8/14/2015)
Eirikur Eiriksson (8/14/2015)
Chris.Hubbard4U (8/14/2015)
Eirikur Eiriksson (8/14/2015)
Chris.Hubbard4U (8/14/2015)
I have a database In Recovery.Where do I check the completion status of the recovery?
Quick thought, query sys.dm_exec_requests and check for command='RECOVERY'
😎
I queried...
August 14, 2015 at 4:26 pm
Jeff Moden (8/14/2015)
Heh... since it's for XML...
Trying to put my finger on this, just cannot find which kind of XML phobia is plaguing you Jeff:Whistling:, so far I've checked these
😎
Ablutophobia...
August 14, 2015 at 4:14 pm
drew.allen (8/14/2015)
Eirikur Eiriksson (8/14/2015)
August 14, 2015 at 3:58 pm
Chris.Hubbard4U (8/14/2015)
Eirikur Eiriksson (8/14/2015)
Chris.Hubbard4U (8/14/2015)
Where I execute the command SELECT @@ServerName it returns NULL?This just started today.
What could cause that?
What does
SELECT SERVERPROPERTY ( 'InstanceName' )return?😎
NULL:unsure:
Are you connected to...
August 14, 2015 at 3:53 pm
Jeff Moden (8/14/2015)
Eirikur Eiriksson (8/14/2015)
Ed Wagner (8/14/2015)
Eirikur Eiriksson (8/14/2015)
Alvin Ramard (8/14/2015)
Eirikur Eiriksson (8/14/2015)
SQLRNNR (8/14/2015)
Eirikur Eiriksson (8/14/2015)
August 14, 2015 at 3:51 pm
tjs8984 (8/14/2015)
It is implied that if there are two occurrences of the same [Name] element then one will have the AnnualizingFactor of 2080.
Correct. When two occurrences with...
August 14, 2015 at 1:03 pm
Ed Wagner (8/14/2015)
Eirikur Eiriksson (8/14/2015)
Alvin Ramard (8/14/2015)
Eirikur Eiriksson (8/14/2015)
SQLRNNR (8/14/2015)
Eirikur Eiriksson (8/14/2015)
Sometimes one wonders what drives the responds when one points out that the posted solutions are not optimal.😎
Maybe he...
August 14, 2015 at 12:51 pm
Chris.Hubbard4U (8/14/2015)
Where I execute the command SELECT @@ServerName it returns NULL?This just started today.
What could cause that?
What does SELECT SERVERPROPERTY ( 'InstanceName' ) return?
😎
August 14, 2015 at 12:45 pm
Alvin Ramard (8/14/2015)
Eirikur Eiriksson (8/14/2015)
SQLRNNR (8/14/2015)
Eirikur Eiriksson (8/14/2015)
Sometimes one wonders what drives the responds when one points out that the posted solutions are not optimal.😎
Maybe he has coded it differently...
August 14, 2015 at 12:41 pm
SQLRNNR (8/14/2015)
Eirikur Eiriksson (8/14/2015)
Sometimes one wonders what drives the responds when one points out that the posted solutions are not optimal.😎
Maybe he has coded it differently than you guys? ...
August 14, 2015 at 12:36 pm
It is implied that if there are two occurrences of the same [Name] element then one will have the AnnualizingFactor of 2080. It is also implied that under no other...
August 14, 2015 at 12:30 pm
Brandie Tarvin (8/14/2015)
Jack Corbett (8/14/2015)
Eirikur Eiriksson (8/14/2015)
Sometimes one wonders what drives the responds when one points out that the posted solutions are not optimal.😎
But you didn't do it...
August 14, 2015 at 12:22 pm
Viewing 15 posts - 4,696 through 4,710 (of 8,755 total)