I use a script in a DTS job to do this. No way I know of in SQL to easily do it.

Try this: http://www.sqlservercentral.com/scripts/contributions/26.asp

Check the actual values in sysusers for your uid and sysobjects for the object id, then check syspermissions. See if you already ahve permissions

It could be because you are dbo.

'' isn't null.

insert mytable select null

will do it.

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...