Forum Replies Created

Viewing 15 posts - 2,686 through 2,700 (of 3,366 total)

  • RE: Cannot save the SQL statement of a dataset

    You can convert it to a stored procedure that takes control from reporting services because all you have to do is point reporting services to the stored procedure in the...

    Kind regards,
    Gift Peddie

  • RE: Right to Left Report

    It just means you have to do more work, the table comes with textboxes with the same property set all, your report dataset comes with the collation in the dataoption window...

    Kind regards,
    Gift Peddie

  • RE: Cannot save the SQL statement of a dataset

    You have run into what I call reporting services annoyances, it is not intuitive so I usually just delete the old dataset and manual work the new select statement into...

    Kind regards,
    Gift Peddie

  • RE: Server Login problem

    If you are using Window authentication you need to add all the users to SQL Server.  If not just use SQL authenthication and change your connection string.  Microsot have covered...

    Kind regards,
    Gift Peddie

  • RE: Getting rid of DBO and SA access

    If you are in Win2003 you can use the Network Service account and use the DBO schema and you will be fine, if you are in Win2k then I will...

    Kind regards,
    Gift Peddie

  • RE: Server Login problem

    You just need to change SQL Server to Mixed authentication mode, the steps are in the link below.

    http://msdn2.microsoft.com/en-us/library/ms188670.aspx

     

    Kind regards,
    Gift Peddie

  • RE: Getting rid of DBO and SA access

    In a .NET web application it will take a developer four months to do the work ASPNETDB will create for the application so you are just adding to employer's cost...

    Kind regards,
    Gift Peddie

  • RE: Getting rid of DBO and SA access

    ASPNETDB creates the stored procedures in DBO schema, we used that in my last contract for a GM Winform application so in .NET application you need DBO permissions granted to whatever...

    Kind regards,
    Gift Peddie

  • RE: sqlexpress full-text search problem

    Then I would say check the configuration Manager to make sure Fulltext Search is set to auto from Manual mine is auto by default but I am running the developer...

    Kind regards,
    Gift Peddie

  • RE: sqlexpress full-text search problem

    Hi

    I just clicked both links and it works so try again.

     

    Kind regards,
    Gift Peddie

  • RE: Getting rid of DBO and SA access

    If your application is .NET it is not good practice to remove DBO but you can create a user with DBO permissions that the application can use, but removing SA...

    Kind regards,
    Gift Peddie

  • RE: Right to Left Report

    You need to be in the Business Intelligence Management Studio and add a Report item and drop a table control on it, you will see the Report properties in Solution Explorer...

    Kind regards,
    Gift Peddie

  • RE: Right to Left Report

    It is in the Report properties in the drop down properties of the controls in the Reports under International after Calendar is page direction, I am in the US so...

    Kind regards,
    Gift Peddie

  • RE: Management Studio Client

    Microsoft does not allow it because Express Advanced comes with it free and the developer edition is only $50 list less than $40 retails.

     

    Kind regards,
    Gift Peddie

  • RE: Visual Studio.. where do I find the install for it.

    Actually there is 64bits regular VS2005 but there is no 64bits BI management studio because you really don't need it.  Microsoft joined Oracle in the 64bits market and in Oracle...

    Kind regards,
    Gift Peddie

Viewing 15 posts - 2,686 through 2,700 (of 3,366 total)