OK Thanks. Both of you.

Why is it better?

http://msdn.microsoft.com/en-us/library/ms130828(SQL.90).aspx

For new applications, if you're using a managed programming language such as Microsoft Visual C# .NET or Visual Basic .NET, and you need to access...

Ok thanks.

In conclusion :

- for managing sqlserver : SMO

- for query : ADO.Net with .NET Framework Data Provider for SQL Server

Hi, thank you for your answer.

Actually I want to know the difference between using SMO and ADO.Net with Native SQL Server .Net Data Provider in terms of performance (connection and...

To change a password :

Dim log As Login = myServer.Logins(myLogin)

log.ChangePassword(myPwd)

instead of

Dim log As New Login(myServer, myLogin)

log.ChangePassword(myPwd)

Of course, the login has not to be "nothing".

Right. Sorry.

I'll try tomorrow.

Thanks

What do you mean "on changing the password"?

I don't need to change it.

Thank you for your answer but I've found out!

I have to delete the schema and database users for the login first and replace Dim log As New Login(myServer, myLogin)

If myServer.Logins.Contains(myLogin)...