I have a vb.net app designed to automaticlly deploy table/stored procedure scripts to a designated SQL Server 2000 database that worked great with SQL 2000 but now gives the following error message when trying to run on SQL Server 2008:
This SQL Server version (10 0) is not supported
The code is:
Dim server As New Microsoft.SqlServer.Management.Common.ServerConnection(connection)
Me.CurrentTask.Text = reader(0).ToString
strFileContents = My.Computer.FileSystem.ReadAllText(reader(0).ToString)
It gives the error on the line above at: server.ExecuteNonQuery(strFileContents)
I've tried to do searches; but haven't found any solution that seems to work - please let me know if I've overlooked the solution here.
Thanks for any help.