Viewing 15 posts - 331 through 345 (of 399 total)
This isn't bad, but personally I use something called Data Scripter (It's from the "I want some Moore" blog, and appears to have been written by a Sean Price).
It's...
February 22, 2011 at 10:24 am
Will this also work for Filegroups that are specified Read-Only?
February 19, 2011 at 3:04 pm
Craig if I may - just one last question on this subject, because you have mentioned it a couple of times. As I have previously stated, the server will...
February 19, 2011 at 12:10 pm
Sorry for the delay on this one Lutz. I did the standard SELECT INTO just above the work you helped me out with, but was getting errors. I...
February 18, 2011 at 1:37 pm
Craig, thank you again. I think the only other thing that will go on C:\DRIVE is going to be the backups, and that is it. That is the...
February 18, 2011 at 1:35 pm
Hi Craig -
Wanted to pick your brain on one other idea for this RAID configuration I have been working on. We previously discussed the idea of putting tempdb...
February 18, 2011 at 10:44 am
I'm almost there...How do I get the result set now into the table? I've tried all the normal methods of SELECT INTO and SELECT / INSERT INTO, but I'm...
February 15, 2011 at 6:49 pm
Blaaaaaaaaaaaaaaaaaaaaaaaaaaah. . .Columns - not data. 🙁
DECLARE @XML xml;
SET @XML ='
<Root>
<Customer ID="1" FirstName="John" LastName="Doe" Street="123, Fake Street" City="Anytown" State="NY" Zip="11280" HomePhone="555-123-4567" WorkPhone="555-456-7890" MobilePhone="555-111-2345" EMail="jDoe@someweb.com">
<Accounts>
<Saving ID="100000" Balance="548.25" Active="1">
<Transactions>
<Transaction ID="1"...
February 15, 2011 at 5:15 pm
LutzM (2/15/2011)
Rich Yarger (2/15/2011)
Hey gang - thank you again!Just one last thing...
My DECLARE and SET up at the top of the XML data should be. . .???
... like the example...
February 15, 2011 at 5:12 pm
Oooooooooh my goodness! You are correct! Oh boy...I need to do some revamp now. We were convinced that we did not have enough uniqueness in our Command...
February 15, 2011 at 5:05 pm
Hey gang - thank you again!
Just one last thing...
My DECLARE and SET up at the top of the XML data should be. . .???
February 15, 2011 at 4:59 pm
Thank you Mister Magoo! I will probably forgo extracting the TransactionDate, only because there is a GETDATE default on that column, and I want that timestamp for when the...
February 15, 2011 at 4:17 pm
You know what? I just noticed from the postings by Sean and Mister Magoo, that those are not dups - they have different AlertID's.
So - that's not it.
:crazy:
February 15, 2011 at 1:22 pm
Hi guys!
What I am needing to do is extract out the Transaction information. Basically I have a tbl called Transactions that has the following columns:
- TransactionID (PKey,...
February 15, 2011 at 12:56 pm
Hi Sean and Mister Magoo!
Yup - I was just coming out here to tell you guys that I found the problem (took the DATETIME data into Excel, and found it).
This...
February 15, 2011 at 12:40 pm
Viewing 15 posts - 331 through 345 (of 399 total)