Sounds to me like your manager is talking about CALs (Client Access Licences)

What happens if you use SQL 2008 compression when taking the back up. Does that reduce the database...

Question: Do you have certifications

Comment: This is rather disappointing point for me. Qualifications generally are welcome but unfortunately many people simply cheat. Companies run courses and then give questions and...

Not sure I can add much however I've just tried this on my system which is running Microsoft SQL Server 2005 - 9.00.3077.00 (X64) SP2 and Excel 2007 and I...

Did you enable the Mail Profile on the SQL Server Agent? Go to SQL Server Agent Properties and then the Alert System page and check the Mail session settings.

check the cursor definition

"SELECT inserted.co, inserted.collegecd, inserted.taxcd, inserted.

inserted.[basic],"

Do you have a trigger on the table that's trying to call the send mail stored procedure?

All months start on the first;-)

Do you mean the day of the start of the month?

Looks to me like its converting @sql from a varchar to numeric so that it can add it to the @GOAL_AMT (which is a numeric value). As you're...

Err how about Redgate's SQL Prompt. The best by far

The throwaway line "Obviously, if SQL Server is going to drive Excel, then Excel needs to be installed on the server that it's running from." has significant implications and MS...