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 |
|
Toekiller
Starting Member
5 Posts |
 Posted - 2006-04-28 : 05:17:58
|
| I've recently been upgraded to Office 2003 and primaraly use Access to edit SQL stored procedures on a SQL 2000 box. It seems though from first glance, things have gotten worse since Access 2000.No more colour coding for example and it also opens some in a view type mode.Any recomendations on what I can use that would allow me to edit the SQL while updating it on the server and pull down data if needed?Someone recommened Visual Studio but I'm unsure of which version to use. |
|
|
jen
Master Smack Fu Yak Hacker
4110 Posts |
Posted - 2006-04-28 : 05:26:59
|
not sure but check ultraedit...--that tea must be alcoholic, i thought he was till talking about access  --------------------keeping it simple... |
 |
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
Posted - 2006-04-28 : 05:34:41
|
use Query Analyser
KH |
|
|
|
Kristen
Test
22859 Posts |
Posted - 2006-04-28 : 05:42:04
|
| +1 for use Query Analyserits on the Server CD - go to make a Server Install [on your workstation] and then just choose "Client Tools" - I know, bit illogical, but that's how it is!Kristen |
|
|
|
Toekiller
Starting Member
5 Posts |
Posted - 2006-04-28 : 06:05:45
|
| That was quick ;)I have QA installed and it has the formatting at least but after I edit it how do you save it? I click on save and it wants to save it as a sql query where I want to save and update the stored procedure. |
|
|
|
Kristen
Test
22859 Posts |
Posted - 2006-04-28 : 06:24:02
|
| Assuming the syntax is:CREATE PROCEDURE ...or DROP PROCEDURE ...GOCREATE PROCEDURE ...orALTER PROCEDURE ...then just Execute it (Green ArrowHead button)(And save it to a file in your Version Control system!!!!)Kristen |
|
|
|
derrickleggett
Pointy Haired Yak DBA
4184 Posts |
Posted - 2006-04-28 : 15:11:11
|
| Buy a good Transact-SQL book from Ken Henderson. Open Books Online (included free with SQL Server also and found in the Microsoft SQL Server area under Start/Programs). Read about Stored procedures. MeanOldDBAderrickleggett@hotmail.comWhen life gives you a lemon, fire the DBA. |
|
|
|
|
|
|
What Editing Tool to Use for SQl on SQL 2000?