Viewing 15 posts - 3,631 through 3,645 (of 7,636 total)
dlongnecker (2/2/2009)
insert into xml_table (data)
select * from example_table where example_table_pk='102' for xml auto
returns
Msg 6819, Level 16, State 1, Line 3
The FOR XML clause is...
February 3, 2009 at 12:00 pm
GilaMonster (2/2/2009)
Matt Miller (2/2/2009) That doesn't mean you get to put down our little tournament:)
Oh, I'm not trying to put your 'little' tournament down. I just don't know what...
February 3, 2009 at 11:22 am
steve (2/2/2009)
February 2, 2009 at 11:39 pm
Glad I could help, Gus. (Suprised, too. I almost never get XML queries right the first time... 🙂 )
February 2, 2009 at 9:41 am
Then use the replication monitor's. You should find them in EM, in the explorer pnae (left hand side). There should be two top level folders for Replication (sorry,...
February 2, 2009 at 9:34 am
Make a change on a published table in the source database. Then go over to the target DB and see if the change shows up.
February 1, 2009 at 8:34 pm
Bruce W Cassidy (2/1/2009)
Max (1/30/2009)
Personally, I think we should scour the earth of all rdbms and use an abacus, ok, at a push flat files, but there my generosity ends.
[font="Verdana"]We...
February 1, 2009 at 7:58 pm
Interesting. I would not have thought that this would work, but apparently it does because LOCK_TIMEOUT is a connection attribute, and not a batch attribute.
February 1, 2009 at 7:40 pm
GilaMonster (2/1/2009)
Marios Philippopoulos (2/1/2009)
I don't think it's the estimated exec plan, I obtained it from sys.dm_db_exec_requests. It was retrieved when the statement was actually executed...
It's the same as the 'estimated'...
February 1, 2009 at 6:38 pm
Jeff Moden (1/30/2009)
February 1, 2009 at 6:31 pm
Thanks for the feedback Stephen.
February 1, 2009 at 6:17 pm
Viewing 15 posts - 3,631 through 3,645 (of 7,636 total)