ASE code was fine, the procedures had to be migrated and the code changed:

They were way too complex to accomplish this with the Migration Assistant, and so the way was...

Dear all,

as Phil and Jonathan gave me valuable input I'll correct my conclusion here:

1. I understand that due to deferred name resolution the temp table is not evaluated  when it...

• This reply was modified 6 months, 1 week ago by  Arthur Kirchner.

EDIT - see my corrected conclusion below

• This reply was modified 6 months, 1 week ago by  Arthur Kirchner. Reason: sum up of correct answer at the end of the threat

Thanks a ton!

I was shocked to learn that this table still exists in SQL Server, and nobody is talking about it ^^.

It seems to be around since the 80s as it is...

Thank you, that reminds me of the tricks for being able to view youtube videos in your country you're not supposed to, it's so long ago I had time for...

I remember having a lot of problems when the default collation changed from 2005 to 2008.

Many of them were solved by using COLLATE DATABASE_DEFAULT. Just a hint, not more 😉

--oops, I overlooked the second page of post, sorry

Thank you Dwain,

yep, I hoped someone could explain the implicit conversion rules...

.... and the ORDER BY 1 means ORDER BY the first column expression the SELECT Statement.

Just adding this because I didn't know that not a long while ago...

Hi Petr,

that worked for me, too, thx.

... after I closed the excel file that is... 🙂

It's February 2013 and there are still no courses out for 2012 on Self Test Software.

It's a pity, because they were really good for preparing for 40-433 and 40-451.

Hi Steve,

thanks a lot for your work!

One tiny addition: You could update the link list here http://www.sqlservercentral.com/articles/Build+List/71065/.

Afterwards it shouldn't change for the next two years I guess.

Hmm, maybe that was a misunderstanding: I want to reduce the time it takes to see the History Log of the Maintenance Plan, has nothing to do with backups or...

Thank you for the fast reply,

no, I didn't, because I don't want to touch the history, if it is possible.

I know, it sounds like wanting to eat the cake and...