Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2002-02-26 : 09:16:58
|
| Mario writes "I have just started some support work off site on a SQL Server 2000 database. Some stored procedures have to be changed. The company I support has a fair amount of admin knowledge, but does not want to get into cutting and pasting the new SQL stored procedure text as they are afraid they may blow up the whole thing.I can send the new sp code to .sql file and send it over. However, we don't know how to make that code part of the databases stored procedure set. These are all custom stored procedures.We use SQL2000 and Windows Advanced server 2000Can you help? Any assistance, thoughts or suggestions will be much appreciated." |
|
|
andre
Constraint Violating Yak Guru
259 Posts |
Posted - 2002-02-26 : 09:30:31
|
| Are you using Enterprise Manager to generate scripts?You will need to run the .sql file under in Query Analyzer and select the database you want to run it in.Edited by - andre on 02/26/2002 09:35:48 |
 |
|
|
jackstow
Posting Yak Master
160 Posts |
Posted - 2002-02-26 : 09:56:25
|
| What about giving them a web page that connects to their database and creates the new stored procedure when they say click on a link..? |
|
|
|
lfmn
Posting Yak Master
141 Posts |
Posted - 2002-02-26 : 13:18:28
|
| Let's get this straight - they have a fair amount of admin knowledge, but they are afraid that cutting and pasting a stored procedure will blow the whole thing up? Sounds more like Dilbert's boss.Why not connect directly to the database and create the procs yourself?Access is a virus! |
|
|
|
|
|
|
import .sql file as a stored procedure