contains(name,'"张三"') will not find the row in database with column named "name" and "张三" is sure there,but will find '张三一'，'张三二' why? name column is sure in the fulltext category and data population is finished!

Hi - I'm trying to install June CTP on Win2k3 SP1.Setup failed when trying to start services for configuration.In log files I found the following Computer type is AT/AT COMPATIBLE. Bios Version is INSYDE - 1 Insyde Software MobilePRO BIOS Version 4.00.01 Current time is 11:26:54 08/30/05. 1 ...

I have installed the community preview version of SQL Express (I think the April preview version). I can't find a way to backup a database created with the SQL Express UI tools. Can you point me in the right direction? Thanks, Leo

i m using SQL 2005 version 8.0.194. i want to upgrade it into 9.0.1399. how can it be possible. Also tell me link from where i can download such upgraded exe.

We have a need for full-text search over related tables. I'll refer to these tables as A, B & C. Table A is the base table and is optionally related to table B through an outer join. Table C optionally has keywords that describe table A and are coalesced in a view with table A using a ...

Hi Guys. I’m doing searches in a DB and am using the Full-Text Indexing. CONTAINS() will only process strings (words!) three letters or more in length. Even though it can do substring searching, it will only do this if it recognises the parameter as a word. So take this code for example: Dim ...

Hi There,I have table called tblFileInfo, full text indexing is done on the field KEYWORDSFTS is enabled on the server. I have done full population.If I use Like 21 results are returned, but using Contains is not returning any results what may be the cause.0 results returnedSelect * From ...

I have set the dboption 'trunc. log on chkpt.' to true; yet the transaction log keeps on growing.sp_dboption pubs_dbdoes show 'trunc. log on chkpt.' to be set.I tried DBCC SHRINKFILE(pubs_db_log,100)and for a while, the pubs_db_log.ldf was about 100M and then it grew to 10GB.I have a ...

We have a database that on a daily basis suffers from poor performance.Our IT folks found through trial and error that running a complete DBCC reindex job on the database at those times acts as a "release valve" and the server / database start performing normally again.I don't think that the ...

Hello, I want to transfer or copy all users from my old native Navision database server (v3.70) to my new SQL Server 2000 for Navision 4.0. How can i make script on native Navision database server (v3.70) and run thin on SQL server 2000 for transfer all users with same rights and ...

About 2 months ago, with great interest installed VS 2005 beta on my local Windows XP Pro. The SQL Express is running.I cannot work FULLY on starter kits like Personal Web Site SK or Community SK. I create a new web site based on the Community SK. I can successfully bring up ASP.NET ...

Hello, I'm having a problem restoring a db from sql server 2000 to 2005. The db is around 4 gigs, and seems to restore fine on other 2000 servers, just not 2005. In the restore window, for some reason it sees the name as 'INCOMPLETE', when starting restore it will get error after about 20% ...

Hi, I'm totally new to sqlexpress and I'm trying to create a database to store websites that my desktop application will manipulate; however, I don't know where to start, I've read many articles on msdn but they all are either non-existent or wasn't very helpful. All I want to do is create ...

In the SQL 2005 help doc on the table data type, it states "Queries that contain table variables do not generate parallel query execution plans. Performance can be affected by the presence of very large table variables, or table variables in complex queries. In these situations, consider using ...

Hi, i need to combine the data of 4 different tables & place it into the 3rd table in sql2000. how do i go for that?? thnx a lot... Amit

I installed 64 bit 2.0 Framework, SQLExpress CTP June to clean Windows 2003 x64 edition. Everything works fine for a while, but sometimes Sql Server fills up System -error log with several hundreds errormessages in few seconds: Source: Yukonx64Category: noneUser: N/AEvent ID: ...

I am running SQLExpress 2005, on Win 2003. Occasionally in the event viewer I see the message: The SQL Network Interface library was unable to register SPN. Error: 0x54b When I click on the link on the event viewer for more info, there is no further details. Can someone clarify what this ...

Hi How it is possible find duplicit values in primary key contrain? Until now I seen two databases which crashed on bad index paging and dbcc chedb with full repair report error on repairing primary key with duplicit values. I am really shocked about it. How it is possible? Or what I can do ...

Hi I am testing the manual failover of a Asynchronous mirroring without a witness but i get the following error when i issue "ALTER DATABASE testdb SET PARTNER FORCE_SERVICE_ALLOW_DATA_LOSS" on the mirror database server. Both the mirror and principal is in a synchronized state before i issue ...

Is it possible to have installed both on the same machine? How can you do to have them listen on different ports? Is there any conflict having framework 1.1 and 2.0 beta 2 on the same machine?

Hi, I've been trying to design a way for me to issue a transaction that: Block all inserts on a table when row X has a certain value (call it A) Add a row to the table with row X containing A Add rows to another table Unblock inserts Commit transaction Is this possible? Can anyone give me ...

When trying an online Backup of my SQL 2005 DB called "SMART" I get the error message: " The backup of the file or filegroup "sysft_SMART" is not permitted because it is not online " Online Backups works for all other Databases. Any Ideas ? thx Peter

i have downloaded AdventureWorksLT_IA64 & AdventureWorksBI_IA64 but when i install it i show's an error that "This installition package is not supported by this processor type" plzz help me out

I have installed VS 2005 (Beta 2.050215-4400) and SQL Server 2005 CTP (File Version 9.00.1187.07). I can connect to the SQLEXPRESS database and created tables from the VS 2005. But when I try to click the + to expand the database diagram folder I get the following window:Microsoft Visual ...

According to a vendor of monitoring products, sp_spaceused does not work properly if there is more than one filegroup: In addition, if you use the sp_spaceused() database function, it only looks at space at the database level. If you use more than one file group per database it doesn’t work ...

hi all, I have got some problem while taking back up of sql server transaction log file.Now its size is nearly 60 GB. And we have got less space in the server. so my idea is I need to take back up of this transaction log file at the sameto wann reduce the size of transaction log file. But Im ...

One of the new features of SQL Server 2005 replication is the ability to initialize a Subscription from a backup instead of applying a snapshot. This is a welcome feature, but it also leads me to a question. Assume I have implemented a filegroup backup strategy. My Subscriber database has two ...

Ok I have a smartclient app that on a WinXP box works fine for the use. Brings back data that is put into a grid, dropdown boxes and textboxes. On the win2K box with same user the app runs and identifies the user but no data comes back to the app. No errors msgs either come back to user or to ...

Hello,With SQL2000 configured with MSCS, we had to stop the SQL service to add additional disk in the SQL Cluster group (in order to use these disks for databases for example).. this was due to the dependencies between the resources.Do we still have the same issue with SQL2005 running on the ...

We have a clean Windows XP Install w/ Visual Studio 2005 Beta 2.I can not create a new database with SQLExpress...We have also been trying to connect to Oracle 10g.. And we constantly get cannot find TNS Names.ora, but we have easily configured this with another clean machine with VS.NET ...

Hello,I'm really stuck on this one, so if anyone can help it's much appreciated. I've written a stored procedure that takes about 3-4 minutes to run in testing. However, when I call the procedure from a C# application the procedure call just hangs..eventually timing out causing an exception. ...

I have set up a simple "ProdTest1" table with 3 columns: ID (int) which is an Identity column and indexed, Name (nvarchar 45), and Description (nvarchar 2000). I have then entered a single row with the following data:ID: 1Name: Purple Black BlueDescription: Black Blue I have then set up a ...

use mastergocreate procedure sp_GetObjectsasselect * from sysobjects;calling this procedure from different databases will return different results (behavior similar to 2000).use mastergocreate procedure sp_GetObjectsasselect * from sys.objects;calling this procedure from different databases ...

HelloI am getting following error:Error 1 The type 'System.Data.Common.DbConnection' is defined in an assembly that is not referenced. You must add a reference to assembly 'System.Data, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089'. C:\Documents and Settings\Adnan\My ...

Hello,I'm having some troubles to set up database mirroring on Itanium II based servers.I have 3 servers registered in the same domain (windows authentication)I have created manually the endpoint and there are all 3 started (port 5022)When I do the alter database set partner on the mirror site ...

Hi! we've got a curious problem. we've two identicall databases, same tables, same date, same indexes, same server, both replicated. One of them is our life database and the other is our development database. If I execute the following query at the development database the query takes less ...

Hello all,The example to this question is better:ID PName Ppurchased PSold PSellPrice AvgSellprice1 Water 50 10 100 202 Water 40 20 200 1003 Water 70 35 50 25What i want to happen within the table or maybe on a different table is to add the AvgSellprice of all 3 together to where it will look like t...

Does anyone know if it is possible to determine the relative word offset (the Occ) from a simple-term query such as:- SELECT CommentsFROM Production.ProductReviewWHERE CONTAINS(Comments, ' "mountain biking" '); So, given the text:- "Maybe it's just because I'm new to mountain biking, but ...

I am trying to create an SQLExpress database file (mdf) in VS2005 but I get the following error:"Failed to generate a user instance of SQL Server due to a failure in making a connection to the user interface. The connection will be closed.”I also get this same error if I try to open an existing ...

Microsoft SQL Server 2005 - 9.00.1187.07 dbcc checkdb is failing with an interesting message:Msg 8908, Level 16, State 1, Line 1 Indexed view 'BritishEnglishMV' (object ID 226099846) does not contain all rows that the view definition produces. Refer to Books Online for more information on ...

Hi, I’m trying to get database mirroring working but having problem when principal and mirror are not on the Domain. (I got it working once if both principle and mirror servers are on the domain.) Both servers have fully qualified domain names. Both have Windows server 2003 SP1 and SQL Server ...

Hi,I am interested in finding the TCP port which has been setup on a principal/witness/mirror server.I have queried the sys.database_mirroring_endpoints and sys.endpoints system views but nowhere does it specify the TCP port.I think the only way to find out is to go to one of the mirrored ...

Hello,I am wanting to install Adobe's Pdf IFilter v6.0 for use with pdf files stored in the database and to use Full-Text searching on those files.I have been unable to find documentation telling me where I need to install the files, and how I register the IFilter with an instance of Sql ...

I noticed that BOL says that the above is possibly going away. What's the official way to print out all your db options once it goes away, i.e. what are we supposed to do to quickly look at dboptions with doing sp_dboption 'databasename'?

This is a compilation of questions from other people:1. Will managed code objects get backed up with the database or must the dlls be copied manually? (Answer: They get backed up with the database. No manual backup of the dll files is necessary.)2. If you have two servers and are using log ...

A simple question – what SQL query can be used to determine the primary key of a given table? I can easily query SQL Server's system tables to determine fields' default values, data types, names etc etc but not the primary key. Any ideas? ...

I searched the forums and SQL 2005 book online to see if Microsoft provides documentation on the format of transaction log entries. I could not find any...Will Microsoft provides this documentation? It will also be nice if Microsoft will provide utilities to help us read content of transaction ...

Hi,I'm trying to get database mirror working with SQL 2005... but I'm not having much luck. Any pointers would be appreciated.I've got 3 separate machines in a work group configuration. There isn't a primary dns suffix so I'm just using the simple machine names.I've configured the ...

I have SQL Server 7.0 and SQL Server 2005 installed on the same machine. When i try to backup SQL Server 7.0 it gives me following error, can anybody help and explain me a resolution:"Backup or restore operation terminating abnormally"I read from one of the KB articles on MSDN that when SQL ...

I just installed SQL Server 2005 CTP (9.00.1116) on Windows Server 2003 with SP1. Then I unzipped DotNetNuke portal site and tried to connect to it with various errors, generally relating to invalid login.I never figured it out after many hours of exploring every SQL interface I could find, ...