SQLCrazyCertified (9/8/2012)

---

I cannot copy and paste the whole error. Here is part of it.

This is from the event viewer...

Description: .NET runtime optimization service (clr_optimization_v2.0.50727_64) - Failed to compile:...

I cannot copy and paste the whole error. Here is part of it.

This is from the event viewer...

Description: .NET runtime optimization service (clr_optimization_v2.0.50727_64) - Failed to compile: C:/Program...

Ok. Thanks for all your inputs.

SueTons.

Grant Fritchey (8/17/2012)

---

Drop does exactly what it says. It's going to drop the existing index and then rebuild it. No, it won't leave the existing index available while it does...

Perry Whittle (8/14/2012)

---

SQLCrazyCertified (8/13/2012)

---

All,

I need help from all of you to put together a checklist for troubleshooting disk space issues. In our environment, we get a lot of tickets...

Thanks Lowell,

"review the OS for a zillion logs from IIS or other processes that might generate a lot of text files."

Can you please provide more details/info regarding the statement above,...

MysteryJimbo (8/10/2012)

---

SQLCrazyCertified (8/9/2012)

---

"SQL Server in a clustered environment: You just need to run edition upgrade on a single node, you can choose to run from either an active or passive...

saidapurs (8/9/2012)

---

Hi Suo,

Ru upgrading the version or updating patch. When you updating patch on that time update 1st node then 2nd node but as...

Nope, I am upgrading...

saidapurs (8/9/2012)

---

Hi SueTon,

Please put SQL SERVER 2008R2 Enterprise edition DVD & give install after you will get MAINTENANCE option in their you will get...

Someone please advise...

Planning to move to production, and might add more nodes in future.

Regards,

SueTons.

MysteryJimbo (8/8/2012)

---

SQLCrazyCertified (8/7/2012)

---

Hi All, Please help/share your experience.

Here are my requirements.

Current Environment

SQL Server 2008 R2

Development environment

2 node Active/Passive cluster, Currently in standard edition

Need to upgrade to SQL 2008 R2...

pooyan_pdm (8/3/2012)

---

There was a database named X . This was the default database for a login named Y . This login was a windows group login. User Z is a...

pooyan_pdm (8/2/2012)

---

Hi there

some body dropped a database which was the default database for a specific login(a windows group login with sysadmin server role) .

after that, users can't connect with that...