Why ? You will miss out on many 2005 benefits.

OP: This has been covered many times. Search...

There were 12 rows that were flagged as having bad data :

Agent

--------

BA BR 1

BA BR 1

33 1U 1

1V 0B :

D2 HB 1

BU GB ...

I'm a SSIS newbie, so it took some poking around, but I was able to find the "Redirect Row" function within the error output feature. This gave me 12 bad...

Did the schedules within the job get disabled somehow ?

quackhandle1975 (7/12/2010)

---

Does anyone know the cost of owning LiteSpeed? I noticed on their website they have developer edition for $200, however initially we would need LS on a Prod...

y.koteswarrao-652921 (7/7/2010)

---

Hi,

thanks for your suggestions...i able to restore further txn logs after stopat as per your suggestions , but my purpose was not met...

From the restore Txnlog_2 with stopat i...

Did you take a full backup of the database first ?

Are you working with SQL Logins or Windows accounts ?

For Windows accounts, I create Active Directory Groups, such as "DatabaseA_ReadWrite", then put Windows accounts such as MyDomain\MikeSmith into that group....

Thanks a lot for the feedback !

If you are not familiar enough with coding it in T-SQL, you can use the GUI to setup the restore and select all the files & locations. Before hitting the...

Is the database in "full" recovery, but you are not taking frequent trans log backups ?

I just deleted a Maint Plan and it deleted the job automatically.

(SQL 2005 SP3)

In the last code example, what does " SELECT CHAR(10)" and "FOR XML PATH('') " do in this case ?

Wow ! What a great answer ! I'll give that a try.

Thanks

You could open the table with native SQL Server Management Studio. You can than open a SQL pane to put in a select statement to bring back just the data...