Wednesday, March 21, 2012

New SQL Database

I have set up applications in Access and am now starting in SQL Server. I
have taken a SQL class, but it did not cover starting from scratch. Our IT
dept set up a blank SQL database for me and gave me all permissions, but I'm
unsure of how to proceed. Do I need some sort of an interface set up on my
PC to connect?You probably want to get the SQL Server install and choose Client Tools Only
option. Look in the Books Online that installs for how to register a server
in the Enterprise Manager (that is the SQL Server GUI for creating
databases, viewing various objects, etc.) The Query Analyzer is the utility
for creating everything but the most basic objects...
Post back as needed...
Kevin Hill
President
3NF Consulting
www.3nf-inc.com/NewsGroups.htm
www.DallasDBAs.com/forum - new DB forum for Dallas/Ft. Worth area DBAs.
www.experts-exchange.com - experts compete for points to answer your
questions
"bills249" <bills249@.discussions.microsoft.com> wrote in message
news:6D26CB63-283F-4395-B990-680187867E7B@.microsoft.com...
>I have set up applications in Access and am now starting in SQL Server. I
> have taken a SQL class, but it did not cover starting from scratch. Our
> IT
> dept set up a blank SQL database for me and gave me all permissions, but
> I'm
> unsure of how to proceed. Do I need some sort of an interface set up on
> my
> PC to connect?

No comments:

Post a Comment