'The following is to add a SQL Server2000 user function in the ASP, and to create a database, give him DBO permissions' *************** Note: SQL Server's verification method does not choose For Windows mode, '*************** Allow remote SQL Server connection' ****************************************** *************************** What questions are welcome to communicate with me, and will introduce some management operations for SQL Server in the future.
'Parameters: strloginname: Added login name, strPwd: Sign in password, strDbname: New Database name' function Local variable instructions: strserver: The server is located in the server name (this machine is local), STRUID: SQL administrator, 'strsapwd : SQL administrator password. The above three variables should be set according to your situation
'This function mainly invokes the system stored procedure to achieve
'Note: This function has no fault tolerance, if an error occurs, you can determine if your SQL Server is set, or the login account or the database' Call Addusertomssql ("TestLogin", "Iamhere", "db_test")
