Snitz Forums 2000
Snitz Forums 2000
Home | Profile | Register | Active Topics | Members | Search | FAQ
Username:
 Password:
Save Password
Forgot your Password?

 All Forums
 Community Forums
 Community Discussions (All other subjects)
 Reality Check: SQL stored queries		  New Topic  Topic Locked
 Printer Friendly
Author Previous Topic Topic Next Topic  

seven
Senior Member

USA
1037 Posts
Posted - 15 August 2003 :  17:00:22  Show Profile  Visit seven's Homepage
If I said "MS SQL stored queries", would you all know what I am talking about?

A host for a website of mine can't figure out what I am talking about. The stored queries in the database suddenly disappeared yesterday rendering the website useless and I am trying to get them to restore them but can't even get my point across as to what they are. Am I crazy or are they just "ignorant"?

Are these usually restorable. I have all the data backed up locally but never saved the query structures.



VodkaFish
Average Member

USA
654 Posts
Posted - 15 August 2003 :  17:39:27  Show Profile  Send VodkaFish an AOL message  Send VodkaFish an ICQ Message  Send VodkaFish a Yahoo! Message
When I hear "Stored Queries" I would think you're referring to those stored queries in Access.

If it's on SQL Server, I would assume you mean stored procedures.

If it's Access, a local file should have them in there if you backed it up, you should be able to just copy the structure into the newer db.

If it's SQL Server, it just depends on whether or not your host or yourself does backups including stored procs.
v ø d k â f ï § h
Go to Top of Page

Gremlin
General Help Moderator

New Zealand
7528 Posts
Posted - 16 August 2003 :  00:36:01  Show Profile  Visit Gremlin's Homepage
It wasn't till I read this twice that I saw your called them "queries" rathar than "procedures" I would think any average person with a bit of MS SQL knowledge should be able to work out what your talking about pretty quickly.

Whether your procedures and views etc are backed up again may be a whole nother matter as VodakFish pointed out.

It really pays to keep your own backup copies of things like that.
Kiwihosting.Net - The Forum Hosting Specialists
Go to Top of Page

seven
Senior Member

USA
1037 Posts
Posted - 16 August 2003 :  23:05:01  Show Profile  Visit seven's Homepage
so i now know to always backup...

Yes, not stored procedures, but simply SQL queries...


quote:
Originally posted by Gremlin



Whether your procedures and views etc are backed up again may be a whole nother matter as VodakFish pointed out.

It really pays to keep your own backup copies of things like that.
Go to Top of Page

Gremlin
General Help Moderator

New Zealand
7528 Posts
Posted - 17 August 2003 :  03:43:54  Show Profile  Visit Gremlin's Homepage
quote:
but simply SQL queries...
I always save mine locally as .sql files personally.
Kiwihosting.Net - The Forum Hosting Specialists
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Topic Locked
 Printer Friendly
Jump To:
Snitz Forums 2000 © 2000-2021 Snitz™ Communications Go To Top Of Page
This page was generated in 0.37 seconds. Powered By: Snitz Forums 2000 Version 3.4.07