Forum Replies Created

Viewing 15 posts - 3,976 through 3,990 (of 9,712 total)

  • RE: Remotely Connect and Query a db.

    mike 61998 (9/11/2012)


    One is a workstation connected to the internet using Comcast (not on a windows domain), and the other is a workstation on a bellsouth connection (not on windows...

  • RE: Installing SQL SERVER 2012 Developer Edition On Top of 2005 Editioon

    jrichards54 (9/11/2012)


    Now I am ready for the sixth install but I would like to install only the Database Service and since I am using Visual Studio 2005 I believe that...

  • RE: Remotely Connect and Query a db.

    mike 61998 (9/11/2012)


    They are not on the same network.

    This sounds like it's a Trust issue. Talk to your network / Active Directory admin and see if they can set up...

  • RE: Reformat Phone Number

    Eugene Elutin (9/11/2012)


    The best and easiest would be creating CLR function which will remove all non-digits from string using RegEx.Replace.

    Forgive me a moment, Eugene, while I poo-poo your "easiest" comment....

  • RE: Reformat Phone Number

    REPLACE() would take care of your spaces and hashes. You could also use the LEN() function to compare the data to what length the number should be in order to...

  • RE: how to best summarize data

    Just a warning, Christina, if your data is set up the way I think it is, t.brown's solution will not immediately give you the answer you're looking for. You will...

  • RE: Upgrade to 2008R Collation

    As it is a side-by-side migration, what you need to do is start testing your data to make sure the collation is compatable and translatable before the migration starts.

    You could...

  • RE: UNION Help

    Eugene Elutin (9/11/2012)


    Actually the attribute splitting may not be a flaw, but done on purpose. One of the common places where you can see this kind of picture is data...

  • RE: Remotely Connect and Query a db.

    Did you create a Linked Server object for which to pass through credentials?

    Are the credentials you are using for one server valid on another, or can those credentials at least...

  • RE: display table in hierarcies

    Glad I could help.

  • RE: UNION Help

    Celko,

    Cute joke.

    Now do you actually have advice that is any different from that which was already offered?

  • RE: display table in hierarcies

    The first thing I advise is taking a look at what you actually want mapped. It doesn't make sense to me.

    You want app3 stuff mapped to app4?

    The second thing I...

  • RE: Are the posted questions getting worse?

    Stefan Krzywicki (9/11/2012)


    Hey Brandie, do you think you're going to WorldCon the next few years? Next year is in San Antonio and the year after is London. I was thinking...

  • RE: Are the posted questions getting worse?

    It's nice to know that every once in a blue moon, I actually do have a clue and can answer some SQL Server questions here without making a total idiot...

  • RE: Maintenance plan versus 3rd party software

    The biggest issue with third party backup tools is that if the company suddenly goes out of business, or you lose your license, you could loose the ability to restore...

Viewing 15 posts - 3,976 through 3,990 (of 9,712 total)