It depends on how much you want to restrict things by. DENY VIEW is only needed if you don't even want the users to know that the databases are...

That makes a lot more sense :-).

Astonishingly, I haven't seen the DATEDIFF with a zero parameter before. That's really useful.

Could be I'm just being thick (it wouldn't be the first time), but I don't follow how the DATEDIFF(hh,0,EventTime) can work.

select datediff(hh,0,'09 feb 2010 12:34:56') returns 965196

and select datediff(hh,0,'09 feb...

If you check DENY in BOL, it says

which is why changing the...

Surely we don't really need the dynamic SQL in there, we can just use:

declare @newName sysname

...

set @newName = @childname + '_' + @parentname + '_' + CAST(@soid as varchar(20)) +...

sp_spaceused returns 2 datasets with different shapes. If I'm reading BOL correctly (I haven't tested it), then in this case, INSERT INTO tries to insert both datasets into the...

I don't think that the problem is that we can't know which is correct as Adi says, but that to know which is correct, you have to have Northwind installed,...

I have to admit that even now I understand the full question, I would still have got it wrong :crying:. As Vinay says, this is very surprising behaviour.

You'll like C# 2010 then:- optional parameters!

I moved from a VB shop to a C# shop a few years ago and after the initial pain of having to learn the syntax, I'd say that there's little...

At the risk of sounding like a moaning Jock, that one's only for England and Wales. The Scottish one's http://www.scotblood.co.uk/

I'm glad you admitted this too. I always feel a bit guilty :blush: when I sneak...

To us maybe - but I'm tempted to send a link to the answer to some of our developers, who seem to be incapable of using this syntax.

I chose 1 as well.

When faced with a problem like this, my brain automatically went into "performance problem" mode, and since these generally occur with big datasets, I selected the...

I'm with David on this one. The question as written is totally ambiguous, and nvarchar or memo are equally valid answers, depending on how you parse the question.