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

Good idea for Vol. 3. I'll keep some stuff handy for that.

In the next article, I'll look at some of the ways in which we actually responded to disasters and...

Thanks for the complements and again, apologies. Even the best make mistakes and I know I'm pretty far from being there .

We try to...

Trace or constant sp_locks should do it. This was a problem in previous versions, but table creation and other ops were supposed to not lock tables in 2000. Are you...

Question corrected, points given back.

Apologies

In the properties for SQLAgent, on the Job System tab is a place you can specify the proxy account. Setup an account that can connect to SQL Server and run...