You should be fine to drop the columns, however you will probably find that the triggers associated with merge replication are still on the table as well so you will...

seems to work fine for me, although there is a possibility its cached.

Your not on IE8 by any chance are you? loads of sites dont work with IE8, they...

check you table sizes. it could be that the history tables are not being cleared down by the clean up jobs

you need to check object ownership and change them all that are currently under his/her login to new ownership.

Books online is a really good place to start. i know thats the answer for loads of questions but seriously for DMV's BOL is very useful and also splits...

The way i read this was that you wanted to delete transaction log backups (typically .trn) from your backup directory? is this correct? If so you can use...

Well spotted 🙂 My apologies - ignore...

if the database is in single user mode thats probably for a reason. you need to find out who put it in single user mode as they probably have...

do you get the same performance issues if you use between instead of the >< operators?

yes, if you use SSMS and go to the table, right click and produce a create script to a new window. then copy and paste that in to a...

can you post the table definitions for SGTALIQDATA and LIQUIDACAO from both the sql 2000 and the sql 2005 databases

It doesnt matter what physical machine your on. connect to server A through EM/SSMS right click on the database, tasks -> detach.

move the mdf and ldf file(s) over...

if you want to move the database completely (ie to remove it from server A and add it to server B) i personally would use the detatch/attach method.

im not really sure where SQL comes into the equation in this problem?? Possibly best looking for a FogLight forum?

recovery bring the database online and allows full database activity.

norecovery leaves the database in a restoring state ready for the next backup file to be applied (nobody can connect in...