Forum Replies Created

Viewing 15 posts - 31 through 45 (of 498 total)

  • RE: maintenance backup failing

    This sounds like the SQL Agent Login doesn't have permission to write to the remote server. Check to make sure that SQL Agent is set up with a login that...




    Gary Johnson
    Microsoft Natural Language Group
    DBA, Sr. DB Engineer

    This posting is provided "AS IS" with no warranties, and confers no rights. The opinions expressed in this post are my own and may not reflect that of my employer.

    July 7, 2004 at 11:21 am

    #513700

  • RE: Deleting with a Foreign Key

    Sounds like the perfect reason to lobby for a dev box! How are you supposed to make sure you don't cause down time if you don't have the ability to...




    Gary Johnson
    Microsoft Natural Language Group
    DBA, Sr. DB Engineer

    This posting is provided "AS IS" with no warranties, and confers no rights. The opinions expressed in this post are my own and may not reflect that of my employer.

    July 7, 2004 at 11:17 am

    #513699

  • RE: Getting rid of dynamic SQL in this stored procedure

    Instead of using Top n try setting the rowcount as follows.

    SET ROWCOUNT @NumRows

    SELECT ....

    SET ROWCOUNT 0 -- Don't forget to do this as soon as you don't want to limit...




    Gary Johnson
    Microsoft Natural Language Group
    DBA, Sr. DB Engineer

    This posting is provided "AS IS" with no warranties, and confers no rights. The opinions expressed in this post are my own and may not reflect that of my employer.

    July 7, 2004 at 11:09 am

    #513697

  • RE: Distributed queries with locking hints in SQL 2000 - Error

    You might try using the OPENQUERY syntax to do the select rather than the fully qualified syntax. I don't have the ability to test this right now as I'm at...




    Gary Johnson
    Microsoft Natural Language Group
    DBA, Sr. DB Engineer

    This posting is provided "AS IS" with no warranties, and confers no rights. The opinions expressed in this post are my own and may not reflect that of my employer.

    July 7, 2004 at 11:05 am

    #513695

  • RE: Column Collation & using the Like operand

    Yes you would still need to use the wildcard. Or you might try using the regular expression engine using a range ( LIKE ('Mu[n,ñ]oz')   Note that I don't have the ability...




    Gary Johnson
    Microsoft Natural Language Group
    DBA, Sr. DB Engineer

    This posting is provided "AS IS" with no warranties, and confers no rights. The opinions expressed in this post are my own and may not reflect that of my employer.

    July 7, 2004 at 11:02 am

    #513694

  • RE: User Defined Function vs Stored Procedure

    I'm not going to argue the political aspects of the above statements. However the following does work...

    CREATE FUNCTION f_DeleteFile(@vFileName nvarchar(528))

    RETURNS int

    AS

    BEGIN

        DECLARE @cmd...




    Gary Johnson
    Microsoft Natural Language Group
    DBA, Sr. DB Engineer

    This posting is provided "AS IS" with no warranties, and confers no rights. The opinions expressed in this post are my own and may not reflect that of my employer.

    June 29, 2004 at 2:24 pm

    #512543

  • RE: Formatting Query output column width

    Better yet hit Ctrl+D and return the results in the data grid




    Gary Johnson
    Microsoft Natural Language Group
    DBA, Sr. DB Engineer

    This posting is provided "AS IS" with no warranties, and confers no rights. The opinions expressed in this post are my own and may not reflect that of my employer.

    June 28, 2004 at 5:58 pm

    #512318

  • RE: User Defined Function vs Stored Procedure

    Well let's see. If you write it as a function then I would think you would want to write it such that only one folder at a time is deleted...

     

    You...




    Gary Johnson
    Microsoft Natural Language Group
    DBA, Sr. DB Engineer

    This posting is provided "AS IS" with no warranties, and confers no rights. The opinions expressed in this post are my own and may not reflect that of my employer.

    June 28, 2004 at 5:51 pm

    #512317

  • RE: Query Analyzer Template Question

    It looks like they are XML values that the Query Analyzer looks for when doing the "Replace Template Parameters" dialog box. My guess is that Query Analyzer looks at these...




    Gary Johnson
    Microsoft Natural Language Group
    DBA, Sr. DB Engineer

    This posting is provided "AS IS" with no warranties, and confers no rights. The opinions expressed in this post are my own and may not reflect that of my employer.

    June 28, 2004 at 5:40 pm

    #512315

  • RE: Alter Table

    You can also create multiple "Alternate" keys by using unique indexes.




    Gary Johnson
    Microsoft Natural Language Group
    DBA, Sr. DB Engineer

    This posting is provided "AS IS" with no warranties, and confers no rights. The opinions expressed in this post are my own and may not reflect that of my employer.

    June 28, 2004 at 5:30 pm

    #512311

  • RE: Avoiding cursors, but...

    Actually not odd when you think about it a little. The distinct is carried out after the concatenation is done. So you only get 1 result anyway.




    Gary Johnson
    Microsoft Natural Language Group
    DBA, Sr. DB Engineer

    This posting is provided "AS IS" with no warranties, and confers no rights. The opinions expressed in this post are my own and may not reflect that of my employer.

    June 28, 2004 at 5:25 pm

    #512307

  • RE: Sp wont delete

    What happens if you add the following before your create statement?

     

    SET QUOTED_IDENTIFIER OFF

    GO

    SET

    ANSI_NULLS OFF

    GO

    -- Put...




    Gary Johnson
    Microsoft Natural Language Group
    DBA, Sr. DB Engineer

    This posting is provided "AS IS" with no warranties, and confers no rights. The opinions expressed in this post are my own and may not reflect that of my employer.

    June 28, 2004 at 4:28 pm

    #512300

  • RE: Adding stored procs from multiple files with one statement

    JB,

    If you have Visual Studio .Net you can create a database project to hold your script files. Then you can simply right click on the folder you want to create...




    Gary Johnson
    Microsoft Natural Language Group
    DBA, Sr. DB Engineer

    This posting is provided "AS IS" with no warranties, and confers no rights. The opinions expressed in this post are my own and may not reflect that of my employer.

    June 3, 2004 at 12:23 pm

    #508885

  • RE: Handling multiple transactions

    The problem with writing this to the database in a transaction and holding the transaction open is it will effectively lock the affected tables until the transaction is commited.

    We...




    Gary Johnson
    Microsoft Natural Language Group
    DBA, Sr. DB Engineer

    This posting is provided "AS IS" with no warranties, and confers no rights. The opinions expressed in this post are my own and may not reflect that of my employer.

    June 2, 2004 at 4:17 pm

    #508745

  • RE: idea will it work

    As Antares stated you can use sp_start_job but if it is running you will get an error. I needed to do something like what you seem to want and here...




    Gary Johnson
    Microsoft Natural Language Group
    DBA, Sr. DB Engineer

    This posting is provided "AS IS" with no warranties, and confers no rights. The opinions expressed in this post are my own and may not reflect that of my employer.

    June 1, 2004 at 3:47 pm

    #508565

Viewing 15 posts - 31 through 45 (of 498 total)