try a different port number for your mirror endpoint.

HTH

Billy

not sure if it applies in your case but how about putting an "endtime" filter on your trace; unfortunately it won't allow you to filter on a finer detail (eg....

use SET DATEFORMAT to explicitly define dateformat when handling dates.  (ie. SET DATEFORMAT dmy).

In general, for international settings, dateformats should be handled with care.

HTH

Billy

how about using the OUPUT parameters to obtain the scope_identity() value?

see below for example:

hth

Billy

--- cut here ---

use tempdb

BEGIN TRAN

GO

CREATE TABLE TX1(THE_ID INT NOT NULL IDENTITY(1,1), TX1USERID VARCHAR(100))

GO

CREATE  PROCEDURE spInsert (@TX1USERID...

Hi George:

You are correct.   The "insert into dd1(tablea_value, tableb_value) values('eee1b','eee1b');" does not include primary Key of table "a".  However, that is the essense of the question.  Primary Key of Table "a"...

not sure if it possible to change a column into identity column after it has been created.  BOL does not state this is explicitly though; all references within BOL to...

use OBJECTPROPERTY, ExecIsTriggerDisabled property name.

that is...

select OBJECTPROPERTY (OBJECT_ID ('trigger_name'), 'ExecIsTriggerDisabled')

which returns

1 = True

0 = False

HTH

Billy

below is link to example of format file:

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/adminsql/ad_impt_bcp_9yat.asp

and of couse there is also the sp_help stored procedure that will also get you the column name and data type information for a given table.

you can query the information_schema views in the current database to get your column names and data types:

see below for example on tempdb database:

use tempdb

select * from information_schema.tables

select * from...

the posted syntax looks fine.

for me, the following works:

select * from mycomputer.tempdb.information_schema.columns

hmmm.. how about loading all primary keys for SINFORM table produced from the WHILE loop into a table variable or temporary table and then join that table with the SINFORM...

thanks for response. this problem is on one of our client's server.  I know they have other stuff running on that box but I don't think they installed anything new...

check out the following link for more info:

http://www.eventid.net/display.asp?eventid=2019&source=srv

good luck

Billy

I checked bol but can't find anything.

I know there is ::fn_trace_gettable but it always returns an error message if the trace has not been stopped yet.

I read somwhere else that...