Forum Replies Created

Viewing 15 posts - 2,446 through 2,460 (of 3,366 total)

  • RE: SQL Server 2000 SP3

    There is really no SQL Server 2000 SP3 because SP3 was later converted to SP3a but the current version of 2000 is SP4 so you need to use that instead...

    Kind regards,
    Gift Peddie

  • RE: Restoring a database without a ldf file

    Put the MDF in the SQL Server data folder and go to management studio and use the attach wizard it will tell you LDF not found in the message section....

    Kind regards,
    Gift Peddie

  • RE: Slack SQL Server

    Oracle does not sell developer edition so it limits what I can do with it in SQL Server there are things I do with it that Microsoft did not say...

    Kind regards,
    Gift Peddie

  • RE: Users creating their own reports??!!!!

    BID(Business intelligence development studio) you get it if you are running SQL Server for pay editions. However if you are running any of VS2005/8 Team Suites it will not...

    Kind regards,
    Gift Peddie

  • RE: migrating package to SQL Agent

    When you run it in BIDs it runs in the context of your permissions and when you schedule it as a job it runs in the context of the Agent...

    Kind regards,
    Gift Peddie

  • RE: Unable to connect to Oracle 10g after upgrading to 2008

    This error is related to the connected user permissions in Oracle the best solution make sure your TNSNAME.ORA file is in your development folder. You also need Oracle client...

    Kind regards,
    Gift Peddie

  • RE: Managing a farm of SQL databases how ?

    I was at a bank with 68 SQL Server instances, 1 Oracle 9i and 1 DB2 the tools we used was Embacadero and Microsoft's System center operations manager, the files...

    Kind regards,
    Gift Peddie

  • RE: Size error when creating database

    I am assuming it is related to your index file definition is bigger than your MDF and LDF files which are the data and transaction log files. Check below...

    Kind regards,
    Gift Peddie

  • RE: ProductID column for Product Identification and index or a separate generated ID ?

    You need both ProductID and ProductNumber because both are needed and I think ProductNumber is Nvarchar and not INT as IDENTITY. The product table in both the commerce starter...

    Kind regards,
    Gift Peddie

  • RE: ProductID column for Product Identification and index or a separate generated ID ?

    Shopping cart is one of the most complex features in a web application so I think you should start with existing code from Microsoft like in the commerce starter kit...

    Kind regards,
    Gift Peddie

  • RE: updatable view

    (Updatable Views

    You can modify the data of an underlying base table through a view, as long as the following conditions are true:

    Any modifications, including UPDATE, INSERT, and DELETE statements,...

    Kind regards,
    Gift Peddie

  • RE: updatable view

    That is because the relational engine is just running your code as a view from one base table, again I don't think you should run it because the RDBMS...

    Kind regards,
    Gift Peddie

  • RE: Users creating their own reports??!!!!

    That is what you do with the Report Builder, I have not used the SQL Server 2008 version but in SQL Server 2005 you create models your users can use...

    Kind regards,
    Gift Peddie

  • RE: can we drop rdls without creating a report server database

    I think you need more than that so rerun setup so you can be sure you have added all you need to run the rdl and solution files.

    Kind regards,
    Gift Peddie

  • RE: can we drop rdls without creating a report server database

    There is no valid reason for your assumptions because you can give your developers the developer edition and ask the developers to just upload ready for deployment code to your...

    Kind regards,
    Gift Peddie

Viewing 15 posts - 2,446 through 2,460 (of 3,366 total)