If you mean the SQL Server receiving the emails, check out sp_processmail or at a lower level, xp_readmail.

Another reason many of us use varchars over ints (or bigints) for non-calculated numeric values is zero-padded left hand side strings, such as '0000362136236'. While we can often control our own...

Joanie, don't let him get to you. While in fairness, Sergiy is often  (but not always) correct in his assessments, he also apparently lives in a fantasyland where everyone is...

Since your error message is in French, I'm guessing it is a localization issue which SQLH2 has had issues with in the past. The documentation that it installs should explain...

If all you want to do is copy the structure from one table to another, without any need for indexes, triggers, permissions, etc., then the easiest method is probably:

SELECT *...

While I agree that both groups performing backups can cause issues, I don't think they're using the agent to back up at 1:00. Based on the IO frozen, IO thawed...

Keep in mind that Isnumeric() returns true for many things that aren't actually a number. It even considers a "Tab" character to be valid. You can rewrite your Isnumeric() function,...

Is it possible that it's your network operations folks using a third-party backup program with a Shadow Copy option, such as Veritas Backup Exec, for instance?

The middle-ware process is generating some strange SQL. The first two tables (PersonnelTeams and PersonnelPositions) are being joined in the spot where the second and third tables are supposed to...

technicalquery, the code that does the trick you were looking for is the first line following the ORDER BY. It assigns the number "1" to a row with NULL in...

SELECT

 [ID]

 ,[Name]

 ,[SEQ]

FROM

 [Customer]

ORDER BY

 CASE WHEN [SEQ] IS NULL THEN 1 ELSE 0 END

 ,[SEQ]

One of the nice benefits of using two columns is if you store the currency types in a separate table, and store only the key from that table with your...

What you heard about it being history in 7.0 was probably the change that allowed SQL to adjust the granularity of locks as needed. While this did indeed help reduce...

...and SELECT INTO and BULK INSERT, and for that matter, your script might create TRIGGERS on a table, and probably a million other things.

Another possibility would be to grab a...

By the way, if you aren't adding indexes to the data after you are done, and if it's always rebuilt from scratch each time you run the report, you might...