Forum Replies Created

Viewing 15 posts - 26,731 through 26,745 (of 39,961 total)

  • RE: who/what should own the db_owner schema?

    I'd think it would be the same, but I've never messed with it enough to know if it really matters.

  • RE: DB Size Growing High

    I agree with Gail. You really want to back up the log every hour or so. I bet if you told you boss that if we had an issue at...

  • RE: How about a Subscribe To option when adding an article to your briefcase?

    It's not a bad idea, especially if you want to keep track of discussion on it. We have adding a discussion to the briefcase on the list, but it's a...

  • 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...

Viewing 15 posts - 26,731 through 26,745 (of 39,961 total)