Forum Replies Created

Viewing 15 posts - 1 through 15 (of 18 total)

  • RE: Cleaning up Replication Monitor

    This same thing has happened to me and what resolved it in my case was to open up the MSreplication_agent_status table in tempdb and delete a record that had a...

  • RE: Shrinking almost empty datafile not possible

    SQL Server does NOT ALLOW you to remove a Primary Datafile.

    Anne

  • RE: The SQL * Wildcard

    I think I may need more than that - they are pretty tough on us here!

    Example - I opened a call with Microsoft about deadlocking (app. vs. replication)...

  • RE: The SQL * Wildcard

    I am not fully satisfied with the answers we have come up with here (not that anyone should really care about that). What about something more substantial like what...

  • RE: Removing Replication

    We've always used sp_removedbreplication 'databasename' on the publisher and subscriber after removing replication.  This gets rid of all the replication system objects that often get left behind and the replication...

  • RE: Urgent problem peformance issue after database migration

    I would recommend turning off hyperthreading on the servers.  We have had 2 recent incidents involving the migration of 2 clusters to new hardware, using Windows 2003 and SQL...

  • RE: DTS Job Failure

    Yes.

  • RE: Moving Large Database

    Thanks everyone for your help!  Although I really am more interested in the moving of the file than I am concerned on fixing the logins - any more ideas in...

  • RE: DBCC SHOWCONTIG

    Thank you Aaron - I think that Advanced tab - Output file is exactly what I was looking for!  I appreciate the non-scientific statistics as well -  I will be...

  • RE: DBCC SHOWCONTIG

    Have you exported the results to a table before?  In BOL it describes TABLERESULTS as this:

    Displays results as a rowset, with additional information

    I was thinking that referred...

  • RE: Maintenance Plan Failing

    Any chance you had recently deleted a database?  If a database is included in a maintenance plan that does not have any of the "all databases" options checked...

  • RE: Trouble running stored proc with a job

    A great suggestion, but this did not solve my problem!  Any other ideas?

    Thanks!

    Anne

     

  • RE: Pros & Cons of backups using Maint. Plans

    I am all for the use of maintenance plans! They are a built in tool and are very easy to use. To find the history of the jobs...

  • RE: SQLAgent hung with "performing completion actions"

    We have found that removing the Contacts Address Book from Outlook keeps this problem from happening. (Properties of Outlook, properties of Outlook Address Book, highlight Contacts, Remove). I...

  • RE: SQLAgent hung with "performing completion actions"

    This may seem like a strange question, but is there an Outlook client installed on the SQL Server?

Viewing 15 posts - 1 through 15 (of 18 total)