Guys,

If we do not have the Microsoft Excel installed on the server where the template (created on my local machine with MS Excel installed) resides, will this approach still work?

Thanks...

I was not clear enough. Yes, everything is totally identical. And the new server does not share anything with any other servers.

I did rebuild the index, so I...

Matt,

I will try that.

Thank you!

Guys,

I digged deeper and found out that there is 1 table which is causing this confusion. When I run EXEC sp_spaceused 'Audit', I get:

Name: Audit

Rows: 12228956

Reserved: 24440904 KB

Data: 3768904...

Mani,

Thank you for the link. I heard that it is not advisable to shrink the database file. Also, shouldn't I have free space before I can shrink it?...

Adam,

Thank you for the query. I ran it and it shows that only 28MB are unused and the other 26+GB are used. So I am guessing it...

Since COLLATION is column specific, is it even possible to have a different collation per language, if the same column is used by all?

Thank you!

Thank you for the information.

So does this mean that I don't need to worry about COLLATION in general? What does that affect?

Thanks a lot for the information!

Got it.

Thank you for the advice!

Thank you all for the suggestions.

I ran the full report today (the full report consists of about 15 of such types of queries).

It took about 1 hour to complete. ...

The problem got solved by clearing the log as stated here: http://www.thescripts.com/forum/thread79839.html

and then deleting and re-adding the subscribers ...

I actually found out that this can be done by using: DBCC DBREINDEX

Thanks

The following stored procedures might come in handy:

sp_start_job

sp_stop_job

sp_disable_job

The system tables (e.g. sysjobs, sysjobschedules) should be able to tell when and if the job finished.

Is the database following the Full Recovery model and is the transaction log backed up regularly (e.g. every 15 mins)?