select name,dbid from sys.sysdatabases

get the DBID from above result then

select object_name(id,yourdatabase id),id from sys.sysobjects

here id=1371151930

check the name of the Object and figure out if this is a index or other...

Pl can you post the result for

dbcc page (cm_hoo_mpg, 1, 2948, 3)

If you are ready to Take a HIT at possible Data Loss (Maybe a record or someting)

use this:...

Check the DEFAULT Database Assigned to the WINdows LOGIN.

Change it to master.

Use IMPORT/EXPORT Wizard to copy Table across Servers.

Check the Indexes after you move the Tables.

Or Use Linked server like : Select * into PRODSERVER.DatabaseName.dbo.productiontable from localTablename

But using this method, the...

Is this something you need:

http://support.microsoft.com/kb/246133

select * from master..syslogins

where password is NULL

and to Filter out NT ID's

select * from master..syslogins

where password is NULL

and isNTName <>1

Mohini, Your Judgement is Correct. But what vidhya tried to Explain was:

Transactional replication is based upon reading the transaction log of an originating server.

Transactional replication is often used for high...

Which SQL Server Edition/Version are you on?

What are your PRocessors like? and How Many?

MEMORY?

HDD:: how much space in each partition?List all partitions

List Databases and Sizes

Are there any other applications Running...

did you rename the server after installation.

Can you run DBCC CHECKDB (dbname) WITH ALL_ERRORMSGS, NO_INFOMSGS and post the RESULT here..

did you change the Database compatibility level to 90 after the migration.

and also did you check for orphaned logins in the database.

Use databasename

sp_change_users_login 'REPORT'

to update the login info:

sp_change_users_login 'UPDATE_ONE',loginname','loginname'

did...

Try Creating a Table Variable and get the output on the Table Variable.

OUTPUT inserted.Id into @tablevariable.

change your compatibility level to 90(SQL 2005) and

Always after and upgrade run the following statements.

DBCC UPDATEUSAGE (aspnetdb) and DBCC CHECKDB(dbname). This makes sure nothing went/is wrong in the database....

Check this out:

http://support.microsoft.com/kb/896556 and

http://forums.databasejournal.com/archive/index.php/t-9758.html OR

http://support.microsoft.com/kb/827714

Yes, the solutions by AART is the way to go..