I'd do a backup and restore to test. Then when you have it down, logins moved (search sp_help_revlogin), then do a full backup on source and move to produciton. Then...

As SQL needs memory, it will request more memory from the OS. You can use Enterprise Manager | Server | Properties | Memory tab and you can limit the maximum...

Been backing up for 10 years and never stopped a database for a backup yet. Restores work without a flaw.

The memory is released, but the caching might be affected. This will balance out as other queries are called. Right now I do not believe there is anyway to affect...

Yeah, I got one

The close wording is intentional. A view having 2 tables does not necessarily impact the ability to update. It could...

I completely agree with the business problem, which was why I provided a couple examples. If I have an OLTP system taking orders and one transaction, not one row, one...

Good suggestion. The question has been edited to reflect SQL 2000.

I'd start by listing the objects that you think you need to store. You need a customer, you need some type of rental agreement, some inventory, some cost structure.

If the...

proc more like a function, can do many things, better security from sql injection, encapsulation of functions, etc.

the view can do similar security, but at a grosser level. Only functions...

Not quite sure what you mean. It has a public IP reachable from the Internet? You need to be sure 1433 TCP is open on your router/firewall.

They are automatically created by the system.

There is not a faster way.

I'd do it in stages. Shrink to 80% full, then 70, 60, etc. Get as much done as you can. If it appears that it's...

There is a checkbox on the data transforms to ignore identity fields. Nothing should be mapped to that field in the map tab.

You guys are overthinking this. It's a simple question on how you restore to a particular point in time, in this case, to a named transaction.

The question did not specify...

You can do a local account not in the admin group. Localsystem may not be able to do everything you need, but it's a smaller attack vector from what I...