Thank you, but FYI, I am running SQL Server 2008 R2.

You are declaring @CityID as INT and then passing it a string, that is your error.

Thank you very much, bt. Yes, you are right and right!

I am very green at SQL Server Security best practice, although I understand logins, roles and authentication and so I...

Any help will be appreciated, please!

As far as possible, I keep all my primary keys as numeric.

Use indexes to maintain order on String columns.

Thanks to all those who replied.

The app is still under development, and the proposed authentication model is as follows:

1. Roles will be created in SQL Server, each with a set...

We use Windows Authentication mode. Does that simplify things or not?

Wrong approach, and it will cause unexpected problems for you later when you least need them.

First, user_id should NOT be an identity column.

Second, SQL Server will NOT allow more than...

Actually, I realised the default value solution is not for datemodified but datecreated, as the default value will only apply the first time that the record being inserted/updated has...

@michael-2: You are right, and so that solves one part of my problem, as I can now set datemodified default value to GETDATE(). Now i only have to...

Thanks, Lowell.

Thank you, all for your valuable inputs.

@Vladan: my experience in programming against SQLServer databases has been that nullable fields are not populated with default values.

@Wayne: the...

Thanks, buddy; now any idea how I can ask VB to receive any message?

For the life of me, I cannot write this down, since I have not touched T-SQL for over two years, although I have the concept in my head:

Try this:...

For the life of me, I cannot write this down, since I have not touched T-SQL for over two years, although I have the concept in my head:

Try this:...