Forum Replies Created

Viewing 15 posts - 121 through 135 (of 174 total)

  • RE: DTS package script

    ...and it's possible tu run it from command prompt. It's clearly explained in BOL "how to execute a DTS package using dtsrun"

  • RE: How to get notification when one node fails to another?

    Thank you Sa24 and John for your ideas! I immediately will try your suggestions

     

  • RE: How to get notification when one node fails to another?

    Thank you for your reply

    I'm not fastidious and our cluster doesn't perform criticial services, so there could be the simplest way to get...

  • RE: Simple log shipper won''''t stop !

    There are three schedules: backup, copy\load, load in a log shipping. And there are not schedule for a proccess lenght, only for intervals of these three types. As I remember...

  • RE: Log Shipment questions only for sql server 2000

    1. No. Only in case when you will change servers roles ex.: after change  your old primary would be new secondary and vice versa

    2.Only updates

    3. It should be if you...

  • RE: how to recover all deleted records.

    Hi, what about your DB backups? Do you have them? If so how often have  you made them?

  • RE: Can''''t reinstall sql virtual server

    Finally it works again!

    Yes I think that my both servers where rebooted in tens times. Don't as me what concrete I've done, you wouldn't get an answer

  • RE: Can''''t reinstall sql virtual server

    Detailed errors:

    The description for Event ID ( 17055 ) in Source ( MSSQL$INST1 ) cannot be found. The local computer may not have the necessary registry information or message...

  • RE: Can''''t reinstall sql virtual server

    Hello, sa24

    Do you mean I  must delete these :

    Locate, and then delete the %drive%:\Program Files\Microsoft SQL Server\MSSQL\Binn folder

    and registries:

    HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer

    HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server

    HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\MSSQLServer$InstanceName

    HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\SQLSERVERAGENT$InstanceName

    HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\MSSQLServerADHelper

    If so it doesn't help. My installation with the same...

  • RE: Shrinking Tempdb Revisted

    I don't understand have you tried to shrink it?

    Quite simple explanation of doing this in  BOL "How to shrink a database (Enterprise Manager)"  Or maybe I missed something?

  • RE: Setting startup service account in EM

    Agreed with Yelena. Your both SQL server services and sqlserveragents must run under the same local admin account (ex. Adm) which you added previously. Then as Adm you can connect through EM to...

  • RE: Remote Installation Stand. Edition

    I had the same problem on XP box when I tried tried to install SQL Enterprise 2000 . I was allowed to install only client tools. When I got developer edition,...

  • RE: Cursor won''''t fetch next row?

    I guess your cursor is built under wrong syntax. I think you missed one 'fetch next' command. For more info see BOL

    It's only my personal oppinion

  • RE: Setting startup service account in EM

    Hi,

    So you see these grayed options on the server where you are not local admin... In this case it should be so. If you want to change these options you...

  • RE: SA Password

    Yes it is possible through enterprise manager. In logins you'll see sa account. Double Click on it and type new password twice

    But you need to have system administrator or local...

Viewing 15 posts - 121 through 135 (of 174 total)