The mail server here (Ssc.com) is W2K3 with SQL Sp3 on it. We're getting ready to install a 2nd server to handle the load with W2K3/SQL SP3 as well. Not...

A little off topic, but it was funny when I heard it. Glad you guys like it.

You need to call sp_start_job, but only the job owner can call this for a job.

I'd say dual, but you'd really want to install on both, run some benchmark, like DBHammer (SQL2K resource kit) or MS Web App Stress Tool) and see what happens.

I do not think you want a trigger to spawn a DTS triggers are part of the transaction and the DTS make take some time, which would slow down the...

If the optimizer thinks that a large number of rows will be returned, then it may force a table scan.

CREATE PROCEDURE dbo.procApptOVDetailUpdate (@nApptID int, @reason varchar, @cxrtime int)

AS

 update ovd

    set ovd.apptreasoncode = @reason SELECT

       , cxrtime = @cxrtime

 FROM ApptOVDetail ovd

 WHERE ovd.AppointmentID=@nApptID

return

If you want to run jobs owned by someone else, then I believe you need sysadmin permissions. From BOL (sp_startjob)

Execute permissions default to the public role in the msdb database....

I believe that growth is a logged event and if the log is full, then you need to clear space before it can grow. Running a "backup transaction with no_log"...

I'd have to agree that not having anyone administer the SQL Server is a recipe for disaster. Despite it being easy to do, or relatively easy, you still need a...

This works for me:

create table MyTest

( levelno int

 , custno varchar(20)

 , part_seq int

)

go

insert MyTest select 1, 'A 251 620 01 87', 1

insert MyTest select 2, 'A 251 620 01 87', 2

insert MyTest...

Also the resource kit is supposed to ahve a stress utility, DB Hammer.

Are you looking to stress SQL only or include the application? Not sure that SQL Server stress along tells you much other than a benchmark for different SQL hardware.

I've used Loadrunner,...

Do you mean it actually grows in MB or that the setting gets changed?

Have not gone through this for SQL Server, but that's interesting. Here's the way I did it at a small shop: http://www.sqlservercentral.com/columnists/sjones/vcspart1.asp

http://www.sqlservercentral.com/columnists/sjones/vcspart2.asp

http://www.sqlservercentral.com/columnists/sjones/vcspart3.asp

http://www.sqlservercentral.com/columnists/sjones/vcspart4.asp

I'll ping someone in our...