| |||||
|
Microsoft SQL Server FAQs Part: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 (Continued from previous part...) In the Windows world, if you hit the "Enter" key on your keyboard between two single quotes and inserted this value, what data would be stored in the column?
Answer: ASCII 13 and ASCII 10
You wish to back up the symmetric key used to protect data on the Reporting Services 2005 instance installed on Sales01. From your workstation, what command do you use?
Answer: You cannot do this from your workstation.
You have a notification set up in SQL Server 2005 to let you know when a job fails. However you would like more details about the step that failed. Which table would you query in your report to get logging information about a job step?
Answer: msdb.dbo.sysjobstepslogs
You want to speed up your SQL Server 2005 Service Broker queue by placing an index on it. What is the best way to do this?
Answer: You cannot create an index on a Service Broker queue.
Which is these is not necessary for a well-formed XML document?
Answer: Contains no text at the top level element.
You want to create a covering index for this query on your SQL Server 2005 database:
Answer: CREATE INDEX IX_Cover ON dbo.Products (productid, product, cost) INCLUDE (productdescription);
On which port does the dedicated administrator connection listen in SQL Server 2005?
Answer: a Dynamic port assigned on server start.
What is the default type of XML data if you do not specify an arguement?
Answer: CONTENT
You created a SQL Server 2005 Service Broker queue, but neglected to add an activation procedure. Fortunately you had not set the status to ON. You use the ALTER QUEUE statement to specify a stored procedure as follows: ALTER QUEUE PublicationQueue WITH ACTIVATION ( PROCEDURE_NAME = new_stored_proc, EXECUTE AS SELF) ; However the procedure does not seem to run when you send a message to the queue. What is wrong?
Answer: The queue activation status needs to be set to on.
When you use the sp_xml_preparedocument stored procedure in SQL Server 2000, what is returned?
Answer: An integer acting as a handle to the document.
(Continued on next part...)
Part: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 |
||||