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

It is written :

Microsft Sql Server 2000 Enterprise Edition (Release A)

Relational Database Management and Analysis System

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

hi nyulg ,

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

hi,

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

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

SaNaZ

Hi,

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

SaNaZ

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

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

Hi,

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

"select * from syslogins"

SaNaZ

Hi,

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

SaNaZ

Hi,

Tanx for quick ur reply.

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

SaNaZ

Hi,

Tanx for ur quick reply.

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

SaNaZ

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

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