Maybe from a stored procdure that you execute in Access.

http://www.codeproject.com/KB/database/Call_SSIS_from_SP.aspx

If the publication was set up with the native sync_method, you should be able to drop the article, add the column and then add the article back to the publication....

I originally found it here, so you can thank him. I modified it to work with Litespeed and SQL Backup. I'm glad it helped.

http://www.sqlservercentral.com/articles/Disaster+Recovery+(DR)/streamliningtherecoveryprocess/837/

I've used the attached proc in the past.

I've used a trigger on sysjobs to alert me when jobs are enabled/disabled. That worked fine. You could do something similar for sysjobsteps.

Check out this link. It looks like you have to enable the related alerts. I did that for the passed validation alert and ran the proc. That...

This can also be useful.

EXEC distribution..sp_replmonitorhelpsubscription

@publisher =null,@publisher_db =null,@publication_type=0

This worked for me locally.

SELECT *

INTO #Temp2

FROM OPENROWSET('SQLOLEDB', 'Server=MyPublisher;Trusted_Connection=yes;', 'set fmtonly off; exec distribution..sp_replmonitorsubscriptionpendingcmds @publisher=''MyPublisher'', @publisher_db=''MyPublishedDB'', @publication=''MyPublication'', @subscriber=''MySubscriber'', @subscriber_db=''MySubscriberDB'', @subscription_type=0')

Can you tell me if you got this to work or isn't the DistributorDeadlockPriority parameter availble in SQL Server 2005? Thanks.

I was recently surprised to find that, for dynamic Where clauses, the dynamic SQL performed better and made better use of indexes. This was pointed out to me by...

I had to do something similar to limit the number of open sessions, based on last batch data, for a particular application due to licensing limitations. I just wrote...

Do you have to do anything special after changing the page verify setting to checksum in order for it to be functional. Thanks.

It only works for SQL Server 2008 servers. I considered trying to figure out the queries that would be required to gather some of the metrics from SQL Server...

There should also be a sp_script_login_2005.txt which works for 2005 and above.

I misread your question. I've reposted what I currently use for SQL Server 2000 servers. It...

This query has worked for me in determining statistics that may nee to be updated.

USE YourDB;

SELECTsch.name + '.' + obj.name AS TableName,

ind.name AS IndexName,

STATS_DATE(ind.object_id, ind.index_id)...