hello !
I am a student in a compagny because itīs my training. But, I must use MS SQL server and i donīt know at all this software !
I must import datas , which are in a ascii form, into MS SQL serveur 7,0.
Can you give me further information please, because itīs not easy at all !
thanks
I am having a problem to get all datas into one table
I must get datas from 2 other tables
datas from the first table are columns
but datas of the second table are rows
I cannot change the structure of TableA because an other application is using it as it is
TableA
num | value | key
1 | a | 1400
2 | b | 1401
3 | c | 1402
4 | d | 1403
...|... | 1403
TableB
key | name | descr | value
400 | john | ok | 451
TableC (the table where I want to insert datas from Table1 and Table2)
val1 | val2 | val3 | val4 |name | descr | value
1 | 2 | 3 |4 | john | ok | 451
TableA has thousands of rows and different numbers
I must get 8 different datas from TableA
so I get an horrible Query !
SELECT
TableB.name, TableB.descr, TableB.value,
TableA_1.value AS val1,
TableA_2.value AS val2,
TableA_3.value AS val3,
TableA_4.value AS val4,
TableA_5.value AS val5,
TableA_6.value AS val6,
TableA_7.value AS val7,
TableA_8.value AS val8
FROM dbo.TableB INNER JOIN
dbo.TableA_1 ON TableB.key = TableA_1.key INNER JOIN
dbo.TableA_2 ON TableB.key = TableA_2.key INNER JOIN
dbo.TableA_3 ON TableB.key = TableA_3.key INNER JOIN
dbo.TableA_4 ON TableB.key = TableA_4.key INNER JOIN
dbo.TableA_5 ON TableB.key = TableA_5.key INNER JOIN
dbo.TableA_6 ON TableB.key = TableA_6.key INNER JOIN
dbo.TableA_7 ON TableB.key = TableA_7.key INNER JOIN
dbo.TableA_8 ON TableB.key = TableA_8.key
WHERE TableA_1.num = 145
AND TableA_2.num = 80
AND TableA_3.num = 3160
AND TableA_4.num = 41
AND TableA_5.num = 50
AND TableA_6.num = 51
AND TableA_7.num = 53
AND TableA_8.num = 56
how can i do it in the best way ?
Thank you
Hi all,
I have to make many tests on datas i have in 2 specific tables.
My goal would be to backup datas somewhere to be able to restart from clean environment and tests many things with the same datas into my tables.
Could someone explain how to do it ?
thanks
Florent
I have downloaded SQL serveur express and I can not start the program.
I have this error: (see at the end of log file:
What can I do?????????
2006-09-21 20:28:11.21 Server Microsoft SQL Server 2005 - 9.00.1399.06 (Intel X86)
Oct 14 2005 00:33:37
Copyright (c) 1988-2005 Microsoft Corporation
Express Edition on Windows NT 5.1 (Build 2600: Service Pack 2)
2006-09-21 20:28:11.21 Server (c) 2005 Microsoft Corporation.
2006-09-21 20:28:11.21 Server All rights reserved.
2006-09-21 20:28:11.21 Server Server process ID is 2456.
2006-09-21 20:28:11.21 Server Logging SQL Server messages in file 'C:Program FilesMicrosoft SQL ServerMSSQL.2MSSQLLOGERRORLOG'.
2006-09-21 20:28:11.21 Server This instance of SQL Server last reported using a process ID of 2684 at 2006-09-21 20:27:58 (local) 2006-09-22 00:27:58 (UTC). This is an informational message only; no user action is required.
2006-09-21 20:28:11.21 Server Registry startup parameters:
2006-09-21 20:28:11.21 Server -d C:Program FilesMicrosoft SQL ServerMSSQL.2MSSQLDATAmaster.mdf
2006-09-21 20:28:11.21 Server -e C:Program FilesMicrosoft SQL ServerMSSQL.2MSSQLLOGERRORLOG
2006-09-21 20:28:11.21 Server -l C:Program FilesMicrosoft SQL ServerMSSQL.2MSSQLDATAmastlog.ldf
2006-09-21 20:28:11.23 Serveur SQL Server is starting at normal priority base (=7). This is an informational message only. No user action is required.
2006-09-21 20:28:11.23 Serveur Detected 2 CPUs. This is an informational message; no user action is required.
2006-09-21 20:28:11.35 Serveur Using dynamic lock allocation. Initial allocation of 2500 Lock blocks and 5000 Lock Owner blocks per node. This is an informational message only. No user action is required.
2006-09-21 20:28:11.37 Serveur Database Mirroring Transport is disabled in the endpoint configuration.
2006-09-21 20:28:11.39 spid5s Starting up database 'master'.
2006-09-21 20:28:11.50 spid5s Recovery is writing a checkpoint in database 'master' (1). This is an informational message only. No user action is required.
2006-09-21 20:28:11.57 spid5s SQL Trace ID 1 was started by login "sa".
2006-09-21 20:28:11.60 spid5s Starting up database 'mssqlsystemresource'.
2006-09-21 20:28:11.82 spid8s Starting up database 'model'.
2006-09-21 20:28:11.84 spid5s Server name is 'BERNARDB'. This is an informational message only. No user action is required.
2006-09-21 20:28:11.84 spid5s Starting up database 'msdb'.
2006-09-21 20:28:12.10 spid8s Clearing tempdb database.
2006-09-21 20:28:12.18 Serveur A self-generated certificate was successfully loaded for encryption.
2006-09-21 20:28:12.20 Serveur Server local connection provider is ready to accept connection on [ \.pipeSQLLocalMSSQLSERVER ].
2006-09-21 20:28:12.20 Serveur Server local connection provider is ready to accept connection on [ \.pipesqlquery ].
2006-09-21 20:28:12.20 Serveur Dedicated administrator connection support was not started because it is not available on this edition of SQL Server. This is an informational message only. No user action is required.
2006-09-21 20:28:12.20 Serveur SQL Server is now ready for client connections. This is an informational message; no user action is required.
2006-09-21 20:28:12.82 spid8s Starting up database 'tempdb'.
2006-09-21 20:28:12.92 spid5s Recovery is complete. This is an informational message only. No user action is required.
2006-09-21 20:28:12.93 spid11s The Service Broker protocol transport is disabled or not configured.
2006-09-21 20:28:12.95 spid11s The Database Mirroring protocol transport is disabled or not configured.
2006-09-21 20:28:13.04 spid11s Service Broker manager has started.
2006-09-21 20:31:04.15 Serveur SQL Server is terminating because of a system shutdown. This is an informational message only. No user action is required.
2006-09-21 20:31:07.90 spid11s Service Broker manager has shut down.
2006-09-21 20:31:07.92 spid11s Error: 17054, Severity: 16, State: 1.
2006-09-21 20:31:07.92 spid11s The current event was not reported to the Windows Events log. Operating system error = 31(error not found). You may need to clear the Windows Events log if it is full.
2006-09-21 20:31:11.29 spid5s SQL Trace was stopped due to server shutdown. Trace ID = '1'. This is an informational message only; no user action is required.
Forum: SQL Express
Posted: : Friday, September 22, 2006 10:49 PM
Post Subject: : SQL Express Cannot Start cpaesano wrote: Hi there,
I recently installed VS Express on a brand-new machine running Win XP SP2. I ran the wizard in VS Developer and created a personal website sample. When I hit CTR + F5 to test drive the sample website, it gives me the following error:
Server Error in '/WebSite2' Application. An error has occurred while establishing 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: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server).
I now realize that the SQL Server is stopped. When I tried to start the SQL server in the manager console, I get the following error log:
2006-09-22 07:48:15.09 Server (c) 2005 Microsoft Corporation.
2006-09-22 07:48:15.09 Server All rights reserved.
2006-09-22 07:48:15.09 Server Server process ID is 568.
2006-09-22 07:48:15.09 Server Logging SQL Server messages in file 'c:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLLOGERRORLOG'.
2006-09-22 07:48:15.09 Server This instance of SQL Server last reported using a process ID of 508 at 9/22/2006 7:43:02 AM (local) 9/22/2006 11:43:02 AM (UTC). This is an informational message only; no user action is required.
2006-09-22 07:48:15.09 Server Registry startup parameters:
2006-09-22 07:48:15.09 Server -d c:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLDATAmaster.mdf
2006-09-22 07:48:15.09 Server -e c:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLLOGERRORLOG
2006-09-22 07:48:15.09 Server -l c:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLDATAmastlog.ldf
2006-09-22 07:48:15.15 Server SQL Server is starting at normal priority base (=7). This is an informational message only. No user action is required.
2006-09-22 07:48:15.15 Server Detected 2 CPUs. This is an informational message; no user action is required.
2006-09-22 07:48:16.23 Server Using dynamic lock allocation. Initial allocation of 2500 Lock blocks and 5000 Lock Owner blocks per node. This is an informational message only. No user action is required.
2006-09-22 07:48:16.32 Server Database Mirroring Transport is disabled in the endpoint configuration.
2006-09-22 07:48:16.39 spid5s Starting up database 'master'.
2006-09-22 07:48:16.42 spid5s Error: 17207, Severity: 16, State: 1.
2006-09-22 07:48:16.42 spid5s FCB::Open: Operating system error 5(Access is denied.) occurred while creating or opening file 'c:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLDATAmaster.mdf'. Diagnose and correct the operating system error, and retry the operation.
2006-09-22 07:48:16.42 spid5s Error: 17204, Severity: 16, State: 1.
2006-09-22 07:48:16.42 spid5s FCB::Open failed: Could not open file c:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLDATAmaster.mdf for file number 1. OS error: 5(Access is denied.).
2006-09-22 07:48:16.42 spid5s Error: 5120, Severity: 16, State: 101.
2006-09-22 07:48:16.42 spid5s Unable to open the physical file "c:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLDATAmaster.mdf". Operating system error 5: "5(Access is denied.)".
2006-09-22 07:48:16.45 spid5s Error: 17207, Severity: 16, State: 1.
2006-09-22 07:48:16.45 spid5s FCB::Open: Operating system error 5(Access is denied.) occurred while creating or opening file 'c:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLDATAmastlog.ldf'. Diagnose and correct the operating system error, and retry the operation.
2006-09-22 07:48:16.45 spid5s Error: 17204, Severity: 16, State: 1.
2006-09-22 07:48:16.45 spid5s FCB::Open failed: Could not open file c:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLDATAmastlog.ldf for file number 2. OS error: 5(Access is denied.).
2006-09-22 07:48:16.45 spid5s Error: 5120, Severity: 16, State: 101.
2006-09-22 07:48:16.45 spid5s Unable to open the physical file "c:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLDATAmastlog.ldf". Operating system error 5: "5(Access is denied.)".
ocol transport is disabled or not configured.
2006-09-16 20:21:47.51 spid11s Service Broker manager has started.
2006-09-16 22:47:08.28 Server SQL Server is terminating because of a system shutdown. This is an informational message only. No user action is required.
2006-09-16 22:47:21.45 spid11s Service Broker manager has shut down.
2006-09-16 22:47:21.76 spid11s Error: 17054, Severity: 16, State: 1.
2006-09-16 22:47:21.76 spid11s The current event was not reported to the Windows Events log. Operating system error = 1717(The interface is unknown.). You may need to clear the Windows Events log if it is full.
2006-09-16 22:47:23.23 spid5s SQL Trace was stopped due to server shutdown. Trace ID = '1'. This is an informational message only; no user action is required.
Any ideas or suggestions of what could be going on here? I was excited to start developing on VS Express, but I cannot even get the samples to work.
Regards,
Carlos
Hello,
2 weeks ago, I installed a SQL Server 2005 Express on one of my computer. I fought to configure the remote access, but finnaly it did work.
Yesterday I had to move my server on another computer and I've never succeeded in configuring the remote access. I don't understand why it is so complicated to install remote access.
I explain you what I did, and if you could say me what i missed, it could be amazing !!
I install SQL Server 2005 Express including the SQL Server Management Studio Express.
I went to the SQL Server surface area configuration and i enable Remote Access (TCP) and turn on the SQL Browser
I enabled Server authentication => SQL Server and Windows Authentication mode.
I created users with all the permission i can give to them.
I restart one million time all the services and nothing...I tried to connect to the database using my local Microsoft SQL Server Management Studio Express, using the Visual studio Sever Explorer and with C# script using this connection string :
sConnectionString = " Server=myIP\SQLEXPRESS; Initial Catalog='myDatabase'; user id = myLogin; password = myPassword";
And I've never succeeded in connecting, I have always the same error :
An error has occurred while establishing 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 Locating Server/Instance Specified)which means the database is not reached.
Please tell me i've just missed a stupid thing.
Hi! I'm a novice in asp .net
I've a SqlDataSource component on an Aspx page.In the associated C# file, I would like to use datas from the query stored in the SqlDataSource component.How to do this?
Thanxs :)
Hello;
i want to get some results but only for one month. like that;
select * from News where PubDate = month(9)
i tried use between dates but i got errors because all of months aren't 30 or 31 days ... For example February is 28 days sometime.. So how can i get a month results...
thanks now for your helping ...
Hello,
i am using sql server ce 2.0 for my device application.but this database sometimes gets corrupt,and i am not working with big size datas,if sdf file's size grow up,sdf file's performance gets knock out. for example: work with 50 mb data..what can i do?please somebody help me ?
Hello All
Im Developing Windows application using VS2005 and SQL SERVER 2000.
I have a table with five columns
ID 1
Clm1 A_B
Clm2 A_C
Clm3 D_A
Clm4 B_C
What i want is
from Clm1 to Clm4
A,B,C is repeating
what is the query to get output as
CLm1 A
Clm2 B
Clm3 C
Clm4 D
the repeated datas should be taken unique data
How to do this
please help
Thanks in Advance
Ragards
Balagangadharan.R
Hi,
All.
For insert new entry...I used dataset and first all entry in dataset then i insert this dataset into datatabel of database.
For update edit entry....First i bind tabel to dataset then i update,delete in dataset then i insert dataset to database then there are problem that is there are once again entry of dataset to that tabel.
I also solved this problem by delete record which bind to dataset on save(insert )data set to database and then again insert dataset to tabel and solve it.
But if any other option for it then plz replay me
Thanks
Hello,
View 4 Replies View RelatedHow to Import a Excel Datas to SQL Server Database
View 1 Replies View RelatedHi guys,I have a problem with my query. What i want to happen is to populate my table EV_NOTIFICATIONDETAILS (Docownerid, CurrentSentDate, LastSentDate, detailsID, GeneralRemarks) using the datas from the two different tables EV_NOTIFICATIONHEADER and EV_DOCDETAILS.I tried to create some a query but im having a error. The problem is once i insert the data from datas to the columns Docownerid, CurrentSentDate, LastSentDate the datas are stored in the database and when i tried to insert the remaining columns TO EV_NOTIFICATIONDETAILS detailsID, GeneralRemarks getting the datas from EV_DOCDETAIL it creates a new set of records in the database. Meaning it doesn't update the records in the table EV_NOTIFICATIONDETAILS but it creates a new set of records.here's my code:INSERT INTO EV_NOTIFICATIONDETAILS (Docownerid, CurrentNoticeSentDate, LastNoticeSentDate) SELECTDocownerid, CurrentSentDate, LastSentDateFROMEV_NOTIFICATIONHEADERINSERT INTO EV_NOTIFICATIONDETAILS (detailsID,GeneralRemarks) SELECTdetailsID,GeneralRemarksFROMEV_DOCDETAIL Any ideas and suggestions will be greatly appreciated.
View 2 Replies View RelatedHi..
I have configured publisher, distributer,subscriber... and tried to replicate it... it has done successfully...
When i try to add datas to the publisher ... it says
"conflict error"
can you please tell me how to check the replication is successfull or not.
and i want to add datas to publisher so that it should frequently updated in subscriber...
Hello,
I have a report in reporting services which has use many datasets.
Those datasets retrieve data from a same table.
Each Dataset use a store procedure.
In the first store procedure (associated to the first dataset), i call an another store procedure which fill the table.
My problem is that datasets haven't datas retrieved in the order of their position. So the third (for exemple) can begin retrieve data while the first store proc (called in the first dataset) is still running.
I had logging start/finish time of each SP and it appears that Dataset are retrieved in an asynchronous way.
Does anyone face the same problÃĻme. Is there a solution to execute an store procedure before retrieving data ?
Thank in advance for your help.
David
Hi
I have to populate some datas from sql server database and display it directly in a CSV Format or CSV file. When i run the project it should provide me an option to whether open or save or cancel the file. when i click open it should be opened and be viewed in a excel sheet in CSV format and when i click save it should ask the destination folder and should be saved there in CSV format and when i click cancel it should be cancelled and the application should be closed. pls note that all these actions should happen in the same browser and should not be redirected to anyother page. Can anybody give me the detailed description and code in Asp.Net using C# .It's very Urgent.
RegardsVijay.
I am trying to import a database into Sql 6.5 from Access 97`.
How shall I go about this ?
Thanks.
mark.
Hello everyone and thanks in advance.
Ok, here's the deal. I am 1 of 2 developers at my organization, the other is a COBOL programmer. Long story short, every night he sends me a 22MB XML file containing our company's inventory. This contains about 40,000 items. In C#, I'm basically looping through all the XML nodes and on each node I load up an object with the particular properties (manufacturer, SKU, serial number, etc.) and call a Stored Procedure to to save the item.
In saving the item, I'm checking to see if it was already in my inventory and I either perform an update or an insert on the table as approriate. The query does a couple of other things like retreiving the Purchase Order Number, Cubic Feet, etc. from other tables. All in all, the query takes about 1-2 seconds to complete. I've optimized the query as much as I know how (including the addition of indexes), but this still takes at least 6 hours to complete the 40,000 items. Is this the best approach? Any other suggestions?
So far the only things I've thought about changing is:
1. Break it out into multiple queries to avoid poor compilation of execution plans
2. Multithread the C# app so that I'm running like 10 queries at once.
3. Get the COBOL programmer to give me a delimited file and do a BULK INSERT on it into an empty HEAP, then run a single INSERT and a single UPDATE (using CASE statements)
Again, Thanks in advance!
Hi everybody:
I want to know how to import to SQL Server an XML File
Thanks for your help and quick answer.
Cristopher Serrato
Has anyone any idea what could be causing this problem.I've a large txt file, with each item on each row seperated withquaotaion marks and seperated from each other by a comma.I can import it no problem to Access, but when I try to import it toSQL server, SQL Server gives me that "cannot find.... within first 8KB"of data error.Any ideas?Ciarán
View 2 Replies View Relatedorange May 14, 5:16 pm show optionsNewsgroups: comp.databases.ms-accessFrom: "orange" <orange...@mail.ru> - Find messages by this authorDate: 14 May 2005 14:16:49 -0700Local: Sat,May 14 2005 5:16 pmSubject: import complex dataReply | Reply to Author | Forward | Print | Individual Message | Showoriginal | Remove | Report AbuseI've got a database in .txt file similar to this:BookName;Author;Year;ReviewedBy;Rating;PagesNemesis;Isaac Asimov;1989;13,31,24;good;110Sense & Sensibility;Jane Austen;1970;45,32;great;120The Bicentennial Man;Isaac Asimov;1965;14;excellent;124...the data in field 'ReviewedBy' should be connected to names of peoplethat read the book. I'd like to have a separate table in Access likethis:Id;Reviewer13;Bob...24;Jim...31;TomHow do I import that data into database?
View 1 Replies View RelatedHi i'v e installed the file: SQLServer2005_DTS.msiBecause i've heard that i need that to import a csv file into a ms sql database. now i have no idea how to work it, like to even make it open.Where would i open it from? I reckon i'v eread enough literature about using it, to be able to have a bash... thanks in advance...
View 3 Replies View RelatedHi All,Here is my code Dim strCon As String = System.Configuration.ConfigurationSettings.AppSettings("OwnerTrader") con = New SqlConnection(strCon) con.Open() Dim strselect As String = "" Try strselect = "INSERT INTO tbl_CSV(CSV_TIME,CSV_SIZE,CSV_LOCATION,CSV_COUNTRY,CSV_LAT,CSV_LON,CSV_COMMENTS)" strselect = strselect & " SELECT * FROM OPENROWSET('MSDASQL','Driver={Microsoft Text Driver (*.txt; *.csv)};DEFAULTDIR=C:UploadFiles;Extensions=CSV;','SELECT * FROM TestNew.csv')" cmd = New SqlCommand(strselect, con) cmd.ExecuteNonQuery() con.Close()i have defined connection string in web.config file and my csv file is inside C:UploadFiles with the name TestNew.csv file.Can u please check it out the code?is it correct or not.I am getting this error"SQL Server blocked access to STATEMENT 'OpenRowset/OpenDatasource' of component 'Ad Hoc Distributed Queries' because this component is turned off as part of the security configuration for this server. A system administrator can enable the use of 'Ad Hoc Distributed Queries' by using sp_configure. For more information about enabling 'Ad Hoc Distributed Queries', see "Surface Area Configuration" in SQL Server Books Online."Regards
View 1 Replies View RelatedI have created a DTS package for SQL Server, saved this as a VB file and upgraded this to the .NET framework.
It is now saved in a file called Shortages.vb.
What I want to do now is add this to an existing ASP.NET project and be able to call this DTS function by the click of a button.
Is this possible and how can I go about it? Can I just add it to the Click event of a button?
Hallo every one,
I', working for a school project.
The setuation is an old database that has to be repaird.
All the data from each table of the old data base are stored in different tabdelimited text files.
I designed a new database, but the tables are a little different.
When I try to import the data I get some errors, because of the changed tables.
An example of my new setuation is a new table thas as colums from 2 different tabdelimited text files.
My question is, how do I solve thos problem!
Do I have to use DTS?
What do I have to do.
tnx
icheron.
Hi folks,
I am having importing problem, when i tried to import tables from sybase to Sql server 7.0, it is not importing the keys, it is creating only datas without keys. Do u know any way in solving this issue?? My next issues will be on Serial number generation. In sybase we have Number (*), if we do
select number(*) from a it will show the sequence numbers, but in Sql server what is the equivalent function to show the sequence number when i am using a select statement.
Can u folks solve both the issues...
thanks and appreiciating u folks...
rgds,
VJ
I have an excel file with 5 columns. 1st column values are -
^^234
^^456
678
123
456
SQL 2000 DTS, doing straight copy into an Access table takes only first two
rows from 1st column ( see top 2 rows with trailing white spaces). How can I
import all of rows ?
Thanks for your assistance !
_Ivan
Hi, Is there any way , we can bulk import sql server logons with password?
Thanks.
I have a project at work that requires me to transfer all the data, including the queries, forms, macros, and modules from Access 97 to SQL Server 7. I was able to import the tables only using DTS wizard. Is there a way to copy the queries, forms, macros, and modules?
View 2 Replies View RelatedHow can you can import results into table from system procedures.
For Ex. if you exec sp_spacesued, how do I import the results into the table.
Thank You
Hi, i've struggled in the past to get ms sql 7 db's from one server to another server and always end up getting frustrated. I usually just export and then import..... more work but it does the trick.
Now i've been sent one single db data file that i'm told is a backup copy of someones database. How do i get this loaded onto my server. I've tried restoring from this file but it complains that the backup file is not for the database i'm restoring to.... which is correct.... this has to be something that many people deal with? isn't it?
Can someone please help me out.... some pointers would be much appreciated.
Thanks in advance,
Mark.
I am importing via DTS a .csv file. I have 2 issues:
-One field from the source needs to be inserted into two existing fields.
-Two fields from the source, First_Name and Last_Name need to be
concatenated to a destination field, Full_Name.
I do not know VB but I do know SQL.
Can anyone help?
Hi, this is my first time and was wondering what's the best way to do the following:
i've sql server 6.5. also have a sql database(.DATfile) in a folder.
i need to import this database to my server. should i just LOAD/import it? or do i need to first create a database device on my server(how much size should i allocate etc) and then load it??
thanks a lot
rohit