Well, if it is poor, missing, or incomplete there really isn't much reason to read it, is there. :w00t:

If you don't know the trigger is there, it is probably due to poor, missing, or incomplete application/database documentation.

Sounds like an auditing firm making a determination not specified in the standard because they think it best. If it isn't in the actual standard how can the justify...

Hard to say since we can't see what you see. There really isn't enough information to make any kind of informed response.

Bit more to think about:

-- datetime data type

declare @DateVal datetime;

set dateformat mdy;

set @DateVal = '2013-02-14';

select @DateVal;

go

declare @DateVal datetime;

set dateformat dmy;

set @DateVal = '2013-02-14';

select @DateVal;

go

declare @DateVal datetime;

set dateformat mdy;

set @DateVal =...

Explicitly declare each column in the select lists and for those columns that are defined as chaacter values include COLLATION and which collation you want to use for the comparision....

Really? Answer to what?

42

Eric M Russell (2/18/2013)

---

Lynn Pettis (2/18/2013)

---

Eric M Russell (2/18/2013)

---

SQL Server doesn't store date/times values in a format, it's just a typed integer.

However, SET DATEFORMAT setting influences how date/time values...

Check out this site for a set of excellent procedures: http://ola.hallengren.com/.

You can use the Windows Task Scheduler to run these using SQLCMD.

Confused. Did it help or not?

If not, what is the problem. I am not a...

Eric M Russell (2/18/2013)

---

SQL Server doesn't store date/times values in a format, it's just a typed integer.

However, SET DATEFORMAT setting influences how date/time values are displayed in a resultset...

gh449 (2/18/2013)

---

Hello,

I need to write a few lines of SQL that will suppress one file from another. I work in foxpro 2.6 for DOS (i know its old but it...

No additional licensing is needed to use mirroring unless you are using the mirror databases for offloading reporting using database snapshots. In that case the server hosting the mirror...

It could also be the job(s) are being run manually. What does the job log tell you?