That is something being done by the remote email systems, so it is not under your control.

You might try contacting the admins of those emails systems to try to get...

A NATURAL JOIN is an inner join where the RDBMS automatically selects the join columns based on common columns names. Some RDBMS vendors, like Oracle but not SQL Server,...

I think the simple answer is supply and demand. It is easy enough to get someone who can click around in the tools and get stuff done without doing...

Angelindiego (11/10/2008)

---

Fair enough....I would like to re-write it, but I am not sure what '=*" means??

It is in this context in my query:

select

something s

from

...

Angelindiego (11/10/2008)

---

:hehe: I am in the process of trying to make db projects in VS2005 TFS. I am getting an error in one current project that says the...

Why don't you just use the NetBackup SQL Server Agent to do your backups?

Have you checked the creation date of the table to verify that it is not being dropped and re-created, instead of truncated?

You should not use NOLOCK hints.

Look into using SNAPSHOP isolation to prevent report queries from causing blocks or being blocked by other processes.

It is usually not necessary to re-index so often. Once per week or less is probably plenty.

You really have two different issues there, database backups and index rebuilds.

You should have some kind of backup happening on a regular schedule, along with transaction log backups if the...

You might want to read through this thread:

http://www.sqlservercentral.com/Forums/Topic583474-357-1.aspx

ROBOCOPY is good for moving files across a network. It has command line switch options for automatic retry and to resume a file copy at the point of failure,...

Jean-François Bergeron (11/5/2008)

---

A trigger is good for the update statement, but I propose you use a simple default value for the new value. Here's how:

USE tempdb

GO

CREATE TABLE [dbo].[Test]

...

The "Anything that is NOT about SQL!" forum?

You could also say that is the "Quantum mechanics" or "Medieval History" forum,...

Yes, and then you get into all sorts of issues with rounding, overflow, etc. if you use integers.

declare @t table (ST datetime, ET datetime)

print 'Load Test Data'

insert into @t

select

*

from

( --Test...