I wanted to say that you can not have trigger called only once for many insert statements.

I think u could have done this for the below statement-

insert into...

SQL Server 2008 upgrade advisor is the tool to identify upgrade issues.

http://www.microsoft.com/downloads/details.aspx?FamilyID=f5a6c5e9-4cd9-4e42-a21c-7291e7f0f852&displaylang=en

It is recommneded to

-do this analysis.

-then resolve the issues

-test the application

-generate the upgraded script

-and...

in SQL Server its statement level trigger. For each statement trigger is fired. There is not any solution for the scenario you are thinking of

---Lines from books online--

A database can become suspect for several reasons. Possible causes include denial of access to a database resource by the operating system, and the unavailability or corruption...

Using SSIS in place of SP is not going to resolve the performance issue. SP is always fater.

This could be issue of indexing. make sure your select and update query...

Its better to have a table valued function returning table from the comma seperated list of values as a input parameter.

And then use select with this function to insert the...

there are three ways-

1. select distinct records and insert it into another dummy table, then truncate all records from original table and then copy records form dummy table to...

Select

EmpID

, EmpFirstname

, EmpLastName

From EMPLOYEE E inner join TRANSACTION T

On

E. EmpID = T. RegisteredBYEmpID

Where T. RegisteredBYEmpID= T. ApprovedByEmpID

I guess this should work. please try and let me...

GO can not be used in dynamic string statement.

Disable syntax is correct-

use something like - execute two statements differetnly

SET @string ='use '+'testdb'

exec (@string)

SET @string =' DISABLE TRIGGER TRIGGeR_NAME...

This is not working if first time you get some error say because-

Column is not correct for constraint or data type is not correct.

Why are you not using bulk insert or BCP ? Sending so many insert statements is going to take time. Also you can explore MERGE statement in SQL 2008 if...

Gr8 !!! can you please post the summary of your learnings about surogate keys.

Yes you can use case statement and generate dynamic SQL query.

http://www.sqlservercentral.com/Forums/Topic884492-146-1.aspx#bm884650

one more similar thread

Please refer to the books online link for how many bytes each data types takes.

msdn.microsoft.com/en-us/library/ms187752.aspx

It will allow you to create table of more than 8060 byte row if you...