Forum Replies Created

Viewing 15 posts - 1,126 through 1,140 (of 1,220 total)

  • RE: No database space

    When you moved the log to another drive, was it on the same server?

  • RE: Importing csv with optional quotes

    This is where a higher powered editor shows its superiority. I built a five million record file, it loaded in TextPad in a matter of seconds, it took NotePad...

  • RE: querying linked servers

    You might try an HP/UX usenet, like Google Groups. They might be able to point you in a good direction.

    Is it required that you have real-time ad hoc querying?...

  • RE: querying linked servers

    I just searched for it on Yahoo, it looks like it was (maybe still is) an HP/UX product.

    A '96 driver is unacceptably old, you're running 2000 or 2003 Server. ...

  • RE: querying linked servers

    I don't have a direct answer, but I would do two things. First, make sure you have the latest drivers to connect to AllBase. Second, check with AllBase...

  • RE: Updating tables A,B&C if duplicates in table A

    There was a Microsoft Tech Net article that had a very easy process to deal with dupes, unfortunately I can't find it and I have no other reference off-hand.

    The basic...

  • RE: Create an empty Access 97 database

    Hmmm. I would go with copying a blank. It's guaranteed to work, it will be compatible with any version of SQL ever, and you never know when something...

  • RE: Importing csv with optional quotes

    I'd consider using TextPad (www.textpad.com) to split the file via a macro then import it as two files.

    Or maybe, again using TextPad, delete the double quotes, unless you absolutely must...

  • RE: Using CREATE ALIAS and SELECT commands

    OK, I have almost zero iSeries experience, but I do have experience using DTS to access an Ingres on SCO DB. Your syntax in and of itself isn't Transact-SQL...

  • RE: Scramble Production Data for testing purposes

    Thanks for the post, Antares!  I modified it slightly to use table variables (I'm becoming a huge fan of those!) and have spread it around a bit.

    Alternatively, if you needed...

  • RE: Phoenix, Arizona area...

    My fiance lives in New Mexico, she's an astronomer/astrophysicist.  Her parents are in Oberlin and aren't in the best of health, so that's where we're to be wed.

  • RE: Phoenix, Arizona area...

    Hopefully.  I'll be back in town, I'm getting married June 4 in OH.

  • RE: Phoenix, Arizona area...

    Well, Don, I was going to suggest the AZ SQL Server site, but it's already been suggested and I know you're already on it. 🙂

    Speaking as a native and still...

  • RE: Server Rename

    Also...

    If you have a remote backup server, or any server that touches that server...

    If you have routines on other servers that copy files to your server...

     

    There's lots of little crooks...

  • RE: SP to create a BCP format file

    My database collation is SQL_Latin1_General_CP1_CI_AS.

    @@VERSION on my development server is:

    Microsoft SQL Server  2000 - 8.00.818 (Intel X86)

     May 31 2003 16:08:15

     Copyright (c) 1988-2003 Microsoft Corporation

     Standard Edition on Windows NT...

Viewing 15 posts - 1,126 through 1,140 (of 1,220 total)