Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...


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



How to Create Login and User through query in Sql server 2005.and also how to delete Login and Use..

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

How to Create Login and User through query in Sql server 2005.and also how to delete Login and Use..

Answer / jagadeesh

create login 'name' with password='cghhicl'
GO
DROP LOGIN name

Is This Answer Correct ?    0 Yes 4 No

Post New Answer

More SQL Server Interview Questions

please give me query code of unique fuction select UNIQUE (name) from emp_info Incorrect syntax near the keyword 'UNIQUE'.

1 Answers   TCS,


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?

0 Answers  


If a table does not have a unique index, can a cursor be opened on it?

0 Answers  


Tell me about the approaches which you used to counter the DI problems.

0 Answers   EXL,


what is spatial nonclustered index

0 Answers  


How many triggers are possible per table?

0 Answers  


explain what is a schema in sql server 2005? Explain how to create a new schema in a database? : Sql server database administration

0 Answers  


How to insert multiple rows with one insert statement in ms sql server?

0 Answers  


Can anybody explain me cold backup and hot backup?

3 Answers   TCS,


syntax and example for bitmap index in sql???

1 Answers  


how to get rank of diffrent student in same table based on newly inserted row in sql server2008

4 Answers   ABC,


Categories