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?
- 2 Answers
- 4966 Views
- I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
What happens if you are trying to access a schema not owned by you?
What are the differences between ms sql server & oracle?
Can we use trigger new in before insert?
Explain sql server service broker?
what are the new features introduced in sql server 2000? : Sql server database administration
what's the difference between a primary key and a unique key? : Sql server database administration
What is sql view?
What is a view and what are its advantages?
Can we make the the chages By Using the Sql if u know any function or process please inform me Actuall result: BRK1 Break 1 Part 1 00:01:00:00 60 BRK1 Break 1 Part 2 00:01:00:00 60 BRK2 Break 2 Part 1 00:01:00:00 60 BRK2 Break 2 Part 2 00:01:00:00 60 BRK2 Break 2 Part 3 00:01:00:00 60 BRK3 Break 3 Part 1 00:01:00:00 60 BRK3 Break 3 Part 2 00:01:00:00 60 Desired O/P: BRK1 Break 1 Part 1 00:01:00:00 60 Part 2 00:01:00:00 60 BRK2 Break 2 Part 1 00:01:00:00 60 Part 2 00:01:00:00 60 Part 3 00:01:00:00 60
What is function of ROLLUP ?
What are scalar functions in sql?
Mention the different authentication modes in sql server.
What are the new features in SQL Server 2005 when compared to SQL Server 2000?
What are rest-style architecture's?
What are the types of user defined functions in sql server?
