- Moderator
- #1
I'm trying to write a little script that will create users on our web page from our accounting software.
The concept is that the salesperson would click on a button that would create the web account, using the email as the user ID, and a randomly-generated password that would be changed the first time they log on.
The issue is that the SQL server that has the stored procedures to create the accounts is NOT on the same server that the accounting software is running.
So the question is this: How can I call a stored procedure on a different server and pass parameters, preferably as a command line?
Something like "SQLCMD EXEC Server.Database.dbo.StoredProcedure UserName,Password,Etc...."
Any thoughts? Or am I approaching this incorrectly?
The button in our accounting software would essentially call a VBScript with parameters from the User Account screen passed to it.
Just my 2¢
"What the captain doesn't realize is that we've secretly replaced his Dilithium Crystals with new Folger's Crystals."
--Greg
The concept is that the salesperson would click on a button that would create the web account, using the email as the user ID, and a randomly-generated password that would be changed the first time they log on.
The issue is that the SQL server that has the stored procedures to create the accounts is NOT on the same server that the accounting software is running.
So the question is this: How can I call a stored procedure on a different server and pass parameters, preferably as a command line?
Something like "SQLCMD EXEC Server.Database.dbo.StoredProcedure UserName,Password,Etc...."
Any thoughts? Or am I approaching this incorrectly?
The button in our accounting software would essentially call a VBScript with parameters from the User Account screen passed to it.
Just my 2¢
"What the captain doesn't realize is that we've secretly replaced his Dilithium Crystals with new Folger's Crystals."
--Greg
