Or buy (or create) a tool such as Idera Compliance Manager to monitor SQL activity.

Ideally, you would put a comment in the SP noting the revision #, date, description...

I don't mean to sound like a wise-guy or anything. But why don't people back up their databases ?? How many posts have there been over the...

Patrick Womack (10/3/2008)

---

Is it legal to purchase 1 license for SQL Server 2000 Enterprise and install the software on multiple servers in our company?

The same question for SQL Server 2005...

Also, I think most companies give you a trial period so you can download them and give them a try. That's the best evaluation to see if it suits your...

Idera makes several tools that I was happy with.

Redgate & Quest also make good tools

What about "zones" ?

I should have posted this in the 2000 section, not 2005. D'oh !! :pinch:

That is specifically for TempDB, and often will only show real perf improvements if there is existing blocking on the allocation structures in TempDB. It is good practice to have...

At my last job, I used Idera's SQLSafe backup tool on our 275 Gig database, and our backup time went from 90 minutes to 30 minutes, and disk space for...

GilaMonster (9/29/2008)

---

Replication makes a big difference to logs. On a replicated DB, the log record can't be discarded...

Replication shouldn't make any difference. When was your last FULL backup ?

What's the name of your backup file ??

I was helping someone the other day, and when he created the backup file, he forgot to put .BAK as the extension. When...

Double post .... Don't reply here, use the other one.

Don't use sa. Create a windows login with the appropriate premissions in SQL and Windows.

http://www.sqlservercentral.com/Forums/Topic113227-5-1.aspx