By default, a transaction log backup will truncate the transaction log. So, unless your normal backups use then NO_TRUNCATE option, you will need to restore all the transaction log...

Yes, I think that's the way to go. Either put a trigger on your table that updates another table, SessionCount, say, whenever a session starts or finishes, or write...

Is this a homework question? You'll find that people are more likely to help you if you show what you've tried so far.

John

Yes, I noticed that too. I assumed that Sandy was using it for testing and forgot to comment it out or delete it before posting the code.

John

A few observations:

(1) You should have separate tables for insurance companies and survey companies. You shouldn't duplicate that information in every record in your Estimates table.

(2) If you have...

Ramesh

Yes, you're right - I corrected it in my SSMS window but then forgot to copy it back into my reply!

Lim

What is a "Memo field"?

John

Am I right in inferring that there should only be a match if the "ABC" is at the end? How about this?

CREATE TABLE #Memo (ID int, Memo1 varchar(10), Memo2...

Rachamim

Strictly speaking, it's not necessary to change the name of the column in the child table. But you will need to drop any foreign key constraints and recreate them...

Sandy

I must admit I'm not clear what you're trying to do. You say in your first post that it's working fine... so what's the problem? Perhaps you could...

Please post it on this thread so everybody can see it. Obviously it will help if you also explain how and for what the database is going to be...

Check that you're connecting using the same network library (Named Pipes or TCP/IP) on both servers. I've seen this make a significant difference in the past.

John

I don't think you're going to be able to do this without at least a momentary interruption to service as you switch to a different database server. You might...

rhat (10/15/2007)

---

I have been using SQL Server for around 8 years and I have never, ever had to use a DBCC command. Why? Because I backup regularly and I design...

Back up your databases and restore them on the new server. Lots of discussion about stuff like that on this site. Likewise, you should also be able to...

Sandy

This behaviour is documented in Books Online. Have a look at this topic:

ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/tsqlref9/html/248df62a-7334-4bca-8262-235a28f4b07f.htm

John