Forum Replies Created

Viewing 15 posts - 331 through 345 (of 463 total)

  • RE: Cluster memory issue

    Regarding your questions, i can't think of anything else except just verify all the settings which you have provided above and make sure that there is not any other process eating...

  • RE: Profiler blues...

    Try Filtering using database id.

  • RE: Login information from SQL Server 7.

    Unfortunately, none of the system tables stores the login information. As steve mentioned, you need to turn the logging on.

  • RE: Backup Possessive or Performance hog ???

    Jim,

    My apologies. I don't know if it was a cached session or something wrong with me that when i saw the thread, it was still in the initial steps where...

  • RE: Sync Users After SQL 6.5 DB Restore

    You can create the logins on the new server and then run the procedure sp_change_users_login which would map the user id's to logins.

  • RE: Backup Possessive or Performance hog ???

    A mapped drive is only available to the user who creates it. SQL Server runs under the system account and the mapping is not recognised by the system account(unless it...

  • RE: SQl Server Rollback?

    Are you referring to cross database ownership ? That's something you can turn on and off with sp_dboption

  • RE: Backup Possessive or Performance hog ???

    I agree with all that backing up to a network drive is not a good idea.

    But if you still need to back up, try giving a UNC path and hope...

  • RE: SQl Server Rollback?

    SP3a read-me file says.

    To revert to the pre-SP3a versions of SQL Server 2000 components, you must have back ups of the master, msdb, and model databases taken prior to installing SP3a

     

    "one...

  • RE: sbs2003 invalid user problem

    Try changing the owner of the object to dbo

    sp_changeobjectowner 'prco_name','dbo'

  • RE: Backup errors

     

    How big is the database that fails the backup? (Could be timing out)

    The database is only 600 MB big.

    Are all the databases backing up at the same time or...

  • RE: Backup errors

    Thanks for the feedback. Do you mean network issues with the network drive ? Also, we have 5 more user databases which are not having any issues to be backed...

  • RE: Controlling Developers and Application

    We have canned application in our environment and unfortunately you have to stay with them.

    Regarding security, we have a separate id which requires...

  • RE: Rights to create a view

    Did this get resolved ?

  • RE: How determine multiple DB usage/workload?

    I think SQL Profiler should be a good place to start. You can just start a standard trace and direct the output to a table. Make sure that you have...

Viewing 15 posts - 331 through 345 (of 463 total)