Simulator

Technical Article

RE: Restore Log in SQL Server 2000

  • Reply

Paul,While in the Restore database dialog, click on the options tab, and select"Leave database nonoperational but able to restore additional transaction logs."for all but your last restore.  When you restore your last transaction log backup (the one with the "point in time" that you are restoring to), then select "Leave database operational.  No addtional transaction […]

You rated this post out of 5. Change rating

2004-09-08

Technical Article

RE: How to export Resultset from cursor to excel

  • Reply

Interesting problem. I think what you want to do is loop through a series of departments and call a DTS package to email the results. At least that's what I'd do. Here's a looping example: http://www.sqldts.com/?246 Or my choice, use one package to loop and call another inside it: http://www.sqldts.com/default.aspx?215.

You rated this post out of 5. Change rating

2004-09-07

Technical Article

RE: Question of the Day for 11 May 2004

  • Reply

If we were to take everything they indicate at face value, I don't see how it could work. Copy direction isn't specified. Without specifying this, BCP will just abord with usage. In native format as specified, the copy will start but end with no rows copied. Changing format to character drops an EOF error.Hmm. 

You rated this post out of 5. Change rating

2004-05-11

Technical Article

RE: Disk Config issues

  • Reply

You might want to make sure that the disk are on different controllers. and also how many HBA's do you have. We have HBA's with a throughput of 100 mb/S but according to SAN experts, the best throughput is achieved at 50 MB/s.

You rated this post out of 5. Change rating

2004-04-08

Blogs

Small Data SF 2024

By

I can’t remember how I heard about Small Data SF 2024, but it caught...

A New Word: Moledro

By

moledro – n. a feeling of resonant connection with an author or artist you’ll...

Snowflake + Azure blob

By

Let’s go back to data platforms today and I want to talk about a...

Read the latest Blogs

Forums

7 sept, scheduled book

By philip.scott

Comments posted to this topic are about the item 7 sept, scheduled book

7 sept, schedlued article

By philip.scott

Comments posted to this topic are about the item 7 sept, schedlued article

6 sept, published book

By philip.scott

Comments posted to this topic are about the item 6 sept, published book

Visit the forum

Question of the Day

Azure Data Lake Storage Gen 2

Azure Data Lake Storage Gen 2 is built on ...?

See possible answers