If you want to assign a value to a parameter use sp_executeSQL

set @SQLString = 'SELECT top 1 @uidEventID = MCONVERT(VARCHAR(50),SLOTID)' +

     ' FROM ' + @in_vchServer + '.' + @in_vchDBName...

To insert a record into the class table when a record is inserted into the brances table.

CREATE TRIGGER branch_branchID_class_branchID

ON branches

FOR INSERT

AS

INSERT into Class (BranchID)

Select BranchID

from Inserted

This...

Which 2 files do you speak of?

an MDF, and a LDF? Sql server requires at least 2 files for a database.

If you detach the database and Delete the the LDF...

Try using the replace function.

Update Mytable

set MyField = replace( MyField, '\\server1\folder1\1234', '\\server2\folder5\1234')

where MyField = '\\server1\folder1\1234'

as suggested put a Print @SqlString in there before the execute,

Also in String concatenation a null + String = NULL

I don't see a value being set for @uidEventID which would...

OR

http://www.sqlservercentral.com/columnists/mcoles/fourrulesfornulls.asp

Have you tried sp_who or sp_who2?

SELECT min(b.CaseRow), IRNumber, CaseName, CaseNumber

FROM @ceb A

JOIN @CCC B

    ON A.IRNumber = B.CaseNumber

Group by IRNumber, CaseName, CaseNumber

Your methodology of having 1 insert procedure for each table is good, Promotes reuse. and creating a wrapper to take all the input, and insert to 3 tables is fine.

Your...

Okay, but now you have this data in a sql server table?

or is it still in its native database system?

How do you guarantee the order of the records?

Is there another...

Try restarting the MSDTC Service (Distributed Transaction Coordinator)

and see.

Also Can you post an actual error from the application log for us to look at?

In your example

How do you know that 2000003 2 goes with 1000002 1?

Why wouldn't it be 2000009 2?

Or why wouldn't 2000003 2 go with 1000002 1?

srcdata...

SELECT (result_date - DATEPART (dw, result_date) + 2) as [Date],

sum(CASE result_by WHEN 'Bushaw' THEN 1 END) AS [Bushaw],

sum(CASE result_by WHEN 'Dunkel' THEN 1 END) AS [Dunkel]

FROM ac_activity

WHERE result_code...

After you asked yourself

"Self.. wouldn't it be great if I had a function that would formatt the information for me so when I pulled it from the database all I...

May have information for you. not sure.

http://www.mssqlcity.com/Articles/Compare/sql_server_vs_access.htm