blandry (12/1/2010)

---

Our jobs are jobs, NOT recruitment into someone's army. Stand up for yourself, show your value, and if sadly, you work for a company that cannot appreciate that,...

Greg Edwards-268690 (12/1/2010)

---

We usually find that some columns are best frozen, some always updated with current value, and some with both a frozen and a current column meets most of...

the constraint checks are very small and don't impact performance in a significant way. Adding them in there is a way of ensuring that your data is correct and accurate,...

Grant Fritchey (12/1/2010)

---

Oooh, good question. I haven't. I...

I'm with Alvin. I'd question the design.

I just saw a request for a beginner "how to back up and restore your databases to keep them safe" presentation.

My guess is this is one that should get written,...

If you assign the account to SQL Server using the Configuration Manager, it will determine the rights for SQL Server to run.

If you mean that the account you used for...

The warning is because SQL Server 2005 does not recognize W2K8. That OS was not around when SSK5 was released. So it warns you about potential issues.

Getting to SP3 will...

Which account? If you set a proxy for xp_cmdshell, just give it the rights needed.

If you change a service account, use the Configuration Manager. It will assign the correct rights...

Quotes are hard. It's why printing out the string is a good idea.

Glad it's working.

cold...

The problem with either solution is that you can break the client side easily.

I'd recommend that you use a set schedule so that people are aware when the db will...

I agree with Gail. I would run this daily on my system databases.

Please no more responses on modifying system tables. It's not safe, and in this case, it should not be done.

To InfiniteError, you cannot modify the transaction log after, nor...

I'll check and see. I'd have thought the "/" was universal, but changing to "-" shouldn't be hard.