Barbara, you found the correct profile option (-MetadataRetentionCleanup = 1).  If your researching metadata cleanup, I have to assume you are concerned about performance.  I'm in an environment with several...

We use the sp_mergecleanupmetadata that is automatically called if you use the default merge profile in SP3.  This assumes all subscribers and publishers are SQL 2K with SP3.  It's a...

Search the BOL for "lazy schema validation" and read the "Configuring OLE DB Providers for Distributed Queries" topic.  This may apply here, but you are correct that there are certain data types...

I have seen a situation where the job as displayed in enterprise manager appears to have never run.  I discovered that this is a result of a bug in some...

Though many people complain about the xp_send/read mail functions, I have implemented a successful and reliable method of sending mails and processing the response.  The nice thing is that if...

Are there many indexes on the table?  The overhead of managing the indexes will significantly increase the processing time.  You may consider dropping the indexes, performing the delete, and recreating...

Is it possibele that someone is launching the "Interactive Conflict Viewer/Resolver"?This utility removes the conflict entries after they are accepted.

rstone--That will work perfectly! Thanks so much, it looks like a few of us will find this very useful.

-Brian

I've used the following to accomplish something similar with Excel. I'm sure by changing the ODBC Driver name/parameters you could use this with a text file too. Search...

The proc does have transaction in it, but I'm printing a message before the first "BEGIN TRAN" statement.

Speaking of checkpoints....does anyone know of a DBCC command to force one to...

I would say that is a good way to accomplish your goal. You do have the ability to do something like this:

select CountrySuperUser, (select MAX(VersionNumber) FROM tblVersion) as Version,...

Testing in SQL2000, it does not even allow a variable when used with the IDENTITY function. You could do something like this, however.

exec ('select field1,

IDENTITY(int,' + @val1 +...

Thank you for the replies....

Andy indicated that the proc would potentially evaluate twice if there was a table owned by dbo and the user calling the proc. From my tests...

Excellent find! Thanks for the post.

Are sure that @MailMsg isn't null or something strange like that? Might be worth trying to reapply the service pack if the dll containing xp_sendmail depends on others that...