 Related Questions Latest Answer : use TableLocks or RowLocks to prevent the other user from modifying the data when the previous user is using the same data. ... Error While creating BACKUP:I am Creating FullBackup for one database Named Postings.I executed below Query and i am getting The Below error message.USE mastergoEXEC SP_ADDUMPDEVICE 'disk','PostingsBac','E:BACKUPPostingsBac.BAK'BACKUP Latest Answer : This is basically a problem with the physical path of the Backup device, I suppose. Be sure the physical path that you are giving has full access from your Windows user Account or not. ... Read Answers (1) | Asked by : Ramesh.M Tags : Backup Latest Answer : Take a full backup and restore or dettach 2000 db copy .mdf and ldf to 2005 server. Attach then switch compatiblity mode to 90 then update statistics. Once you go to 2005 you can go back. ... Read Answers (1) | Asked by : santanu What is the Difference between Attach and Restore of a Database? Latest Answer : Database attach is faster as compaired to Database Restore. SO if you have both options then may be you can choose Database attach than Database Restore. ... Tags : Restore How to display list of tables from a particular database in MS-SQLHow to display description of that particular table? Latest Answer : To Display list of tables in the database:SELECT * FROM INFROMATION_SCHEMA.TABLES WHERE TYPE='basetable'To describe the structure of a particular tableSP_HELP table_name; ... How to deny insert, update, delete, update permissions for a specific user of a specific user database? Latest Answer : So what context is the user in? A role a datareader? Datawriter?You want no permissions?USE Drop USER In a role?EXEC sp_droprolemember 'rolename' , 'Member'single objects?Revoke SELECT, ... How to deny delete and drop permission to the user for the particular database in SQL Server 2005. Latest Answer : USE [PARENTDB] GO DROP SCHEMA [USER] GO USE [DB]GO DROP USER [USER] GOor in GUI SQL SQL server Managment Studio go to your DB open it's security section up. . select users folder .. select user adn press delete on the keyboard .. ... How can we rename a Database with query? Latest Answer : Syntax of renaming the database:sp_renamedb old_database name new_database nameEg:Â name of the database is tree. Now if you need to change the database as three. So the query for changing the database as follows:sp_renamedb tree three ... How to secure data in the SQL Server Database?
Sponsored Links
| |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
