Also, you can add a backup log operation (full recovery) or checkpoint (simple recovery) for each iteration to reduce growing the transaction log too much.

I don't think the first query is working the way you think it is. By including in the where clause any column from the tables you have left...

Read the article I link to in my signature to find out how to post your question so it can be answered better/faster. What you are looking for is...

Thanks for the update.

In addition to what Steve has outlined, you are going to have to disable/drop foreign keys before you can recreate the tables. And, don't forget to script the indexes...

mgrammer (3/23/2009)

---

Thanks everyone for the help. It looks like it will not be a simple fix :crying: .

Even though I still have the tables stored on our SQL 2000...

Yes - it does seem to be related to SQL Server 2000. I just tried with one of my 2000 boxes and was prompted every time I opened a...

mgrammer (3/23/2009)

---

Thanks Steve.

I went ahead and ran that statement. I'm assuming that will prevent any future tables from being marked as system, but unfortunately the existing tables did not...

John (3/23/2009)

---

Sorry for not being clearer, I want to open the sql scripts after I have already connected and I want to newly opened files to use the connection that...

We...

I hear this from lots of people and I ask them the...

JamesNZ (3/22/2009)

---

If you schedule a transaction log backup every 15 mins, and do a nightly full backup at 9pm, what will happen to the transaction log backup job running every...

In addition to what Mohit has stated, each server you have open in Object Explorer will be a connection in Activity Monitor.

You also will get a connection if you have...

Did you change the server name?

Do you backup to a network share that is no longer available?

Can you open the maintenance plans and verify the connection and setup for each...

You can provide the default connection information:

ssms -S.\InstanceName -E {filename}

But, I don't know of any way to open a file disconnected unless you use the functionality available in SSMS to...