Seems internally it is running the following command through a user written SP..

DBCC UPDATEUSAGE(dbname) WITH COUNT_ROWS, NO_INFOMSGS

Error:

Running Command: DBCC UPDATEUSAGE(dbname) WITH COUNT_ROWS, NO_INFOMSGS [SQLSTATE 01000] (Error 0) Msg 1205,...

This can be done by taking a synchronous backups in production and restore them to development.

Here are some links that will guide you,

http://blogs.msdn.com/b/repltalk/archive/2010/03/16/deep-dive-on-initialize-from-backup-for-transactional-replication.aspx

http://msdn.microsoft.com/en-us/library/ms147834.aspx

Does the job has multiple steps?

If Yes, you should have triggered the job using Activity monitor and its waiting for response to submit your response for start at step. In...

Try something like this.

xtable has test column with datatype nvarchar.

select test from xtable

Output:

test

1

2

3

select CONVERT (int, xtable.test) from xtable

Output:

1

2

3

The query is a SSRS generated query. And it differs from each time.

It's not using any DML statements either.

It includes select and multiple joins (Left Join). I've checked the actual...

I haven't done that before..

I'm aware that backups can't be restored to lower version and not about this.

Thanks for your inputs...

Try attaching to Higher Version of SQL server, if attaching works fix it. detach it and attach it back to SQL Server 2000.

I'm not sure, that this will work. But...

Have u found any solution on this? I'm also facing the same issue...

Did u find any answer.. I'm facing same issue.

You are not selecting the right backup..

Try adding one more data file to the database in to a new disk where you have got good amount of place.

We got the same error and the above work...

Script not working for me... 🙂

Version 2005 RTM

I figured it out, Finding MDF file and attaching it will give the information of other files as well.

Step 1:

Execute the Following in the database context where you need to pull those permissions, This will create a sp_showpermissions stored procedure.

/****** Stored Procedure dbo.sp_showpermissions v 1.0 ******/

CREATE PROCEDURE sp_showpermissions

@group...

Hey guys... The thread is easiest but restoration went like a mission....

After the Successful restoration the Customer gave me a Big Surprise Smile...

txtPost_CommentEmoticon(':w00t:');

Anyways I'm just documenting the stuff.....