Fatal Error 682 And SqlCacheDependency

Hello,



I have tried two ways for executing a query and creating a dependency

on it, one using plain Sql commands, the other using Enterprise

Library wrapped commands.



I keep getting:



Warning: Fatal error 682 occurred at Oct 12 2007 11:01AM. Note the

error and time, and contact your system administrator.



string xml = cmd.ExecuteScalar() as string;



When I execute it. Does anyone know what could cause this.



I have read both of these posts and have not yet been able to

investigate the SQL machine's event viewer though:



http://forums.asp.net/p/959871/1188606.aspx#1188606



http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1203630&SiteID=1



The "value" column is an XML datatype field.



Thanks,

Josh







        public static ContentXmlUtilResult GetContentXml(

            string key,

            bool createDependency)

        {

            ContentXmlUtilResult result = new ContentXmlUtilResult();



            string connString = Global.Current.ConnectionString;



            using (SqlConnection conn =

                new SqlConnection(connString))

            {

                SqlCommand cmd =

                    new SqlCommand(

                        "SELECT Value FROM dbo.ContentXml WHERE [Key]

= '" + key + "'",

                        conn);



                if (createDependency)

                {

                    System.Web.Caching.SqlCacheDependency dependency =

                        new SqlCacheDependency(cmd);



                    result.Dependency = dependency;

                }



                conn.Open();



                string xml = cmd.ExecuteScalar() as string;



                conn.Close();



                result.Content = xml;

            }



            return result;



            //SqlCommand cmd = (SqlCommand)

            //    Global.Current.Database.GetSqlStringCommand(

            //    //@"SELECT Value FROM dbo.ContentXml WHERE [Key] =

@Key");

            //    @"SELECT Value FROM dbo.ContentXml WHERE [Key] = '"

+ key + "'");



            ////cmd.Parameters.Add("@Key", SqlDbType.VarChar).Value =

key;



            //if (createDependency)

            //{

            //    System.Web.Caching.SqlCacheDependency dependency =

            //        new System.Web.Caching.SqlCacheDependency(cmd);



            //    result.Dependency = dependency;

            //}



            //string xml = Global.Current.Database.ExecuteScalar(cmd)

as string;



            //result.Content = xml;



            //return result;

        }