Don't you just love the way a simple question - with some context - with the possibility of being ambiguous triggers a bunch of discussions.

"Make it fool proof and they...

I just wonder:

- how many figures behind the decimal point is their working unit :w00t:

- do they have ctrl+alt+del :hehe:

- do they run on alpha software or RC-1 😀

- finally...

Lynn Pettis (9/11/2008)

---

Unfortunately (or not), I disagree. By specifying SQL Server 2005 in the question, that should automatically eliminate SQL Server 2000 tools from the equation. In my...

Emilio.Mendoza (9/10/2008)

---

Thanks for the reply I've already use those options, probably I didn't explain myself correctly, I need to have the DBO name and the login 'NT AUTHORITY\NETWORK SERVICE' I...

... I don't think that the database should be enforcing the front-end validations, since from a performance standpoint, this would initiate extra DB communication and network traffic if, for example,...

David Paskiet (9/10/2008)

---

UNfortunately, I am trying for the quick and lazy solution. Coding another solution is not my idea of fun to rehash work alreayd done. :: sigh...

1) you could install a connectivity client (but you'll have to check if that contains OSQL)

2) as a workaround, you could "remote submit" the bat file using sysinternals psexec.

1) what's the info in the job step history.

2) your first step should work, you'll need to add ", replace" if you want to overwrite the current db !

3) you...

how about...

declare @startdate datetime, @enddate datetime

SELECT @startdate = dateadd(dd, (-6 - DATEPART (dw, getdate())),DATEADD(dd,DATEDIFF(dd,0,getdate()),0))

, @enddate = DATEADD(dd,DATEDIFF(dd,0,getdate())+ 1 ,0)

print convert(varchar(26), @startdate,121)

select yourcolumn list

from yourtable

where thedatetimecolumn between...

proving once again one should provide index on a FK column,

unless actually tested that it hurts that particular system.

Well, if there is no "default" value that can be justified at logical database schema design, there will be no default value at physical fase.

Having a column without a default...

good gut feeling :w00t:

It depends what's the definition for the particular view.

e.g.

[Code]

Create view myview

as

select col1, col2

from mytable

where thekey = 15

go

Select * from myview

[/code]

Will most likely not do as...

e.g.

This one will map sqlaccount sa to the dbo user of your db.

Check BOL

exec sp_changedbowner 'sa', true

you could just embed your primary query ...

Select nestsel.*,

mkt_rate = dbo.get_mkt_rate( ,...),

pipsaway = dbo.Calc_Pips_Away(nestsel.ticket,

...

just my 2ct.

You could also consider a constraint to be meta data for your database. This way it needs to be part of your system.

Having it as a constraint will...