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...

add the logins to the dev db.

the users will be there once you restore

sp_change_users_login will synch them.

The DBA should be setting standards, naming, format for procedurs, comments, etc. See what they have and if they don't have something, start getting one in place. It's an easy...

It also stops the lookup for syspermissions and the recompilation. In general, if you run this on your personal server or any server not loaded, there is no difference. The...