Abhinav Jain

• Nov 19th, 2007

User Identification: In virtue of Data base server Identification tries to find whether you are registered user in the database or not. It applies to whole database server. Authentication: It ap...

Answer Question  Select Best Answer

sutanu_halder

 Profile Answers by sutanu_halder Questions by sutanu_halder

• Mar 29th, 2008

DTS is a set of tools you can use to import, export, and transform heterogeneous data between one or more data sources, such as Microsoft SQL Server, Microsoft Excel, or Microsoft Access.The Import/Ex...

Answer Question  Select Best Answer

Chetna

• Oct 16th, 2007

If a Trigger is having Insert/Update/Delete statement of a table which is also having a trigger defined on it for Insert/Update/Delete, then Trigger1 would cause Trigger2 to get fired when a data Manipulation has occured. This is called nested trigger.

Answer Question  Select Best Answer

amitm79

 Profile Answers by amitm79 Questions by amitm79

• Feb 8th, 2008

Bigint can hold values from -2^63 (-9,223,372,036,854,775,807) to 2^63-1 (9,223,372,036,854,775,807) and it takes 8 bytesint can hold values from -2^31 (-2,147,483,648) to 2^31 - 1 (2,147,483,647) and it takes 4 bytes

Answer Question  Select Best Answer

sutanu_halder

 Profile Answers by sutanu_halder Questions by sutanu_halder

• Dec 14th, 2007

There are over 80 distinct system privileges. Each system privilege allows a user to perform a particular database operation or class of database operations.Such as:- 1. ANALYZE ANY   ...

Answer Question  Select Best Answer

Kiran Patil

 Profile Answers by Kiran Patil Questions by Kiran Patil

• Mar 26th, 2008

Yes, there is table partitioning in SQL Server. Unfortunately I don't know how to do that, If anyone knows that, let me know.

Answer Question  Select Best Answer

Chetna

• Oct 16th, 2007

SQL Server runs on port 1433. It can be changed from the Network Utility TCP/IP properties > Por number, both on client and the server.

Answer Question  Select Best Answer

vijaya_pitta

 Profile Answers by vijaya_pitta Questions by vijaya_pitta

• Dec 12th, 2007

Architecture is the frame work of the Database Management System. They are simply classified into logical and physical.

Answer Question  Select Best Answer

I would like to know whether it uses SOAP or XML.

opbang

 Profile Answers by opbang Questions by opbang

• Dec 9th, 2007

XML for Analysis (XMLA) is a Simple Object Access Protocol (SOAP)-based XML protocol, designed specifically for universal data access to any standard multidimensional data source residing on the Web. ...

Answer Question  Select Best Answer

bugeye

 Profile Answers by bugeye Questions by bugeye

• Mar 15th, 2008

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.

Answer Question  Select Best Answer

How to display the table data in XML format using SQL Server.

Ravi

• Nov 21st, 2007

The only thing you have to do is to insert "for XML Auto" in your query and the result will be returned in XML format.Eg. Let there be a table with name tblABCNormally??? Select * from tblABCFor XML Data??? Select * from tblABC for XML Auto

Answer Question  Select Best Answer

If I have 10 statements, individually committing each statement is efficient or doing a bulk commit of all the 10 statements at the end is efficient.Also if we say one of them is efficient... is it efficient in space or time or cpu?Thanks,rbala_sjsu

debasis.yours

 Profile Answers by debasis.yours Questions by debasis.yours

• Dec 14th, 2007

There is a trade-off in this case. In case of transaction-oriented scenario, I think executing 10 statements separately would be a better option since it will hold the lock for a very short duration a...

Answer Question  Select Best Answer

How we can pulish the connectivity of SQL query to the HTML file or web page? Please Explain.

Mena1710

 Profile Answers by Mena1710 Questions by Mena1710

• Jan 30th, 2008

Normally connection of SQL file to a web page can be done in two ways1. Through the code2. In web config fileIf we give through the code, we need to alter the relevant pages, where as if we give throu...

Answer Question  Select Best Answer

How many levels a trigger can be nested? Explain about nested triggers.

quietguy999

 Profile Answers by quietguy999 Questions by quietguy999

• Jan 23rd, 2008

There are up to 32 nested trigger levels.

Answer Question  Select Best Answer

How to deny insert, update, delete, update permissions for a specific user of a specific user database?

bugeye

 Profile Answers by bugeye Questions by bugeye

• Mar 15th, 2008

So what context is the user in?  A role a datareader? Datawriter?You want no permissions?USE <your db>Drop USER <your  user> In a role?EXEC sp_droprolemember 'rolename&#...

Answer Question  Select Best Answer

What is tail log backup? Where can we use it?

Kiran Patil

 Profile Answers by Kiran Patil Questions by Kiran Patil

• Mar 26th, 2008

Tail Log Backup is the log backup taken after data coruption (Disaster). Though there is file corruption we can try to take log backup (Tail Log Backup). This will be used during point in time re...

Answer Question  Select Best Answer

How to join same fields of four tables at SQL Server?

psingla

 Profile Answers by psingla Questions by psingla

• Mar 19th, 2010

There are 5 types of join in sqlservercross joininner joinleft outer joinright outer joinfull outer joincross joinselect * from table1cross join table2cross join table3cross join table4inner joinselec...

Answer Question  Select Best Answer

ramaniy

 Profile Answers by ramaniy Questions by ramaniy

• Jun 2nd, 2008

Prefix column name with table name like tableName.columnName

Answer Question  Select Best Answer

There is a problem in creating relationship between two tables using SQL Server Database.What are the requirements and data that should be had before creating table relationship.

charanpathania

 Profile Answers by charanpathania Questions by charanpathania

• Apr 1st, 2009

The datatype of the both the columns used in relation must be the same

Answer Question  Select Best Answer

How to select Distinct columns from the table, table having 20 columns and i want all columns

Thenchinnu

 Profile Answers by Thenchinnu Questions by Thenchinnu

• May 15th, 2008

SELECT DISTINCT *FROM Tabe1

Answer Question  Select Best Answer