Is clustered index defined on the table in question?

MJ

See what message you receive when you try to run it under management studio...

MJ

I don't think you can share the same installation folder amongst multiple instances.

Manu

Copy the t-log from the primary with norecovery (tail log) and apply to secondary. This would also leave the primary in restoring stage.

You need to setup log shipping from your...

Were you able to implement it? I need to implement the same. Please help.

Thanks in advance.

Manu

What do you see in output when you run the following query under the same database:

Select * From dbo.sysfiles

HTH!

MJ

Read http://support.microsoft.com/kb/321822 as stated in http://sqlserver-qa.net/blogs/replication/archive/2007/12/18/2974.aspx

HTH!

MJ

Is this occuring on a clustered sql server instance?

MJ

Check

http://blogs.msdn.com/dataaccess/archive/2005/08/05/448401.aspx

MJ

Rudy,

varchar(max) is in SQL 2005 so I dont think your code will work.

MJ

What values do you see under Target Server Memory and Total Server memory counters under memory manage in performance monitor?

Task manager won't show the awe mapped memory in it.

MJ

STATISTICS_NORECOMPUTE = { ON | OFF }

Specifies whether distribution statistics are recomputed. The default is OFF.

1. Backup the databases in Sql server 2000.

2. Script the logins,jobs in...

Try:

UPDATE tablename

SET columnname= REPLACE(SUBSTRING(columnname, 1, DATALENGTH(columnname)), char(13), '')

WHERE charindex(char(13) , columnname) > 0

HTH!

MJ

Followign code might help to find the object owned by him in a current database:

select * from sys.objects o join sys.schemas s

on s.schema_id=o.schema_id

and s.principal_id=user_id('Username')

or o.principal_id=user_id('Username')

HTH!

MJ

Have you checked http://blogs.msdn.com/sqlstuff/archive/2008/11/27/sql2005-hotfix-fails-with-msp-error-29512-sql-server-setup-was-unable-add-user.aspx?

HTH!

MJ