My last job was 95% telecommuting. For me, that was actually a little too much. I found that I missed the interaction with the other team members. (Of...

Yes and yes. Separate DB's / customer with separate DB's / module. Much more configurable and flexible. With 2K5, I might even suggest multiple instances - one...

You might want to have a look at this article:

http://www.microsoft.com/technet/prodtechnol/sql/bestpractice/sap-top-10.mspx

for a few pointers.

Paul Randal (10/5/2007)

---

Given that the corruption problems keep happening after they fixed it by restoring from a backup, I'd guess you have a hardware issue. Even though the hardware checks...

With DTC running, you need to keep a lookout for orphaned transactions. They're crafty little buggers that like to hide and can really hose the system. (I know...

Are you running DTC?

I can think of three ideas off the top of my head:

1) get rid of the nulls

2) create an update/insert trigger to enforce the "uniqueness"

3) allow updates / inserts only...

Have a look at QUOTENAME:

QUOTENAME ( 'character_string' [ , 'quote_character' ] )

I haven't invested in any 2005-specific books yet (other than some administrative ones). For performance tuning, I've been spending quality time with Microsoft's whitepapers. http://www.microsoft.com/technet/prodtechnol/sql/2005/tsprfprb.mspx

As Andras stated, that information is stored in the master database. The loss of logins, etc, that you describe is expected behavior for the upgrade path that you used....

What do you mean by "the database engine" being 80 compatability? It is only databases that have compatability levels. If you mean SQL Server itself, issue xp_msver in...

Here's a great link to a bunch of troubleshooting you can try:

http://www.sqlskills.com/blogs/paul/CategoryView,category,Corruption.aspx

(as well as things to NOT do)

xp_msver

then go here to check:

http://support.microsoft.com/kb/321185

The scripts are fairly straightforward, it's the minutiae that is troubling me. Things like: is tablespace the equivalent of a schema or a file/folder? Is varchar2 = nvarchar?...

GRANT ALTER TRACE TO [loginname]