Hello, I am currently running Visual Studio 2005, and I also have SQL Server 2005 Express Edition Advance series where I have FULLTEXTSEARCH working. I have just bought a new computer and I will like to install Visual Studio 2008 on it, what do I need to do in order for me to migrate my database to my new computer? Do I need to install a different SQL Server?
Thanks
Louis
I've enabled the Fulltextsearch in some Tables of my DB.
In SQL Server Management Studio the querys are all have results and running free of errors.
If i will use the same querys in VWD, they're running in a SqlException. Translated from german:
The Fulltextsearch cant be used in the Userinstance.
But a SelectCommand from the WebSite to the IndexState:
SELECT crawl_end_date FROM sys.fulltext_indexes WHERE fulltext_catalog_id = 10
works fine.
What i'm wrong?
The ConnectionString i'm using:
="Data Source=.SQLEXPRESS;AttachDbFilename=|DataDirectory|Support.mdf;Integrated Security=True;User Instance=True" providerName="System.Data.SqlClient"
The FulltextService (msftesql.exe) is running under a UserAccount.
Thanx
Klaus
Hello,
i am making a Fulltextsearch on MS SQL Server 2005 (indexed, with "Contains").
Because of performance reasons i am only showing the first 200 rows mssql finds ("select top 200...:").
Is there any possibility to get the estimated totalnumber of all rows? i have heard something that is possible to get this in mssql-server. The server then estimates how many rows with that searchword could be in the whole database. google i.e. makes the same thing....
is that true? what do i have to do to get this?
greetings and thx
cpt.oneeye
Hi all,
back in the day we switched to SQLServer2005, we had trouble with fulltextsearch stored procedures, it wouldn't work because in 2005, calling those stored procedure (like sp_fulltext_table) would automatically create a transaction.
The error is "procedure cannot be executed within a transaction"
So the fix was to call execute those stored procedures in autocommit mode.
It worked fine until switch from jDriver to jtds, while it was OK with jDriver, jtds is complaining that "commit() should not be called in autocommit mode"
To summarize :
if we don't set autocommit, the execution fails with the follwoing error
Got exception=[java.sql.SQLException: The procedure 'sys.sp_fulltext_table' cannot be executed within a transaction.] for sql=[sp_fulltext_table 'AttrsBlobTab', 'create', 'AttrsBlobTab_cat', 'ARIBAPK334']
if we do set autocommit, execution fails with an other error
Got exception=[java.sql.SQLException: commit() should not be called while in auto-commit mode.] for sql=[sp_fulltext_table 'AttrsBlobTab', 'create', 'AttrsBlobTab_cat', 'ARIBAPK204']
it seems like we can get around this with replacing stored procedures calls by DDL statements but it's really cumbersome in my case, I was wondering if there was a way to avoid this.
Any idea ?
Thanks,
Farid
There are a few features in the new SQL Server - Reporting Services that I really need in production. I have tested everything and it works great. I am running the CTP version since Microsoft is saying they aren't releasing the release version until 3rd quarter 2008.
Since Microsoft won't sell SQL 2008 until 3rd quarter, can I run the CTP in production until the release and then purchase SQL 2008?
Jim
when I try to make a sqldatasource with visual studio 2008 and SQLServer 2008 . I found that there are a message that the visual studio 2008 can support only SQLServer 2005 and SQLServer 2000how to make my visual studio 2008 support SQLServer 2008
View 1 Replies View RelatedHello!
Recently, I set up server with Windows Web Server 2008 RC1, SQL 2008 Express beta, .NET 3.5, IIS 7.
I'm running ASP.NET web application with SQL database. Everything works fine until the first application state on the server expires. After that, any postback that starts a new application state on the server and connects to the database, results in the following error:
Failed to generate a user instance of SQL Server due to a failure in starting the process for the user instance. The connection will be closed.
Is this a bug that will be fixed in release of Windows / SQL or am I doing something wrong?
Many thanks for help,
Jan
Hi all,
New to this so please be patient and please help.
I have developed an SQL 2005 Express command line option install for our company which has been working seamlessly for the last 18 months.
http://msdn2.microsoft.com/en-us/library/ms144259.aspx
I downloaded the €œMicrosoft SQL Server 2008 Express CTP, February 2008€? from http://www.microsoft.com/downloads/details.aspx?FamilyId=749BD760-F404-4D45-9AC0-D7F1B3ED1053&displaylang=en
I simply replaced the 2005 file €œSQLEXPR.EXE€? with the 2008 file €œ€?, recompiled the installation and tested only for it to fail. I than read the 2008 books online and noted the change in command line options.
http://www.microsoft.com/downloads/details.aspx?familyid=19DB0B42-A5B2-456F-9C5C-F295CDD58D7A&displaylang=en
http://msdn2.microsoft.com/en-us/library/ms144259(SQL.100).aspx
I then changed the command line to suit the Microsoft 2008 books online, recompiled the installation and tested only for it to fail once more.
Interestingly I tested the install from the default GUI and at the point of adding the €œsa€? login credentials it fails to allow the installation to proceed. Strangely by selecting the windows authentication credentials, €œnext€? than €œback€? it now allows me to add the €œsa€? login credentials and continues to install correctly as required.
I hope I have explained this clearly enough.
1. Is this a bug in the €œMicrosoft SQL Server 2008 CTP, February 2008€? installation?
2. If so is this causing the command line install options to fail?
3. How do I obtain a version of €œMicrosoft SQL Server 2008 Express€? that will work installing from the command line?
Thanks in advance.
Hello - does anyone have experience w/SQL Server 2005 in a virtual environment? I'm considering this for a production environment but not sure if performance will suffer. Our databases will have a lot of writing but not too much reading. A SSRS solution is currently the only app. connecting to the SQL db. Max users to server at any given time will be very low (~10 users max). But the databases are pulling in data from other, outside multiple data sources on a daily basis.
Any pointers to documentation or any advice?
Thanks,
A Brown
Hello,Is SQL Express 2008 already available for download? Where can I get it?Is it shipping already with VS 2008?Thanks,Miguel
View 5 Replies View RelatedHi All
Im trying out connecting to a SQL Server database.
Ive got a Web Application and have Dragged and Dropped a SQLDataSource on the page.
Ive Selected the "Configure Data Source" option on the component.
Ive then selected the "New Connection" button on the "Configure Data Soure - SQLDataSource1" pop-up window.
Choose Data Source Ive then selected the "Microsoft SQL Server" then pressed continue.
On the "Add Connection" Window Ive then:-
Selected the Server Name from the drop down list
Selected the "Use Windows Authentication"
Selected "Select or enter a database name" and put a path in like "C:DataMyDatabase.mdf"
then pressed the "Test Connection" and get "Test Connection Succeeded" (this is the same whether a DB path exists or not ???)
then pressed ok and the following message appears:-
"Unable to find the requested .Net Framework Data Provider. It may not be Installed"
Any ideas why ?
tia
Andrew
Hi this is srinivasa rao ,installation problem server configuraions sqlserver 2008 express edition username and password do not match the error
View 1 Replies View RelatedHi,
does anyone have some information about the further developments of bi in the next release SQL 2008? Does anyone have a kind of timetable for the release?
Thanks in advance,
hs
Howdy,
With SQL 2008 do out in the near future, I need to know the specs on SQL CE 2008.
I have been digging around on the net but it looks like mum is the word thus far... so I am going to ask you straight out.
Please give us all a taste of the spec for SQL CE 2008 including the following:
Will Linq be supported?
What Proc limit will be supported?
What DB size limit will be supported?
How many concurrent connections will be supported?
Will .net types be supported?
Will the new filestream type be supported?
One last question on SQL CE 2005. As I am sure you are aware - Server Manager (2005) will not pick up a sdf created with 3.5. Since we (the developers out there) have to wait for SQL CE 2008 for an unanounced amount of time, will you give a hot fix so we can look at a 3.5 sdf in Server Manager (2005)?
Thanks, Johnathan
Hi,
Can some one give some links for reporting and notification better explanation in sql 2008
Anyone know when about SQL 2008 will be released, trying to plan upgrades.
View 2 Replies View Relatedis there a version of SQL express 2008 ??
View 1 Replies View RelatedI want to use VWD 2008 and MS SQL 2005 with SP2 for my app.
I can't make a connection to a database !!!
I created a new mdf database using SQL Server Management Studio.
When I try to connect to the new database from VWD 2008 I get the following error :
An error has ocurred while establising a connection to the server.When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections.( provider SQL Network Interfaces,Error 26 - Error Locate Server/Instance Specified)
I read over the internet many articles about but still the same result.
From this link I followed every step :
http://www.sql-server-performance.com/faq/establishing_remote_connection_seetings_not_allow_remote_connection_p1.aspx
My SQL Server and SQL Server Browser are exempted by the firewall on the server machine. My SQL server and VWD are installed on localhost and allow remote connections are checked on database properties - connections and SQL Server Surface Area Configuration - local and remote connections.
What can I do?
Thank You !
Hello all,
I just wanted to share my happiness with the Microsoft's release of the new version of SQL Server 2008, MS SQL Server 2008 RC0.
You can download and install the evaluation versions from Microsoft Downloads.
http://download.microsoft.com/download/2/0/c/20cf6e18-0448-4e7b-8d8c-60a3c4802671/Download_Instructions_ENU.htm
I liked the new logo very much!
Eralper
MS SQL Server Articles
The best mail today was, witout doubt, the one from Grant Dickinson at Microsoft telling that SQL Server 2008 June CTP is available from the SQL Server (http://www.microsoft.com/sql/prodinfo/futureversion/default.mspx) pages at Microsoft. :)
It's time to play. :cool:
Hi all I have a question, has anyone tried the new ACT Premium 2008 apparently it runs off of SQL Server and can support 31-50 Users.
Has anyone tried it??
We are trying to get rid of Access and have a database that has a customizeable front end and will run off SQL Server 2005
Hello,
I just installed SQL Server 2008, i'm not certain if I am missing a step or theory...
just ran a simple command:
USE master
GO
For some reason, the process simply keeps on running.
Correct or incorrect statement, the results shouldnt appear any longer than a few seconds...
Does anyone know why this is taking a lot longer than it should?
I have a Actual_dt column that is a type of date. I am trying to get all the values from the table that have the date less than 2008/01/01.
Please help.
Thanks
I would like to buy SQL server 2008 book. I need it badly. would you please tell me where I can find it? thanks. and I look forward to hearing from you as soon as possible.
thanh
I just downloaded the SQL Server 2008 CTP. Anyone here check it outyet? Thoughts?
View 1 Replies View RelatedThe RTM bits provide an upgrade capability.
My first stab at this with a 450mb .sdf was illuminating.
The process grinds away, writes out the new .sdf and then, just as it completes and raises it's 'successfully completed' banner, it deletes the new .sdf!
Tried both with and without encryption. Made no difference. No, it's not in the recycle bin either, or anywhere else on the drive.
How cool of an upgrade feature is that?
Using VS2008 Pro installed on XP
SSCE team: Time to bring out a separate upgrade tool?
Dear Sirs.
I have Client Server Application
on Client Side i have .NET 1.1 WinForm Application
on Server Side i have SQL Server 2000
I'm using "OLE DB PROVIDER FOR SQL SERVER" for the Data Access
1)
I'd like to upgrade Server Side to SQL Server 2005 (I will copy same database with users to sql2005)
Should i update Clients to .NET 2.0 too ?
Do i need install Native Client Lib on Client ?
2)
when SQL Server 2008 is Relesed
Can i connect to it from .NET 1.1 Application ?
Thank you in Advance.
I installed VWD 2008 on my Vista Business. I had a lot of trouble installing SQL Express 2005 & SQL EXpress 2008 CTP and SQL Express 2008. Finally managed to install SQL Express 2008 on my Vista Business. If anybody has problem installing SQL Express on Vista let me know. I found resources on MSDNER and this forum to resolve this.
But now I have a new problem that is. I can not add the SQL connection from DataExplorer of VWD 2008. It say it can connect only up to SQL 2005. Now I try to install SQL 2005 it goes up to the stage where it says looking for IIS server and disappears.
Does anybody know how to install SQL Express 2005 on Vista Business (while SQL Express 2008 is installed, I don't want to loose it) or get VWD to talk to SQL Express 2008?
Your help is much appreciated.
Hi
i am new to sql2008 and coming from vb6,sql2000 background. We tried Orcas. we dont want to move our project to dotnet for atleast one year. we want to makie it tune with windows vista also. so kindly tell us which version of adodb can be used with vb6 and sql2008. i am pasting our old code from vb6 here.
Code Block
dim cn as new adodb.connection
cn.open "Provider=SQLOLEDB.1;password=NETECH0507;Persist Security Info=False;User ID=sa;Initial Catalog=" & dbname & ";Data Source=" & gStrSQLServerName
Let me know what are the changes required while connecting with vb6 and sql 2008 express edition
Rgds
Pramod
Anyone here aware of Sql Server 2008 RTM availability date.
View 1 Replies View RelatedI see the Developer edition of SQL Server 2008 is available. When will the Express version be available?
View 3 Replies View RelatedHi-
VS 2008 supports targeting different versions of the .NET Framework. Will this apply to SSCE as well? I have some older apps that I want to keep in .NET 2 and SSCE 3.1. But I would also like to develop new stuff in 3.5. Will the targeting mechanism in VS 2008 support using SSCE 3.1 with .NET 2.0 and SSCE 3.5 with .NET 3.5?
Thanks.
-Gary
as title
View 4 Replies View Related