server error log

server| stored procedure stored procedure return result There are three ways to return results from a stored procedure: 1. Return result set This is the most common way for a client application to return results. The result set is produced by

Today the Sql-server database suddenly complains: SQL Server has detected a consistent, logical I/O error checksum (should be: 0x7c781313, but actually: 0X67A313C9). In the file ' C:\Program Files\Microsoft SQL

If you run a linked server query in the SQLServer2000 installed on Windows.netserver, the following error may be returned (even if MSDTC is running on the server): Symptom if you run a linked server query in the SQLServer2000 installed on

server| Stored Procedures --Get MS SQL version numberExecute master.. Sp_msgetversion --Get Hard disk file information--Parameter Description: directory name, directory depth, whether to display filesExecute master.. Xp_dirtree ' C: 'Execute master..

Obtain the version number of MS SQL Execute master.. Sp_msgetversion Get Hard Drive File information Parameter Description: Directory name, directory depth, whether to display files execute master..xp_dirtree 'c:' execute master..xp_dirtree 'c:',

Phenomenon:--------------------------------------------------- 1, connect SQL Server database hint: Login failed for user ' sa '. Reason:not associated with a trusted SQL Server connection error Question:--------------------------------------------