hi,
for the last 1+ hour i have been looking in the forum for some answer,, also in asp.net forum and google too. ,..but finally m writing my issues here... hope to get some replies ,,coz m really stuck. ;)
:: i recently downloaded the install package version 4.0.7 to my local computer and then installed it on my local computer... however i gave the database details in the config file which was pointing to a ms sql 2000 server at a database server otherthan my local computer..
the installation started and was going smooth, but it did not complete and threw some error...
when i checked the database server,, i saw the tables and stored procedures and views have been created....
NOW: i have uploaded the install package files to my host,, and trying to reinstall from there.... but its not starting installation ther....
i discovered few talbles and stored procedures are missing....
NOW IT WILL TAKE DAYS TO ME IF I DELETE THE TABLES AND STORED PROCEDURES FROM THE DATABASE MANUALLY before reinstall,, so please suggest what to do..
so my question is:
Q1. in a scenario where many tables/stored procedures are present from a previously unsuccessfull installation .. what should i do..
Q2. iam doing it right by direly installing on the remote server... or should i do something locally before deploying at the server..
Q3. if u dont understand or cant reply Q&2,,, can you atleast tell me what is the best way (sql script) to delete multiple storedprocedures (that start with a specific prefix) efficiently.
thank you (even if you not reply,,(for reading such a long question)
regards