Forum Replies Created

Viewing 15 posts - 31 through 45 (of 52 total)

  • RE: How can I activate Sql Server 2000 license?

    Hi all,

    At last I found the problem.On that system I installed Sql Server 2000 and uninstalled it again but It seems that there was some entries on the windows registry about...

  • RE: How can I activate Sql Server 2000 license?

    It is written :

    Microsft Sql Server 2000 Enterprise Edition (Release A)

    Relational Database Management and Analysis System

  • RE: How can I activate Sql Server 2000 license?

    K. Brian Kelley "Do the CDs have any language like "SELECT" or anything of that sort on them?"

    what do you mean by this?(would you please explain more?)

    thanks for your reply

     

  • RE: database options

    hi nyulg ,

    tanx for ur reply it works fine. But I search for a command to give...

  • RE: Backup can not be performed on this database.

    hi,

    what are the database options? Is there any specific setting for this db?

  • RE: login failure

    But I don't have any userid matches USERB in windows nt.

    SaNaZ

  • RE: Maintenance on system tables

    Hi,

    Antares686: I don't know whether this DBCC SHOWCONTIG is useful in this case or not?

    SaNaZ

  • RE: Can I schedule my db full backup to take it on tap

    Hi,

    I have read that KB Article and scheduled following job :

    BACKUP DATABASE db_name

    TO TAPE = N'\\.\TAPE0',

    TAPE = N'\\.\TAPE1',

    TAPE = N'\\.\TAPE2',

    TAPE = N'\\.\TAPE3'

    WITH DIFFERENTIAL , FORMAT

    GO

    but I still got the following...

  • RE: restore failed

    I try to restore db on another servers with Sql7.0,sp4 and also sql2k,sp2but but the same result.I have access to all tables except one.I checked that table with dbcc checktable...

  • RE: Null User

    Hi,

    the following query will show u null user that is BUILTIN\Administrators:

    "select * from syslogins"

    SaNaZ

  • RE: Enterprise manager times out while connecting

    Hi,

    Check ur Client Network Utility - Default Network Library. May be u should change it to TCP/IP.

    SaNaZ

  • RE: sysadmin

    Hi,

    Tanx for quick ur reply.

    It's "BUILTIN\Administrators".I find it with: select * from syslogins

    SaNaZ

  • RE: sysadmin

    Hi,

    Tanx for ur quick reply.

    It's "BUILTIN\Administrators".I find it with: select * from syslogins

    SaNaZ

  • RE: SQL Mail

    Hi,

    u can refer to this article for more info. "http://support.microsoft.com/default.aspx?scid=kb;EN-US;q263556" and also check ur sqlserver connection (by right clicking on sql server agent on em)

    SaNaZ

  • RE: Transaction Log Size

    Hi,

    The best way to control size of ur tran. log is : Schedule Backup job (DB Compelete backup and Trans Log Backup), But if it's already grow to very large...

Viewing 15 posts - 31 through 45 (of 52 total)