Forum Replies Created

Viewing 15 posts - 391 through 405 (of 3,366 total)

  • RE: Apply Service Pack 2 / Service Pack 3

    I would like to apply SQL Services packs 2 and 3. Can I jump straight to SP3 or would the reccomended upgrade path be SP2 then SP3?

    I have downloaded Microsoft...

    Kind regards,
    Gift Peddie

    March 3, 2010 at 7:35 pm

    #1128205

  • RE: Not able to invoke SSIS package from VB.NET code

    The main purpose of copying ManagedDTS dll from x32 box to x64 box was that, we found the DLL is missing in the location where its suppose to be in...

    Kind regards,
    Gift Peddie

    March 3, 2010 at 3:52 pm

    #1128145

  • RE: Reporting Services Login Box always prompting when deploying my report

    Kevin Stump (1/14/2010)

    drobinson-968235 why aren't you using Active Directory to control your security instead of logging everyone in as the same user. If you use AD you can control...

    Kind regards,
    Gift Peddie

    March 3, 2010 at 9:11 am

    #1127866

  • RE: CREATE SQL Login using Active Directory

    Edwin-376531 (2/26/2010)

    I tried to digest you all discussion and a little heavy for me 🙂

    That is correct just remember not to define users permission with AD only if some of...

    Kind regards,
    Gift Peddie

    February 26, 2010 at 2:28 pm

    #1125841

  • RE: CREATE SQL Login using Active Directory

    Toby White (2/26/2010)

    Then just use active directory groups and grant permissions to the groups on the SQL Instance.

    When there is an application context both Winform and Asp.net resolves users based...

    Kind regards,
    Gift Peddie

    February 26, 2010 at 2:24 pm

    #1125839

  • RE: CREATE SQL Login using Active Directory

    Toby White (2/26/2010)

    Use connection pooling from the IIS app pool. IIS will connect to the database with one account. You are not going to create an account for everyone on...

    Kind regards,
    Gift Peddie

    February 26, 2010 at 2:02 pm

    #1125818

  • RE: CREATE SQL Login using Active Directory

    The most important thing about the "best practice" is that you use Active Directory accounts. In other words DON'T use SQL Server account.

    The above is only applicable if there is...

    Kind regards,
    Gift Peddie

    February 26, 2010 at 1:27 pm

    #1125805

  • RE: Not able to invoke SSIS package from VB.NET code

    1. Is there anything that I am missing in my 64 bit machine? Any specific set ups required in 64 bit machine to get the ManagedDTS dll?

    Do you really want...

    Kind regards,
    Gift Peddie

    February 26, 2010 at 9:52 am

    #1125694

  • RE: Doubt about table report in SSRS 2005

    Per Google and Bing that is 156 inches so you should think of using SSRS 2008 where you can create a View with all your columns and use the Table...

    Kind regards,
    Gift Peddie

    February 25, 2010 at 11:43 am

    #1125144

  • RE: Can't install Express Edition and Management Console on Win 7 64-bit machine

    Ed Mini (2/25/2010)

    Thanks for the reply. However, although this gets me a lot further, the install of both SQL Server Express and the Management Studio still fails. :hehe: I tried...

    Kind regards,
    Gift Peddie

    February 25, 2010 at 8:46 am

    #1125037

  • RE: copy Database properties in Visio into clipboard ?

    Franky Leeuwerck (2/25/2010)

    Hi,

    Does anyone know how to copy the information from the columns pane in the Database Properties window of a table entity in Visio?

    Specifically on the columns page, I...

    Kind regards,
    Gift Peddie

    February 25, 2010 at 8:19 am

    #1125025

  • RE: Doubt about table report in SSRS 2005

    veeren4urs (2/24/2010)

    Hi ,

    Thank you very much for quick response.

    Actuvally i changed the layout size to landscope since the report body width was lessthan the report width may be it will...

    Kind regards,
    Gift Peddie

    February 24, 2010 at 12:14 pm

    #1124486

  • RE: Doubt about table report in SSRS 2005

    veeren4urs (2/24/2010)

    Hi ,

    I created One rdl which have Dynamic columns (Max is 278) based on user selection and some times i got the index length (not remembered exactly)error when the...

    Kind regards,
    Gift Peddie

    February 24, 2010 at 12:00 pm

    #1124469

  • RE: SQL Server 2005 Installation Directories

    After the install, the data and log folders were created in D:\mssql2005\MSSQL\MSSQL.2\OLAP\Data. Again, this is such a long path name. Should I have just enterred d:\mssql2005? It appears the installation...

    Kind regards,
    Gift Peddie

    February 24, 2010 at 11:55 am

    #1124463

  • RE: Doubt about table report in SSRS 2005

    only4mithunc (2/23/2010)

    Hi Sorry I mentioned length, I wanted to know the max width of the table item in SSRS 2005.

    Regards,

    MC

    I have created a report that generated more than 270 pages...

    Kind regards,
    Gift Peddie

    February 24, 2010 at 9:35 am

    #1124345

Viewing 15 posts - 391 through 405 (of 3,366 total)