Forum Replies Created

Viewing 15 posts - 196 through 210 (of 320 total)

  • RE: Reading File attributes (datecreated,datemodified....) using sp_OACreate....

    I have to compare the file in 2 directories based on their modified date.

    Regards,
    [font="Verdana"]Sqlfrenzy[/font]

  • RE: Reading File attributes (datecreated,datemodified....) using sp_OACreate....

    Hi Jeff,

    How to traverse a directory/subdirectory to save all file into a table.....

    Regards,
    [font="Verdana"]Sqlfrenzy[/font]

  • RE: Executing multiple .sql files in folder

    any body on this one.......

    Regards,
    [font="Verdana"]Sqlfrenzy[/font]

  • RE: Reading File attributes (datecreated,datemodified....) using sp_OACreate....

    Thanks Jeff....I ran this command on my machine and setup.txt file do exist........

    well....I will try this wid some other file name.....one more I have evaluation edition ......

    Regards,
    [font="Verdana"]Sqlfrenzy[/font]

  • RE: Information Required regarding Monitoring SQL Server 2005

    Sudeepta (11/6/2008)


    Hello everyone,

    I am looking for some documentation on Monitoring SQL Server 2005. I have a Ms Press Book titled as SQL Server 2005 Implementation and Maintenance. However, that book...

    Regards,
    [font="Verdana"]Sqlfrenzy[/font]

  • RE: Problem in printing reports from the report viewer

    Jon Burnett (11/7/2008)


    Microsoft in their infinite wisdom decided to disable the client side print program due to a security problem. I've been having my users select the export to PDF...

    Regards,
    [font="Verdana"]Sqlfrenzy[/font]

  • RE: Problem in Job Execution

    Steve Jones - Editor (10/19/2008)


    When you execute the job, the SQL Agent service account (or a proxy that is configured) is who executes the batch file. That account needs to...

    Regards,
    [font="Verdana"]Sqlfrenzy[/font]

  • RE: Problem in Job Execution

    The error is "Access is Denied", I have loggedin as sa

    however the batch file executes successfuly at the command prompt

    Regards,
    [font="Verdana"]Sqlfrenzy[/font]

  • RE: Adding report to Report server

    Luke L (10/15/2008)


    Exactly, If you setup a shared datasource in your Report Project/Solution you can point all of your reports to that datasource. Then just publish the datasource with...

    Regards,
    [font="Verdana"]Sqlfrenzy[/font]

  • RE: Adding report to Report server

    Kishore.P (10/15/2008)


    Use shared datasource for all reports. For better organizing.

    I am using shared database ... I had to assign shared database to each report manualy...Is there a way to...

    Regards,
    [font="Verdana"]Sqlfrenzy[/font]

  • RE: Adding report to Report server

    Luke L (10/14/2008)


    sorry about the delay I was out of the office for a few days.

    Yes. I deploy reports from my workstation to my report server in...

    Regards,
    [font="Verdana"]Sqlfrenzy[/font]

  • RE: Adding report to Report server

    Luke L (10/10/2008)


    no script is needed, inside of VS just select the reports you want to deploy, right click and deploy them.

    -Luke.

    Does this method can be used to deploy reports...

    Regards,
    [font="Verdana"]Sqlfrenzy[/font]

  • RE: Adding report to Report server

    Luke L (10/10/2008)


    Yes, I do this all the time with visual studio. You can either deploy your entire project, or use cntl+click to select the reports you want to...

    Regards,
    [font="Verdana"]Sqlfrenzy[/font]

  • RE: A restore scenario

    Steve Jones - Editor (10/9/2008)


    RESTART

    Note:

    Supported only by RESTORE.

    Specifies that SQL Server should restart a restore operation that has...

    Regards,
    [font="Verdana"]Sqlfrenzy[/font]

  • RE: Few interview questions

    It depends on the distribution of the inserts... if the distribution is wide across the table, then nonclustered indexes can suffer quite badly. If the distribution is "close"...

    Regards,
    [font="Verdana"]Sqlfrenzy[/font]

Viewing 15 posts - 196 through 210 (of 320 total)