Forum Replies Created

Viewing 15 posts - 196 through 210 (of 498 total)

  • RE: Query Returns Data From Linked Server Despite Loss of Connection?

    So more than likely TCP/IP is failing and SQL Server is using Named Pipes rather than TCP/IP. I'm pretty certain that Named Pipes is the default setting. Next time 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.

    January 22, 2004 at 8:58 pm

    #491257

  • RE: BUG Or What Am I Missing

    Bill,

    I think you need to re-read the third query.

     

    Kevin,

    I don't see why you would have a problem with your third query. I also didn't have time to create 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.

    January 22, 2004 at 8:53 pm

    #491256

  • RE: Switch Case statement in t-sql

    Actually I think your multiple IF statements are easier to read. But...

    SELECT @test1 = case convert(varchar,@a)  WHEN '0' then 'XYZ' END

    , @test2 = CASE convert(varchar,@a) WHEN '1' THEN 'abc' END

    ,...




    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 22, 2004 at 8:43 pm

    #491255

  • RE: How can I see progress within a transaction?

    Sorry I didn't respond sooner. But I was having trouble getting a cursor in the reply box when I was at work

     

    If your...




    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 22, 2004 at 8:34 pm

    #491254

  • RE: cloning a table

    I usually do all my data modeling in Erwin. It then creates a script that I modify to create the tables and triggers. Once I have run the script 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.

    January 22, 2004 at 8:20 pm

    #491253

  • RE: cloning a table

    Yogi,

    Doing the Select <fieldlist> INTO <newtblname> FROM <originaltable> will create the table for you with the same structure. It won't however create any constraints or indexes. Often times I will...




    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 22, 2004 at 4:31 pm

    #491240

  • RE: cloning a table

    As you surmised you will want to use SELECT INTO...

    SELECT

    <fieldlist>

    INTO <newtablename>

    FROM <oldtablename>




    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 22, 2004 at 3:20 pm

    #491227

  • RE: Multiple connection strings

    You're correct that a dristributed transaction could be used. So might SET XACT_ABORT ON. The biggest problem is that these transactions are based on a dynamically entered value from the...




    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 22, 2004 at 2:41 pm

    #491224

  • RE: Snapshot Replication

    My replication scenario is probably different than 99.9% of people. We use a replicated environment to act as a source control of the data in the database. We have people...




    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 22, 2004 at 12:55 pm

    #491197

  • RE: access query to sql server HELP!!!

    As Frank stated I don't think there is a LAST or FIRST but you can certainly use the ORDER BY with TOP 1

     

    select nbr, type, last(location) as Lastoflocation from loadplans...




    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 20, 2004 at 4:13 pm

    #490918

  • RE: How to pass TABLE datatype as input parameter to a stored procedure

    Dana,

    In the post that Frank points to the line that states "this is a powerful feature that you should use with care" is the one you must take to heart....




    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 20, 2004 at 4:04 pm

    #490917

  • RE: Replicating Changing Databases

    Well it will be far less work to re-initialize. You just need to make sure to sync up all your subscribers before modifying your schema and re-initializing.




    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 19, 2004 at 10:06 pm

    #490768

  • RE: Replicating Changing Databases

    Managed identities are when you have a column in the table with the identity propberty turned on but the "Not for Replication" flag set. Then when you replicate the 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.

    January 19, 2004 at 5:14 pm

    #490758

  • RE: VB Equivalent Format function for T-SQL?

    I would submit that the Format function belongs to the front end app and not in SQL. The front end application is the only app that truely knows how the...




    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 19, 2004 at 4:14 pm

    #490751

  • RE: Replicating Changing Databases

    I would have to say it all depends. If you are simply adding new tables you might be better off just adding another publication. If you can get all the...




    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 19, 2004 at 4:11 pm

    #490750

Viewing 15 posts - 196 through 210 (of 498 total)