Gary

The easiest way to do it is to right-click on your existing database in Enterprise Manager and choose All Tasks, Generate SQL Scripts, and use the dialog box to choose...

Gary

I take it all of your tables have a date column? Do your tables have foreign key relationships to each other? If so then you'll need to make...

So when you ran that commmand you didn't get an error like this?

[font="Courier New"]Msg 102, Level 15, State 1, Line 1

Incorrect syntax near 'MyTable'.[/font]

John

Please don't post the same question more than once. Answered here:

http://www.sqlservercentral.com/Forums/Topic412090-149-1.aspx

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