As per the conditions mentioned, the following solution should work.

ALTER TRIGGER [dbo].[Trg_Insert_Temp2]

ON [dbo].[Temp1]

FOR INSERT,UPDATE...

I...

Can you post the queries which are failing on batch insert/update?

Using SQL OLEDB:

Provider=SQLOLEDB;Integrated Security=SSPI;User ID=myUserID;Initial Catalog=myDataBase;Data Source=myServerAddress;Password=myPassword;

Using SQL Native Client:

Provider=SQLNCLI;Server=myServerAddress;Database=myDataBase;Uid=myUsername; Pwd=myPassword;

I don't think so there is any equivalent function in SQL Server. But you can create you own function using the existing REPLACE function.

Here is an article that explains how tally tables can be used solve many RBAR problems in a set based method.

http://www.sqlservercentral.com/articles/T-SQL/62867/[/url]

You need to grant ALTER permissions on the table.

GRANT ALTER ON OBJECT::<<Table>> TO <<User>>

Look for OVER() clause with PARTITION BY clause and aggregating with SUM function in BOOKS ONLINE. Something like this should do.

SELECT *, ( Units * 100 ) / SUM(...

Yes, you can connect to any SQL 2005/2000 database engine (not sure about the earlier versions) from SSMS 2008 Express.

Follow this link for more details

http://msdn.microsoft.com/en-us/library/ms365247.aspx

The AFTER triggers fires only after the insert is completed but the...

Just a stupid question, are you saying that the procedure is not executing (or raising some errors) or the ELSE part is not executing? I am asking you this...

You need to set the "ConnectionString" property of the destination connection manager's "Expressions" collection using global variables or package configurations.

Can you explain what should be the expected behavior of the IF block?

What you are trying to do within the trigger?

Aren't you using the main table instead of...

You have to enclose the object names in [] when the object name contains special characters, keywords etc.

select * from [cic-nic-2].Arrow.dbo.circle

Using SQL 2005's UNPIVOT method

SELECT*

FROM(

SELECT[Name], CONVERT( VARCHAR(100), AGE ) AS Age

FROMEmp

) E

UNPIVOT

(

RowValue FOR RowType IN( [Name], [Age] )

) UP