Sorry for the late reply chaps...

I was busy loosing yet another football match with my Kids team!

Lost 7-5 last week, 6-4 this week against the same team. This is starting...

Frank,

Thanks for your answer, it confirms my impressions.

I know about degenerate dimensions but I don't think there is one in this datamart/datawarehouse regarding dates.

It's wonderful, there is lots of scope...

indeed

Looks like the moral is that we should test the return code from that procedure...

DECLARE @Return INT

EXECUTE @Return = sp_rename N'fakename', N'fakename2', 'OBJECT'

SELECT @Return

Forget @@Error!

Sorry to be a bit late but I don't see why the first one is incorrect.

Could someone explain, please? :ermm:

several rows.

Funny enough, I thought about writing to a local table too.

In theory there should be only one such request at a time but I could return some kind of...

In the end, it looks like there was a failed Security Update for Sql Server 2005 sp2 and we were lucky that there seemed to be a second set of...

For those interested (it can happen)

The solution was effectively to

- create a table in the database (that is, if you want to store the info)

- create a Package (or...

The point (tell me if I am wrong...) of QotD is to make us all think a little bit about some technical point(s).

Not to "trick" the reader...

That does not...

Sorry guys for being late but I'd really like my three points, please...

I said yes you can because it was so obviously implied that a full backup was done.

Otherwise, is...

Christian,

Is it not "part of the fun" to sometimes get it "not entirely right"?

I actually find the debate as interesting if not more interesting than the original question and/or answer.

It...

Another aspect to solve your problem is...

I warn you: you won't like this...

DOCUMENTATION!!!

I used to use a tool called Case Studio to document my database schemas.

It still exists and...

With 2005, you can use "Schemas" to achieve a little bit of that.

To a large extent, working with flat files for each object also helps a lot.

You could put these...

I think this should do

SELECT OBJECT_NAME(object_id), * FROM sys.sql_modules WHERE definition LIKE '%CURSOR%'

🙂

Cool, it's now official: I did not get insane yet... 😛

This was really driving me up the wall!

Although I don't understand why your function works the way it is, I'll...