Im new to working with SQL server, I just aquired a 2005 final release from Microsoft and installed it, When i went to create a DB, the aplication crashes and gives an error then it asks to debug, wheather you choose yes or no it further creates an error then the whole applcation closes,
View 5 RepliesHi, I've read from a topic in this forum saying that we could store PDF files in a hard drive location and import the link into a table of database in SQL server 2005, but i don't know how. So I really appreciate if someone could show me how to write a store procedure or a scripto to do this?
And by the way, i have another question. From that PDF files link, is there any way that we could call that pdf files and print that files from SQL script or SQL store procedure. Thanks a lot
Nick
hi
i have a dbf file which i need to import in sql server 2005.
anyone having any idea to import these files either through integration services or any other tool ???
Hi There
I have not had much luck finding info in BOL for tsql or SSIS that tells one how to load images on the file system into sql server 2005.
All i have really been able to find is that IMAGE data type will not be used in future and that one should use a varbinary(max) data type.
I am thinking of using a for each file loop in SSIS, but then how do i load the images (.tif) into a sql server database table ? Perhaps i need to use a sql task with the filepath , or an active x script.
Anyway if anyone knows how i can load images from the file system into sql server 2005, please let me know.
Thanx
hey all,
i want to know Equivalent of Load Data Infile of MySQL in SQL Server 2005?
in mysql we can direclty load file with Load Data infile query.
my question is how to do this in sql server 2005?
thanks.
I have a user who is trying to load SQL server 2005 Express on a new Acer laptop computer. The computer has the following:
Windows Vista Home Premium 32 bits
AMD Turion 64 mobile technology CPU
1790 MB of RAM
When the user tries to load SQL server 2005 Express it does not load. The user after the load is getting an €œUnhandled exception has occurred in your application€? when he tries to run the application.
Does anyone know how to fix this problem?
Thank you,
Photomultiplier
Hello,
I would like to ask you if there is better to recreate database structure on 2005 from 2000 and move data or to just load
2000 backup.
Currently I loaded the backup, but I am wondering if there might be slightly better performance on 2005 when recreating structure on 2005 to loading 2000 backup?
Does loading 2000 backup create 2005 binary structure?
Thanks for help in advance
Initially I loaded SQL along with C# however it said at the time that the load had been unsuccessful. I continued as I knew I wouldnt need SQL for a while.
I also have Web Developer loaded and this would not load SQL 2005 Express either.
I have tried loading SQL 2005 Express as a seperate download and I note that rollback occurs - I presume because of the COM+ warning that appeared. I have been through the 'Work around COM+ System Configuration Check Failure in SQL Server Setup' document - to no avail. The following parts of SQL that have not loaded:
SQL Server 2005 Database Services.
I have also tried deleting all components of Visual Studio 2005 Express Edition and loading SQL as the first component; that also failed.
I have saved the logfile, however I dont really know what I'm looking for. sqlActionManaged = 3, sqlStateManaged = 2.
Hi
This is more a product featuer question which I cant seem to find the answer to
If we wanted to share the loads of SQL Server requests over say 2 or 4 servers, is this possible?
What I mean is basically Active/Active load balancing / clustering? So we have one Virtual IP and all requests are forwarded to the least busy server.....
J
My company is planning on using a datacenter for our customers. These are manufacturing plants from which we collect batch and trend data (currently stored in SQL Server)
View 6 Replies View Relatedi have a table with 10,000,000,000 records and i need Select and Insert many
records from or into this table in less than one second.
i can't buy a very expensive hardware(Server) for this SQL Server 2005
but i can buy many medium price hardwares(Servers) for this SQL Server
2005.
how can i distribute or cluster this table between many hardwares(Servers)?
note: i have few users (maximum 5 users) for my database but i have a
very large table and Sql server 2005 server need to respond to this
users in less than 1 second.
i want to distribute this huge table in seperated hardwares. becuase i
can't buy a very expensive hardware from my server but i can buy many
medium price hardware for my server.
note: i need this: when a user run a select query on this huge table
his/her request distribute between many hardwares not one hardware.
I'm having an issue trying to load some old CVS files created in the year 2005. I'm using SQL server 2008 express edition for now. I've never seen files in this format. For reason, i can't go into, i can't user SSIS and need to load them using the bulkinsert comand. the files contain about 20 fields with a mix of numerics and text. the text fields are delimited by 2 sets of quotes, and a , and the numeric fields by just a , with each line contained in double quotes.
ex """abc"",12,198504,""tom"",""Smith"",49,3322,""mai n st."""
how to define the format file so that i can remove the "" quotes before and after each text field and how to remove the set of quotes that each record is enclosed with.
Currently we have a single SQL server. It went down and the higher ups were none to happy. Lots of money lost, down time, unhappy customers....the whole nine yards. They want to throw all sorts of money at the problem and want a solution that is high availability and provides load balancing. I think I came up with a solution.
3x Windows 2003 Enterprise Edition servers running SQL 2005 Standard in a cluster all connected to a SAN.
I'm guessing I need to set up Network Load Balancing in order to load balance the SQL database. What we would love to have happen is if one of the servers goes down, everything else just picks up. That coupled with our database that is increasing in size and transactions gets load balanced.
Am I going down the right path? Something else I should look at? Or that I am missing?
Thanks!
Currently we have a single SQL server. It went down and the higher ups were none to happy. Lots of money lost, down time, unhappy customers....the whole nine yards. They want to throw all sorts of money at the problem and want a solution that is high availability and provides load balancing. I think I came up with a solution.
3x Windows 2003 Enterprise Edition servers running SQL 2005 Standard in a cluster all connected to a SAN.
I'm guessing I need to set up Network Load Balancing in order to load balance the SQL database. What we would love to have happen is if one of the servers goes down, everything else just picks up. That coupled with our database that is increasing in size and transactions gets load balanced.
Am I going down the right path? Something else I should look at? Or that I am missing?
Thanks and sorry for posting this in multiple places!
Hi,
Here I will describe my problem.
1. We are loading large amount of data from database on background thread which is starting on Application_start event in global.aspx.cs file.The data is later cached for subsquent request to improve the performance.
2. Now when we put the application on web farm garden, it is not able to load the application.
3. We are sending the request the servers through Router kind of application.
4 This application is working fine on single server enviornment.
Please help us.
Ajay Kumar Dwivedi
Is the any issues running SQL 2005 Reporting Services on Load balanced web servers?
View 1 Replies View RelatedI just have done the SSIS example in the tutorial document included when install SQL 2005 ENT. I have a problem that whenever I test to run, the service load all data from source with out noticing about the data (I mean it load all the data to the destination), I do it several time and it continue to load all without checking. That mean the data is dublicated when the schedule run???
I think there should be a paramete or something like that to help the engine just load the new data to the destination. Could you help please?
Thank
I can't use DTS nor DTSwizard as I need to put it in a .sql and run it through a command line via .bat file (it's more for the users).
Each row ends with an EOL character, the fields are all fixed width, but I have a little problem here, some rows are empty but just with a EOL character.
How shall I go about it?
many thanks! :D
hello,
I want to load some table fromoracle database:
first : i created a datasource link between sql server and oracle database
second : i maked a flow to load data
Thus simple thing works good for one table...
But my question is how can i do for a group of table
In reality we have 30 table to do and i hear about variable, parameters ....
but i don't understand what it mean !!
so if somebody could explain to me the steps to do !!
I need to load the latest csv files from file server , The files are placed in a folder called -
Posted 02022015- --> csv files .
I am able to copy the csv files from filserver using bulk insert (manually) , giving the file location
I am having difficulty picking up the latest folder which is posted on the server and import it into database using a stored proc .
Hi,
How can i install Report server on a load balanced server.. My sql server is on a different machine and we have 2 webservers where we need to install Reporting services. Any help will be appreciated.
Thank you,
Karen
Please help. We have no idea what is wrong.
Error message occurs at the end of the load.
"Error at Destination for Row number 6218607. Errors encountered so far in this task: 1. SqlDumpExecptionHandler: Preocess 11 generated fatal exception c0000005 EXCEPTION_ACCESS_VIOLATION. SQL Server is terminating this process."
Thanks for your help
Adrian.
Is it possible to take a backup of a database and load it to another server?
I know the users id will be messed up. But, I don't want to do a detach
or a DTS task. I just want to verify that the backup is good.
thanks
I want to schedule a job on a 7.0 server that will run a LOAD DATABASE command on a 6.5 server. Is there a way to do this?
View 1 Replies View RelatedI tried to load data from the table in different server.
If I just want to limit one year data ( using date_key in that table ) then what task do I need to do that?
Please let me know.
Thanks.
I am trying to 'load' a copy of a SQLServer 2000 database to SQLServer 2005 Express (on another host). The copy was provided by someone else - it came to me as a MDF file only, no LDF file.
I have tried to Attach the database and it fails with a failure to load the LDF. Is there any way to bypass this issue without the LDF or do I have to have that?
The provider of the database says I can create a new database and just point to the MDF as the data source but I can't seem to find a way to do that? I am using SQL Server Management Studio Express.
Thanks!!
Hi there,
How do i load a XML document saved in SQL server as a XML data type into
XmlDocument xdoc = new XmlDocument();xdoc.Load(// INTO HERE );
I can load a xml file saved to disk but haven't figured out how to retrive from a recordset. I have tried the following:
XmlDocument xdoc = new XmlDocument();xdoc.Load(GetXmlFile(pnrID).ToString());
public string GetXmlFile(int pnrID){
SqlConnection cnn = null;SqlCommand cmd = null;
string XML = "";
try {
cnn = new SqlConnection(); cnn.ConnectionString = "Server=;Initial Catalog=;UID=;PWD=;"; cnn.Open();
string selectQry = "SELECT [XML] FROM [TEMP_PNR] WHERE PnrID = @PnrID";
cmd = new SqlCommand(selectQry, cnn);
cmd.Parameters.AddWithValue("@pnrID", pnrID);
SqlDataReader rdr = cmd.ExecuteReader();
if (rdr.Read()) XML = rdr.GetSqlXml(0).ToString();
}
catch (Exception ex) { throw ex; }
finally { cmd.Dispose(); cnn.Close(); }
return XML;
}
But this genereates the following error: Could not find file 'C:Program FilesMicrosoft Visual Studio 8Common7IDESystem.Data.SqlTypes.SqlXml'.
Any idea how i can achive this?
Hi!Currently we only have one SQL Server database in our production system. I would like to add one more SQL server 2000 database. I would like to configure them so that both server share the load and Failover. I did some research and I found that I can do this by installing the OS (Windows 2000 Server Enterprise Edition) and SQL 2000 Enterprise Edition on both machines using the windows clustering. I want both servers to be active. They both have a copy of the production data. What I don't know is that, if it is possible to synchronize the data on both databases using SQL Server Replication utitlites. From what I know one SQL Server must be Publisher and one Subscriber. Can one sql server be both? Because I want both sql server to be identical. Can I set up replication between more than 2 servers? We just need to add one server for now but I would like it to be expandable. In the future we may need more.So Please provide me some ideas and answers about the following.1- Can two SQL Server cross replicate (both update each other in order to be identical)?2 -Does replication work beyond 2 servers.?3- If you were to set up a production database; what do you recommend considering the load balancing and Failover using Windows 2000 Server Enterprise Edition and SQL Sever 20000 Enterprise Edition?Thanks,Michael
View 3 Replies View RelatedI need to create a test load a MS SQL Server 7.0 server of 250 users.
Does anyone know of any application(s) that can do or any processes
that can mimic a load such as this?
hi gurus,
im sure someone may have already posted this thread once before, but i cant seem find any topics using the search engines.
could some one point me in the right direction when it comes to inserting images into the databases. i.e. how to load/insert images into SQLSERVER2K
thanks in advance
I have to periodically overwrite selected tables in one environment (Prod) with the contents of the same named tables from another environment (Staging).
There are about 200 tables involved.
In SQL Server what would be the best way to do this and minimize logging?
Thanks in advance.
Gerry
Hi all,
The company that I work for has an internet application that has been running in our client's environment for 2 years.
The SQL box is a quad Xeon 750 with 4 gig of ram and over 50gig of disk. This box has 4 databases that are used for the application. The primary database is about 1.5gig in size (.mdf file) the others are relatively small.
The box is queried from a separate windows 2000 server box with our COM based application running under IIS.
The boxes are located on the same switched LAN.
Up until recently the application has been running fine, but all of a sudden we have had masses of database time outs and the processor utilisation is always 80-100. In turn these time outs crash IIS eventually.
I Understand all of the ideas about increasing the timeout in a command object, etc.
I have monitored blocking on the SQL server and over a 30 minute period of live usage I saw 1 block and 0 deadlocks.
In addition to the above often our application gets an imediate time out error, hence after no time.
We have also monitored the network bandwidth between the two boxes and they only use about 30% on average of available bandwidth.
My 1st question is - Does SQL give a time out error (hence refuses connections) if it is running at 100% and cannot handle any more load??
My 2nd question is, In other peoples experience is the box we are using powerful enough.
My 3rd question is, Can the network have an effect on the time outs even though there is plenty of bandwidth.
Thank you in advance for your time in reading this and I appreciate any input that you may have.
Simon Gratton
Senior/Lead Developer
Fastrack Software Ltd.