I think this article can help you.

http://support.microsoft.com/kb/308518/en-us

-JP

Thanks..I tried that too but no success.Got the same error message.

-Jp

use sp_revokelogin

hth

guys...nevermind..

it was pretty simple but sometime we forget as we don't use frequently.

Thanks.

Thanks Guys.!!

Below is the excerpt from beow MS article and it conflicts with what the article you said.

http://support.microsoft.com/?scid=kb;en-us;274750&spid=2852&sid=global.

Support for operating system versions

Windows 2000 Server

Thanks Johnrowan.

Is it possible on WINDOWS 2000 SERVER edition + sql enterprise???

Can you send me the step cmd of distribution agent that is failing? Also the job history details.

Thanks.

Mubeen,

look from EM ,under Tools-replication-Configure Publishing,Subscribers and Distribution...

if sa account used on any of the tabs ,it needs to be changed there too.

HTH

-JP

Try using dbcc updateusage.

--JP

Try at support.businessobjects.com/forums/default.asp.

Goodluck.

-jp

yes . Use  dbcc dbreindex for each table .It should work in most cases.Remember tlog backup job should run frequently (e.g.every 5 mins) to have small backup files.If it don't...

I also had the same issue with one of db (~200 GB).It was genereating almost 50-60 gb tlog backup files.We work around with :

-not using checkdb or reindex jobs created...

Sorry I do not have ready script but you can try using xp_getfiledetails with xp_cmdshell and storing the info in temp table.Then you can loop thru the info and identify...

If you have only one maint plan for all db then it's difficult though not impossible but it's a pain.

I would create separate maint plan for each database and select the...