Viewing 15 posts - 151 through 165 (of 536 total)
thats the way i understand it to be yes. i stand to be corrected by anyone though if its wrong. You can obviously schedule the packages to run...
November 23, 2009 at 6:25 am
like steve said just use a simple SSIS package and run that as a sql job. If its an SFTP site you will have to use a 3rd party...
November 23, 2009 at 5:58 am
integration services are needed for running the packages. designing them is done in BIDS (Business Intelligence Design Studio - or something like that)
November 23, 2009 at 5:55 am
thats a user SP not a system one. it just so happens to have the same name as one of the answers in the SSC question. probably one...
November 22, 2009 at 9:47 am
Good stuff. Probably worth making sure the replication tables are included in any maintenance scripts you have running
November 13, 2009 at 3:37 am
xp_sendmail was replaced by sp_send_dbmail in sql 2005 and i believe removed completely from 2008. xp_sendmail used a MAPI profile and could therefore understand and resolve your group names...
November 11, 2009 at 4:35 pm
sqllearner-339367 (11/11/2009)
I have just diasbled the log reader. There has been page lock on to my subscriber table... need to investiagate further.
Try rebuilding the indexes on that table. Ive...
November 11, 2009 at 10:03 am
If you're running every minute, you probably chose #2. I don't know if you can modify it to #3, or if you have to drop the subscription & start over....
November 11, 2009 at 9:47 am
sqllearner-339367 (11/11/2009)
I have setup transactional replication (read only) and set the synchronization to happen for every minute. Past two days we have problem that our live server is slowing...
November 11, 2009 at 8:01 am
have a look in the scripts folder for yourself and see what suits you best.
November 10, 2009 at 2:27 am
for tables with indexes you can use sysindexes to see when they were last used. for all objects (Sp's, views etc) you could run a profiler trace for...
November 5, 2009 at 3:25 pm
Bhuvnesh (11/4/2009)
10/26/2009 12:20:06,,Warning,[360] SQLServerAgent initiating shutdown following MSSQL$REPORT_DEV shutdown
looks like someone pressed stop on your sql server to me 🙂
November 4, 2009 at 10:59 am
I wouldnt like to say 100% that you cant get the data back but i dont know of any way in which you can. Without a full backup before...
November 4, 2009 at 10:23 am
thats quite an open ended question. i would start by looking at the BOL topic to get a general idea for what replication type would provide the right solution...
November 4, 2009 at 5:45 am
Viewing 15 posts - 151 through 165 (of 536 total)