Code By Experience

S tored Procedure is m ost popular database  object .   A stored procedure in SQL Server is a group of one or more Transact-SQL statements    . Procedures resemble constructs in other programming languages because they can: ü   Allow input parameters and return multiple values in the form of output parameters to the calling program. ü   Contain programming statements that perform operations in the database. Can calling other procedure, functions ü   Return a status value to a calling program to indicate success or failure (and the reason for failure). Benefits of Using Stored Procedures:          ü   Reduced server/client network traffic: A procedure contain a batch of sql statement, even execute other procedure, This can significantly reduce network traffic between the server and client because only the call to execute the procedure is sent across the network. ü   Stronger sec...

When we try to visit a Web page that is hosted on a computer that is running Internet Information Services (IIS) 7.0, sometimes we may receive the following error message: HTTP Error 404.2 - Not Found   The page you are requesting cannot be served because of the ISAPI and CGI Restriction list settings on the Web server Reason: ------------------------------------------------------------------------------------------------------------------- This issue occurs because the requested Internet Server API (ISAPI) resource or the requested Common Gateway Interface (CGI) resource is restricted on the computer that is running IIS 7.0. Resolution: ---------------------------------------------------------------------------------------------------------------------------------------- To resolve this issue, configure the restriction on the ISAPI and CGI Restrictions page to allow the requested ISAPI resource or the ...

Checks the logical and physical integrity of all the objects in the specified database . DBCC CHECKDB( 'Galaxy' ); Message Results: DBCC results for 'Galaxy' . Service Broker Msg 9675 , State 1 : Message Types analyzed: 14 . Service Broker Msg 9676 , State 1 : Service Contracts analyzed: 6 . Service Broker Msg 9667 , State 1 : Services analyzed: 3 . Service Broker Msg 9668 , State 1 : Service Queues analyzed: 3 . Service Broker Msg 9669 , State 1 : Conversation Endpoints analyzed: 0 . Service Broker Msg 9674 , State 1 : Conversation Groups analyzed: 0 . Service Broker Msg 9670 , State 1 : Remote Service Bindings analyzed: 0 . Service Broker Msg 9605 , State 1 : Conversation Priorities analyzed: 0 . DBCC results for 'sys.sysrscols' . There are 1309 rows in 23 pages for object "sys.sysrscols" . DBCC results for 'sys.sysrowsets' . There are 135 rows in 2 pages for object "sys.sysrowsets" . DBCC results...

I am working several remote server those are connected with DB link. I need create a DB link (remote server oracle db) with my SQL Server, but don't know the required server is connected or not.  at this moment used SQL server default procedure   EXEC SP_LINKEDSERVERS Found below results: all link server name, provider name, DataSource IP those are connected with DBLINK MSDN Column name Data type Description SRV_NAME sysname Name of the linked server. SRV_PROVIDERNAME nvarchar( 128 ) Friendly name of the OLE DB provider managing access to the specified linked server. SRV_PRODUCT nvarchar( 128 ) Product name of the linked server. SRV_DATASOURCE nvarchar( 4000 ) OLE DB data source property corresponding to the specified linked server. SRV_PROVIDERSTRING nvarchar( 4000 ) OLE DB provider string property corresponding to the linked server. ...