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 |
|
ICFire
Starting Member
7 Posts |
 Posted - 2005-01-25 : 14:22:43
|
| First I'm a newb to SQL admining so if I say stupid things just look over it please. Ok, I want to peruse one of our sql databases. Is there an easy method of doing this? It was created before I was hired and has been in use for some time. I've requested Veritas SQL agent but it's been placed on hold till new money becomes available. The reason this has came up is we use Sharepoint Portal Server with a hook/plug-in to a high-end cad program (Solid Edge/Insight) and some of the files our engineers work on cannot be found on the server itself. This became an issue when one of them deleted a folder/files and they were not shown on the tape backup (Veritas) The cad program just shows the Sharepoint url for the file and not an actual file location. I'm thinking these files may in fact reside strictly in the db so I'm wanting a palnless way to view/interrogate the db.TIA for any assistance. |
|
|
chadmat
The Chadinator
1974 Posts |
Posted - 2005-01-25 : 16:58:53
|
| Query Analyzer. Select * from <Table Name>-Chadhttp://www.clrsoft.comSoftware built for the Common Language Runtime. |
 |
|
|
Pace
Constraint Violating Yak Guru
264 Posts |
Posted - 2005-01-26 : 06:22:32
|
If you have sql server installed you should also have "books online" this will be a god send for you if you have been dumped with this  hthPace |
|
|
|
robwhitby
Starting Member
6 Posts |
Posted - 2005-01-27 : 06:34:29
|
| To simply browse your data, open enterprise manager from the start menu and drill down the tree structure on the left - Console Root > Microsoft SQL Servers > [YOUR SERVER] > Databases > [YOUR DATABASE] > Tables.Then right click on a table and choose Open Table > Return all rows |
|
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2005-01-27 : 06:45:13
|
| It would be better NOT to get into the habit of using EM to browse data. It was not designed for real data work, and it's a major resource hog. DO NOT use it to edit data either. |
|
|
|
robwhitby
Starting Member
6 Posts |
Posted - 2005-01-27 : 06:58:41
|
| EM may not be perfect, but for a new user inexperienced with t-sql I don't see a problem, or an alternative without buying 3rd party software. |
|
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2005-01-27 : 07:18:51
|
quote:
but for a new user inexperienced with t-sql I don't see a problem
Except that they'll never BECOME experienced in T-SQL if they don't start using it.I'm not saying you're wrong, but I've seen this really bad habit too many times in too many people. Best way to break a bad habit is not to start in the first place. |
|
|
|
ICFire
Starting Member
7 Posts |
Posted - 2005-01-27 : 12:29:57
|
Thanks for the responses. We got this resolved and got an answer from the vendor also. They are virtual files/folders for the website and data for the db.Well some of them are virtual, some of them are real files/folders...  |
|
|
|
|
|
|
Newb - really newb question