Forum Replies Created

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

  • RE: Cannot login after default database is deleted

    I've had this problem. Since then I make sure that my login is ALWAYS set to default to the master database. In my case the database in question became suspect...




    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.

    March 2, 2004 at 11:51 am

    #496728

  • RE: How to query for current Recovery Model ?

    Try

    ALTER DATABASE YourDB SET RECOVERY SIMPLE




    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.

    February 26, 2004 at 9:39 am

    #495895

  • RE: select where NOT in (query with null values)

    In this situation you are better off using NOT EXISTS with a correlated subquery.




    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.

    February 25, 2004 at 12:58 pm

    #495655

  • RE: Parsing Question

    Hmmm... Upgrade to SQL2K so you can use User Defined Functions?

     

    You can take this function and modify it to suit your needs.

     

    CREATE FUNCTION...




    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.

    February 25, 2004 at 11:48 am

    #495638

  • RE: Scripting Backup, Restore and Shirink of DB

    Also, If you create a backup device on each of the machines then they can go anywhere on the machine and your TSQL becomes much easier...

    BACKUP DATABASE MyDb TO MyDevice...




    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.

    February 24, 2004 at 12:43 pm

    #495404

  • RE: How Do You Pass input parameters to a Stored Procedure Using an ASP Input Screen?

    I don't have time right now to look up the actual syntax but what you need to do is use the "Parameters" collection and add it to the command object.




    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.

    February 24, 2004 at 12:39 pm

    #495403

  • RE: remove duplicate records

    Give this a try...

    SET NOCOUNT ON

    IF EXISTS(SELECT * FROM tempdb..sysobjects WHERE id = object_id('tempdb..#Foo'))

        DROP TABLE #Foo

    CREATE TABLE #Foo

        (

        FLD1            int

        , FLD2          nvarchar(25)

        , FLD3          int

        , FLD4         ...




    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.

    February 19, 2004 at 3:15 pm

    #494808

  • RE: recursive stored procedure problem

    This seems like a great place to use a function rather than a procedure. You would then be able to eliminate the cursor and use the function call directly in...




    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.

    February 19, 2004 at 12:31 pm

    #494773

  • RE: Save Stored Proc Results

    If you want to do this you can convert your SP to a UDF that returns a table. You will then be able to do something like the following

    SELECT *...




    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.

    February 19, 2004 at 11:53 am

    #494762

  • RE: How do you debug a trigger?

    The easiest way I have found to debug a trigger is to create a simple stored procedure that will fire the trigger. Then debug the stored procedure in Query Analyzer...




    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.

    February 16, 2004 at 3:54 pm

    #494277

  • RE: Syntax to write to file

    Since you need to do this monthly the best thing to do would be to set up a DTS package and then have a SQL Job run the package once...




    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.

    February 13, 2004 at 5:24 pm

    #494068

  • RE: How To Check if Job is Running?

    Koyan,

    Try running sp_helptext sp_help_job when you are in query analyzer in the msdb database.




    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.

    February 12, 2004 at 8:48 pm

    #493929

  • RE: Parsing XML Doc into multiple tables

    I'm surprised no one has helped you out yet. I would probably go the OPENXML method. Have the XML passed into an SP as a parameter of type text or...




    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.

    February 11, 2004 at 1:35 am

    #493566

  • RE: Insert Into, Append, Temp Table ?

    This could also have been done like this...

    UPDATE Foo

    SET Keywords = Keywords + @NewKeywords

    WHERE...




    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.

    February 11, 2004 at 1:28 am

    #493564

  • RE: collation

    Fred,

    I would double check the DTS package and make sure that the transformations being done are indeed using nvarchar, nchar or ntext. Also make sure that if the package makes...




    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.

    February 11, 2004 at 1:23 am

    #493563

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