Please run the below query and post the output here:

select log_reuse_wait_desc

from sys.databases where name = 'dbname'

No. Not necessarily. Orphaned users situation araises only if...

Is "ORDER BY C.FDDOC#, C.FDLINE" required?

What is the type of C.FDLINE?

Creating an index on C.FDDOC#, C.FDLINE should imporve the tempdb size and execution time.

You can leave the publication option as "False".

It won't break anything.

May be domain account password has "expired".

Check the account properties. Is "Password never changes" enabled?

Check the distribution agent job history.

You might find some clues there.

No. Changing the publication property does not trigger snapshot.

You need to manually start the snapshot.

It is because there is used page at the end which needs to be moved to front of the file.

Please run DBCC SHRINKFILE with NOTRUNCATE option as shown in...

Happy to know that everything fine now.

Thanks for updating.

You can use DBCC SHRINKFILE. For example:

use IEDBNew

go

dbcc shrinkfile(IEDBNew_Data, 30720) -- 30GB

No. SQL Server password is one-way encryption (Hash algorithm).

It says "Invalid object name: Sales.CreditCard".

I suspect, Data Source is pointing to wrong database.

Check the Data Source or use three part object name in the query as follows:

select * from...

No

Will the log backup taken by log shipping truncate the log file so...

Hi Neeraj,

I did not understand your questions correctly.

Yes, Setting the publication property is needed.

Regards,

Suresh

Is this database upgraded from SQL 2000 version?

What is the log file size?

Please run this query and post the results here:

use dbname

go

select name, type_desc, size/128 'Size(MB)', FILEPROPERTY(name, 'SpaceUsed') / 128...