Discussion :

[Drahu]

quelqu'un pourrait-il m'expliquer comment fonctionne les authentifications sous SQL-serveur?

Je souhaiterais savoir comment attacher une base de donnée sous un ID et un password spécifique.

En mode graphique, j'arrive à le faire, mais pas en mode commande.

Merci d'avance.

[WOLO Laurent]

La MSDN est très clair à ce sujet.
Pour attacher une base de données, regardez du côté de sp_attach_db :

sp_attach_db
Attaches a database to a server.

Syntax
sp_attach_db [ @dbname = ] 'dbname'
, [ @filename1 = ] 'filename_n' [ ,...16 ]

Arguments
[@dbname =] 'dbname'

Is the name of the database to be attached to the server. The name must be unique. dbname is sysname, with a default of NULL.

[@filename1 =] 'filename_n'

Is the physical name, including path, of a database file. filename_n is nvarchar(260), with a default of NULL. There can be up to 16 file names specified. The parameter names start at @filename1 and increment to @filename16. The file name list must include at least the primary file, which contains the system tables that point to other files in the database. The list must also include any files that were moved after the database was detached.

Return Code Values
0 (success) or 1 (failure)

Result Sets
None

Remarks
sp_attach_db should only be executed on databases that were previously detached from the database server using an explicit sp_detach_db operation. If more than 16 files must be specified, use CREATE DATABASE with the FOR ATTACH clause.

If you attach a database to a server other than the server from which the database was detached, and the detached database was enabled for replication, you should run sp_removedbreplication to remove replication from the database.

Permissions
Only members of the sysadmin and dbcreator fixed server roles can execute this procedure.

Examples
This example attaches two files from pubs to the current server.

EXEC sp_attach_db @dbname = N'pubs',
@filename1 = N'c:\Program Files\Microsoft SQL Server\MSSQL\Data\pubs.mdf',
@filename2 = N'c:\Program Files\Microsoft SQL Server\MSSQL\Data\pubs_log.ldf'

.

[Drahu]

La MSDN ne m'explique pas comment définir le PROPRIETAIRE de la Base de données

En mode graphique, SQL-Serveur demande le nom du PROPRIETAIRE de la base. comment se fait cette opération en mode commande?

[Gandalf Le Blanc]

Slt,

Code :

Sélectionner tout - Visualiser dans une fenêtre à part

1
2
3
Syntaxe
sp_changedbowner [ @loginame = ] 'login' 
    [ , [ @map = ] remap_alias_flag ]

a+

[Drahu]

Merci bcp, mais je n'arrive pas à définir la base de donnée que je souhaite modifier.

[Gandalf Le Blanc]

Slt,

la procedure sp_changedbowner modifie le proprietaire de la base ou tu es connecte.

a+