.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
Gaurav Pal
Post New Web Links

ERROR: The version of SQL Server in use does not support datatype 'date'.

Posted By:      Posted Date: May 22, 2011    Points: 0   Category :

I receive the subject error when I attempt to update a simple SQL database that I've created in Visual Web Developer 2005 Express Edition.  I also have SQL Server 2005 Express Edition installed.  I'm running XP SP3.


The database has one table called Customers with the following 5 fields: CustomerID (int) & primary key, FirstName (varchar(50)), LastName (varchar(50)), CreditLimit (smallmoney) and CustomerSince (smalldatetime).  I've added about a dozen records to the table.


I can display the table in the web site and select records.  However, after I add editing and deleting and attempt to update an edited record I receive the subject error which is pasted at the end of this question.  Thinking my installation of SQL Server 2005 was the problem, I uninstalled and reinstalled.  Still got the error.


NOTE:  I have created the same database on a virtual machine also running XP SP3 with the Express Edition products mentioned above.  The table updates with no error.


So I'm thinking the error message is probably not directly related to a SQL problem but some system problem that is on my host computer but not on my virtural machine.


Any ideas?

View Complete Post

More Related Resource Links

Transactional Publication With Article Using DATE Datatype Causes Snapshot Agent to Fail with Error

So I am using SQL Server 2008 Enterprise Edition (64Bit) and have run into a strange problem that is baffling me. I have two tables that I need to replicate.  They are identical in specification except the name (one is for monthly stats and one daily stats) CREATE TABLE [dbo].[statsDailyLite]( [EntryDate] [date] NOT NULL, [SetID] [int] NOT NULL, [ProductID] [smallint] NOT NULL, [Hooks] [int] NOT NULL, [AdViews] [int] NOT NULL, [Clicks] [int] NOT NULL, [UAdViews] [int] NOT NULL, CONSTRAINT [PK_statsDailyLite] PRIMARY KEY CLUSTERED ( [EntryDate] ASC, [SetID] ASC, [ProductID] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, FILLFACTOR = 90) ) GO CREATE TABLE [dbo].[statsMonthlyLite]( [EntryMonth] [date] NOT NULL, [SetID] [int] NOT NULL, [ProductID] [smallint] NOT NULL, [Hooks] [int] NOT NULL, [AdViews] [int] NOT NULL, [Clicks] [int] NOT NULL, [UAdViews] [int] NOT NULL, CONSTRAINT [PK_statsMonthlyLite] PRIMARY KEY CLUSTERED ( [EntryMonth] ASC, [SetID] ASC, [ProductID] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, FILLFACTOR = 90) ) GO They both conatin a thousand or so test rows of data, and they are both in a transactional publication going to another SQL 2008 box. Now when the tables are empty

Does MOSS 2007 Support SQL Server 2008 R2 RTM version?

Hi, We have MOSS 2007 SP1 databases in SQL Server 2005 EE x64 with SP3. Now, we want to upgrade the SQL Server 2005 to SQL server 2008 R2 EE x64 RTM version. Does MOSS 2007 Support SQL Server 2008 R2 RTM version? If yes, please take me to the MS link where I can find this information. Thanks

sql server doesn't support version

The database DATABASE.MDF cannot be opened because it is version 655. This server supports version 611 and earlier.  A downgrade path is not supported.Could not open new database 'DATABASE.MDF'. CREATE DATABASE is aborted. 

MS Message Queueing 4.0 HTTP Support - 500 Internal Server Error

Hi all,   I've been trying to set up MSMQ 4.0 with HTTP Support to allow one of our partners to send messages to us. However, whenever I make any call to the msmq page I get an internal server error 500 (See below). My platform is Windows 2008 SE (64-bit) running as a DC (though MSMQ is running in workgroup mode).   Any hints on what might be causing this or how I can investigate further? Are there any log files for the ISAPI extension, or the MQISE.dll, or the MSMQ service that might help me shed light on this problem?   I've seen blogs about an issue with MSMQ 3.0 where the machine name can't be 15 characters long, is this still the case with MSMQ 4.0?   The error details are as below,     Server Error in Application "WWW.MYDOMAIN.COM/MSMQ" Internet Information Services 7.0 HTTP Error 500.0 - Internal Server Error There is a problem with the resource you are looking for, so it cannot be displayed. Detailed Error Information  Module IsapiModule Notification ExecuteRequestHandler Handler AboMapperCustom-113521 Error Code 0x8007007e Requested URL http://www.mydomain.com:80/msmq Physical Path c:\inetpub\www.mydomain.com\msmq Logon Method Anonymous Logon User Anonymous The path to the ISAPI Filter is incorrect. IIS received the request; however, an internal error occurred during the processing

Error - The evaluation period for this version of SharePoint Portal Server has Expired

I am using SharePoint Portal Server 2003 and in the app log I'm seeing this error "The evaluation period for this version of SharePoint Portal Server has Expired" which I believe is causing the search service to not work and I can no longer sign in to the SP central admin console. While I did not perform the install myself it has been running for over a year and according to MS the SP PS 2003 eval was only 120 days so I assume the full version was installed.  Any idea's? There are a couple more errors in the event log but I assume they are symptoms and not causes. Event Type:    Error Event Source:    SharePoint Portal Administration Service Event Category:    None Event ID:    502 Date:        9/13/2010 Time:        9:05:03 AM User:        N/A Computer:    SP1 Description: An exception occurred in the search synchronizer. Event Type:    Error Event Source:    Service Control Manager Event Category:    None Event ID:    7023 Date:        9/13/2010 Time:        9:11:34 AM User:        N/A Computer:    SP1 Description: The Microsoft Shar

after restoring content database getting error (HTTP/1.1 200 OK Server: Microsoft-IIS/7.5 Date: Tue,

Hi All, Problem i have taken backup of Old site content database procedure see below 1) first i changed the database to read only mode (Opened SQL Server2005-->selected DB--> properties--> Option-->Database Read-Only=True) 2) taken backup of database from the task--Backup(new.bak) 3) Copied the taken backup to new server and restored (Opened SQL Server2005 --> Right Click on Database Folder--> Restore Dataase) In To database: ihave given DB name From Device: i have selected database from the location where i have saved. click ok.  It has restored successfully 4) I have created a new webapplication and removed its content database from central admin. 5) with the help of stsadm command i restored the above db to this webapplication. then iam getting below error: HTTP/1.1 404 Connection: close Date: Tue, 14 Sep 2010 06:20:08 GMT Server: Microsoft-IIS/6.0 X-Powered-By: ASP.NET MicrosoftSharePointTeamServices: i have refered the below url for restoring http://metahat.blogspot.com/2008/11/backup-restoring-sharepoint-2007-site.html Please help. Thanks in advance.



Reporting Services Error-The version of the report server database is either in a format that is not


 Hi,I have Configured All Reporting SErvices Through Rep Serv Configuration Wizard


When I type 


on top of Address Bar Of Browser I Am Gettin This Error

  • The version of the report server database is either in a format that is not valid, or it cannot be read. The found version is 'Unknown'. The expected version is 'C.0.8.40'. To continue, update the version of the report server database and verify access rights. (rsInvalidReportServerDatabase)
PLease Help Me


SQL Server 2008 r2 - Setup support files - Install error / reading from file


I'm installing SQL server 2008 r2 on a Win2003 R2 x86 system.

After i start the setup, the "setup support files" box begins installing, after a while i get this error:

"Error reading from file f:\1033_ENU_LP\x86\setup\sqlsupport_msi\PFiles\SqlServr\100\Setup\ewbfphdh\x86\Patch\rs2000.msp verify that the file exists and that you can access it."

I've tried another DVD, i've tried a mounted share on another machine...no go....i've tried an ISO file mounted on this server... same error.

Is there any way i can install this "setup support files" from another location? (download)

Is there a switch soo it won't install reporting services? (...i think this file rs2000.msp is from reporting services)





Date picker shows "Server Error"

Out of the blue, the standard date picker in default SP forms (not InfoPath) show a server error instead of the current date in a month view. Anyone seen this before?

'TDS Protocol stream is not valid' error when running SQL Server 2008 with jdbc driver of version


I am using SQL Server 2008 on Windows Server 2008 R2 and one of our servers running as a windows service (on Windows Server 2008 R2) contacts the SQL Server 2008 in a timely fashion to get some information. During one of these runs, we encountered the following error logs in the service logs and thereby we took a hit in serving client requests. The jdbc jar that is used for database connectivity is of version 3.0 (sqljdbc.jar).


I can provide more details on this issue. Can someone please let us know why this can be occurring ? Just so you know, the set of errors repeats itself after sometime although on a different JDBC Connection (with different ConnectionID). We have a reconnection algorithm running in case the JDBC Connection is lost for some reason (but I would be surprised if this issue relates to the re-connect algorithm).


INFO   | jvm 1    | 2011/02/28 22:26:54 | Feb 28, 2011 10:26:54 PM com.microsoft.sqlserver.jdbc.TDSParser throwUnexpectedTokenException
INFO   | jvm 1    | 2011/02/28 22:26:54 | SEVERE: TDSReader@4686d ( ConnectionID:25 TransactionID:0x0000000000000000): FetchBufferTokenHandler: Encountered unexpected TDS_RET_STAT (0x79)
INFO   | jvm 1    | 2011/02/28 22:26:54 | Feb 28, 2011 10:26:54 PM com.microsoft.sqlserver.jdbc.TDSReade

My Site not accessible, getting error "The evaluation version of Microsoft Office SharePoint Server


I am facing this problem from last couple of days and I am not able to figure out the root cause or find some solution. When I try to access My Site. It gives "The evaluation version of Microsoft Office SharePoint Server 2007 for this server has expired" error.

I tried creating different web application for my site, and created the root site collection by selecting MySite Host template. After site collection creation when tried accessing it ended up in same error. but when i tried creating site collection of different template it worked. Only for My Site I am getting that error.

I have tried all options mentioned in the below URLs. still not able to resolve.




Error on upgrading from SQL Server 2005 to 2008 R2 from version 628 to version 629

We having dificulties in restoring a SQL Server backup from 2005(x86) to 2008 R2(x64). We used a typical backup/restore combination to a file. After importing data (aprox. 90GB), it gets to 100%, and then an error appears:

8631 - Internal error: Server stack limit has been reached. Please look for potentially deep nesting in your query, and try to simplify it.

We think the problem is related to a problem in one of the upgrade steps:

This is the output:
10 percent processed.
20 percent processed.
30 percent processed.
40 percent processed.
50 percent processed.
60 percent processed.
70 percent processed.
80 percent processed.
90 percent processed.
100 percent processed.
Processed 11289048 pages for database 'My_Database', file 'FILE_Data' on file 1.
Processed 188 pages for database 'My_Database', file 'FILE_Log' on file 1.

Converting database 'My_Database' from version 611 to the current version 661.
Database 'My_Database' running the upgrade step from version 611 to version 621.
Database 'My_Database' running the upgrade step from version 621 to version 622.
Database 'My_Database' running the upgrade step from version 622 to version 625.
Database 'My_Database' running the upgrade step from version 625 to version 626.

Essential SQL Server Date, Time and DateTime Functions

The essential date and time functions that every SQL Server database should have to ensure that you can easily manipulate dates and times without the need for any formatting considerations at all.

Date/Time Conversions Using SQL Server

There are many instances when dates and times don't show up at your doorstep in the format you'd like it to be, nor does the output of a query fit the needs of the people viewing it. One option is to format the data in the application itself. Another option is to use the built-in functions SQL Server provides to format the date string for you.

SQL Server Date Formats

One of the most frequently asked questions in SQL Server forums is how to format a datetime value or column into a specific date format. Here's a summary of the different date formats that come standard in SQL Server as part of the CONVERT function. Following the standard date formats are some extended date formats that are often asked by SQL Server developers.

Sys.Net.WebServiceFailedException: The server method '' failed with the following error:



Let's say we have 2 time consuming functions, aaa and aaa1 inside a aspx page.

        public static string aaa(int i)
            return i.ToString();

        public static string aaa1(int i)
            return i.ToString();



        <asp:ScriptManager ID="ScriptManager1" runat="server" EnablePageMethods="true">
        <span id="displayspan"></span>
        <br />
        <input type="button" value=
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend