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...

Also a nice tool for this can be SQLCMD

If you have an inventory table containing all your sqlserver instance names, you can run a script and save all results,....

Create a...

barb.wendling (9/10/2008)

---

I did the same thing, edited the single line to two lines and it worked in QA. I was wondering if anyone had ideas on how this feature (GO...

Most of my jobs only have step with "Fail job if step fails", so I've only checked for the failed steps.

This version only reports if the actual job failed...

You need to use SSMS (SQL 2005) to get the result aimed for with the question.

Apparently it's SSMS that puls this trick !

Indeed With Query Analyser, you'll get the syntax...

Keep in mind SSMS has some issues with e.g. char(13) resulting in a "syntax error near ...."

And off course you'll need to have the default 'go' for batch separator...

sqlserver timestamp is "for internal use only" !!

This kind of columns will be updated by sqlserver itself with every modification to the row !!

This is not a datetime column !!!

We...

Considerations for the "autogrow" and "autoshrink" settings in SQL Server

http://support.microsoft.com/kb/315512