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?

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?

New indexes not shipped to secondary server

I am running SQL 2k on WinS2003 servers. We are using Log Shipping,
leaving our secondary in a Read-Only state to be used for reporting. I
have a need to get a new index on the secondary server (to decrease the
14 hour run time for a report). Our primary is in Full Recovery mode
as well.
I have created the index on my primary and expected it to be created on
the secondary when the logs were shipped this morning, only to find
that the Index was not created on the secondary.
I am not very familiar with Log Shipping and our in house expert is
unavailable.
Any thoughts on what gives?
I would even take pointers on where to start looking to find the
problem.
Meredith Ryan
> I have created the index on my primary and expected it to be created on
> the secondary when the logs were shipped this morning, only to find
> that the Index was not created on the secondary.
>
You need the logs shipped AND applied for this to occur.
"mryan" <coffegrl@.gmail.com> wrote in message
news:1143761656.789619.3450@.v46g2000cwv.googlegrou ps.com...
> I am running SQL 2k on WinS2003 servers. We are using Log Shipping,
> leaving our secondary in a Read-Only state to be used for reporting. I
> have a need to get a new index on the secondary server (to decrease the
> 14 hour run time for a report). Our primary is in Full Recovery mode
> as well.
> I have created the index on my primary and expected it to be created on
> the secondary when the logs were shipped this morning, only to find
> that the Index was not created on the secondary.
> I am not very familiar with Log Shipping and our in house expert is
> unavailable.
> Any thoughts on what gives?
> I would even take pointers on where to start looking to find the
> problem.
> Meredith Ryan
>
|||The logs had been applied. I guess I should have been a bit more
specific.

New indexes not shipped to secondary server

I am running SQL 2k on WinS2003 servers. We are using Log Shipping,
leaving our secondary in a Read-Only state to be used for reporting. I
have a need to get a new index on the secondary server (to decrease the
14 hour run time for a report). Our primary is in Full Recovery mode
as well.
I have created the index on my primary and expected it to be created on
the secondary when the logs were shipped this morning, only to find
that the Index was not created on the secondary.
I am not very familiar with Log Shipping and our in house expert is
unavailable.
Any thoughts on what gives?
I would even take pointers on where to start looking to find the
problem.
Meredith Ryan> I have created the index on my primary and expected it to be created on
> the secondary when the logs were shipped this morning, only to find
> that the Index was not created on the secondary.
>
You need the logs shipped AND applied for this to occur.
"mryan" <coffegrl@.gmail.com> wrote in message
news:1143761656.789619.3450@.v46g2000cwv.googlegroups.com...
> I am running SQL 2k on WinS2003 servers. We are using Log Shipping,
> leaving our secondary in a Read-Only state to be used for reporting. I
> have a need to get a new index on the secondary server (to decrease the
> 14 hour run time for a report). Our primary is in Full Recovery mode
> as well.
> I have created the index on my primary and expected it to be created on
> the secondary when the logs were shipped this morning, only to find
> that the Index was not created on the secondary.
> I am not very familiar with Log Shipping and our in house expert is
> unavailable.
> Any thoughts on what gives?
> I would even take pointers on where to start looking to find the
> problem.
> Meredith Ryan
>|||The logs had been applied. I guess I should have been a bit more
specific.