"How centralized backup tools promise the moon and don't deliver"

Hmm, ok, now I see how this topic helps making friends at ISVs -...

You can use profiler from a different machine.

What's the problem? Not returning the data you expect?

Can you please post:

- Table scripts

- Sample data

- Expected results?

See http://spaghettidba.com/2015/04/24/how-to-post-a-t-sql-question-on-a-public-forum/ for directions.

Looks like a kerberos delegation issue. Try to see if the Kerberos Configuration Manager for SQL Server points out some obvious issue.

T-SQL is a horrible tool for this job and using the CPU of the SQL Server box to send pings is not a wise choice, generally speaking. Not to mention...

A relation must have a primary key. If your table does not have a primary key, then it's the physical implementation of something that doesn't exist in the relational model.

Maybe...

Weird. I don't know what to say.

DId you try to trace it with profiler (capture statement completed events and include rowcount column)?

Hahaha. Brent is always a star!

You should alse be seeing non negligible waits for PAGELATCH_UP.

Multiple data files do definitely help alleviate contention.

You can set up a trace and capture the execution of the trigger. As Sean already pointed out, it's a strange requirement. Can you expand what you're trying to accomplish?

For those trying to answer:

Sample data:

CREATE TABLE #Finanaid(

PK_ID INT NOT NULL PRIMARY KEY

, Comments VARCHAR(39)

, Desired_Output VARCHAR(2)

);

INSERT INTO #Finanaid(PK_ID,Comments,Desired_Output) VALUES (1,'Mike''s student loan 5% car payment...

Try this:

select [Week],

SUM(CASE Brand WHEN 'PRIME' THEN AWR_holiday_hours END) AS [total hours for PRIME],

SUM(CASE Brand WHEN 'PRIME' THEN Statutory_Holiday_Hours END) AS [statutory hours for PRIME],

SUM(CASE Brand WHEN 'PRIME' THEN...

Please post table scripts, sample data and expected output. See this page for instructions: http://spaghettidba.com/2015/04/24/how-to-post-a-t-sql-question-on-a-public-forum/

Use SET NOCOUNT ON in the database mail query:

Create Procedure DailyCheckList

As

SET NOCOUNT ON

Declare @EmailSub varchar(500),@dt varchar(100),@Msg varchar(max),@M varchar(max)

set @dt= convert(varchar(20),GETDATE(),107)

Set @EmailSub='Daily Checklist for '+ @dt

exec msdb..sp_send_dbmail

@Profile_name = 'XXX',

@recipients ='XXX',

@subject =@emailSub...

Errors:

Msg 207, Level 16, State 1, Line 31

Invalid column name 'saempno'.

Msg 207, Level 16, State 1, Line 31

Invalid column name 'saempno'.

Msg 207, Level 16, State 1, Line 31

Invalid column name...