Not knowing what application you are running I can only give you this suggestion: shutdown the app server then do your restore on the database server. I am assuming...

David,

I really liked the helicopter story. Well played!

😎

Actually, since it looks like you are using Access as a front end to a SQL Server 2000 database, you should be able to do the same thing with Access...

You really shouldn't cross post. This looks like it has been posted in three separate forums.

Edit:

I suggest using the following forum: http://www.sqlservercentral.com/Forums/Topic516075-145-1.aspx

😎

You really shouldn't cross post. This looks like it has been posted in three separate forums.

Edit:

I suggest using the following forum: http://www.sqlservercentral.com/Forums/Topic516075-145-1.aspx

😎

Jeff Moden (6/12/2008)

---

Not sure the use of a correlated subquery (a form of hidden RBAR) will speed anything up here... Maybe...

The real fact of the matter is the OP...

I'm not making any judgements on the design. I was trying to point out that somethings that don't seem right could be based on other factors.

You could desgin a...

Not knowing the full details of the example it is difficult to make a judgement. One thing to remember is that while designing a database for a production application...

The answer to this is Yes and No. there are a few that I can talk to about almost anything, just as a friend. I actually consider these...

Here is my solution:

declare @TheDate datetime;

set @TheDate = '2008-08-15';

select

@TheDate,

dateadd(mm, datediff(mm,0,@TheDate) + 1, 0) -

...

Jeff, I will post my solution as soon as I get to work. My code is sitting there, but I'm still at home getting ready to leave. See...

At this point, since you figured it out, is when you'd post what you did to answer your own question. One reason, others may have a similiar question, but...

Matt,

I want to thank you for taking the time to format the test data pino_daddy provided. I just didn't have the time even though using UltraEdit would have made...

pino_daddy (6/11/2008)

---

Thank you very much.

I appreciate the response. I wish I had a copy of Quest Software, it seesm to help out sometimes by rewriting the query and trying it...

VALEK (6/11/2008)

---

Lynn Pettis (6/11/2008)

---

To paraphrase what someone else once said on this site, "The proof is in the code." Here is the code:

...

while @LoopCnt < 100

...

Based on the results,...