Interested to Buy Any Domain ? << Click Here >> for more details...
Can we drop user if user mapped to any logins
- 1 Answers
- 3288 Views
- I also Faced
- E-Mail Answers
Answer / neetu
Yes,This feature is only in latest version of SQL
| Is This Answer Correct ? | 1 Yes | 0 No |
As a general practice, it is recommended to have dbo be the owner of all database objects however, in your database you find number of tables owned by a user other than dbo, how could you fix this?
Why is there a performance difference between two similar queries where one uses union and the other uses union all?
What is measure group, measure? : sql server analysis services, ssas
i want only duplicates rows from coloumn ex. emp_id(colomn name)1,1,2,3,3,4,5,5. so i want only duplicates no.
What type of locking occurs during the snapshot generation? : sql server replication
Write a query to delete duplicate records in SQL SERVER
How can you swap values between two rows in a table using single- SQL statement?
1 Answers Tavant Technologies, Virtusa,
How do I find the sql server database version?
How to select all columns of all rows from a table with a select statement in ms sql server?
Why normalization is used?
What are the rules to use the rowguidcol property to define a globally unique identifier column?
What are three ways you can use an identity value inside a trigger? Why would you prefer one way over another?
-
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)
