SQL Server FAQs

There are up to 32 nested trigger levels.

Definitely Windows Authentication Mode. Firstly, the Windows security policy is used to authenticate is employed at user login reducing extra overhead. Secondly, if we implement any extra group policy...

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.

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

You have to connect your database first than you can open asly.....

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.

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.

Save the query results to .csv file.

Create Procedure TestExport
as
Begin

xp_cmdshell 'bcp "SELECT * from YourDatabase.dbo.YourTable" QueryOut d:Temptest.xls -S alexissqlsrv01 -U dpi -P Value*() -c -T'

Create Procedure TestExport
as
Begin

xp_cmdshell 'bcp "SELECT * from YourDatabase.dbo.YourTable" QueryOut d:Temptest.xls -S alexissqlsrv01 -U dpi -P Value*() -c -T'

It is to know the no of rows feched from cursor
It is used in situations like

We have to do the modifications up to five rows

Their is some situations to print up to no of rows fetched from cursor

In pl/sql table it is used like an array index to store values

In the stored procedures to the total counts of the rows affected by the query.

use TableLocks or RowLocks to prevent the other user from modifying the data when the previous user is using the same data.

See if two user are updating same time at same time it will affect one by one!! it means 1st user changes will accept then 2nd user changes it iwll accept