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

Oh yes, SCADA stuff, not that much sqlserver performance...

just curious: Do you have "auto shrink" enabled for this database ?

(Bad practise ! If you actually need a shrink operation, you'd be better off doing it in a planned...

stop / start the instance and it will re-allocate tempdb with its prior space numbers.

(because it has to clear its work space file)