Changing default directory for stored procedures

I want to change the default directory for my stored procedures. It is extremely inconvenient for me that they are placed in \documents and settings\... I cannot find a place in the Tools where I can change it.

Thanks.

hi,

stored procedures are not "saved" to file in your \doc & settings\ folder...

stored procedures are saved in the database they have been created in..

only "queries" are saved by SQL Server Management Studio (Express as well) in that folder, and I quiet sure you can not modify that folder..

regards

|||

Thank you Andrea.

Then what can I do about this, I would say, serious problem?

I make a modification in my stored procedure, and try to save it. The only options I am given is to save a "Query1" (it may be Query23" or something) or "save as."

Let's say I saved it. Then I close the SQLEXPRESS and open it up again. Go to my stored procedure and cannot find my changes.

Now it does not seem to happen every time but so annoyingly often that I cannot see any pattern to change my behavior accordingly.

I have about a dozen queries now saved. I actually have only 3 stored procedures I am working with now, one per a database. When I open them up in notepad I can see my old stored procedures (in spite of what you just said) some of them with chaotic changes I made days ago when I did not know what I was doing.

I try to keep track of the disorder. I recall that working with one database I saved a procedure as "Query1." I go to another database where I need to remove a bug from a similar stored procedure, open it and it appears as "Query1" AGIAN. But inside it does not look like my previous Query1 which I just saved. So I am afraid to modify it because I may wipe out the change I made in my previous database a minute ago.

It is a madhouse. It is just a bunch of nonsense as I see it.

I need clarity.

Thanks.

|||

Alex,

Execute it to persist (drop existing first if any)

Save it for your reference and for executing later on demand. IOW you're saving code (like a prg in VFP).

|||Thank you, Cetin.