exploring databases? I'm using the AdventureWorks2008R2 database (downloaded from MS) for the online class and I've learned a few commands to help me look around such as EXEC sp_helpdb 'accounting', EXEC sp_helpconstraint customers or SELECT * from customers. I'm not sure how to see things like sprocs or stored procedures, we've also only used commands or queries thus far and not the GUI. This is my first experience with a database so please forgive me if this phrasing is wrong, I'm trying my best to convey what I would like to do. If there are any nice DBA's out there that would like to share some helpful tips to simply "look around" in SQL 08 I'd very much appreciate it!
I'm taking my first on-line class on SQL Server 08 and need some simple help in
- Thread starter kit
- Start date