Why do you want to update the ID field? Typically these are primary keys for each table, which means that they are not updateable.

If you have fields from two tables...

I'd add a third note that you need to get a consultant on site to help you understand this. Your questions indicate that you don't really understand what you are...

select * is resolved into the actual column names at compile time. If you have changed columns, then it might start to fail. This is why you never use SELECT...

thanks for the update. The other thing you can try is to script out replication and then re-run the scripts to set things up.

If I remember, you need a trace file of activity on the system and DTA will analyze it. It wasn't as good in 2000 as it is in 2005/2008. Tends...

there isn't necessarily any improvement from having the dbs in separate instances. You are now sharing memory, which is an issue on 32 bit systems. You have to set the...

Wow, sounds like you have a busy job ahead of you.

I'd look to do a few things. First, see if the clustered indexes make sense. They might all be created...

If you reindex, and then shrink without just truncating off the end, you may re-fragment the indexes.

I would recommend you shrink to a level that will let you work with...

I would use the link above. I don't have a procedure I've used. You can also search for FineBuild on Codeplex. Ed Vassie has built a great utility for slipping...

Yes, sorry, was providing the idea there.

The code should look like:

declare @cmd varchar(max)

select @cmd = 'alter database test modify file ( size = ' + @required_size + ' MB)'

exec(...

I've had good and bad experiences with Microsoft. By and large, however, I think that most of their software works well when it is released. There are bugs, but it's...

DRP is typically disaster recovery plan. Be ready in case you create your own disaster. Know what exact build number you have, and you may want to script out jobs/alerts/packages...

Make sure you have good backups.

The data files and log files will get attached to the new instance when it's upgraded, and they'll be migrated to the new formats as...

Thanks for the update and resolution.

Separate backup file for each backup.

The maintenance plans have a maintenance cleanup that does this well. We used to script something, but the maint plan item does it better. You...