You don't have to edit the Registry for that.

Open SQL Server Agent Properties. Go to "Alert System" tab. At the bottom of the screen you can see the checkbox "Replace...

k.subramanyam1017 (5/2/2012)

---

Yes friend! in my resume i have put the experience in logshipping. If u dont mind pls tell me that general quesiton if primary server failed or deleted...

k.subramanyam1017 (5/1/2012)

---

Hi Friends,

Interview question

1) For example In organization logshipping servers are running if primary server failed or deleted when users are connecting in production environment. How to...

Thanks Koen. I was not aware of it. I learned something new from...

Benki Chendu (4/30/2012)

---

Some of my team mates had accidentally given the sysadmin for the user.:-D

Now, I revoked it.

Now, its so confusing here. When RDP rights are revoked, sqlcmd is...

Ron Kunce (4/27/2012)

---

... but for some reason right-clicking on the Data Flow Task opens a pop-up that has no execute option preventing me from running it from there. What...

Benki Chendu (4/30/2012)

---

no..it doesnt work with SSMS also..

But when RDP access is given for that windows user, he is able to use sqlcmd but dangerous thing is, he gets access...

Quoted from BOL

Shared memory is the simplest protocol to use and has no configurable settings....

Additional partitions can be added later as and when required.

No need to create all the partition in the beginning.

al_yamama_1980 (4/30/2012)

---

Of curse i will tall you all the step

control panel\odbc\sysytem dsn\add\Sql serverame=Local Server , srver :Local\ with sql usre name = admin pwd= ??\ and when i chose...

1) Are you able to enter data into this database?

2) Are you getting any error messages?

3) Is the drive full?

AllaboutSQL (4/24/2012)

---

I do get the desired result with this query, but my table t1 is huge and it has around 11.5 million rows and it takes around 4 minutes to...

If you have configured Outlook client in the PC for that account, you can check Outlook settings.

Please check Line 77 of procedure sp_ReIndex

Consider using IDENTITY.