the first thing that pops in my head is can the database server relay email through the mail server (assuming you are using exchange).

It looks like all that this will ever return is BILLINGHC, it will never get to the else statment.

Please give me an example of what the data is and what...

Type in sp_trace_create on the index tab of books online. That will give you the syntax.

If you do not have access let me know.

Just wondering. You are using xp_cmdshell and...

try running it as - assuming that the result from the subquery is numeric.

DECLARE @result numeric (18,0)

SET @result = (select top 1 id from DVD_I_Have where Userid=78 and DVDID=8...

Schedule a SQL job that executes every day

sp_trace_create  which has a stop time parameter. Look in Books online for syntax (books online comes with SQL server standard install)

Microsoft suggests that you wait until the service pack is provided. You should only apply a hot fix if it matches a current condition you have. Hot fixes are not...

Lowell - There is actually a known issue with the connection breaking. many times caused by a cursor but other things too. It will break your connection over and over...

Is there more then 1 ID that matches the where clause in the sub query?

I ask because I am wondering why you have such a complicated script for what...

Are you using sp_executeSql? To work correctly as an order by clause you may have to. Useing sp_executeSql should let you make it as dynamic as you want it.

It could be but to be safe you could run

SELECT * FROM sysobjects where ID = 99

Which should give you the object that is corrupted per your maintenance logs.

Then you...

INSTEAD of

select PatientID, combine_cptcode(PatientID) from   CPTCodeop

PUT

select PatientID, dbo.combine_cptcode(PatientID) from   CPTCodeop

NOTE the dbo.

If setup to do so the data file will grow with out a scheduled alter db cmd.

IF you do need to set the auto file growth (you should) then Open...

Steve you are correct - you need to assign a drive letter to connect the SAN to the server - or atleast to have it accessable

you would be better off changing the sql jobs to not look at a drive letter. try creating a share on a drive use the $ after the share so...

--Just to get your example data in a table --Start

CREATE TABLE #A

 (A Varchar (1)

 ,B Varchar (1)

 ,C Varchar (1)

 ,D Varchar (20))

INSERT INTO #A

 (A, B, C, D)

VALUES('A', 'B', 'C', 'CUST_1 SEQ1')

INSERT INTO #A

 (A, B, C, D)

VALUES('A',...