How to Create Login and User through query in Sql server
2005.and also how to delete Login and User through query?
Answers were Sorted based on User's Feedback
Answer / rajiv singh
CREATE LOGIN ra
WITH PASSWORD = 'passwd';
USE COREDATA;
CREATE USER ra FOR LOGIN ra;
GO
DROP LOGIN name
| Is This Answer Correct ? | 2 Yes | 4 No |
Answer / jagadeesh
create login 'name' with password='cghhicl'
GO
DROP LOGIN name
| Is This Answer Correct ? | 0 Yes | 4 No |
please give me query code of unique fuction select UNIQUE (name) from emp_info Incorrect syntax near the keyword 'UNIQUE'.
Explain various On-Delete options in a DB table. Which is the default option?
0 Answers Akamai Technologies,
Can you please explain the difference between primary keys and foreign keys?
If a table does not have a unique index, can a cursor be opened on it?
Tell me about the approaches which you used to counter the DI problems.
what is spatial nonclustered index
How many triggers are possible per table?
explain what is a schema in sql server 2005? Explain how to create a new schema in a database? : Sql server database administration
How to insert multiple rows with one insert statement in ms sql server?
Can anybody explain me cold backup and hot backup?
syntax and example for bitmap index in sql???
how to get rank of diffrent student in same table based on newly inserted row in sql server2008
Oracle (3259)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)