Forum Replies Created

Viewing 15 posts - 571 through 585 (of 1,136 total)

  • RE: issues in reading dead lock graph

    Nope I cannot read it either, cannot zoom it either.

    --------------------------------------------------------------------------------------
    [highlight]Recommended Articles on How to help us help you and[/highlight]
    [highlight]solve commonly asked questions[/highlight]

    Forum Etiquette: How to post data/code on a forum to get the best help by Jeff Moden[/url]
    Managing Transaction Logs by Gail Shaw[/url]
    How to post Performance problems by Gail Shaw[/url]
    Help, my database is corrupt. Now what? by Gail Shaw[/url]

  • RE: Service terminated with error 3417

    Timothy.Cloud (9/22/2009)


    What does it mean when you find that your SQLAgent service terminated with error 3417?

    It's the only "odd" event surrounding a period of time when my SQL Server stopped...

    --------------------------------------------------------------------------------------
    [highlight]Recommended Articles on How to help us help you and[/highlight]
    [highlight]solve commonly asked questions[/highlight]

    Forum Etiquette: How to post data/code on a forum to get the best help by Jeff Moden[/url]
    Managing Transaction Logs by Gail Shaw[/url]
    How to post Performance problems by Gail Shaw[/url]
    Help, my database is corrupt. Now what? by Gail Shaw[/url]

  • RE: out-of-range datetime value

    Jim Howerton (9/22/2009)


    ISNULL(sold_date,'1/1/1700 12:00:00.000 AM')

    Error

    The conversion of a char data type to a datetime data type resulted in an out-of-range datetime value.(22007,242)

    provider='MSDAORA'

    Oracle 10

    Can you indulge me and see if it...

    --------------------------------------------------------------------------------------
    [highlight]Recommended Articles on How to help us help you and[/highlight]
    [highlight]solve commonly asked questions[/highlight]

    Forum Etiquette: How to post data/code on a forum to get the best help by Jeff Moden[/url]
    Managing Transaction Logs by Gail Shaw[/url]
    How to post Performance problems by Gail Shaw[/url]
    Help, my database is corrupt. Now what? by Gail Shaw[/url]

  • RE: Errorlog showing insufficient memory to run this query

    joeroshan (9/22/2009)


    Thank you Silverfox.

    We will plan for a memory upgrade. Or probably a 64 bit upgrade.

    Meanwhile, if I setup a trace against the server, how will find out who is...

    --------------------------------------------------------------------------------------
    [highlight]Recommended Articles on How to help us help you and[/highlight]
    [highlight]solve commonly asked questions[/highlight]

    Forum Etiquette: How to post data/code on a forum to get the best help by Jeff Moden[/url]
    Managing Transaction Logs by Gail Shaw[/url]
    How to post Performance problems by Gail Shaw[/url]
    Help, my database is corrupt. Now what? by Gail Shaw[/url]

  • RE: Shrinking db with sql2005

    Patrick Groce (9/22/2009)


    Well sql 2005 does not appear to manage space effectively. I can see from many copies of our ERP systems in testing that saving that 30% of disk...

    --------------------------------------------------------------------------------------
    [highlight]Recommended Articles on How to help us help you and[/highlight]
    [highlight]solve commonly asked questions[/highlight]

    Forum Etiquette: How to post data/code on a forum to get the best help by Jeff Moden[/url]
    Managing Transaction Logs by Gail Shaw[/url]
    How to post Performance problems by Gail Shaw[/url]
    Help, my database is corrupt. Now what? by Gail Shaw[/url]

  • RE: Transaction Log Backups Failing.

    Duran (9/22/2009)


    Hello

    Thanks for getting back, all of my DB's are in full recovery mode. Here is the log that will hopefully help you to help me. Hope its right.

    Failed:(-1073548784) Executing...

    --------------------------------------------------------------------------------------
    [highlight]Recommended Articles on How to help us help you and[/highlight]
    [highlight]solve commonly asked questions[/highlight]

    Forum Etiquette: How to post data/code on a forum to get the best help by Jeff Moden[/url]
    Managing Transaction Logs by Gail Shaw[/url]
    How to post Performance problems by Gail Shaw[/url]
    Help, my database is corrupt. Now what? by Gail Shaw[/url]

  • RE: db_owner script

    Yes on that database only, although you can look at stored procedure with lower rights, if they can run select statements against the syscomments table.

    --------------------------------------------------------------------------------------
    [highlight]Recommended Articles on How to help us help you and[/highlight]
    [highlight]solve commonly asked questions[/highlight]

    Forum Etiquette: How to post data/code on a forum to get the best help by Jeff Moden[/url]
    Managing Transaction Logs by Gail Shaw[/url]
    How to post Performance problems by Gail Shaw[/url]
    Help, my database is corrupt. Now what? by Gail Shaw[/url]

  • RE: How To write before Trigger in sql server 2005

    This will give you a bit more information on triggers

    http://www.sqlservercentral.com/articles/Triggers/64214/

    this link basically shows you all the content on this site about triggers, and you can watch videos which give...

    --------------------------------------------------------------------------------------
    [highlight]Recommended Articles on How to help us help you and[/highlight]
    [highlight]solve commonly asked questions[/highlight]

    Forum Etiquette: How to post data/code on a forum to get the best help by Jeff Moden[/url]
    Managing Transaction Logs by Gail Shaw[/url]
    How to post Performance problems by Gail Shaw[/url]
    Help, my database is corrupt. Now what? by Gail Shaw[/url]

  • RE: Errorlog showing insufficient memory to run this query

    joeroshan (9/22/2009)


    Thank you both of you for quick reply.

    I forgot to mention we have total four instance on the server.

    Two of them uses 4 GB each. One 3GB . Another...

    --------------------------------------------------------------------------------------
    [highlight]Recommended Articles on How to help us help you and[/highlight]
    [highlight]solve commonly asked questions[/highlight]

    Forum Etiquette: How to post data/code on a forum to get the best help by Jeff Moden[/url]
    Managing Transaction Logs by Gail Shaw[/url]
    How to post Performance problems by Gail Shaw[/url]
    Help, my database is corrupt. Now what? by Gail Shaw[/url]

  • RE: What is Exchange Event in dead locks?

    Grant Fritchey (9/22/2009)


    It's blank. If you're posting XML, you need to use the code listing on the left

    [ code = "xml" ]

    Just remove the extra spaces.

    I...

    --------------------------------------------------------------------------------------
    [highlight]Recommended Articles on How to help us help you and[/highlight]
    [highlight]solve commonly asked questions[/highlight]

    Forum Etiquette: How to post data/code on a forum to get the best help by Jeff Moden[/url]
    Managing Transaction Logs by Gail Shaw[/url]
    How to post Performance problems by Gail Shaw[/url]
    Help, my database is corrupt. Now what? by Gail Shaw[/url]

  • RE: Administer all SQL Servers from a central console (SSMS)

    Fernando-235287 (9/22/2009)


    Sorry, guys, I did this a few years back with 2000, but totally forgot. Any articles or ways of doing so? I think I am searching with the wrong...

    --------------------------------------------------------------------------------------
    [highlight]Recommended Articles on How to help us help you and[/highlight]
    [highlight]solve commonly asked questions[/highlight]

    Forum Etiquette: How to post data/code on a forum to get the best help by Jeff Moden[/url]
    Managing Transaction Logs by Gail Shaw[/url]
    How to post Performance problems by Gail Shaw[/url]
    Help, my database is corrupt. Now what? by Gail Shaw[/url]

  • RE: out-of-range datetime value

    Jim Howerton (9/22/2009)


    I am reading an MS SQL table and inserting rows in an Oracle table using a linked server. If a date field is null in the MS table,...

    --------------------------------------------------------------------------------------
    [highlight]Recommended Articles on How to help us help you and[/highlight]
    [highlight]solve commonly asked questions[/highlight]

    Forum Etiquette: How to post data/code on a forum to get the best help by Jeff Moden[/url]
    Managing Transaction Logs by Gail Shaw[/url]
    How to post Performance problems by Gail Shaw[/url]
    Help, my database is corrupt. Now what? by Gail Shaw[/url]

  • RE: Report Server URL Access Cache Problem

    try adding &rc:ClearSession =true

    or

    I was having report caching problems and cured them by updating the properties of the Reports directory in IIS. On the HTTP Headers tab I...

    --------------------------------------------------------------------------------------
    [highlight]Recommended Articles on How to help us help you and[/highlight]
    [highlight]solve commonly asked questions[/highlight]

    Forum Etiquette: How to post data/code on a forum to get the best help by Jeff Moden[/url]
    Managing Transaction Logs by Gail Shaw[/url]
    How to post Performance problems by Gail Shaw[/url]
    Help, my database is corrupt. Now what? by Gail Shaw[/url]

  • RE: During the posts or replys, problem with FireFox

    Site seems to be a bit better now, not seeing all the asp error pages coming up as much

    --------------------------------------------------------------------------------------
    [highlight]Recommended Articles on How to help us help you and[/highlight]
    [highlight]solve commonly asked questions[/highlight]

    Forum Etiquette: How to post data/code on a forum to get the best help by Jeff Moden[/url]
    Managing Transaction Logs by Gail Shaw[/url]
    How to post Performance problems by Gail Shaw[/url]
    Help, my database is corrupt. Now what? by Gail Shaw[/url]

  • RE: Are the posted questions getting worse?

    How much can you receive for aricles posted here?, just out of comparision 😀

    --------------------------------------------------------------------------------------
    [highlight]Recommended Articles on How to help us help you and[/highlight]
    [highlight]solve commonly asked questions[/highlight]

    Forum Etiquette: How to post data/code on a forum to get the best help by Jeff Moden[/url]
    Managing Transaction Logs by Gail Shaw[/url]
    How to post Performance problems by Gail Shaw[/url]
    Help, my database is corrupt. Now what? by Gail Shaw[/url]

Viewing 15 posts - 571 through 585 (of 1,136 total)