Forum Replies Created

Viewing 15 posts - 586 through 600 (of 1,098 total)

  • RE: Stopping replication

    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...

  • RE: Increasing Max Server Memory on the fly

    yes, there is no need to reboot the server.

  • RE: triggers

    You can query sysobjects like

    select * from sysobjects

    where xtype = 'TR'

    or execute

    EXEC sp_helptrigger TableName

  • RE: bcp out utility

    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...

  • RE: SQL Mail Configuration & Usage

    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...

  • RE: Explore Snapshot Folder error

    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...

  • RE: Multiserver jobs

    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...

  • RE: Invalid object name

    also add in all the procedures the dbo. when calling to any object.

    For example:

    SELECT * FROM dbo.TableName

    EXEC dbo.spname

  • RE: Stopping replication

    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...

  • RE: Log File Removed - can't attach/detach!

    If you have missed the log, try using

    DBCC Rebuild_log (Db_name)

  • RE: Old Instance Name won't go away

    Maybe you should uninstall SQL server, and then reinstall it with the new instance name.

  • RE: job error status performing completion action

    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,...

  • RE: Cannot change security to SQL Server and Windows

    Does it shows any error while trying to change the authentication mode?

  • RE: More than 2 Databases Synchronization

    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.

    ...

  • RE: View Documentation

    Maybe you should used joins between tables when posibble. But you should check wich is the best choice.

Viewing 15 posts - 586 through 600 (of 1,098 total)