Thank You :-):-):-):-):-):-) !!! Its working now :-):-):-):-):-)

Have you checked the error logs? What does it say?

First you need to create an Operator(The Operators option can be found when U drop down the Sql Server Agent menu).

When a Maintenance plan is created a Job will also...

My other requirement is:

I am inserting values into my table test.

The attributes are:

col1

col2

status

Now when inserting if I insert 3 into status, i need to generate a trigger which will send...

I figured it out

USE Test;

GO

CREATE TRIGGER ColumnChanges

ON DATABASE

FOR ALTER_TABLE

AS

-- Detect whether a column was created/altered/dropped.

DECLARE @Message varchar(200);

DECLARE @Message1 varchar(100);

DECLARE @Message2 varchar(100);

SET @Message1='The folowing Changes have been applied to...

Let me check with the IT guys about the SMTP settings.

Hakuna Matata (11/24/2011)

---

Hope this helps 🙂

http://blogs.msdn.com/b/petersad/archive/2011/01/24/how-to-perform-an-sql-server-edition-upgrade.aspx%5B/quote%5D

When I upgraded my Eval to DataCenter for testing purpose...

Hope this helps 🙂

http://blogs.msdn.com/b/petersad/archive/2011/01/24/how-to-perform-an-sql-server-edition-upgrade.aspx

Still have no idea , why it generated so mails. The schedule was every hour. If somebody can...

I cracked it. I had to first remove the subscription & then delete the report from Report Manager.

Under normal circumstances the client is created using the application. When the clients to be created is high they provide me an excel to populate the tables. There is no...

Thats right I did get it from google

EXECUTE SP_CONFIGURE 'show advanced options', 1

RECONFIGURE WITH OVERRIDE

GO

EXECUTE SP_CONFIGURE 'Ad Hoc Distributed Queries', '1'

RECONFIGURE WITH OVERRIDE

GO

EXECUTE SP_CONFIGURE 'show advanced options', 0

RECONFIGURE...

Maddy...! (11/9/2011)

---

I am struck with the similar problem....

The scenario is something like this :

I have two instances of sql server 2008 r2 on the same...

Dev @ +91 973 913 6683 (11/9/2011)

---

The main purpose is if I have made any change to the field(such as change the name of field) , i need to update...

Thanks a ton Lowell for the help. I am able to retrieve the Tables referencing the Field.:-):-):-):-)