Viewing 15 posts - 76 through 90 (of 104 total)
I called Microsoft for this. After several weeks of emails, phone calls and FTP to send our MSDB for their diagnosis, Microsoft finally admits it's a bug ! There is not...
December 23, 2004 at 12:57 pm
A low rate of Pages Faults/sec (commonly 5-10 per second) is normal. See article:
http://www.devarticles.com/c/a/SQL-Server/SQL-Server-Hardware-Tuning-and-Performance-Monitoring/2/
December 17, 2004 at 12:59 pm
see Microsoft KB article: 31453
December 17, 2004 at 12:46 pm
exec xp_cmdshell 'dtsrun /S servername /E /N"dtsname"'
December 17, 2004 at 12:38 pm
xp_msver is a system procedure that should tell you the fileversion.
December 17, 2004 at 12:34 pm
We use Novell network and SQL Mail is not compatible with Novell Network. Since you have SMTP account, WIN2K and SQL Server 2000, you can use CDOSYS to send email. It...
December 6, 2004 at 1:25 pm
You can try TSQLUnit. See link below:
December 3, 2004 at 3:07 pm
As Steve mentioned, you will need some other languages to retrieve long text because QA is not the right tool for that. If you just want to see part of...
December 3, 2004 at 1:21 pm
You're right. It will not be just one script. I only showed where you can get the information about failing jobs.
Since you mentioned your company have hundreds of servers, do you mean...
December 3, 2004 at 12:56 pm
You can use DTS to extract the running status from other servers. For each server that you want to extract, use the code below:
select
server = convert(varchar(20), @@servername),
s.job_id,
jh.step_id,...
December 3, 2004 at 9:43 am
The interval between the checkpoints is based on the number of records in the log and not time. The fact log keeps growing does not necessary triggers checkpoint. See BOL...
December 3, 2004 at 8:58 am
If SQL Server was installed with mixed authentication then you can login as domain administrator. Then change the sa password.
December 3, 2004 at 8:21 am
Changing the plan name will not affect the job because Sysdbmaintplans table uses Plan_id as pk and not plan name.
You can join Sysdbmaintplans to Sysdbmaintplan_jobs to get job_id, and if...
December 3, 2004 at 8:15 am
I don't know what your package is trying to do, but I didn't have any problem when executing within another package.
December 1, 2004 at 2:55 pm
If the database is in a production environment, you should never turn on autogrowth. The reason is simply to avoid blocking. This can occur when SQL Server is shrinking your db/log...
December 1, 2004 at 2:42 pm
Viewing 15 posts - 76 through 90 (of 104 total)