Forum Replies Created

Viewing 15 posts - 166 through 180 (of 181 total)

  • RE: Can't connect to SQL

    Here is the entire entry in the log:

    2003-03-04 08:42:41.04 ods Error: 17826, Severity: 18, State: 1

    2003-03-04 08:42:41.04 ods Could not...

  • RE: Can't connect to SQL

    Here is another scenario related to SQL Server 7. A colleague working for some other company ran into a similar problem, and I have been trying to help him...

  • RE: monitor

    Page69,

    I think you are probably refering to something else. Replication monitor will only be displayed in EM when the you have successfully configured a distributor on the server. Racosta...

  • RE: Copy DB to another DB on the same Server?

    DTS is your best and most simple option

  • RE: losing primary key for snapshot publication

    There is also a way in EM to make sure primary keys are replicated. When you specify articles to be published, you can go to the properties of each...

  • RE: books online

    strick9,

    Where can I get these downloadable updates? Can you please send the URL for SQL Server 7.

    Thanks

  • RE: books online

    Matt, I think you need to looks at the basics of SQL before you start digging into perf counters etc. Start with things like Logical and Physical Database Architecture...

  • RE: the sql learning method

    I was pushed into a SQL Server DBA position when we migrated our DBs to SQL Server from Oracle about 2 years ago. The company did not have money...

  • RE: Backup time increased

    I have used SQLLITE Speed and am really impressed with it - don't know if we will get the nod to purchase a licence at this moment, but I think...

  • RE: Backup time increased

    I think its a good practice to backup to local disk first and then schedule a backup to tape later

  • RE: How To Copy DB Between Servers

    If the DB is small in size, prob easiest to perform a network backup to the server you want to restore on and then restore the DB there.

  • RE: SQL Server VS. Oracle

    Through experience with both I feel that Oracle is more forgiving to a poorly designed DB.

  • RE: Transaction logs increased up to 16 GB

    use DB detach and then DB attach to free up the log enteries in the trans log. Take a full backup before and after this.

  • RE: Installing SQL Server 7.0

    Brian, you are correct. You cannot install SQL Server 7.0 as well as apply SP's via TS Client.

  • RE: syntax error

    This also works:

    sp_dboption 'Northwind','single user', 'on'

Viewing 15 posts - 166 through 180 (of 181 total)