Here are the steps to show existing sql server databases into analysis services

http://msftdbprodsamples.codeplex.com/wikipage?title=Installing%20Analysis%20Services%20Database

Thanks

Thanks for the link.

yes, I am trying to create PerformancePoint Reports (Dashboard, reports, charts, etc.). and I would like to use cube and therefore need to user Analysis Service.

My understanding...

I nested the try catch block and still error. I think it does not matter. If there is an error then it rollbacks.

so if insert to remote server fails then we can still continue. hmm. let me see.

do you have any examples?

Thanks Lynn...

So, would this be a good example?

http://technet.microsoft.com/en-us/library/ms189872.aspx

And how is it related to my post? Little Lost here..

USE [myDATABASE]

GO

/****** Object: Trigger [dbo].[it_myTrigger] Script Date: 12/09/2009 13:35:59 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

ALTER TRIGGER [dbo].[it_myTrigger]

ON [dbo].[Dodge]

FOR INSERT

AS

DECLARE@tTable varchar(30),

@tID int, -- New Dodge ID from Dodge...

1. Okay. Now I need a help big time. How do I handle if there are multiple updates or inserts?

2. I declared some variables before the try block. Are they...

As I understood reading from different blogs that Trigger only handles one row at a time.

If not then I guess I have to declare an array and then use...

Lynn,

It's now working. However, it was suggested i used join instead of subquery.

select se.desc from se where (se.id = d.seid)) as seDesc . how would you do it?

I am re-formatting...

DECLARE @tID int

SET @tID = (SELECT ID FROM inserted)

I added this before the insert statement and bingo it worked.

Thanks for all your help.

FROM

INSERTED D

set @NewBody = 'A record with id ' + @@IDENTITY + ' has been updated.'

Actuall, d.id should come from the temporary inserted table. since it's automatically...

Yes, you are right. I didnt' know that. I moved the @body and it's now working since it has access to d.id

@body = 'A record with id ' + convert(varchar(50), d.id) + ' has been updated.',

I am getting this error

Incorrect syntax near '+'.

The error on this line....

Incorrect syntax near '+'.

@body = 'A record with id ' + convert(varchar(50), d.id) + ' has been updated.',