Re: Starting SQL



Database name on whcih you want to perform the operations.
use <database name>

"Hari Prasad" ने लिखा:

> Hi,
>
> How do you start in SQL? Did you meant to start sql server service
>
> Go to Control Panel -- Administartive tools -- Services -- Select MSSQL
> Server -- mouse right click and start.
>
> What do u type in first at the top of the SQL Query analyzer?
>
> You can execute any TSQL command which includes DDL, DML , Permission
> commands, Admin commands ...)
>
> Eg:-
>
> Create table, Create View, Create Index, Create procedure ,....
>
> INSERT , UPDATE, DELETE
>
> SELECT
>
> GRANT
>
> BEGIN TRAN, COMMIT TRAN, ROLLBACK TRAN
>
> Backup database, Backup Log, Restore database, Restore Log ...
>
> See more information about this commands in SQL Server Books online.
>
> Thanks
> Hari
> SQL Server MVP
>
>
>
> "TYE" <TYE@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
> news:E789F7E3-AE1C-44D9-8C03-18E4729FA6E9@xxxxxxxxxxxxxxxx
> > HI,
> >
> > How do you start in SQL What do u type in first at the top of the SQL
> > Query
> > analyzer
> >
> >
> > Thanks
> > tye
>
>
>
.



Relevant Pages

  • Re: How do i move an SQLDatabase to another location?
    ... I went to my clients and installed SQL Server ... Express and copied my database to the same location it was in while i was ... knowing that i can bring a database with me and install ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: New to Windows CE Development - Have some questions
    ... validating against the main database, or querying the database during data ... iterate through the SQL CE table and create new entries in the ... SQL Server database that correspond. ... >>> not connected to the Enterprise. ...
    (microsoft.public.windowsce.app.development)
  • RE: Logging in in background
    ... wold take all kinds of modifictions as I'd need to be checking that each SQL ... my database and all have connection strings associated with them. ... I suspect that there is also an issue on the SQL Server side as I keep ...
    (microsoft.public.access.modulesdaovba)
  • RE: SBS 2003 Unable to connect to database STS_Config
    ... MSDE to store SharePoint uses the MSSQL$SharePoint database, ... SharePoint named instance to full SQL. ... You cannot upgrade the Monitoring instance to SQL ... What I see is the SQL server group and under ...
    (microsoft.public.windows.server.sbs)
  • Re: URGENT: SQL 6.5 Server Crash
    ... > Are these database backup done by SQL Server? ... > Or file backups performed by some Windows backup software? ... were they performed while SQL Server was running? ...
    (microsoft.public.sqlserver.server)