Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Goldmine Open 1

Status
Not open for further replies.

tomknoblaugh

IS-IT--Management
Apr 24, 2008
3
US
Hello All,

I recently downloaded some SQL stored procedures for Goldmine CRM. After downloading, I installed them by running them inside Query Analyzer. Most of them would not run from a straight copy and paste, I had to change several double quotes to single quotes to get them to run without error. Once they were all run and I could see they were all available as stored procedures, I attempted to run them but continually get errors.

Has anyone had experience using the SQL stored procedures released by Frontrange?

Thanks!
 
first of all, running them right in SQL Query manager is not the simplest way to get them installed, as you've seen. It's much easier to go into the database in enterprise manager and create a new stored procedure there and paste them into the small window that pops up for input there.

As for using them, yes, I have many clients who make extensive use of them.

Doug Castell
Castell Computers
 
Thanks so much for your response. Do you know where I can find any documentation/resources to help out in using the procedures? I have some SQL experience, but not much with stored procedures. I have been trying to use the procedures to insert new records into the GM database and keep getting errors.

Thanks!
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top