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 ...
What is the buffer size of SQL query output row?
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 are SQL Server databases physically stored under Windows 2000?
How we will access a table of one server from a stored procdure in other server?
Latest Answer: You can access this through the following syntax[Another Server IP].[Database Name].[Owner].[Table Name]e.g.[XXX.XXX.XX.XX].[myDB].[DBO].[EmployeeMaster] ...
How to transfer data from a text file to SQL table, Which is the best method to do that?
Latest Answer: By using OPENROWSET commandExample: INSERT INTO dbo.ImportTestSELECT * FROM OPENROWSET('Microsoft.Jet.OLEDB.4.0','Excel 8.0;Database=C:ImportData.xls', ...
How To Define Unique Key in SQL Server
Latest Answer: CREATE TABLE product(pid INT PRIMARY KEY,pname VARCHAR(10),invoiceid INT UNIQUE) ...
Explain what is Distributed deadlock?
What is the different between Logging and Transaction?
How to join same fields of four tables at SQL Server?
View page << Previous 1 [2] 3 4 5 6 7 Next >>
Go Top
