Forum Replies Created

Viewing 15 posts - 31 through 45 (of 47 total)

  • RE: Transfer login

    This is how I handle this situation:

    1. run sp_dropuser for the database

    2. for SQL logins run sp_addlogin. for Windows logins run sp_grantlogin

    3. run sp_grantdbaccess for the login(s)

    4. run sp_addrolemember...

  • RE: URGENT : Database maintenance History

    Use sp_purge_jobhistory to purge the job history.

  • RE: EM and QA show different counts

    How are you doing the counts in EM? If you are just looking at properties of the table, then you can possibly get a wrong count in EM. I am...

  • RE: ODBC Connection failure

    Look up "guest user" in BOL. It has a pretty decent explanation.

  • RE: Change password using sp_password

    Try this: sp_password [ [ @old = ] 'old_password' , ]

    { [ @new =] 'new_password' }

    of course, you must be logged in...

  • RE: Merge Replication Problems - SQL Server 2000

    Look at these KB articles as possible causes and resolutions to your problem:

    http://support.microsoft.com/?id=307356 INF: Understanding Merge Replication Article Processing Order

    ...

  • RE: MSDE Installation Blues

    Is this a fresh installation of MSDE or are you applyint a service pack to an existing insallation? Also, exactly how are you installing (i.e. command line parameters)?

  • RE: Enterprise vs. Standard Edition

    The data space and memory limits are the same. However, there are other differences you need to look at. It would be too lengthy to mention here, but you need...

  • RE: Memory usage

    SQL Server 2000 dynamically acquires and frees memory as needed. It is typically not necessary for an administrator to specify how much memory should be allocated to SQL Server, although...

  • RE: Renaming a SQL Server Instance

    Renaming a Server (From BOL)

    When you change the name of the computer that is running Microsoft® SQL Server™ 2000, the new name is recognized during SQL Server startup. You do...

  • RE: Is there a way to restore a job?

    The only way I know would be if you had scripted the job and kept the query. Then you could rebuild the job through the query.

  • RE: Routine Maintenance

    There is a Maintenance Plan wizard you can use in Enterprise Manager. It will guide you as to what type of maintenance you will need. It is not the end...

  • RE: how to reduce database size

    Or, you can use the dbcc shrinkdatabase command. See below:

    DBCC SHRINKDATABASE

    ( database_name [ , target_percent ]

    [...

  • RE: QOD 8/7/03

    sniff .. sniff ... do I smell sour grapes in here ???

  • RE: reinit merge pull article.

    Thanks for the reply, but I take exception with what you said about ALL publications. You CAN reinitialize a single article for Transactional push subscriptions. I do this a lot....

Viewing 15 posts - 31 through 45 (of 47 total)