Forum Replies Created

Viewing 6 posts - 1 through 6 (of 6 total)

  • RE: viewing History of a Stored Procedure

    Another sugestion is to do a backup scheme for sysobjects with a bcp for example, quick and easy.

    Just remember that some sp's are split in several rows.

    Regards.

  • RE: BCP Help

    This is what I will do, very basic testing:

    (all from xp_cmdshell)

    -Check if you can "dir" the directory

    -Creating a file like "dir > path/test.txt"

    -do a bcpout and then bcp in

    Very basic...

  • RE: About service account

    When you change the account in EM it suppose to do all necesary things to get the account to work with the service but make shure all the properties are...

  • RE: corrupt mdf and ldf file

    The thing about this is that the corrupted database is not on master..sysdatabases anymore, it had been deattached.

    Regards

  • RE: Backup large Database to networkshare

    After checking all those good network suggestions above try doing it without DTS and VBScript, (backup query, xp_cmdshell for zipping) it had worked fine for me for years (if you...

  • RE: corrupt mdf and ldf file

    I had this similar problem, I crash a DB trying to restore a backup to it but got stuck in the middle of the process, I try the same detach...

Viewing 6 posts - 1 through 6 (of 6 total)