Viewing 15 posts - 586 through 600 (of 1,098 total)
I'm not sure if it is a good idea to automate replication.
To check if you have any subscribers, run sp_helppullsubscription at the subscriber on the subscribing database and capture...
May 14, 2003 at 10:00 am
yes, there is no need to reboot the server.
May 14, 2003 at 9:40 am
You can query sysobjects like
select * from sysobjects
where xtype = 'TR'
or execute
EXEC sp_helptrigger TableName
May 14, 2003 at 9:36 am
If I where you I would run the bcp command from a T-SQL script with the xp_cmdshell extended procedure.
With t-SQL you can manage the result of the query and then...
May 14, 2003 at 9:18 am
But you don't need to configure SQL mail to recieve a backup file. You can recieve from any mail (hotmail? or whatever) and then restore directly to SQL.
SQL mail is...
May 14, 2003 at 7:16 am
Check running sp_browsesnapshotfolder to see if it finds it. If not I think that you didn't changed right the property of the snapshot folder. If possible, drop and re create...
May 14, 2003 at 6:55 am
If the master server fails, the targets servers still have all the jobs originated from the master server. So the jobs won't loose.
But if you installed a new master...
May 14, 2003 at 6:46 am
also add in all the procedures the dbo. when calling to any object.
For example:
SELECT * FROM dbo.TableName
EXEC dbo.spname
May 13, 2003 at 10:06 am
Yes that is for me the best way in case you still want to use the publication. But be carefull with the time that SQL will maintain the publicatio...
May 13, 2003 at 9:17 am
If you have missed the log, try using
DBCC Rebuild_log (Db_name)
May 13, 2003 at 9:14 am
Maybe you should uninstall SQL server, and then reinstall it with the new instance name.
May 12, 2003 at 9:16 am
If you kill the process, then check the status witl kill spid with WITH STATUSONLY
to see it's rollback process. If it says 100 % complete and it is still rollbacking,...
May 12, 2003 at 8:00 am
Does it shows any error while trying to change the authentication mode?
May 12, 2003 at 6:38 am
It is a replication when a publisher is also a susbcriber, and the subscribers are also publisher.
It is not the easiest schema, but it is the one I use here.
...
May 12, 2003 at 6:32 am
Maybe you should used joins between tables when posibble. But you should check wich is the best choice.
May 9, 2003 at 1:56 pm
Viewing 15 posts - 586 through 600 (of 1,098 total)