Forum Replies Created

Viewing 15 posts - 391 through 405 (of 498 total)

  • RE: join help

    Try something like this...

    

    UPDATE M

    SET Port_Desc = S.Port_Desc

    FROM master M

        JOIN ACCESS A ON M.OrderID = A.OrderID

         ...




    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.

    September 24, 2003 at 1:34 pm

    #475671

  • RE: i want to UnPublish one article from Replication

    You can't drop an article if you have any subscriptions to the publisher on Merge Replication. See sp_dropmergearticle or sp_droparticle in Books Online.

    Gary Johnson

    Microsoft Natural Language Group

    DBA, Sr. DB Engineer




    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.

    September 24, 2003 at 1:27 pm

    #475668

  • RE: Export DB to System off Network

    If that doesn't work make sure that the 2 servers have the same sort order. That is the only reason I can remember for ever having a problem restoring a...




    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.

    September 24, 2003 at 1:16 pm

    #475666

  • RE: Problem BCP (Format File) with NULL Fields

    Rather than trying a fixed length type of file why don't you try a delimited file? That way you should be able to just export the nulls and then handle...




    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.

    September 24, 2003 at 1:13 pm

    #475665

  • RE: Drop and Recreate indexes

    A generic script to do this could really be detrimental, ie: how would you go about making sure you have created the indexes for the best performance you need? This...




    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.

    September 24, 2003 at 1:01 pm

    #475664

  • RE: One backup job - two copies

    Well I don't use a maintenance plan for anything so I would do the following.

    STEP 1 (transact sql script)

    BACKUP DATABASE <DBName> TO <device name>

    ....

    STEP 2 (operating system command)

    COPY <filename> <newfilename>

    I...




    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.

    September 18, 2003 at 5:06 pm

    #474955

  • RE: Stored Procedure Replication

    I've found the best way for me to make sure that my subscribers have the correct SPs is to use a DTS Package to copy the stored procedures and functions....




    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.

    September 18, 2003 at 11:41 am

    #474921

  • RE: Linked server latency

    If you use trusted connections you could use the other type of connection. (Sorry I'm at home and don't have the code handy). I would probably go with a trusted...




    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.

    September 18, 2003 at 1:08 am

    #474811

  • RE: Linked server latency

    I would just drop the server and recreate it. I would think that would be the best route to go. 

    

    DECLARE @LinkedServerName   ...




    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.

    September 17, 2003 at 1:24 pm

    #474732

  • RE: DBCC Shrinkfile output

    Take a look at Books Online. It gives you a nice table to explain it's output.

    Gary Johnson

    Microsoft Natural Language Group

    DBA, Sr. DB Engineer




    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.

    September 17, 2003 at 1:14 pm

    #474724

  • RE: Restore

    Yikes, I'm hoping what you really want is to know what "FILE" you want to restore inside your backup file. For that you would want to use something like

    RESTORE HEADERONLY...




    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.

    September 17, 2003 at 1:10 pm

    #474722

  • RE: Inserting Leading Zeros into columns

    One note: I found an error in my sql. You need to offset the start position 1 character to the right so it should be like the following..




    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.

    September 17, 2003 at 12:57 pm

    #474717

  • RE: Object Owner

    The best practice here is to make sure that all his scripts to create the objects use the dbo.objectname. That way you will always know they are created correctly.

    I...




    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.

    September 16, 2003 at 4:57 pm

    #474526

  • RE: How would you handle this and why??? (Common Data)

    Well I'll step in a little late here...

    I would go with the single phone table but I wouldn't bother with the tbl_from field.

    As a side note: I would probably 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.

    September 16, 2003 at 4:15 pm

    #474521

  • RE: Inserting Leading Zeros into columns

    I think I would use the STUFF function. 

    

    DECLARE @Mask varchar(10)

        , @TelNumber varchar(10)

    

    SET @Mask = '0000000000'

    SET @TelNumber = '1234567'

    

    SELECT STUFF(@Mask, LEN(@Mask)...




    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.

    September 16, 2003 at 3:49 pm

    #474518

Viewing 15 posts - 391 through 405 (of 498 total)