I have Big texts And I Want To searching In These texts By MSSql Database,
i saved this texts in about 4800 rows in one table with one ntext field.
when I finished I surprised with some problems:
1- when I want to search in this table by simple Select Command like this: "Select topicID from topicstbl where topictxt like '%vb forums%'
I faced this ERR MSG "Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding." And It does not continue searching to the last row so it returns only some of the results.
2- it is too slow and it took three minuites to performe one incomplete search operation because it was "TIMEOUT".
3- the size of original texts is 300MB but when i saved these texts to MSSql Database its size becomes too large its more than 1GB.
what can I do with these problems taking into concideration that I do not want to use FULL TEXT SEARCH?
When I import my tables from MySQL, it put " " with the contents in the field. Will someone show me a SQL statement that I can use to clean all the " " out of the table's contents?
When I SELECT text FROM mytable, I don't retrieve all the data in thatcolumn. When I take a look directly inside the database, I can seethat there exists more data than I get when running the select query.How can I get all the data retrieved?obscurr
i was planning to create a database migration tool .. its a certain database of a DMS (document management system) to another DMS (two different DMS)... from DMS using msde 2000 server .. and tranfer to a DMS using a postgre sql or mssql .. depends ..
they have different table structures and names . . :D
i was thing of what language shall i use.. or what language is the best to work on this kind of project :)
I am trying to do one scheduling website for my company. Its contains tasks thats we scheduling for ourself each one and the assigning task by the boss to everyone. I want to do this with two tables. I need to save the task and assigned task in one column named as "Tasks" and to gave after the task name assigned or myself scheduled. Also after deletion of each assigned and scheduled it must save in the table with some name like deleted or any symbol. How can I do this?please help me to solve this issue.
While attempting to set up sql replication in MSSQL 2005 one of my user databases is now in the systems database folder. I need to move it back to the user databases folder. Any help would be greatly appreciated.
We have a Prinicipal, a Mirror and a Witness server. We have automatic failover configured between the Prinicipal and Mirrored server. When we stop MMSQL service on Prinicipal, not all the databases failover to the Mirrored instance. Any suggestions would be welcomed as we have a tight deadline to get this in Production.
I am new to ms SQL. I only have the use of the Enterprise Manager. Creating tables I understand. However I am confused on how to add data to a table or view the data in a table. Can this be done through Enterprise Manager? If I am adding a large amount of data do I have to use the query window. This seems like a tedious method. In Access yo have a form basically pop up where you can type in the record sets. Any advice would be appreciated! Sincerely, Bill Bequette
Would any body be able to suggest the best way switch a Lotus .nsf file to Ms SQL database or even to an Access?
I have a .nsh file that I am able to see the contents of but not the database structure, and rather then rebuilding the database and manually inserting the content I would like to import all the information from an old .nsf file that appears to have restriction on it.
I am very new to asp.net. I really mainly use PHP but want to migrate to asp.net, but it doesn't seem that easy.I am creating a page for peson to pay a subscription page where they will enter personal information an credit card information.I created the form for this with validation controls.I don't know however how to write the form data to the mssql database.I am using mssql 2005, but i would need a work out for the 2000 version as well.
Hello,Is it better to use a DSN connection or using a connection string Set Connection = Server.CreateObject("ADODB.Connection") Which is easier to use and more reliable? Also could I have all the connection info on one page and then just include it with a include statment everytime I need to query the database?? Thank you, Rich
I've come from the asp world into .NET and I have looked all over the web for the proper way to make a database connection to a MSSQL server and all I have found is samples of connections to Access databases. Can anyone point me in the direction of how to create a db connection for microsoft sql server.thanks
We have set up an user acceptance server with a database that is the same as production. However, I have been told that this database and server may be used for applying fixes rather than user acceptance.
To avoid confusion over which database is on which server, it might be a good idea to rename the database. I am not sure if this can be done un der mssql 6.5?
1)Can I rename a database?
2)If so, how can I do so?
Which system tables would I use to update?
Any information you can furnish will be appreciated. THanks.
When using the "Management Studio" how do I create a database? When it starts up, I only seem to have the option of connecting to a database, while not actually creating one :S
David writes "Dear sir, I've installed VS.NET 2005 Professional many times and find that the MS SQL Express 2005 is running. My ambition is to log into this server so that I can convert my MySQL database into it. What is the default; Hostname Port Username Password
What tool is provided so that I might execute my schema to create a database in this server. This 'schema' will obviously have many tables inside. Most SQL products provide some type of utility program where one can create, edit, delete databases and an adminstration program. I see nothing of yours in my Programs -> MS SQL Server 2005 -> SQL Computer Manager. Thank you, David Kennedy"
Hello, another question from a newbie to mssql.Is there a way of allowing access to database only by providing username andpassword (disabling trusted connection and preventing administrator toaccess database through enterprise manager or otherwise without supplyingusername and password)?What I would like is that my application upon instalation creates databasewith appropriate tables (already done this) and somehow solely creates andmanages user list and passwords so that there is no access to database otherthrough application. (Application would create a backdoor account shouldsomething go wrong)
Hello,I try to export a mssql database into a csv-file.I tried this with asp, but it doesn't work.<%Dim objConnDim csv_pathSet objConn = Server.CreateObject("ADODB.Connection")objConn.open "database","username","passwd"csv_path =Server.MapPath("./") & "csv_test.csv"SQL ="SELECT * INTO OUTFILE 'C:inetpubwwwrootcsv_test.csv' FIELDSTERMINATED BY ';' OPTIONALLY ENCLOSED BY '"' FROM GROUPS"objConn.Execute SQLobjConn.CloseSet objConn = Nothing%>There is a problem near 'C:inetpubwwwrootcsv_test.csv'Can anyone help? Thank you.Manuel
I've made af site in Visual Web Developer. On that site i've made a database and it worked finde when I first uploaded it to my FTP as a database file on the server. But due to security problems, my web hotel host has deactivated that possibility. Så now I have to put my data and tables into the MSSQL 2005 Database the host uses. Now here's the problem.
1: How do I do that?
2: How do I get tha tables I've made i Visual Web Developer over in SQL Server Management Studio Express så that I can upload it?
Has anyone had a problem transfering a database to a server. This is the first time I have done this. I have a site and sqldatabase hosted by a hosting company and I am supposed to transfer my database This is what I'm doing
From the Start Menu, select "Programs" -> "Microsoft SQL Server" -> "Import and Export Data" then click "Next". In the "Server" field, type in the Name or IP of the source server (your server), choose "Use SQL Server Authentication," type in your username and password, choose your database from the "Database" field, click "Next". Note: You can also use Windows Authentication if the SQL server is a local server. In the "Server" field, type in the hostname of the DiscountASP SQL Server (this is listed in your hosting control panel), choose "Use SQL Server Authentication," type in your DiscountASP database username and password (this was sent in your database order confirmation email), choose your database from the "Database" field, click "Next". Choose "Copy objects…", click "Next". Uncheck Use Default Option. Click Options, uncheck "Copy Database users and database roles", "Copy SQL Server logins", "Copy object-level Permissions". Leave next window as is, click "Next". Click "Finish".
It seems to work ok untill it gets to about 90% done then a message says "There has been an error" and gives no more info. Can anyone help me out
Does anyone know of a good (free) tool that will compare the structure of two databases. Something that will compare Stored Procedures and Views would be great.Thanks.
Hi all, Well, I have created an applicatin in asp.net and it connect to MSSQL database, and it work fine.
There is another application which was developed in Oracle and the database is oracle 8i.
Well, wat i want is whenever a form is submitted from the asp.net application, the data is inserted in the MSSQL server database and the Oracle8i database also.
We are working on using a database as a publisher and a remote database as a subscriber for one replication in Canada.
WE havw just been told that another application on a different server(publisher/ distribution) wants to replication to our database as a subscriber.
We also will need(as a publisher/distribution) to replication to a second subscriber database after we completely test the first replication to Canada.
Therefore my questions are:
1) Can a database on a local database -- our database -- on one server be a publisher and subscriber to ther different databases?
2)has any one been involved with replication on a database used both as a publisher and subscriber to different replications requirements?
What are the pitfalls aside from the scheduling conflicts?
3) In terms of database space requirements, how much disk space extra do we need? What guidelines should we use? For each table as an article, assuming we are doing the full table, do we add 100% more space or what?
Hi.. When I go to my MSSQL 2000 database--> properties-->Databse size is 1500MG and the space available is 305MB
But I don't understand how space available come from. As I had put my Database file and Transaction log file as unrestricted file grow. And put automatically file grow by 10% for both file and log
Why is the limit come from ?
Besides, I have a database which indicate space available as 0M in the database properties but it is still functioning. why?
Here is the case. I have up and running database on MSSQL server. My client deliver me updates. Since now they were as INSERT statements, but they decided to change some stuff at their side. Now the updates will come as pairs of files (.dbf and .mdx) for each table...
Several months ago I installed what I thought was an unlimited license of MSSQL Database Server 2000. This weekend the database expired. What can I do? I don't want to lose the data. If I attempt to reinstall the software, will that work? We are in the process in purchasing the software but not for a few months. The database is used to store and retrieve data in our OutStart server. Any idea is helpful.
i have got stucked into one programming problems which is called paging.i m using mssql as my database.i m using php for displaying data in to several pages but it is not supporting LIMIT functions, so can any one help me how to create php+mssql paging with accurate coding..? plz help me its urgent
I am using MSSQL 2005 but we have to work in compatibility mode with MSSQL 2000 and also we are only allowed to use 2000-compatible features, now my question:
I need to programmatically copy a database within the same server (including all stored procs, triggers and tables, indices) ...
Can anybody give me a hint what is the best way for reaching this target??
Can not attach database, Error message; The file you've specified is not a valid SQL Server database file.
My costumer HDD some files Deleted mybe elektric prblem -Elektric go,com,go,come- then windows not opened. insert corrupt hdd Another computer, then recovering (recover my files software) Recover mdf and ldf files. but I can not not attach mdf. file,
I am recovery .mdf file http://www.officerecovery.com/mssql/ some table ok. but my importand table is not ok.
if I can recover another recovery software , my database correct recover or same.? I am using RecoverMyFiles.
