Anyone seen the OP since this morning?

CirquedeSQLeil (4/29/2010)

---

Steve Jones - Editor (4/29/2010)

---

I went back and looked at the wording in Jeff's draft. The issue there is that many of us borrow code for others and use...

aqkhan_k (4/29/2010)

---

When a publication database is mirrored, Log Reader Agent behavior is governed by the mirroring state of the database. By default, the Log Reader Agent can only replicate log...

CirquedeSQLeil (4/29/2010)

---

Brandie Tarvin (4/29/2010)

---

Please tell me what...

Just a little scary.

Executing the query "BACKUP LOG [master] TO DISK = N'\\\\oxygen\\SQLBackups\\carbon\\master\\master_backup_201004290800.trn' WITH NOFORMAT, NOINIT, NAME = N'master_backup_20100429080009', SKIP, REWIND, NOUNLOAD, STATS = 10

" failed with the following error: "Cannot back up...

Not yet. I think we all have gotten a bit busy with other things and gotten a little...

Must be using multiple t-log files since the max size of the t-log is 2 TB.

Since you are not using a witness, if the mirror databaseis unavailable, the transactions will get committed on the principal database. This will start approximately 10 seconds after the...

And the school work continues.

Since this appears to have the potential of being homework or class project, the first thing many of us would like to see is what have you done so far...

This:

DECLARE @str1 VARCHAR(MAX)

DECLARE @str2 VARCHAR(MAX)

DECLARE @Symbol VARCHAR(20)

DECLARE @CreatedON DATETIME

SET @Symbol ='MSFT'

SET @CreatedON = getutcdate()

SET @str1 = '04/20/2010,5.02,5.06,4.92,4.97,1024893100,4.97#04/21/2010,5.03,5.04,4.82,4.93,987875700,4.93#04/22/2010,4.85,4.89,4.77,4.87,806903800,4.87#04/23/2010,4.87,4.95,4.83,4.86,760414400,4.86#04/26/2010,4.79,4.8,4.6,4.61,1242088300,4.61#04/27/2010,4.55,4.57,4.33,4.34,1337330600,4.34#04/28/2010,4.42,4.56,4.4,4.45,1103714300,4.45#';

SET @str2 = '04/20/2010,5.02,5.06,4.92,4.97,1024893100,4.97#';

with InitSplit as (

select

ItemID,

...

Not sure if you have the delimited split function, I have posted it several times here on SSC and I'm sure there are others, but using that iTVF, this is...

Two strings or one? Your initial post makes it sond like a single variable.

Is this data actually coming from a text file?