Forum Replies Created

Viewing 15 posts - 1,756 through 1,770 (of 7,636 total)

  • RE: CLR - Access Denied Error

    What permission set are you loading the assembly with in production?

  • RE: Possible Performance Issues ?

    What kind of numbers are you seeing in perfmon on the server during those times that performance is bad?

  • RE: Are the posted questions getting worse?

    Grant Fritchey (8/13/2009)


    RBarryYoung (8/13/2009)


    Another real Gem...

    I went to respond to your interpretation of the SSMS shorthand and decided that it would look too much like picking on the guy who...

  • RE: move the files

    charipg (8/13/2009)


    i am new to sql..........first time i am using extended sp.............

    thanks.............

    That's not really an answer to the question I asked. Here is it again in case you have...

  • RE: Are the posted questions getting worse?

    Another real Gem...

  • RE: move the files

    charipg (8/13/2009)


    EXEC xp_cmdshell 'copy c:\folder1\file1

    \\server2\folder2\file1, NO_OUTPUT';

    correct?

    still waiting ...

  • RE: move the files

    charipg (8/13/2009)


    master..xp_cmdshell 'copy C:\folder1 \\ + @Server1 '

    is it correct?

    Still waiting for an answer to my question ...

  • RE: move the files

    charipg (8/13/2009)


    in server1 , file is C:\folder1

    i want to copy that file in server2 , file is D:\folder2

    pls give the complete command.

    I'm curious. What is your position in your...

  • RE: move the files

    To copy files from the command level? The command is "COPY".

  • RE: Possible Performance Issues ?

    You'll need to describe your symptoms. Plus, how you are using SQL and why you think that this has to do with SQL's use of RAM.

  • RE: sqlprofiler

    Grant Fritchey (8/13/2009)


    GilaMonster (8/13/2009)


    sivark1 (8/12/2009)


    pls tell how to c the o/p of the profiler

    What?

    Guessing:

    Please tell me how to see the output of the profiler?

    Huhn. Now I would have thought...

  • RE: BNF Basics

    Paul Hunter (8/13/2009)


    ...

    <opinion type="humble">The SQL team wrighting BOL should include a link to understanding the BNF convention as a part of BOL. Kind of like you get with a...

  • RE: Just pull back the MAX Date

    Ryan Keast (8/13/2009)


    Thanks for the reply - however I am getting the following error -

    Server: Msg 170, Level 15, State 1, Line 28

    Line 28: Incorrect syntax near '.'.

    Yep, small...

  • RE: Just pull back the MAX Date

    Try it like this:

    SELECT dbo.DW_SALESINVOICES_F.Reference AS [Sih.Reference],

    dbo.DW_SALESINVOICES_F.InvoiceDate AS [Sih.InvoiceDate],

    DATEPART(YYYY, dbo.DW_SALESINVOICES_F.InvoiceDate) AS...

  • RE: Checking for Overlap in Date Ranges

    jack ha (8/13/2009)


    This is the main definitions used in this case scenario, the tables contain more columns, but these are the columns specific to this situation

    tblBooking :

    id int

    resourceId int,...

Viewing 15 posts - 1,756 through 1,770 (of 7,636 total)