Hellow, everyone:
I have PDF files on local hard drive, and want to save them to the table in SQL Server. Can I execute by SQL Server? If yes, how to do that.
Someone said to create a table with IMAGE column, and write PDF files to this table. How about details for this way?
Thanks a lot.
ZYT
Hi ,
i want to save a employee image in my database.
I have chosen field type as varbinary.
Now is there any way to save image directly (like other data e.g text,no) into table column using Enterprise Manager ?????
thanx in advance
San
Using ASP.net I need to be able to save and retrieve PDF Files in SQL.I believe the best way to do this is through a BLOB datatype.I have been searching (without luck) for a tutorial/code sample explaining how to do this.Any help would be greatly appreciated.Chrisp.s. I know many prefer to store the files on the server and simply store pointers to the files in SQL, but I need to store the actual files in SQL.
View 8 Replies View RelatedHi all,
Can someone please brief me on how to save 'pdf' files(there are about 15 files) into a SQL database and retrieve/open it from a datagrid?
I have about 15 pdf files on my webserver and need to save it in the SQL database, so every pdf file saved in the database will have a primary key and the file will be saved either as 'ntext' or 'binary' type...I just have this rough idea.
If someone has a ready code in VB.net then nothing better( i know thats a shortcut :) but it will help me like a tutorial. C# code will do too, I can then convert the code to Vb.net
Thanks a ton.
to utf8 format through BCP or throuhg the dos command prompt?
Cheers
Hello:I didn't find any documentation that notes save point names are casesensitive, but I guess they are...Stored Proc to reproduce:/* START CODE SNIPPET */If Exists (Select * From sysobjects Where Type = 'P' and Name ='TestSaveTran')Drop Procedure dbo.TestSaveTranGoCreate Procedure dbo.TestSaveTranAsBeginDeclare@tranCount int--Transaction HandlingSelect @tranCount = @@TRANCOUNTIf (@tranCount=0)Begin Tran localtranElseSave Tran localtranBegin Try--Simulate Error While ProcessingRAISERROR('Something bad happened', 16, 1)/*If this proc started transaction then commit it,otherwise return and let caller handle transaction*/IF (@tranCount=0)Commit Tran localtranEnd TryBegin Catch--Rollback to save pointRollback Tran LOCALTRAN --<< NOTE case change--Log Error--Reraise ErrorEnd CatchEndGo--Execute Stored ProcExec dbo.TestSaveTran/*Should receive the following message:Cannot roll back LOCALTRAN. No transaction or savepoint of that namewas found.*//* END CODE SNIPPET */What is really strange, if there is a transaction open, then no erroris thrown. So if you execute as so:/* START CODE SNIPPET */Begin Tran--Execute Stored ProcExec dbo.TestSaveTran/* END CODE SNIPPET */There is no "Cannot roll back LOCALTRAN...." message.Questions:1-)Can someone confirm save point names are case sensitve and this isnot happening because of a server setting?2-)Is this a logic error that I am not seeing in the example codeabove?We have changed our code to store the save point name in a variable,which will hopefully mitigate this "problem".Thx.
View 4 Replies View RelatedHey,
I have an SSIS package that creates a new file and saves results into that file. However, the requirement has it that I need to create this file on a server residing in a different domain. How can I achieve this in an SSIS package when it is scheduled as a job?
Thanks,
Aravind
Hey all,
I know this is a very minor gripe, but I cannot find any way to get SQL Server Management Studio to stop prompting me to save queries. I've poked through all the options without success, but it doesn't seem possible that they would have left this out.
Am I out of luck?
Hello --
I'm building an app that will allow users to create their own photo galleries. At this point, I'm planning on storing all photos as byte arrays in SQL server image fields.
Besides the organizational benefit, is there a space benefit to doing this? That is, if I have 1MB of .jpg's, will those same images take up less than 1MB of file space within the database?
One of the reasons I ask is that most hosting plans out there seem to offer more "normal" disk space than is allocated for the database, so I'm trying to make a best plan to accommodate what will probably end up being the biggest disk space consumer in my app (the photos, that is).
Any other recommendations re: this scenario (hosting, best practices) are appreciated.
TIA,
Eric
Hi,
I'm just starting off in SSIS and have a question that I can't find an answer to...
I'm loading in a number of files (in separate Data Flows) and performing some transformations on them before merging them back together. What I'm not sure about is what I should be doing with the data at the end of each of my "Import Data From XXXX Flat File" Data Flows. Am I better off using OLE DB Destinations (or SQL Server Destinations) and saving this intermediate data to temporary tables, or am I better off using a Raw File Destinations and saving this intermediate data to files? Or is there, perhaps, a better option that I'm currently unaware of?
If the Raw File Destination is the way to go, then isn't there a maintenance issue with cleaning up all the files created? And will there not be a management issue to ensure that there is sufficient disc space available on the drive you are saving to?
I'm a bit confused and overwhelmed by SSIS at the moment, so any help would be much appreciated!
Thanks in advance,
Lawrie.
We have the following requirement :
1. In daily basis auto loop through each item in the invoice table.
2. passing invoice number into a Summary SSRS report as parameter.
3. Auto download ALL generated PDF reports into a window folder with a special file name format i.e. <INVOICE_NO>_<DATE>.pdf
how to achieve this via SSRS, Store Procedure or Power Shell?
I am new to sql sever management studio express, but a long time query analyzer user. This is a very basic question.
I want to change the default directory in sql server management studio express so that when I go to save a query, it is already pointed to the correct one. Where do I change that?
Thanks,
Nanci
Hi gurus,
I've created a linked server (and set up the corresponding schema.ini file) in order to perform bulk-inserts from some CSV text files into SQL tables (from my standpoint the text files are just for reading purposes). The linked server works fine (I can select the data in the files without a problem).
Now the question: is possible to automatically detect when one or more of those files change in order to start the import process automatically? Something like having a trigger created on the CSV files Or there's no easy way to do that so I have, to say something, to create a Job that periodically checks if the files have changed programatically (say, recording each file's timestamp everytime is imported and comparing the recorded value with the current one, or whatever)?
Thanks a lot in advance!
I proposed on a new server that we separate Data Files, Log Files, tempDB, Backups, etc. onto separate LUNS on a SAN with High Speed Solid State Drives.I was told that with the new technology with solid state SAN's that it would decrease performance and that it did not work the same way as it did when you had RAID 5's etc.I thought that if things were cared out correctly by a SAN Administrator they would know how to configure for optimal performance.
View 2 Replies View RelatedI have the need to delete old backup files via TSQL job. Found this solution online:
PushD "
emoteservershareDIFF" &&(
forfiles -m *DIFF*.sqb -d -1 -c "cmd /c del /q @path"
) & PopD
It works remotely if I run it via command prompt. But when I add this to a TSQL job on my remote SQL instance, it runs without deleting anything. What I'm missing?
I am trying to create a website that people can upload an image and have it saved to a database. Can someone point me in the right direction on this? What properties need to be saved in the db and how?
View 4 Replies View RelatedI have the need to allow a user to upload a file via the web and then save it into a database. THen I also need to be able to retrieve the file for download.
Can someone give me guidance as to code or a sample on how to do this.
Thanks.
When I am trying to save byte[] of an image to SQL server which is having an image column, I am getting an error like this " A severe error occured on the current command. The results, if any, should be discarded.". I am trying to save through a stored procedure.
In the sp also, the datatype is image.
Can you give a reply to this?
I am using a Wysiwig editor, FCKeditor, i my CMS. I try to save the html text from the editor in a SQL Server. But noting get stored in the database.
I think the problem is how the tabel in the datebase is setup.
How shall a tabel look like so it can store html?
Hi all,
When I try to save a DTS package on SQL Server(local),I have a error message "refused acces" ,T don't know what's the problem?
Any help will be appreciate?
thanks in advance
Hi im trying to save the location of images to a sql server db in the form of a url, i am trying to find out what datatype this comes under here. In ms access u can just select the hyperlink option in the data type dropdown and it saves the address entered into these fields as a hyperlink to the database. How can u do this in sql server ?????
View 3 Replies View RelatedHello All, I have a problem with my database. It appears that it does not save the passwords for a login account that I have created. Every time I put in the password (using the Management Studio) it looks like the new password has been accepted. But when I look at the password using properties, the password is different. Any ideas? Thanks a lot for your help.
View 2 Replies View RelatedWhen I try to save a package to sql server with the delpoyment manifest I got this error
TITLE: Package Installation Wizard
------------------------------
Could not save the package "C:copiaPackage.dtsx" to SQL Server "ATLANTE".
------------------------------
ADDITIONAL INFORMATION:
The SaveToSQLServer method has encountered OLE DB error code 0x80004005 (Client unable to establish connection). The SQL statement that was issued has failed.
------------------------------
The SaveToSQLServer method has encountered OLE DB error code 0x80004005 (Client unable to establish connection). The SQL statement that was issued has failed.
------------------------------
BUTTONS:
OK
------------------------------
===================================
Could not save the package "C:copiaPackage.dtsx" to SQL Server "ATLANTE". (Package Installation Wizard)
===================================
The SaveToSQLServer method has encountered OLE DB error code 0x80004005 (Client unable to establish connection). The SQL statement that was issued has failed.
------------------------------
Program Location:
at Microsoft.SqlServer.Dts.Runtime.Application.SaveToSqlServer(Package package, IDTSEvents events, String serverName, String serverUserName, String serverPassword)
at Microsoft.SqlServer.Dts.Deployment.DtsInstaller.SavePackageToSqlServer(WizardInputs wizardInputs, String packagePassword, Boolean bUseSeverEncryption, String serverName, String userName, String password, String packageFilePath, List`1 configFileNames)
at Microsoft.SqlServer.Dts.Deployment.DtsInstaller.InstallPackagesToSqlServer(WizardInputs wizardInputs)
===================================
The SaveToSQLServer method has encountered OLE DB error code 0x80004005 (Client unable to establish connection). The SQL statement that was issued has failed.
------------------------------
Program Location:
at Microsoft.SqlServer.Dts.Runtime.Wrapper.ApplicationClass.SaveToSQLServer(IDTSPackage90 Package, IDTSEvents90 pEvents, String ServerName, String ServerUserName, String ServerPassword)
at Microsoft.SqlServer.Dts.Runtime.Application.SaveToSqlServer(Package package, IDTSEvents events, String serverName, String serverUserName, String serverPassword)
Scenario: I have created a dataset from an excel file to display it on a screen. Now I would like to save this same dataset in a SQL Server table.
Any ideas would be greatly appreciated.
Thanks
Hi,
I want to upload a file (e.g. .xls, .pdf, .doc) and save into the Sql Server 2000 database through the web interface, and then to download this file. Any idea???
Hi,
I have to store images in database. I have a table which contains field picture which is an image.
How can I do this using C# ?
In Visual Studio .NET i found a code how to obtain BLOB values from the database but I do not know how to do upload an image to the database.
Thanks in advance for your help.
Rafi
how can i save pictures in sql server and retreive them
View 1 Replies View RelatedHi,on my dev-machine i am running SQL Server 2005 Standard Edition.Now i have to do a project for a client who is on a server with ASP.NET 1.1 and SQL Server 2000.Is there a way i can build his database in 2005 and export or whatever it as SQL Server 2000?I don't really like the idea of installing 2000 and 2005 side by side on the same machine.Thank you very much in advance.Tjerk Heringa
View 1 Replies View RelatedHi there,Not sure if this is the right place to ask. I have a custom object in ASP.NET called TransactionResponseObject.And I want to save this object AS IS - in one piece in SQL Server 2005 (instead of taking each and every property of it and individually saving it into separate columsn of a table in the database).Question:1). What type of SQL Server 2005 datatype will I be using in this case ?2). Is there a good and easy tutorial on converting a custom object into XML format? and perhaps saving the xml into the database (I feel it's just an extra step - meaning extra processing which i want to avoid).ThanksTorontoMale
View 1 Replies View RelatedI previously installed SQL 7.0 on my machine. The name of the Server was DEVELOPMENT. Unfortunately I needed to change the computer name, but I had already created my databases and did not want to lose the information. It was suggested that I should simply change the computer name and reinstall SQl. I changed the name to DEVSERVER. This seemed to work fine. Now I am having a problem when I try to create a DTS package on the renamed server from another SQL server . I receive the following error. "A connection could not be established to Development. Specified SQLserver not found" The server which is now called Devserver, is registered on the server I am creating the package from, however the message seems to imply that the server I'm connecting to is still called Developement and cannot be found. Any ideas would be appreciated.
View 8 Replies View RelatedHow to save more than 10,000 characters in SQL Server 2000? I have a text field in a table. but it only takes about 2000 characters.
Thanks,
hi all
I am working on query performance and tuning.
I want to save current statistics for the latter use. do SQL Server provide any utility or command (like exec dbms_stats in ORACLE and OPTDIAG in sybase) to do this?
thanks
Gourav
So now ive got a ssis project that works and does what i need it to. How do I save the package into sql server ?
View 4 Replies View Related