Flip, you were right.

See, I wasn't expecting numbers for the postcode.

Usually it's a mix of numbers and letters. In this case it was set up differently.

But what still bothers me...

to be honest, it doesn't seem to make much sense

Conversion failed when converting the varchar value '13-10-10 21:00:00 ' to data type int.

FYI: On New years eve all of a sudden my license expired.

I ordered the Developers edition and found out that one of the sections there is an "upgrade" option. Apparently...

Way too long. That is: it could have been a lot shorter, as you can read in my previous post.

It took me about three months.

If time is critical: Focus on...

PaulB-TheOneAndOnly (8/12/2010)

My question...

Hm, Ok.

One of my Laptops has Windows 7 and SQL server 2008 Express.

So I best uninstall SQL Server 2008 Express, and after that install 2005 express.

After that I can install...

You're saying: Only upgrades of database versions are possible (2005->2008).

But what if I initially create it one 2005 and then use it one 2008. Will it automatically convert the format...

Had a good night sleep over it: Changed my mind a bit. It's really good to know that the function exists and might use it occasionally. But all together it...

Well, it looks like that this is what I'm after.

is_rolemember, ok only explicetly assigned will work, which is just fine. Definitely another step forwards.

I am going to test this tomorrow,...

Thanks,

I'm one step further now. Knowing that suser_name() returns the user that is executing the query really helps. I'm looking for a pretier solution though. I would like to know...

Grant,

First of all thanks for your reply. I hope you, or some one else can help me a bit further though.

Having said that I have to say I'm a SQL...