|
Articles
|
| |
 |
which function displas the state of information of the transaction in the session?
sys.dm_tran_current_transaction function
|
|
| 21 Feb, 2009 |
Views: 565 |
Comments: 40 |
|
|
|
|
Which transport protocol cannot be used for database mirroring?
HTTP protocol
|
|
| 21 Feb, 2009 |
Views: 591 |
Comments: 52 |
|
|
|
|
Which Stored procedure will be used to create an alert in database?
sp_add_alert procedure.
|
|
| 21 Feb, 2009 |
Views: 546 |
Comments: 39 |
|
|
|
|
which clause specified while creating a stored procedure causes the stored procedure to recomplile every time it is run?
the WITH RECOMPILE clause
|
|
| 21 Feb, 2009 |
Views: 493 |
Comments: 28 |
|
|
|
|
which clause in the CREATE CERTIFICATE statements specifies the user who owns the certificate?
AUTHORIZATION clause
|
|
| 21 Feb, 2009 |
Views: 383 |
Comments: 32 |
|
|
|
|
which pages in the SQL Server Management Studio allow you to configure different properties of backup?
General and Options pages
|
|
| 21 Feb, 2009 |
Views: 667 |
Comments: 47 |
|
|
|
|
Which function displays the state of information of the transaction in the session?
sys.dm_tran_current_transactioin function
|
|
| 21 Feb, 2009 |
Views: 624 |
Comments: 36 |
|
|
|
|
Which argument should be specified in the bcp command to perform an export?
OUT argument
|
|
| 21 Feb, 2009 |
Views: 608 |
Comments: 31 |
|
|
|
|
Which clause specifies the assembly name and class name while creating a user-defined type by using the CREATE TYPE statement.
the EXTERNAL NAME assembly_name [.class_name] clause
|
|
| 21 Feb, 2009 |
Views: 702 |
Comments: 42 |
|
|
|
|
on which two editions of Windows 2003 can you install the SQL Server 2005 Enterprise edition?
Windows Server 2003 with Service Pack 1
Windows 2003 Datacenter Edition Server Pack 1
|
|
| 21 Feb, 2009 |
Views: 643 |
Comments: 30 |
|
|
|
Database Knowledge Base