Forum Replies Created

Viewing 15 posts - 166 through 180 (of 498 total)

  • RE: problem on TSQL expresion

    It seems to me that you would be better off to use a self join rather than the subselect. Since I don't know your schema this is a little hard...




    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 2, 2004 at 1:20 pm

    #492532

  • RE: Create Excel XLS from T-SQL (Append)

    anderson,

    Have you simply tried a direct insert using the OPENDATASOURCE syntax?

    INSERT INTO OPENDATASOURCE('Microsoft.Jet.OLEDB.4.0'

        ,'Data Source="<FilePath>.xls";User ID=Admin;Password=;Extended properties=Excel 8.0'

        )...Sheet1$

    (Field1, Field2)

    SELECT Field1, Field2

    FROM Foo

     




    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 2, 2004 at 12:44 pm

    #492523

  • RE: Adding Columns to table in the proper order

    First off, I've never worried about column ordering. If I need to add a column I just add it and never look back. Since all my database access is usually...




    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 2, 2004 at 11:41 am

    #492516

  • RE: How to FileCopy LAN to DMZ using SQL?

    I haven't tried this but what if you turn your insert statement into an SP on the DMZ side. Then simply pass the blob data as a parameter?




    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.

    January 28, 2004 at 4:28 pm

    #492101

  • RE: How do I show progress of backup in query analyzer message window?

    Mike,

    Great idea, unfortunately I never think about it until AFTER I start a process and by then it's too late. The other problem is you would have to actually do...




    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.

    January 28, 2004 at 4:26 pm

    #492100

  • RE: How do I show progress of backup in query analyzer message window?

    From another window in QA you should be able to run a query against the table you are updating to see watch the results change by using the NOLOCK hint....




    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.

    January 28, 2004 at 12:31 am

    #491884

  • RE: Error occuring during Restoring database

    As Alzdba stated use sp_who2 to find out who is connected. Then if you want to kick them off use KILL along with thier SPID that was in sp_who2. Just...




    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.

    January 28, 2004 at 12:26 am

    #491883

  • RE: How to FileCopy LAN to DMZ using SQL?

    Yikes, glad I'm not working in that environment!

    I would hate to have to do this but... you could write a simple VB app...




    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.

    January 28, 2004 at 12:22 am

    #491881

  • RE: Scripting ALTER TABLE - and ALTER STORED PROCEDURE

    Lars,

    I don't know of any way to script them in bulk using alter rather than create. In Query Analyzer if you right click in the object browser on Views, SPs,...




    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.

    January 28, 2004 at 12:12 am

    #491878

  • RE: Best Practice - Copy Database

    As Thomas stated I would use backup/restore to move the database. For the dts packages (I think they are actually stored in the msdb database) I would manually open them...




    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.

    January 28, 2004 at 12:01 am

    #491876

  • RE: Error, The process could not deliver update(s) at the publisher

    If you look at the merge agent history for the one that failed on you the error should still be in the history if you go to the session details....




    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.

    January 27, 2004 at 11:55 pm

    #491875

  • RE: Prompt for user input

    I concur with Frank. Also since SQL2K is the "BACK END" you should create a stored procedure that accepts parameters and then have a "FRONT END" application pass those parameters...




    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.

    January 27, 2004 at 11:49 pm

    #491874

  • RE: Next Number

    If you are doing this from VB then I would suggest calling the sp with all paramters for both records. Then have the sp do all the inserts. If it...




    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.

    January 27, 2004 at 11:43 pm

    #491873

  • RE: EXPORT TO XML

    Look for the "FOR XML" clause in SQL Books Online.

    SELECT Field1, Field2

    FROM FOO FOR XML AUTO




    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.

    January 27, 2004 at 11:54 am

    #491808

  • RE: Next Number

    As Frank stated I would use the scope_identity() function. If you are doing the inserts within a SP then this not a problem at all for multi-user scenarios. Simply insert...




    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.

    January 27, 2004 at 11:50 am

    #491807

Viewing 15 posts - 166 through 180 (of 498 total)