2007-05-29 Nagappan A * SqlCommand.cs (Dispose): Command.Dispose closing connection. Fixes bug # 81710. Thanks to AMC for the fix. 2007-05-10 Nagappan A * SqlClientMetaDataCollectionNames.cs: Fixed incorrect constructor type. * SqlConnectionStringBuilder.cs: Fixed missing attributes. 2007-05-09 Igor Zelmanovich * SqlConnectionStringBuilder.cs: added MonoNotSupported attribute. 2007-04-03 Amit Biswas * SqlDataReader.cs (GetSqlBytes, GetProviderSpecificFieldType) (GetProviderSpecificValue, GetProviderSpecificValues): Implemented missing API. * SqlParameter.cs (XmlSchemaCollectionDatabase): Implemented missing property (XmlSchemaCollectionName): Implemented missing property (XmlSchemaCollectionOwningSchema): Implemented missing property (SourceColumnNullMapping): Existing implementation was not correct, Replaced the implementation (.ctor): Implemented mising constructor new in .net 2.0 * SqlErrorCollection.cs (CopyTo): Implemented missing API * SqlParameter.cs (InferSqlType): Corrected bug related to default values of SqlDbType and DbType (ResetSqlDbType): Implemented missing API (ResetDbType): Implemented missing API 2007-03-09 Amit Biswas * SqlParameterCollection.cs (CopyTo): Implemented missing API 2007-04-02 Nagappan A * SqlParameter.cs: Variable name fix. 2007-03-20 Nidhi Rawal * SqlClientFactory.cs: Added two using directives. (CreateConnectionStringBuilder): Implemented the method. (CreatePermission): Implemented the property. * SqlCommand.cs: Added one using directive. (Clone): Implemented the method. (Dispose): Implemented the method. (BeginExecuteXmlReader): Implemented the method. * SqlCommandBuilder.cs (QuoteIdentifier): Implemented the method. (UnquoteIdentifier): Implemented the method. * SqlConnection.cs (ChangePassword): Implemented the method. 2007-03-19 Nidhi Rawal * SqlClientFactory.cs (CanCreateDataSourceEnumerator): Implemented the property. * SqlCommand.cs (Notification): Implemented the property. (NotificationAutoEnlist): Implemented the property. * SqlDataReader.cs (VisibleFieldCount): Implemented the property. * SqlConnectionStringBuilder.cs (TrustServerCertificate): Implemented the property. (TypeSystemVersion): Implemented the property. (UserInstance): Implemented the property. (ContextConnection): Implemented the property. * SqlConnection.cs (FireInfoMessageEventOnUserErrors): Implemented the property. (StatisticsEnabled): Implemented the property. * SqlDataAdapter.cs (UpdateBatchSize): Implemented the property. * SqlParameter.cs: Implemented one attribute. 2007-03-16 Andreia Gaita * SqlParameter.cs: Move isVariableSizeType flag to TdsMetaParameter so that the TdsMetaParameter can validate itself for valid size / values. * SqlCommand.cs (Execute): Call Validate on TdsMetaParameter. 2007-03-14 Nagappan A * SqlCommand.cs (CommandType): Exception type thrown in 2.0 profile is different than 1.0, ArgumentOutOfRangeException. (Connection): Exception type thrown in 2.0 profile is different than 1.0, ArgumentOutOfRangeException. (Execute): If Size property is 0 for String and Binary type, then throw InvalidOperationException. (ValidateCommand): Exception type thrown in 2.0 profile is different than 1.0, NullReferenceException. 2007-03-09 Nagappan A * SqlDataReader.cs: Fixed syntax erros reported in class status page. 2007-03-09 Andreia Gaita * SqlCommand.cs (ExecuteScalar): Fix returned value for stored procedure calls to return the first column of the first row produced by the proc. 2007-03-08 Nagappan A * SqlCommand.cs (CloseDataReader): Checks whether the SQL connection is created or not. 2007-03-07 Andreia Gaita * SqlCommand.cs (ExecuteScalar): when calling stored procedures, implement support for return of output values in the parameter collection. 2007-02-16 Nidhi Rawal * SqlParameter.cs (CompareInfo): Implemented the property CompareInfo. (LocaleId): Written the property LocaleId. (SqlValue): Written the propert SqlValue. 2007-02-15 Nidhi Rawal * SqlCommand.cs: Added some attributes which were not implemented for .NET 2.0 and removed extra attribute which are not there in .NET 2.0. * SqlCommandBuilder.cs: Added some attributes that were not implemented for .NET 2.0. * SqlParameterCollection.cs: Added some attributes that were not implemented for .NET 2.0. * SqlConnectionStringBuilder.cs: Added some attributes that were not implemented for .NET 2.0. * SqlConnection.cs: Added attribute that was not implemented for .NET 2.0. * SqlParameter.cs: Added some attributes which were not implemented for .NET 2.0 and removed some extra attributes which are not there in .NET 2.0 2007-02-09 Nagappan A * SqlConnection.cs (SetConnectionString): Fixes bug # 80712. A small typo. 2007-01-08 Nagappan A * SqlTransaction.cs (Dispose): Fixed compliation warning. * SqlDataReader.cs (GetValues): Length of elements to be copied was decided based on the argument array passed, which caused a bug, if the length of given array is more than actual column values. * SqlCommandBuilder.cs (CatalogSeparator, SchemaSeparator) (CatalogLocation): Implemented missing properties. (CreateDeleteCommand, CreateInsertCommand, CreateUpdateCommand): Modified private methods to take bool flag. If true, add actual parameter name instead of p1, p2 etc. (CreateParameter): Added overloaded private method to create parameter with the actual column name. (GetUpdateCommand, GetDeleteCommand, GetInsertCommand): Implemented missing overloaded methods. (SetRowUpdatingHandler): Implemented missing protected method. * SqlCommand.cs: Fixed compilation warning. Removed bogus MonoTODO's. 2006-12-05 Nagappan A * SqlCommand.cs (Execute): If sql2 length is greater than 0, then add ';' and the respective sql2 string and then execute the string. Fixes bug # 79880. 2006-08-30 Nagappan A * SqlConnection.cs: Implemented SqlConnection.GetSchema (). 2006-09-08 Konstantin Triger * SqlClientFactory.cs: implemented SqlClientFactory.CreateConnection (). 2006-07-13 Senganal T * SqlClientFactory.cs SqlCommand.cs SqlConnectionFactory.cs SqlClientPermission.cs SqlParameterCollection.cs SqlDataReader.cs SqlConnection.cs SqlParameter.cs SqlTransaction.cs : 2.0 Api fixes 2006-05-31 Gert Driesen * SqlConnection.cs: Removed extra destructor, as destructor on System.ComponentModel.Component already calls Dispose. * SqlParameter.cs: Removed explicit interface implementation of IDataParameter.ParameterName. 2006-05-26 Senganal T * SqlParameter.cs : - InferSqlType : if value is null or DBNull.Value, retain the current parameter type. 2006-04-18 Senganal T * SqlConnection.cs : - SetConnectionString : set the pareameter to default values if connection string is empty or null - Open : Raise InvalidOperationException if Connection String is empty or null - Dispose : Test exception not raised if dispose called on a connection with empty connection string slight modification of the patch by Jonel Rienton 2006-04-07 Senganal T * SqlCommandBuilder.cs : * CreateDeleteCommand () * CreateUpdateCommand () * CreateInsertCommand () - Changed the signature. Do not need DataRow parameter as the Query generated is parametric. - Correct the null-check term in the WhereClause, set the correct properties for null-check parameter fixes #78027 - Modified the generated query to match the query as generated by 2.0. We now ignore null-check in the whereclause if the Column does not allow nulls. * ctor () : Set QuotePrefix and QuoteSuffix for 2.0 profile * GetUpdateCommand () * GetInsertCommand () * GetDeleteCommand () - Do not create new command everytime. Create only if not already created. * RefreshSchema : Reset the commands. 2006-02-17 Chris Toshok * SqlCommand.cs, SqlCommandBuilder.cs, SqlConnection.cs, SqlDataAdapter.cs: remove DataSysDescription attributes for >= 2.0 2006-02-17 Chris Toshok * SqlDataReader.cs: remove VisibleFieldCount property. 2006-02-10 Senganal T * SqlDataReader.cs : - GetBytes : Read binary/blob/clob data sequentially when CommandBehavior is set to SequentialAcccess - GetChars : Read String/clob data sequentially when CommandBehavior is set to SequentialAccess * SqlCommand.cs : - ExecuteReader : set SequentialAccess property on TDS - CloseDataReader : Reset the command behavior 2006-01-27 Senganal T * SqlCommandBuilder.cs : - Modified CreateUpdateCommand,CreateDeleteCommand , to not include column name in the query if its a expression col. Also, modified the queries to match the generated queries in ms.net * SqlCommand.cs : - Modifed Prepare, to check if Parameter is explicitly initialized * SqlParameter.cs : - Added CheckIfInitialized : Checks if datatype is explicitly set and non-zero size is set for variable datatypes. * SqlDataReader.cs : - Added code for GetSqlBinary () - Fixed GetFieldCount () - Added more checks and exceptions. 2006-01-17 Senganal T * SqlCommandBuilder.cs - Modified CreateNewCommand () : Clean up any existing parameter list before reusing the command.Fixes #77225 2005-11-24 Senganal T * SqlConnection.cs - Modifications to get the correct Packet Size 2005-11-21 Senganal T * SqlClientFactory.cs * SqlCommandBuilder.cs * SqlParameterCollection.cs * SqlDataReader.cs * SqlDataAdapter.cs * SqlParameter.cs * SqlTransaction.cs Added stubs and other changes for ADO.NET 2.0 compatibility 2005-11-12 Gonzalo Paniagua Javier * SqlConnection.cs: don't throw NotImplementedException when using 'PERSIST SECUTIRY INFO'. Just do nothing. 2005-10-27 Senganal T * SqlCommand.cs * SqlDataReader.cs Made changes so that the number of rows affected can be got directly from Tds regardsless of the type of query.Fixes bug #75698 2005-10-19 Senganal T * SqlConnection.cs (SetProperties) : - Added support for AttachDBFileName 2005-10-19 Senganal T * SqlException.cs (Constructor) - Modified the constructor, so that the message parameter of base class is not the same as that of the Exception message. fixes bug #76468 2005-09-24 Sureshkumar T * SqlParameterCollection.cs (AddWithValue): added method. patch from awaddell@fnfr.com (Andy Waddell). 2005-09-21 Senganal T * SqlConnection.cs : - Set the correct Default Values for Parameters. - Added Argument Checks (where missing) for the Properties and throw the correct exception on error. - Modified SetDefaultParameters() to make sure that the parameters are all reset to default values everytime it is called. - Modified SetProperties() to take into account the order of the keywords in the ConnectionString. SqlConnection Fixes for the failing sqlserver connected-mode testcases in ProviderTest/System.Data.SqlClient/SqlConnectionTest.cs 2005-09-21 Senganal T * SqlTransaction.cs : Modifed the Rollback() method, so that connection can be used for another transaction after the previous transaction is rolled back. fixes bug 75904 2005-09-02 Umadevi S * Removed SqlResultSet.cs file 2005-08-26 Sureshkumar T * SqlConnection.cs (Open): enable sp_reset_connection. 2005-08-25 Sureshkumar T * SqlCommandBuilder.cs: BuildInformation (): continue on columns who don't have basetablename. 2005-08-12 Daniel Morgan * SqlCommandBuilder.cs: update command builder based on OdbcCommandBuilder latest changes to fix regression of bug 75552 2005-08-05 Sureshkumar T * SqlCommandBuilder.cs: Set SourceVersion property to the created parameters as it is used by the Adapter's Update method. 2005-07-22 Sureshkumar T * SqlCommandBuilder.cs, SqlParameterCollection.cs, SqlConnection.cs, SqlParameter.cs: - updated attributes & attribute descriptions to match with masterinfos. 2005-07-16 Daniel Morgan * SqlCommandBuilder.cs: CreateUpdateCommand should get the current value, not the orginal value when setting one of the SET variables 2005-07-15 Sureshkumar T * SqlCommandBuilder.cs: - set_DataAdapter: unsubscribe event if DataAdapter is reset. - CreateInsertCommand, CreateUpdateCommand, CreateDeleteCommand: if column mapping is missing, use the source column name. use proper version to get the data. - RowUpdatingHandler: set status to continue to actually process the query. 2005-07-04 Ben Maurer * SqlError.cs: Patch from dezelin@gmail.com to fix serialization. 2005-06-29 Sureshkumar T * SqlConnection.cs: Open (): catch TdsInternalException and throw SqlException. * SqlException.cs: code re-organised to pass message as well with the exception. 2005-06-23 Sureshkumar T * SqlConnectionStringBuilder.cs: simplified multiple keyword mappings and allowed-key checking. fixed Item, Remove, ContainsKey, ShoudSerialize, TryGetValue implementations. 2005-06-21 Sureshkumar T * SqlConnectionStringBuilder.cs: Connection String Builder class for SqlClient Data Provider. 2005-06-01 Gonzalo Paniagua Javier * SqlParameter.cs: moved the 'using S.D.SqlTypes' out of NET_2_0. Fixes the build. 2005-06-01 Sureshkumar T * SqlParameter.cs: Parameter's value can be SqlTypes. Convert to framework type to pass to TDS layer. Fixes bug #75044. 2005-05-24 Umadevi S * fixed some 2.0 and 1.0 specific fields/attributes for various classes. * Added SqlClientMetaDataCollectionNames.cs, Implemented some 2.0 properties for SqlParameterCollection for the bulkcopy feature. 2005-05-20 Kornél Pál * Fixed Bug #53169 - SqlDataReader incorrectly returns bigint as decimal Note: The fix works around the limitations of TDS 7.0 to avoid this difference between Mono and .NET Framework TDS 8.0 should be used instead. 2005-05-20 Umadevi S * Fixed Bug 74948 - SqlParameter also takes DBNull Value. Correct some attributes stuff of 1.1 and 2.0 for SqlParameter.cs 2005-05-20 Umadevi S * Continuing on implementation for bulkcopy and notification Added files SqlNotificationEventArgs.cs, OnChangeEventHandler.cs Modified SqlRowUpdatingEventArgs.cs 2005-05-19 Umadevi S * For implementation of bulkcopy and notifications added files SqlBulkCopyOptions.cs,SqlBulkCopyColumnMapping.cs,SqlNotificationAuthType.cs SqlNotificationTransports.cs,SqlRowsCopiedEventArgs.cs, SqlRowsCopiedEventHandler.cs 2005-05-19 Umadevi S * Corrected types,enum values of SqlNotificationType,SqlNotificationSource, SqlNotificationInfo and added new method in SqlRowUpdatingEventArgs.cs (For implementation of bulkcopy/notifications) 2005-04-19 Sureshkumar T * SqlDataReader.cs: NextResult (): Re-create schema table for each result set. don't re-use, as it may be referenced from somewhere. 2005-04-07 Sureshkumar T Ankit Jain * SqlConnection.cs: Implemented additional connection string property "Asynchronous Processing". * SqlCommand.cs: Implemented Asynchronous command execution API. * SqlAsyncState.cs: A internal state object for asynchronous operations. * SqlAsyncResult.cs: Added. Class to hold result for asynchronous queries. 2005-03-28 Sureshkumar T * SqlCommand.cs: Execute: Add a semicolon at the end of CommandText. Multiple semicolon's are not being complained. fixes bug #74134. 2005-03-11 Gonzalo Paniagua Javier * SqlConnection.cs: added a finalizer for correct implementation of the IDisposable pattern. 2005-03-11 Gonzalo Paniagua Javier * SqlException.cs: make it serialization-compatible with MS. Patch by Aleksandar Dezelin. Closes bug #73596. 2005-03-08 Sureshkumar T * SqlDataReader.cs: Call base constructor with CommandBehavior parameter instead of passing DbCommand object. The internal base class with DbCommand Parameter is removed. 2005-03-07 Sureshkumar T * SqlCommand.cs : Set CommandBehavior on ExecuteReader,ExecuteScalar,ExecuteNonQuery. This is used in CloseDataReader. This fixes bug #73252. 2005-03-03 Sureshkumar T * SqlClientFactory.cs: While creating command, create using DbConnectionFactory as DbConnectionBase.CreateDbCommand needs to have a connection factory. * SqlConnection.cs: Added an internal constructor which takes DbConnectionFactory. * SqlConnectionFactory.cs: Added. Concrete class for abstract factory DbConnectionFactory. 2005-02-22 Sureshkumar T * SqlDataReader.cs: GetBytes: return the length of the data if output buffer is null. if not, copy the values to buffer and return the bytes actually read. 2005-02-02 Sureshkumar T * SqlConnection.cs: - Database: return db name from database if connection open, otherwise take from connection string. - Set default values for parameters in the constructor itself. - Dangling else problem with Close method. - reset values of parms (TdsConnectionParameters) rather setting to null. - set disposed to false in Open method - finally call base.Dispose in Dispose (bool) Fixes nunit regressions SqlConnectionTest:DefaultConnectionValues and SqlConnectionTest:DatabaseSynonyms. 2005-01-27 Sureshkumar T * SqlCommand.cs (DeriveParameters): Change parameter name to "procedure_name". * SqlParameter.cs (SqlParameter (object [])) : call default constructor to create Tds.Metaparameter. fixes bug #63122. 2005-01-03 Sureshkumar T * SqlCommand.cs: Fixed bug #68973. Reset Tds.RecordsAffected to 0 for each execute statement. 2004-11-25 Sureshkumar T These changes are for 2.0 profile only. These changes implement the generic data base access technique using Provider Factory Implementation. These classes need to be dervided from abstract base classes so that the corresponding factory classes are created when calling CreateCommand, CreateParameter, etc. * SqlClientFactory.cs: Provider Factory class Implementaion for SqlServer * SqlParameter.cs: Change base classes and override methods. * SqlParameterCollection.cs: Change base classes and override methods. * SqlTransaction.cs: Change base classes and override methods. * SqlDataSourceEnumerator.cs: DataSource Enumerator stubs. * SqlDataReader.cs: Change base classes and override methods. * SqlConnection.cs: Change base classes and override methods. * SqlCommandBuilder.cs: Change base classes and override methods. * SqlCommand.cs: Change base classes and override necessary methods. 2004-10-14 Umadevi S * SqlCommand.cs - Implemented the clone method correctly. (fixed bug 67301) 2004-10-06 Umadevi S * ISqlNoticationReceiver.cs - changed namespace * Added files SqlNotificationType.cs, SqlNotificationInfo.cs, SqlNotificationSource.cs 2004-09-24 Umadevi S * SqlTransaction.cs - Dispose will not call rollback incase the transaction is not open. 2004-09-14 Sebastien Pouliot * SqlClientPermission.cs: Added internal constructor accepting an Sql ClientPermissionAttribute parameter (using base class protected ctor). * SqlClientPermissionAttribute.cs: Copy now use the new SqlClient Permission constructor. 2004-09-13 Sebastien Pouliot * SqlClientPermission.cs: Mostly completed (needs tests). * SqlClientPermissionAttribute.cs: Completed. 2004-09-02 Umadevi S * SqlCommand.cs - ExecuteNonQuery to return -1 incase of executing a storedprocedure 2004-08-16 Gert Driesen * SqlConnection.cs: added TODO on ConnectionString for keywords that are not yet implemented. check value of Integrated Security keyword, check value of bool keywords, improve error reporting for int keywords, added support for the following keyword synonyms : APP, TIMEOUT, NETWORK, PERSISTSECURITYINFO, WSID, LANGUAGE, USER. Throw NotImplementedException when encrypt keyword is set to true, enlist keyword is set to false or attachdbfilename keyword (or one of its synonyms) is set. Added FIXME for PERSIST SECURITY INFO keyword, throwing a NotImplementedException here would break lots of apps 2004-08-16 Gert Driesen * SqlConnection.cs - spaces to tabs 2004-08-12 Sureshkumar T * SqlDataReader.cs - In Close method, the remaining resultsets are drained out, to read output parameters & to avoid stream overlap 2004-06-30 Umadevi S * SqlCommand.cs : In the Execute Method the commandbehavior parameters were ignored correct these 2004-06-22 Atsushi Enomoto * SqlCommandBuilder.cs : Avoid cast exception caused by DbNull. 2004-06-18 Umadevi S * SqlCommand.cs - ExecuteNonQuery returns -1 in all cases except insert,update or delete. 2004-06-18 Umadevi S * SqlConnection.cs - handled null being passed as a connectionstring - checked for minimal set of parameters in connectionstring. - handled unrecogonized keywords similar to MS.NET 2004-06-17 Umadevi S * SqlTransaction.cs - fixed multiple rollbacks being called causes invalidoperationexception 2004-06-04 Gert Driesen * SqlClientPermission.cs: removed extra CreateInstance method 2004-06-02 Gert Driesen * SQLDebugging.cs: added missing attributes, marked ctor public to match MS.NET 2004-05-22 Atsushi Enomoto * SqlClientPermission.cs : don't use chained obsolete .ctor. 2004-05-20 Gert Driesen (drieseng@users.sourceforge.net) * SqlClientPermissionAttribute.cs: change AllowMultiple and Inherited to match .NET 2004-05-20 Umadevi S * Fixed bug 58406- implemented the hasrow method, test program used to test with the bug report 2004-05-13 Umadevi S * SqlClientPermission.cs, SqlDataReader.cs - added missing methods with TODO tags * SqlCommand.cs, SqlDataAdapter.cs - implemented ToolboxItemAttribute * SQLDebugging.cs - Added new file with a TODO tag 2004-04-05 Lluis Sanchez Gual * SqlConnection.cs: Use connection pool implemented in Mono.Data.Tds. 2004-04-01 Lluis Sanchez Gual * SqlDataReader.cs: Null values are now represented with DBNull instances. Deal with this. 2004-03-14 Tim Coleman * SqlCommand.cs SqlConnection.cs: Changes from two patches by Andres Taylor 2004-03-12 Andreas Nahr * SqlParameter.cs: DO NOT USE the consts scheme if types can be referenced directly! 2004-01-10 Atsushi Enomoto * SqlClientPermission.cs : Fixed NET_2_0 build related to obsolete attribute problem (see DbDataPermission.cs) 2003-12-28 Tim Coleman * SqlResultSet.cs: Stubbed out this class. 2003-12-23 Tim Coleman * SqlConnection.cs: Improved connection string parsing. See System.Data.Common.DbConnectionString for source. 2003-12-21 Tim Coleman * SqlConnection.cs: Enable Integrated Security 2003-12-19 Tim Coleman * ISqlNotificationReceiver.cs SqlResultSet.cs: New stubs added * SqlClientPermission.cs: Fix constructor for 1.2 2003-12-04 John Luke * SqlXmlTextReader.cs: applied patch from Chris Masters fix peek so it checks if it is at the end and also to make sure that if Read() advances the position past the end of the localBuffer array, it makes a call to GetNextBuffer(). fixes bug #40253 System.IndexOutOfRangeException when using SqlCommand.ExecuteXmlReader() 2003-11-20 Joerg Rosenkranz * SqlConnection (SetDefaultConnectionParameters): Changed default value of WORKSTATION ID to reflect real host name instead of "localhost". 2003-11-16 Ben Maurer * SqlParameterCollection.cs (Clear): Clear needs to take the parameter out of the collection so that it can be used again. (Remove): (RemoveAt): Ditto. 2003-10-03 Diego Caravana * SqlCommand.cs: no change. * SqlConnection.cs (Close): Added checks for null instance variables. * SqlParameter.cs (Direction): Now handles parameters of type ReturnValue and InputOutput. * SqlParameterCollection.cs (IndexOf(string)): Search for SqlParameter object in list is done by obtaining ParameterName attribute, not directly through list.IndexOf(). 2003-08-22 Duncan Mak * SqlCommand.cs (ExecuteNonQuery): Return Connection.Tds.RecordsAffected if it is successful. Patch from Jörg Rosenkranz . This is part of a fix to bug #40315. 2003-08-20 Duncan Mak * SqlConnectionPool.cs (ReleaseConnection): A patch from Joerg Rosenkranz . Currently, if a connection is closed by an external event (network problem, etc.) it is pushed back into the connection pool. The next Open call retrieves this invalid connection which leads to exceptions when executing statements. This patch fixes this problem. This closes bug #47429. 2003-07-04 Miguel de Icaza * SqlDataReader.cs: Added extra information to the exceptions thrown by all the GetXXXX methods. 2003-03-15 Daniel Morgan * SqlConnection.cs: if Server in the ConnectionString is set to "(local", use "localhost" as the hostname to connect 2003-03-04 Gonzalo Paniagua Javier * SqlException.cs: implemented GetObjectData (). 2003-02-16 Daniel Morgan * ChangeLog: added this file * SqlConnection.cs: - parse data source for 3 possible uses: "Server=hostname", "Server=hostname\\instancename", "Server=hostname,port" and open the connection based on the resulting server name and port. - Added support for named instances by discovery of the sql server tcp port via the sql monitor (udp port 1434) thanks to Phillip Jerkins (Phillip.Jerkins@morgankeegan.com) contribution. Also, thanks to Gonzalo and Tim for their help with timeouts.