|
|
|
| This question seems embarrassingly basic, but here goes. I
need to add several tables to a db in SQL Server 7 that
uses a Access front end. Before I add these tables do I
need to stop the server or take any other precaution?
Thanks
| |
| Dinesh.T.K. 2002-10-05, 9:07 pm |
| Evan,
[colo
r=darkred]
>>>Before I add these tables do I
> need to stop the server or take any other precaution?[/color]
No need.Just make sure that you create the tables in the correct database.
Dinesh
--
--
SQL Server FAQ at
www.tkdinesh.com
"Evan" <Shurak@erols.com> wrote in message
news:e5d401c259c4$95250a90$37e
f2ecf@TKMSFTNGXA13...
> This question seems embarrassingly basic, but here goes. I
> need to add several tables to a db in SQL Server 7 that
> uses a Access front end. Before I add these tables do I
> need to stop the server or take any other precaution?
>
> Thanks
| |
| Anith Sen 2002-10-05, 9:07 pm |
| >> Before I add these tables do I need to stop the server
or take any other precaution? <<
No. You cannot add the tables when the Server is stopped.
Just add it.
--
- Anith
| |
| Geoff N. Hiten 2002-10-05, 9:07 pm |
| No changes are necessary. SQL can add and delete tables on the fly.
You might want to read a bit more on SQL server, especially about backups
and restores. Saves time as well as wear and tear on your resume should bad
things happen.
--
Geoff N. Hiten
Senior Database Administrator
Careerbuilder.com
"Evan" <Shurak@erols.com> wrote in message
news:e5d401c259c4$95250a90$37e
f2ecf@TKMSFTNGXA13...
> This question seems embarrassingly basic, but here goes. I
> need to add several tables to a db in SQL Server 7 that
> uses a Access front end. Before I add these tables do I
> need to stop the server or take any other precaution?
>
> Thanks
|
|
|
|