Forum Replies Created

Viewing 15 posts - 1 through 15 (of 15 total)

  • RE: ORDER BY

    works fine in SQL Server 2000

    nothing indicates it's for 2005, so I should get a point. It's the first answer.

    this is now the second one in a row that...

  • RE: Storage Size

    um.....

    nvarchar(n)

    Variable-length Unicode character data of n characters. n must be a value from 1 through 4,000. Storage size, in bytes, is two times the number of characters entered. The data...

  • RE: SQL " Instances"

    no problem, I too was a newbie, not too long ago, it's amazing how fast you can learn things when the responsibility is put on your shoulders. 🙂

  • RE: SQL " Instances"

    An instance is an extra copy of the tools that run, the database controller, the SQL Server Agent, etc.

    We use one instance and the reasoning for it is security. ...

  • RE: Error 42000 on restore, SQL Server 2000

    at this point with as long ago as that was, I don't remember what I did.

    I have however discovered if you have a maintence Job set up, do not under...

  • RE: Error 42000 on restore, SQL Server 2000

    problem solved, permissions issue

  • RE: Error 42000 on restore, SQL Server 2000

    I used SQL Server Enterprise Manager, which does that for you automatically, but it still didn't work unfortunatelly.
     
    currently I'm running with an older version of the one table that was...
  • RE: Weird user authentication problem

    Wow, we were soo making it more complicated than it should have been.
     
    KISS as they say *smacks forehead*
     
    Glad it's taken care of for you!
  • RE: Weird user authentication problem

    hmmm, well if all updates are installed, I'm temporarily stumped

  • RE: Weird user authentication problem

    XP? Home Pro?

  • RE: Weird user authentication problem

    are you doing this through .net or something like that where you have a connection string?  If you are, and the database and the files are on different servers, and...
  • RE: Consecutive spaces in 1 field

    Definatelly post some samples, I can't quite understand what exactly you're trying to do.
     
    Obviously don't post the real data, as you're talking about social security numbers.
     
     
  • RE: How to write a query to combinate two tables?

    if you want that space you will have to do a cross join, with a + " " in the middle, otherwise with the statement of the person prior to...

  • RE: just swapped over to a new server. now some users cant connect

    not sure how helpful this will be, but it's not passing the username, The person may be able to connect no problem, but for some reason it's passing a NULL...

  • RE: Advertising

    being an ASP.Net developer and working for an advertising firm, I have to say that the page peel ad is not only effective, it's very inobtrusive, I have pointed to...

Viewing 15 posts - 1 through 15 (of 15 total)