Please follow the articles in sequence.

Troubleshooting Insufficient Disk Space in tempdb

http://msdn.microsoft.com/en-us/library/ms176029.aspx

Capacity Planning for tempdb

http://msdn.microsoft.com/en-us/library/ms345368.aspx

Optimizing tempdb Performance

http://msdn.microsoft.com/en-us/library/ms175527.aspx

Backup / Restore would not be a right option for you. Try to split your data in source server or in ETL. For Example export selective tables in multiple DBs.

Who designed this table you, your organization or your customer? If it's given by customer I...

Did you Google for it?

Getting Started with SQL Server 2008 R2 Failover Clustering

http://msdn.microsoft.com/en-us/library/ms189134.aspx

Shabba (12/8/2011)

---

Thanks Dev.

I was looking into this when you replied. Any idea what permissions I would need to grant to allow a login to see other user processes in...

Lavanyasri (12/8/2011)

---

Dev (12/8/2011)

---

Before I ask anything related to issue, one general question...

You started this thread in 'Tuesday, September 06, 2011 4:09 PM'. Your issue is still unresolved? I...

gopalchettri (12/8/2011)

---

What i know it will be the subscription based ERP (initially following modules,Customer,Membership,Roles,Permission, HR, Finance in its beta edition and later on other modules will be created)

Client will register...

Ninja's_RGR'us (12/8/2011)

---

No point in begging, they just don't care about us, only themselves. Just report to Steve and mark it as reported...

anthony.green (12/8/2011)

---

This user has done it on a number of topics now and is getting quite annoying, I have gone through...

Before I ask anything related to issue, one general question...

You started this thread in 'Tuesday, September 06, 2011 4:09 PM'. Your issue is still unresolved? I believe it's not a...

Try context switching...

Using EXECUTE AS in Modules

http://msdn.microsoft.com/en-us/library/ms178106.aspx

Please follow the articles. (You didn't provide much information so I am putting all Articles that might be useful to you.)

Troubleshooting Problems with MSDTC

http://msdn.microsoft.com/en-us/library/aa561924(v=BTS.20).aspx

How to configure Microsoft Distributed Transaction Coordinator...

UI shouldn't do it. It's very BAD practice. If at all required to add something in table at runtime, use XML data type or add a table to store additional...

:w00t: Your questions are more difficult Craig... :hehe:

Are you hosting something for your customers? Would you please describe it?