Thanks, when I change the database from bulk-logged mode to simple recovery mode, do I need to do a full backup right after that? By changing the recovery mode, does...

Somehow it fixed itself, the double quotes now disappeared, I clicked aroud to the skip rows, then change it back.

Mac1986 (10/22/2012)[/b]

---

Limitations and Restrictions

If other users are connected to the database at the time that you set the database to single-user mode, their connections to the database will be closed...

Thank you Tom and Gail.

I just did some experiment, and I think one point I didn't make it clear. I said earlier one server is dev, the other is ...

Sorry, I don't understand what you said.

And I cannot fix the schema, this is a consultant sql developer developed database, and he just left.

He was still remoting work on this....

I found this is a logical backup device,

We have to drop it first then recreate it with different path.

Thanks

Thanks,

I got this:

nametypetype_descphysical_name

RenaissanceServer2DISKE:\MSSQL\DataRenaissanceServer.bak

RenaissanceServer_LOG2DISKE:\MSSQL\DataRenaissanceServer_log.bak

MASTER_MSDB2DISKE:\MSSQL\DataMASTER_MSDB.bak

I noticed the vendor didn't put the device to our backup drive which is G:\Backup,

How can I change the device to it?

Thanks,

This reminds me, now I try to use:

Insert into...

Select * from another table

This makes it run very fast.

Thanks, that helps.

Can I do the below too?

I can create a new table and with the column set up with identity (500, 1).

Then I insert the records that existed...

Thanks, But how about the column was not identity before?

Thanks a lot, that helps.

So does it mean there is no updates happened?

Thanks all.

Jeff answered my question just on the point, but sql-lover's answer help me too.

Thanks,

but I mean the starting seed number, I mean in order for it start again from 5000 in a table that already have records, it seems I need...

Thanks, good to know