Post reply

Application gets installed but creates only one table in SQL - Please help..!

  • November 17, 2011 at 1:24 am

    #1409005

    A fresh installation of SQL will very do exactly the same thing, this sounds like a bad code problem, not a SQL settings problem. Have you spoken with the vendor?

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • November 17, 2011 at 4:34 am

    #1409079

    krishikrish (11/16/2011)

    Thanks for the quick reply...! In this case i represent the application vendor but i am not from a support or development background. 🙂

    The only way we can help is for you to run a trace on the server while re-re-re-retrying the install.

    Maybe we'll be able to spot something in the last statement to run (assuming it's the one that fails).

  • November 22, 2011 at 12:45 am

    #1411228

    Thanks for your inputs guys. The issue has been resolved.

    It was a database collation problem. Reinstallation of SQL Server 2005 did the trick. Actually, the IT team of the client had not chosen the default installation configuration of SQL Server 2005. It was an issue of enforcing case sensitivity. Basically dbo and DBO were being considered as different and thats the reason why queries were not getting executed when tried through an application.

  • November 22, 2011 at 4:21 am

    #1411339

    krishikrish (11/22/2011)

    Thanks for your inputs guys. The issue has been resolved.

    It was a database collation problem. Reinstallation of SQL Server 2005 did the trick. Actually, the IT team of the client had not chosen the default installation configuration of SQL Server 2005. It was an issue of enforcing case sensitivity. Basically dbo and DBO were being considered as different and thats the reason why queries were not getting executed when tried through an application.

    Dude I'm on a case sensitive server and I'll NEVER have it rebuilt for a new application. You guys need to get this sorted out. Move dev to a CS server and then do all your tests there so that it never happens again.

Viewing 4 posts - 16 through 19 (of 19 total)

You must be logged in to reply to this topic. Login to reply