Forum Replies Created

Viewing 15 posts - 1,666 through 1,680 (of 2,436 total)

  • RE: BCP Timeout problems

    A good 'rule of thumb' is to execute the BCP on the database server to a local file then utilize XCOPY or some other utility to get the results where...

    RegardsRudy KomacsarSenior Database Administrator"Ave Caesar! - Morituri te salutamus."

  • RE: Attaching a database

    All good posts for solutions ... but ... what caused them transaction log to fill in the first place ? I've never run into a situation where you could not...

    RegardsRudy KomacsarSenior Database Administrator"Ave Caesar! - Morituri te salutamus."

  • RE: API Cursors

    SET RANT_MODE ON

    It's PeopleSoft (or as I used to call it PeopleS_it) .. I worked on a number of of their systems. You've got to use People  'this' and People...

    RegardsRudy KomacsarSenior Database Administrator"Ave Caesar! - Morituri te salutamus."

  • RE: Backup large Database to networkshare

    Carl, in our case we needed to set both the NIC and the switch port (now it is the site standard).

    RegardsRudy KomacsarSenior Database Administrator"Ave Caesar! - Morituri te salutamus."

  • RE: Problems with Sophos installing MSDE

    I remember the filename now (thanks Steve) ... It's sqlstpx.log where x is a number starting with zero and incremented for each failure.

    I also remember an issue with file permissions...

    RegardsRudy KomacsarSenior Database Administrator"Ave Caesar! - Morituri te salutamus."

  • RE: Backup large Database to networkshare

    We have just gone through and performed the same thing on all of our servers - changed the NIC cards to 100 Mb Full Duplex. The remaining piece is to...

    RegardsRudy KomacsarSenior Database Administrator"Ave Caesar! - Morituri te salutamus."

  • RE: Connection pool size

    A SQL Server can choke on a 20 conenction load with a single processor (let alone 200 !). In this day and age hardware is cheap. Our minimum server spec...

    RegardsRudy KomacsarSenior Database Administrator"Ave Caesar! - Morituri te salutamus."

  • RE: Backup large Database to networkshare

    Out of your options a NAS device is the best. However you are still exposed to the perils of a network. Issues such as bandwidth, latency and load will affect you....

    RegardsRudy KomacsarSenior Database Administrator"Ave Caesar! - Morituri te salutamus."

  • RE: Problems with Sophos installing MSDE

    You get the error: "This installation is forbidden by system policy. Contact your system administrator."

    Before doing anything I'd talk to the Windows Admins and see if they are applying/updating AD...

    RegardsRudy KomacsarSenior Database Administrator"Ave Caesar! - Morituri te salutamus."

  • RE: New install select collation

    AM I missing something ? An attended installtion does not offer the collation that you need but an unattended installation does ? If this is the case is there any...

    RegardsRudy KomacsarSenior Database Administrator"Ave Caesar! - Morituri te salutamus."

  • RE: Active directory and sql server integration

    Sorry folks ...

    When will this [

    was meant to be

    When will this multiple posting lunatic END and just post once.

    RegardsRudy KomacsarSenior Database Administrator"Ave Caesar! - Morituri te salutamus."

  • RE: Active directory and sql server integration

    This is a duplicate posting of:

     

    http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=92&messageid=238329

     

    When will this [

    RegardsRudy KomacsarSenior Database Administrator"Ave Caesar! - Morituri te salutamus."

  • RE: Help AD & SQL 2K

    Is the computer in the domain ? Is your account a domain account ? Does the domain account have the correct permissions ? Are there any corresponding entries in the...

    RegardsRudy KomacsarSenior Database Administrator"Ave Caesar! - Morituri te salutamus."

  • RE: Copy job get failed when we copy a backup file to network drive

    Norton (like most anti-virus software) has an 'exclusions' list (actually it's a 'mask' - e.g. *.BAK, *.TRN might have to be added).

    RegardsRudy KomacsarSenior Database Administrator"Ave Caesar! - Morituri te salutamus."

  • RE: New install select collation

    This might be worth investing in the time (and money) for a call to MS PSS.

    RegardsRudy KomacsarSenior Database Administrator"Ave Caesar! - Morituri te salutamus."

Viewing 15 posts - 1,666 through 1,680 (of 2,436 total)