Hi, here is the stored procedure...

/* **********************************************************

To check dependency as per object, use following values as

input of the procedure.

For,

Stored Procedure : 'P'

Views :'V'

Primary Key :'PK'

Function :'FN'

********************************************************** ...

Did you get your solution?

Please update us with your result.

Are you able to send mail from any programing language application (eg, from ASP, or C#) with your setting which you used here?

@rajendran.e

I think, you have posted this another time.

see your (i hope so) earlier posting here with, it has very good answers (though, this post also collects nice info :rolleyes:)

http://www.sqlservercentral.com/Forums/Topic467890-146-1.aspx?Highlight=DBA

also see,

http://www.sqlservercentral.com/Forums/Topic590432-146-1.aspx?Highlight=DBA

Hi, this will return only SPs.

DECLARE @PROCEDURE VARCHAR(40)

DECLARE @TABLES VARCHAR(MAX)

DECLARE @Iterate INT

SELECT @Iterate = 1

DROP TABLE #GROUPS

SELECT

DENSE_RANK() OVER (ORDER BY S.ID) 'GROUPID',

OBJECT_NAME(S.ID) 'SP',

OBJECT_NAME(S.DEPID) 'TableS'INTO #GROUPS

FROM SYS.SYSDEPENDS S(NOLOCK) JOIN SYS.SYSOBJECTS SS...

Are you getting any error message?

If you can give some example data for insert and update, then it will be very helpful to understand the problem.

Hope this works,

CREATE procedure [dbo].[sprInsertServiceTypeToTicket]

@ticketID int

,@dateAdded datetime

,@agentCreated nvarchar(50)

,@flagRemoved bit

,@agentRemoved nvarchar(50)

,@dateRemoved datetime

,@serviceID int

,@IndexTicketServiceID int output

,@resultCode int OUTPUT

,@resultMessage varchar(1000) output

as

BEGIN

BEGIN TRY

IF EXISTS(select null from [dbo].[tbl_index_ticket_services] WHERE [TicketID] = @ticketID and [ServiceID] =@serviceID...

According to example given by Christopher Stobbs, can you do something like this?

CREATE TABLE Client

(ClientId INT IDENTITY(1,1),

LastName VARCHAR(100),

FirstName VARCHAR(100),

MiddleName VARCHAR(100))

CREATE TABLE ClientAccount

(AccountId INT IDENTITY(1,1),

ClientId INT,

AccountNumber VARCHAR(100))

--TEST DATA

INSERT...

select name, surname, (select count(*) from Info where name=a.name) as countname

from Info a

What exactly you want to do? Cant you use cursor?

Dear members,

My sincere apology for posting the link. I found the link from one of the mail regarding study material, but couldnt check it due to firewall protection in our...

With above, also check that if your service is dependent on any other service; and if yes, then check run mode for that parent service.

Please check it here..

Editor's Note: website removed.

There are many kind of notifications on Microsoft site itself, what you have to do is to search them only.

Also, search for individual on MSN or google, you may get...

Bob, no need to be sorry!!! 🙂

It happens... 😎