Viewing 15 posts - 36,391 through 36,405 (of 49,562 total)
Roy Ernest (10/8/2009)
Gail, that is a politically correct way to confront the DBA... 🙂 My hats off to you. 😀
I used to be a developer remember. A developer that knew...
October 8, 2009 at 2:56 pm
SELECT @XML = '<outer>
<inner>
value
</inner>
</outer>'
SELECT @XML = '<outer><inner>value</inner></outer>'
Edit: It's the presence/absence of line breaks. If there's a linebreak anywhere in the code block, the < and > come out correct. If...
October 8, 2009 at 2:44 pm
stricknyn (10/8/2009)
Very interesting. Now I have to figure out a way to tell the DBA he's wrong without stepping on his toes...
"Sorry to bother you, I just noticed this...
October 8, 2009 at 2:42 pm
This makes no sense. Why did your XML come out fine when I posted it, but nothing else I post gets the < and > correct?
select @XML = '<root>
<column_name>
<node_a>value1</node_a>
<node_b>value2</node_b>
</column_name>
</root>';
select @XML...
October 8, 2009 at 2:33 pm
Took your code, copied into management studio. Ran it (just to see what it did. XML is not my friend)
Copy paste back here.
declare @XML XML;
select @XML = '<root>
<column_name>
<node_a>value1</node_a>
<node_b>value2</node_b>
</column_name>
</root>';
select x.y.value('local-name(.)', 'VARCHAR(50)'),
x.y.value('.',...
October 8, 2009 at 2:26 pm
GSquared (10/8/2009)
October 8, 2009 at 2:22 pm
A checkDB on the database dbdata returned no error messages?
October 8, 2009 at 2:17 pm
Nope. A restore will always restore the data and log files and will restore them to the same sizes they were at the time of backup. You can elect not...
October 8, 2009 at 2:03 pm
Krasavita (10/8/2009)
Should run under master
Anywhere. You're specifying the name of the database in the command. It can run from any database, doesn't matter.
October 8, 2009 at 1:59 pm
Hmmm...
SELECT Something FROM SomeWhere WHERE Col1 <> Col2
DBCC CHECKDB (<Database Name>) WITH NO_INFOMSGS, ALL_ERRORMSGS
Forums definitely don't like me. :crying:
October 8, 2009 at 1:52 pm
Jeffrey Williams-493691 (10/8/2009)
Edit: interesting, worked on preview - then gets modified as above.
Yeah, I noticed that earlier.
October 8, 2009 at 1:32 pm
stricknyn (10/8/2009)
Could not allocate space for object 'dbo.CLAIM_DETAIL'.'idx_CLAIM_DETAIL_7' in database 'Claim' because the 'PRIMARY' filegroup is full.
That's not a log full error. That's saying that the primary data file is...
October 8, 2009 at 1:23 pm
That doesn't really help me. I've got a fair few 'templates' that I have set up for quick insert via a firefox plugin. Cutting them to management studio and pasting...
October 8, 2009 at 1:08 pm
Krasavita (10/8/2009)
Before I run DBCC CHECKDB ({Database Name}) WITH NO_INFOMSGS, ALL_ERRORMSGS. Is this going to cause my webside to go down?
No, but it may slow things down.
Make sure you replace...
October 8, 2009 at 12:34 pm
Krasavita (10/8/2009)
Error: 0, Severity: 19, State: 0
Attempt to fetch logical page (1:38) in database 'dbdata' belongs to object '0', not...
October 8, 2009 at 12:33 pm
Viewing 15 posts - 36,391 through 36,405 (of 49,562 total)