Problem was not resolved , was living with it but found a way to get notified when jobs executes without actually running the BAT file.

Schedule a job which has...

Hi,

Query following sys.dm_db_index_operational_stats(DB_ID(),null,null,null) function to list how many inserts, deletes and updates are done for an index. This function will give u index/table level view Formulate SQL statement...

Hi,

Can you run DBCC on MSDB database and see if you are getting any error(s)? To me is looks some kind of Corruption is system tables.

Deepak

OOPS !! It should not be here...

Hi,

DB is in Simple revoery mode, plus has enough free space on log file.

Deepak

Hi,

I can see the distributor has received the commands

select * from msdistribution_status s join msarticles a on s.article_id = a.article_id and UndelivCmdsInDistDB >

but subscriber is not...

Hi,

Installation of WMI is fine. If I make connection from VM server to itself, it works fine plus I can make a connection to all other server (physical and...

Hi,

Could you view your memory ussage :

Procedure Cache and buffer cache.

Quite often on 64 bit version, procedure cache grow (query syscacheobjects) and it cause data cache to be...

If you really wish to split to MDF into two files then you have only one solution and it has to be done on SOURCE Server/Database.

1) Add another Filegroup and...

Hi,

Check if port 25 is not blocked by anti virus program..

Get two sp (dbo.sp_help_revlogin, dbo.sp_hexadecimal)

from microsoft web site and create it on your live server's master database. run sp_help_revlogin to generate logins script.

Take the generated script and run on TEST...

Look into

MSrepl_transactions

MSrepl_commands

looking info sp_browsereplcmds

What I can think of is, you might be having two agents running one to run at scheduled time (recurring) and another in –Continuous mode.

Investigate by looking into MSdistribution_agents and...

What I can think of is, you might be having two agents running one to run at scheduled time (recurring) and another in –Continuous mode.

Investigate by looking into MSdistribution_agents and...

Hi,

It all depends on WHAT you are using Server B and C for. A solution depends on your requirements. SQL 2005 provides number of different ways (logshipping, mirroring, replication)...