Forum Replies Created

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

  • RE: Database Backup?

    Be aware of your recovery mode on the database that you are backing up.  Also keep in mind what the expectations are for recovery.  Is the expectation there that you...

  • RE: Error using Linked Servers

    What are you settings in MSDTC?  Have you tried allowing anonymous connections within your MSDTC properties, inbound and outbound.  I know it will not be the most secure but it...

  • RE: Error using Linked Servers

    Erich is correct.  Here is a article for the settings that he is referring to.  http://support.microsoft.com/default.aspx?scid=kb;en-us;329332

    You will or should see error 7391 in the log files.

     

  • RE: DTSRUN authentication issue

    Sorry about that.  I meant to put that in my post.  We are using 'Mixed Mode' authentication.  It is a SQL 2000 SP3a server.  When you mention a delegation issue,...

  • RE: Timestamp Column

    Thanks Remi,  I must have something wrong with my query. 

  • RE: Setup SQL Mail Agent

    c70070540 is correct.  SQLMail can be an issue, especially when work is done on your network or your mail server and the connection is interupted.  SQLMail relies on MAPI,  I have had...

  • RE: Log Shipping- Again!

    Mike does bring up a good point.  If the stand-by database is to be used for reporting then you will not be able to restore the transaction logs.  I hold...

  • RE: ALL-IN-ONE BOX

    lakusha makes some pretty vailid points.  It is entirely possible but I would not expect much out of the server when complete as far as performance goes. 

  • RE: URGENT: Error 11004 When Connected Via VPN

    Not 100% sure,  but make sure your WAN administrator is allowing traffic on Port 1434 on the firewall.

  • RE: Access to SQL to ASP

    If you already have to manage a SQL Server(s) and are familiar with administering SQL, I would migrate the db.  It also depends on how large the Access database is or...

  • RE: Upgrading 6.5

    Denis,

    Be sure that you have applied the latest service pack for SQL 6.5. I think that was 5a. Be sure to check this out. Also look in...

  • RE: Stored Procedure error

    jlaz,

    Are you by chance a administrator of the server?

    BK

  • RE: SQL server is not known to be running

    I would think it would be a time out issue. This has occurred to me when our SQL server was outside of our existing firewall. I was able...

  • RE: How to pronounce SQL

    Around here we just call SQL Server - Squirrel. The population around here have bred like rodents.

    Brian Kramer

  • RE: Orphaned Users

    Thanks Andy. I will give it a try.

    Brian

    Brian Kramer

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