If you could add a column to the first table then when you process the data with your stored procedure you could update this column with a mark that already...

I didn't have any problems. Maybe you should try reinstalling, if you don't mind.

Sorry Greg, you posted the message while I was still writting...

Check http://support.microsoft.com/default.aspx?scid=kb;en-us;246133

This Stored procedure will not only transfer the password, but also the user id SQL uses internally. The output of the stored procedure is the t-sql commands needed to...

Well, once I finish re designing my repliaction topology, I think I also could use some tables and maybe build some stored procedures to automatically creates the script I need...

You should add the 6.5 server as a linkled server. Check sp_addlinkedsrv, sp_serveroptions and sp_addlinkedsrvlogin in BOL. And then execute a remote query from the trigger.

how are you calling hte scripts? with osql?

Another way is:

CREATE TABLE #tmp_Table

(Pos INT IDENTITY (1,1) not null,

c1 datatype,

c2 datatype,

c3 datatype)

INSERT INTO #tmp_Table

SELECT * FROM Yourtable

In here you have your table but with a column name col with...

Well, SQL takes the Update as a delete of the old values and an insert of the new ones. To avoid granting delete permissions you might use a Stored procedure...

If you use xp_sendmail from QA, does the mail arrives inmediately?

I think your app is using the name dbo as the user name, you should use 'select suser_sname()' instead of 'select user_name()' in your app.

I don't think you would be able to concatenate so many records into a single variable. Maybe you should do it from outside SQL. You could copy to severals text...

IS the differential backup the one that has erros? or both?. Try running a RESTORE VERIFYONLY on the backups files.

To know if the column actually change in a trigger you can compare the values that the CHECKSUM() functions returns in the column from the updated (in the trigger the...

you should import from excel to a .txt and then bulk insert from the .txt adding the datafiletype parameter.