Viewing 15 posts - 61 through 75 (of 101 total)
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...
February 15, 2010 at 4:31 am
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)...
August 11, 2009 at 5:29 am
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 🙂
May 28, 2009 at 6:45 am
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...
May 28, 2009 at 6:38 am
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
May 28, 2009 at 6:24 am
Follow the microsoft article below to manually remove the replication
http://support.microsoft.com/kb/324401
hope it helps
-Sat:-)
May 26, 2009 at 9:04 am
- 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...
May 26, 2009 at 8:59 am
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...
May 24, 2009 at 11:31 pm
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...
May 14, 2009 at 5:34 am
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...
May 13, 2009 at 5:00 am
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...
May 13, 2009 at 4:50 am
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...
May 11, 2009 at 3:48 am
Are you planning workload test or benchmark test for new application in production ?
🙂
May 11, 2009 at 3:34 am
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...
May 11, 2009 at 3:29 am
one way to recycle logs is scheduling the script below once a week,
Exec sp_cycle_errorlog
-:-)
May 8, 2009 at 2:23 am
Viewing 15 posts - 61 through 75 (of 101 total)