Do this using query analyzer, it will only change the datatype for the table for which you will run ALTER statement.

MJ

Is your issue resolved by taking DAC connection?

MJ

Try this from Lowell:

--##################################################################################################

--Purpose: Load All The existing .trc files on a given server to a tracetable so they can be queried.

--Created By Lowell SQLServerCentral.com

--##################################################################################################

-- declare variables

DECLARE

@rowid...

Is it resolved now?

MJ

What entry do you see in sys.servers for this server instance?

MJ

Is this job making use of any word applications based objects?

If yes, then check-->http://kbalertz.com/257757/Considerations-Automation-Office.aspx else ignore.

MJ

As suggested by John go thru this(http://support.microsoft.com/kb/904804) KB article and you will get your answer.

This error message indicates that the contiguous virtual memory is either insufficient or is too fragmented...

Have you selected the option "Include Referential Integrity" under Right click Publication-->Articles-->Objects(Right hand side) ellipse button-- (bottom window)?

Select that option and u will get primary key replicated too.

HTH!

MJ

Chk this-->http://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx?FeedbackID=352106

MJ

Do this at ur own risk:-

There IS a way though. You can put the SERVER into single-user mode, then connect with the DAC and you can then update the system...

Thanks a lot for sharing the link.

MJ

Start time is the same as tempdb database creation date. Stop time-->you can get that from sql error logs. To get this information in a table use the method mentioned...

How frequently indexes are getting rebuilt? Too many updates/inserts could be the reason for fragmentation too.

MJ

Check under event viewer logs and installation log files at C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files.

MJ

It seems to be used for internal use only.

http://msdn.microsoft.com/en-us/library/aa260585(SQL.80).aspx

srvstatus smallint For internal use only.

MJ