Forum Replies Created

Viewing 15 posts - 136 through 150 (of 321 total)

  • RE: SQL Server 2005 with Visual Studio 2008

    Jonathan Mallia (11/21/2008)


    Hi guys,

    Does anybody knows whether it is possible to have SQL Server 2005, Visual Studio 2005 and Visual Studio 2008 installed on the same machine and having the...

    kshitij kumar
    kshitij@krayknot.com
    www.krayknot.com

  • RE: Backup Strategy / Backup the Backup

    Philip Horan (11/21/2008)


    Hi. I have a job that backs up:

    Master / Model / msdb / ReportServer / ApplicationDB on a daily basis.

    I have a second job that cleans up the...

    kshitij kumar
    kshitij@krayknot.com
    www.krayknot.com

  • RE: money convertion

    yogaanand.me (11/21/2008)


    hi friends

    i want to convert money value in the term of word through query

    example

    1000 (rupees) to one thousand

    please help me ..urgent

    here is the procedure. this calculates...

    kshitij kumar
    kshitij@krayknot.com
    www.krayknot.com

  • RE: Versioning the stored procedure

    Chirag (11/21/2008)


    Hi

    Iam working on a proj with a very similar scenario.

    First Iam the DBA and i change the procs and have the final call on them. This makes it easier...

    kshitij kumar
    kshitij@krayknot.com
    www.krayknot.com

  • RE: Versioning the stored procedure

    noordeenshah.nf (11/20/2008)


    Hi all,

    I have more than one application and these applications use some shared Stored Procedures. Any application can modify the shared stored procedure.

    If for an example, lets consider...

    kshitij kumar
    kshitij@krayknot.com
    www.krayknot.com

  • RE: Copy file from one server to another using SSIS

    CSherwood (11/20/2008)


    Copy the file from one machine to another. Works fine.

    However, I then use a stored procedure on the destination machine to import that file into a table. That is...

    kshitij kumar
    kshitij@krayknot.com
    www.krayknot.com

  • RE: Using SQL Server procedures from Excel

    Marty Sprague (11/20/2008)


    We have an existing excel 2003 spreadsheet which has an account number in each row. I have a sql server procedure (sql server 2005) that accepts an...

    kshitij kumar
    kshitij@krayknot.com
    www.krayknot.com

  • RE: linked server

    cherie (11/20/2008)


    I am trying to create a linked server from A to B. Both have sql 2005. Services at both servers run under same accont. I am logging in using...

    kshitij kumar
    kshitij@krayknot.com
    www.krayknot.com

  • RE: Which is faster for Mathmatical Operations?

    markmeiller (11/7/2008)


    So assuming the SQL Server and Reporting Server are in separate but equal environments which would be faster SQL (performing calculations in the Select Statement) or SSRS (performing the...

    kshitij kumar
    kshitij@krayknot.com
    www.krayknot.com

  • RE: SQL Database version control

    Paresh Prajapati (11/20/2008)


    I have configure SQL Redgate ChangeSet with micosoft VSS..

    is it ok?

    i have heard about it that this is useful. but in my case , i prepare a set...

    kshitij kumar
    kshitij@krayknot.com
    www.krayknot.com

  • RE: Database Mirroring or Log shipping on different server

    Paresh Prajapati (11/20/2008)


    But i think Mirroring is degrade database performanance than shipping..

    As per the locations of your servers, the performance will surely degrade but the purpose for which you are...

    kshitij kumar
    kshitij@krayknot.com
    www.krayknot.com

  • RE: SQL Database version control

    Paresh Prajapati (11/18/2008)


    I have to implement SQL Database version control..

    I have Micosoft visual source safe 6.0 and also have Redgate SQL Compare Pro edition...

    But i don't know how to...

    kshitij kumar
    kshitij@krayknot.com
    www.krayknot.com

  • RE: send mail in html format

    nplinares (11/18/2008)


    How can i send email in html format using send mail task of SSIS?

    1. create a mail format

    2. save its html content in a table with the desired column...

    kshitij kumar
    kshitij@krayknot.com
    www.krayknot.com

  • RE: Query result/Grid Font

    piplucse (11/20/2008)


    I am inserting information (Consisting Bangla font & English font) from windows form (Using C#.net). Information are inserted correctly. But Bangla font is too small to read in result/grid....

    kshitij kumar
    kshitij@krayknot.com
    www.krayknot.com

  • RE: How to change the boolean parameter value

    arunkumar.sp (11/20/2008)


    Thanks for your suggestion Gurusamy.

    I tried this but not working.

    I preview yes,no is coming in combo format.

    But in deployment (http://localhost/reports/ ) it is coming as true,false in boolean format.

    Any...

    kshitij kumar
    kshitij@krayknot.com
    www.krayknot.com

Viewing 15 posts - 136 through 150 (of 321 total)