it worked perfectly in my vb code though.

Thank you very much for sharing your knowledge with a pesky newbie such as myself.

Can it be done at all with a T-SQL Statement instead of a stored procedure? Just asking.

How do I mark this as solved?

Thank you very much I found my solution.

I need the T-SQL Statement or a stored procedure that maps a login to a database.

No I actually want to map a login that I created to a database

It is possible to map a Login to a Database in the Management Studio by right clicking on the Login and then selecting properties, then in the left Menu "Select...

No it is not a duplicate post it is a different problem. In my first post there was a syntax error in the create login statement in my second post...

Thank you worked.