The error message indicate your login credential on for agent is not valid, can you check if you can login to SSMS with the login on the server where you...

Yes Gail you are right... forgot to post complete output of select @@version

Microsoft SQL Server 2005 - 9.00.1399.06 (X64) Oct 14 2005 00:35:21 Copyright (c)...

The first link below explains the code that can be used which you might be already aware,the second answer your questions.

http://www.mssqltips.com/tip.asp?tip=1112

http://my.advisor.com/doc/16671

Hope it helps 🙂

Looks like a bad design in first place , points below explain why....

First schema on Pocket PC SQL CE should have same constraints or rules and identical objects as in...

When you restored publisher data did you use the option KEEP REPLICATION to retain the settings, if not afraid you might to re-configure from scratch.

-Sat

Follow the microsoft article below to manually remove the replication

http://support.microsoft.com/kb/324401

hope it helps

-Sat:-)

- The real difference between using 32 bit vs 64 bit is memory mapping, performance wise it has more benefits as it does not use VM concept of paging as...

1. Could you please post type of packages you are running ?Is this serving a datawarehouse ? if yes how many tables does it populate ?

2. Briefly describe the...

use the COPY_ONLY option with differential and full backups so that you do not have to break existing schedules

EG

Full Backup

backup database TEST_V

to disk = 'c:\backup\test_v_full.bak'

WITH INIT,COPY_ONLY

Differential backup

backup database TEST_V

to disk...

Need to change the recovery model to FULL if you need logging to happen for all transactions and later propagated by log shipping

Refer BOL on operations which are not logged...

Completly understand your circumstances, there used to be days when working as developer making a graphics application the PM allocated less 256 GB RAM and had to work on it.

Back...

Though SQL server provides user friendly tool to create rebuilding tasks , these tasks need to be run only once a week during weekends if posssible when the load on...

Are you planning workload test or benchmark test for new application in production ?

🙂

Going by the DBCC output you mention in you post you have no indexes on the table and is usually referred to as heap. This output can be ignored for...

one way to recycle logs is scheduling the script below once a week,

Exec sp_cycle_errorlog

-:-)