Forum Replies Created

Viewing 15 posts - 26,566 through 26,580 (of 39,793 total)

  • RE: Job runs slow when scheduled but quickly when run live

    No issues I'm aware of. You might try profiling/tracing this when it runs both ways and look for differences.

    Is security the same? What does the job do?

  • RE: The Financial Crisis

    Good thoughts and we're not buying him a car, at least not completely. We're matching what he's earned and he has the upkeep on the car. Where we live, he...

  • RE: Adventure Works database cannot connect

    You have to have SQL Server running. I do not believe Compact Edition will work.

    You can download SQL Server Express, which is the free version, if you have no other.

  • RE: Lock user SA - Server Authentication Mix

    What does release mean? Please explain what you are trying to do and what is happening in more detail.

  • RE: SQL connection issue?

    It sounds like networking. How is the app connecting? Is it trying for a named instance? Might need UDP 1434 open as well.

    Can you browse there from isqlw, click...

  • RE: Split up continuous text

    Sorry, you can also use the 2nd charindex to determine where to stop the first line in the substring function

  • RE: Split up continuous text

    charindex can take a third parameter, the location at which to start. Use the charindex from the first one as the starting point.

    SELECT line1 = substring(TXTFIELD,1,charindex(CHAR(13),TXTFIELD))

    , line2 = substring(TXTFIELD,charindex(CHAR(13),TXTFIELD),...

  • RE: Affect of changing domain on windows user accounts

    You'll need to change the logins. This data is stored in the server, so if the outside domain changes, you need to either setup trust or change the logins. You...

  • RE: Sql Server 2005 Transaction Logging

    Sorry, look for blocking. Mistyped earlier.

    Are these two dedicated servers for testing or production? Can you answer on hardware?

  • RE: Querying a sql 2K5 table

    cache? Are you clearing this before testing?

    That's not much of a difference though. Could be other factors.

  • RE: Data Ownership

    Yes, it is all humans, not just Americans. Was thinking here at home we need to lead the way on copyright. Start here and then see if others will follow...

  • RE: Data Ownership

    weird as in Steve is weird, weird Steve picked a weird topic, or it's weird I think Steve made sense 😛

    I vote for the original 14 years + 14 extended.

    We...

  • RE: Data Ownership

    The response from YouTube is well done and it outlines the issues. They need to protect themselves because of the laws. It also seems to hint to the McCain campaign...

  • RE: log for tempdb full

    This does sound strange and I don't think this happens often. It's likely an anomaly as mentioned above. If it happens again, I'd recommend calling MS, running PSdiag, and posting...

  • RE: Trigger Or Broker Services?

    If you're willing to do Broker, I'd do that. It gives you some flexibility to move the archive to another server/system easily later if need be. Harder to do that...

Viewing 15 posts - 26,566 through 26,580 (of 39,793 total)