To total the sum of all columns together:

SELECT IntrestMark, SUM(col1 + col2 + col3 + col4 + col5 + col6) AS [Total]
  FROM mytable
 GROUP BY IntrestMark

(See...

First, your current arrangement is actually part of a recommended practice:  put only system tables on the [PRIMARY] group, then create one or more additional filegroups for data tables and...

Take a look at the sp_spaceused_report procedure posted in message

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=8&messageid=265290#bm265442

You can change the final SELECT statement to sum up the #Res table for your result.

You can also remove all...

Reports are delivered either

A: Upon user request, to a browser

B: On a schedule to an email address or network location (or other if you've rolled your own extension), or

C:...

1. The message about the semicolon is part of the answer:

<...>

SET @user-id = 'EC3C39B4-0E80-4EE9-A235-364A17B3A92C';

WITH Arbo...

Outlook 2003 does not install MAPI.  You will need to install an older version of Outlook.

I keep a CD with Outlook97 on it just to install MAPI on SQL Servers.

#!&^&**$!!!...

The prep guide at http://www.microsoft.com/learning/exams/70-431.asp covers the list of topics to understand.  I just grabbed that list and went through BOL to pick up the new stuff and the things...

sp_MSforeachtable @command1="select count(*), '?' from ?"

I was a few months ago

Note that if the value you are testing is blank or just spaces, then either LTRIM or RTRIM will reduce it to a zero-length string.  You don't need to do...

Have you started the service with trace flag 1400?

See: http://support.microsoft.com/default.aspx?scid=kb;en-us;907741

[Quoting the above article]

Currently, Microsoft support policies do not apply to the database mirroring feature in Microsoft SQL Server 2005.

By default,...

Placing the "$" character in front of a formatted number makes it a character value, which is not a number, and cannot be stored as a number.

Formatting rules are not...

#include usual and customary warnings about using undocumented features (test outside of production, have good backups, etc.)

...that being said...

There is an undocumented trace flag that will disable lock escalation.  I...

I've used that technique - performing an XSLT translation on data to convert it to an Updategram document - several times to deal with stuffing data from several different sources...

> I’ve noticed in the search option for adding logins the only object types for logins that are available are "users", "groups" and “Built-in security...