Hello Everyone,
I'm doing work for a client that stores word documents in a SQL server database and need to be able to do a search and replace from a stored procedure. I was hoping someone could point me in the right direction. It's Microsoft. So I know there has got to be a way to do it. :-)
Thanks!
Hello Everyone,
I have a client that stores word documents in a SQL server database and I am trying to import some text data from another database. The problem is that I need to convert the text to a word doc with minimal formating since they convert word docs to bitmaps in order to display the text on custom embedded devices that do not support unicode.
I was hoping someone could point me at the right docs/books that would give me the info on how to construct a word doc from T-SQL. Something like a word merge would work, but I'm not sure how to call it from a T-SQL stored proc.
Thanks a Million!
Hi Guys
i have a list of 10 word docs and i want to store them in sql server.
How can i do that??
Should i create any fmt files for that???
Thanks
Vic
I was putting a database together (its a C# application MSSQL)  the application will handle a few hundred customers records and save  maybe a couple of thousand  word docs/images/other doc files wondered if the way to go was blob or filestream, I see the medium and larger databases seem to go for filestream but just wondered as not much mentioned about smaller dbs.I do not think  security/disk space/super fast access  will be a big issue.
View 4 Replies View RelatedHi Everyone,
Can anyone provide me a good links for learning SSIS with some good examples?
Thanks,
priya
hey everbody,
i'm absolutely new to any sort of data management
here it goes: suppose we store 100 .txt or .doc files in sql server and we want that none of the files data should match more than 60%: the question which arises are
1. how do we store files in ms-sql (binary format or normal text)?
2. how do we match the files?
3. what code we write in c# for this purpose?
4. has this nething to do with pattern recognition?
My request to all new n active experienced user's to participate because Plzzzzz help me?
Correct me if I'm wrong...
There is a potentially costly error in at least 2 Reporting Services
2005 licensing docs on Microsoft€™s web site. They fixed the docs a few months
ago after I called and told them about it but, now they are bad again! Here are
links to the bogus docs:
http://www.microsoft.com/sql/howtobuy/howtolicensers.mspx
http://www.microsoft.com/sql/howtobuy/sqlserverlicensing.mspx
Both of these docs say that you need 2 SQL licenses to run
Reporting Services 2005 on a separate server from the SQL engine. This is not
true. You only need 1 license! You do of course need the correct number of CAL's or a CPU license.
The license.txt file that ships on the SQL Server 2005 standard edition install
disk is very clear about this. As you know this is the only doc that is
legally binding. It€™s the only doc that matters. Also, I called and talked to both the
licensing department and the SQL Server product manager about this. Both
confirmed that this was done on purpose in response to customer feedback!
Please help me pressure the marketing document at Microsoft
to fix these confusing documents once and for all! This will be my last post
about this issue. I felt that I had to make one final attempt to get this fixed
before I give up. I€™m having a lot of trouble getting people to actually read
the license.txt and understand the issue. I bet you $5 that the first reply to
this thread will be someone who says I€™m wrong but didn€™t actually read the
license.txt file.
Thanks,
Greg
i have report with parameter and he can have a null in parameter ther is null word can i change it to another word like all or any thing else
View 4 Replies View RelatedIs there a keystroke such as "CTRL-N" that would allow me to havemultiple .SQL files open at once in SQL Query Analyzer?I feel like I am "jumping through hoops" to edit multiple documents.I have to keep selecting "connect" from the menu bar to get a newdocument for editing.TIA-Brian
View 2 Replies View RelatedOK, I'm setting up my first database, and I need one field to hold very long html code (several pages worth of info each). Which field type works best? Someone told me "memo", but I don't see that option in MS SQL 7
View 2 Replies View Relatedhi!
I'm just wondering does anyone know how to create an sql command that can search word by word?
what i mean is like I have a product with name 'harry potter broom'.
I want an sql command where if i type only 'harry broom' this 'harry potter broom' product will show up.
Does anyone have any idea?
Here's my sql comand: (I'm using asp.net vb script do develop this system)
-------------------------------------------------------------------------
query = "select distinct * from product where " & _
"(pname like '%" & keyword & "%' or " & _
"pdesc like '%" & keyword & "%' ) and " & _
"(price >= " & price1 & " and price <= " & price2 & _
") and status <> 'out of stock' order by price asc"
-------------------------------------------------------------------------
Thank you.
Is the word "Name" a reserved word in SQL? look at line 10 of my stored procedure. When I use the word "Name"it is highlited in blue by SQL Server?
Note I only list part of the stored proc
1 CREATE PROCEDURE [dbo].[GetXMLPeopleNames] 23 (4 @Status nvarchar(3)5)6 AS7 SELECT8 PersonId,9 PersonDescription,10 Name,11 UpdateDate,12 UpdateAppUser13 FROM14 Customer WHERE Customer.PersonDescription=@Status15 ORDER BY
Hi all,
I work for a financial company where we send out lots of correspondence to clients on a daily and monthly basis. This would typically be something like a financial report, account statements, etc. We've decided to use PDF as the format which these documents must be in when our clients receive them.
Our marketing and sales departments designs the templates of these documents using Microsoft Word. They can save these MS Word documents in the Word XML format (either 2003 or 2007). We want it in XML format, because it is text based, and we can therefore string replace the content to update the template with a client€™s information. In the same token RTF would also do, but the file size when converted to RTF is a problem.
What I am looking for is a way to convert this XML into PDF using something like XSL-FO - i.e. we do not want to use the Word Interopt on our Production Server, firstly it is a little slow and secondly the production server is unmanned and we cannot allow a WinWord.EXE process to not close successfully for some or other reason.
I've tried a number of companies' evaluation software to try and achieve this (converting the WordML to PDF via XSL-FO), but so far no luck.
Does anybody know of a stylesheet out there with which I will be able to achieve this? Or an alternative method of converting MS Word files into PDF without using Word to do it?
Thank you in advance.
Regards
If I have a *.dts file, and want to change the originating server database from SERVERA DB_A to SERVERB DB_B, is there an easy method to do this, besides editing the file in the GUI form?
View 1 Replies View RelatedI need help transferring a SQL database. I currently have my website database on a SQL 4.0.27 (vdeck) and want to transfer it to a new server (VPS) which has SQL 4.1.2
I have imported the database to my desktop computer. It will not let me import to the new server. I have to edit/reconfigurate.
Any suggestions, comments, advice, help would be greatly appreciated.
Ed
ed.sistrunk@sistrunk.net
Can I edit database (Tables, SPs, Views,...) with ADO.NET?
View 3 Replies View Relatedhey guys,
is it possible to add or edit columns once there is data in the tables??
not the data in the columns but the columns themselves..
for example lets say i have a table with 4 columns and for some reason or
another, i want to add a 5th or 6th column after data has already been entered,
like a few months down the line..
I have scheduled a T-SQL job that runs every morning using Enterprise Manager. Now I want to change the SELECT and UPDATE statements that this job runs, but I can't find anywhere to edit a job that has already been scheduled. Any help would be appreciated.
Thanks
I keep getting "cannot update a timestamp column"!! How can I change the timestamp to all zeros? or can I not do that?
JOhn
Hi
I want to Enable Editing in the GridView
but there is a problem
the GridView take its data from 2 tables and I do this by the
build query
so I can't choose the " advance " button and check for enable update and delete statements
and when I try to build the update query in the update tap
I don't know what to write in the "new value" column
so how can enable editing in the GridView that take from
2 tables???????
please help me
and thanks
can someone help me why it produces an error....
error is: ERROR 22001 Microsoft ODBC SQL Server Driver SQL Server STRING or data of BINARY was cut short. ERROR 01000 Microsoft ODBC SQL Server Driver SQL Server statement was ended.
This is my code here for editing a record....
Protected Sub Button_save2_Click1(ByVal sender As Object, ByVal e As System.EventArgs) Handles Button_save2.Click '||||| Create string connection Dim StrConn As String = "Dsn=MS_PKG01;UID=emiline;APP=Microsoft® Visual Studio® 2005;WSID=MSHNP200603;DATABASE=MS_PKG01;Trusted_Connection=Yes" '||||| Create connection object Dim MyConn As Odbc.OdbcConnection = New Odbc.OdbcConnection(StrConn)
'||||| Open connection MyConn.Open()
'|||| Create odbcCommand object Dim Update_record As New Odbc.OdbcCommand("UPDATE TM0001 SET TM0001.syain_name = ?, TM0001.syain_pass = ?, TM0001.office_id = ?, TM0001.birth_date = ?, TM0001.empl_date = ?, TM0001.user_iden = ? ", MyConn)
Dim hireYear As String Dim hireMonth As String Dim hireDay As String Dim date_hire As String
hireYear = DropDownList_hire_yr.Text hireMonth = DropDownList_hire_mo.Text hireDay = DropDownList_hire_day.Text
date_hire = hireYear + "/" + hireMonth + "/" + hireDay
'|||| Add command parameters Update_record.Parameters.Add("@P1", OdbcType.Char, 8).Value = TextBox_id.Text Update_record.Parameters.Add("@P2", OdbcType.Char, 20).Value = TextBox_name.Text Update_record.Parameters.Add("@P3", OdbcType.Char, 20).Value = TextBox_pswd.Text Update_record.Parameters.Add("@P3", OdbcType.Char, 40).Value = DropDownList_office.SelectedValue Update_record.Parameters.Add("@P3", OdbcType.Char, 2).Value = date_hire Update_record.Parameters.Add("@P3", OdbcType.Char, 10).Value = TextBox_bday.Text Update_record.Parameters.Add("@P3", OdbcType.Char, 1).Value = DropDownList_iden.SelectedValue
'|||| Execute command Update_record.ExecuteNonQuery()
'|||| Close connection MyConn.Close() End SubEnd Class
Hi,
I want to get (SELECT??) data from a db (SQL), edit the data (+1) and then update (UPDATE??) the table with the edited value. How do I get the value from the db and then edit it and then update the field in the db?? Does someone has an example so I get on the way??
Thanks,
Roel
Is there anyway possible to edit table design with data already entered in the table.If not, is there anyway I can cut and paste the info back in. Ive tried importing to access and then back to SQL, however, when i tried to view my table design in ASP.NET webmatrix, it gave me an error.
View 1 Replies View RelatedI've just created a new maintenance plan (sql2k sp2) and attempted to re-enter it to make a change. right click - choose properities (or double click)...I see the dialog box 'flash' very briefly but it's not making itself available for editing.
I've deleted and recreated the plan ... same result.
I _should be able to edit it, shouldn't I?
thankx
--steve...
Hi guys
Am i able to deny the SA account access to a specific database?
thanks in advance for your help.
TheGing
I have a SQL 2000 SP4 server running on Windows 2003 SP2. About 6 months ago I started experiencing problems editing existing DTS packages. At that time it was just 1 package. (I tested that I could edit all others but this one package the first time I experienced the problem.)
But now it seems like anytime we experience import problems, I cannot edit the package so that I can verify that the import file is good. (So far the initial problem is always with the import file and once we figure out what that is and resolve it the package runs ok again.)
The problem is I'm planning on migrating to SQL 2005 and since I can't import DTS packages, I'm going to have to rewrite them as Integration Service Projects. If I can't edit the workflow tasks in DTS, it will be time consuming figuring out what the actual import file is. Also, most of these imports are coming from our AS400 which we are phasing out so I have to rewrite these to work with the new ERP package we are going to as we bring on each division.
I have not installed any post SQL 2000 SP4 hotfixes. So if anyone is aware of a hotfix that resolves this issue, please let me know.
Hi to all,
We have an application that used Ms-Access for its backend.
We wanted to move up to MSDE so I wrote a conversion utility that creates the SQL database, copies all the data from the Access database, creates all the indexes and relationships.
Now, the application used a lot of sql statements which would have to be rewritten for SQL Server so we decided to create a ms-access database with linked tables to the SQL server (ODBC). Don't tell me not to do that because I have no control over it :).
The weird thing happening now is that:
All the records that were moved from access are fine.
New records can be added fine.
However, when trying to edit/delete the new records, I get an error saying that:
Write Conflict.
I can't change the record because it has been changed by another user since I started editing it.
Any ideas?
Thanks
I've recently been upgraded to Office 2003 and primaraly use Access to edit SQL stored procedures on a SQL 2000 box.
It seems though from first glance, things have gotten worse since Access 2000.
No more colour coding for example and it also opens some in a view type mode.
Any recomendations on what I can use that would allow me to edit the SQL while updating it on the server and pull down data if needed?
Someone recommened Visual Studio but I'm unsure of which version to use.
Please direct me towards good documentation about updating, inserting and deleting data using views involving multiple tables.
Thanks
I have an SP which I use to insert into a table data from another. Forexample...INSERT INTO myWorkTable(Field1, Field2)SELECTmyField1, myField2FROMmyNewTableIt's a pretty straight forward sp. Now, the data that gets insertedseems to have remained in a state that stops me updating it later. TheSP is called by one app which is then closed and not used again untilthe following month. The sp shouldn't be used by anything else.I have another application which goes to the table (in my examplemyWorkTable) and is supposed to open and edit specific records whichit does correctly navigate to (a few days after the sp). It fails andI get an error message stating that the record is being edited byanother user. This record should not be opened by any other process.If I export the data and re-import it into the table, it worksperfectly fine.The code used to edit the table is fine and has worked for a couple ofyears and I'm happy with it. The only change I have made is to use anSP to import the data instead of an old method using Access 2000. Thefunctionality is the same, even though the connection is different.The Delphi app uses BDE.Inserting directly through SQL works as I would have expected and Ican edit the record as I need.I'm guessing that Delphi (which I use for the app) is somehow notfreeing up the data locked by the SP when it finished calling the SP,even when it is closed. However, it seems a little bizarre as I wouldexpect it to free up the data affected by the SP once it has finished(maybe this is the wrong assumption).So, my question is, can an SP lock records in this way ? If so,how/why and can I stop this once finished, or is there a way ofchecking / resetting records which were locked up and should no longerbe this way. I can't see anything obvious which shows the records arelocked, but am willing to delve further.ThanksRyan
View 2 Replies View RelatedI have some software (written in Delphi 5) which has been working forseveral months without a problem.I have been given a copy of the database on our development server(SQL 7) and have pointed the software to this. So, nothing has changedwith the software. In theory the servers should be the same.However, if I try to make a small change to any record (as I would onthe 'live' system), I get an error stating that another user isediting the record. Now, I'm the only person with access to thisserver. So am I stopping myself I wonder ?If I create an ODBC connection to the database through Access 2000, Iget the same error. I feel I can reasonably assume that the softwareis not at fault.I'm sure it's something SQL based, whether it's an error orconfiguration difference, but I'm stuck.I've checked who is locking/blocking, and yes it will show me ashaving the record open, but this is me attempting to edit the recordso I would expect this.I can edit the table directly in SQL, but it takes 30 seconds or more,freezes EM and then allows the change. Table info below :if exists (select * from sysobjects where id =object_id(N'[dbo].[PostReceived]') and OBJECTPROPERTY(id,N'IsUserTable') = 1)drop table [dbo].[PostReceived]GOCREATE TABLE [dbo].[PostReceived] ([PostID] [int] IDENTITY (1, 1) NOT NULL ,[Type] [varchar] (100) NULL ,[ClientsName] [varchar] (100) NULL ,[DateReceived] [datetime] NULL ,[EnteredBy] [varchar] (100) NULL ,[AssignedTo] [varchar] (100) NULL ,[DateAssignedTo] [datetime] NULL ,[Adviser] [varchar] (100) NULL ,[TargetDate] [datetime] NULL ,[CompletionDate] [datetime] NULL ,[Completed] [bit] NULL ,[KeyAccount] [varchar] (100) NULL ,[Notes] [text] NULL ,[Specific1] [varchar] (20) NULL ,[Specific2] [varchar] (20) NULL ,[Specific3] [varchar] (20) NULL ,[Specific4] [varchar] (20) NULL ,[Specific5] [varchar] (20) NULL ,[ToDelete] [bit] NULL ,[EnterUser] [varchar] (20) NULL ,[Returned] [bit] NULL ,[ReturnDate] [datetime] NULL ,[ReturnReason] [varchar] (87) NULL ,[PrintAdviser] [bit] NULL ,[EmailAdviser] [bit] NULL ,[EmailSM] [bit] NULL ,[EmailRegionManager] [bit] NULL ,[ReturnText] [varchar] (150) NULL) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]GO(Yes I know about using Identity in the key, but it's on my list tochange before anyone says anything).
View 5 Replies View RelatedHi, I need to modify the ModelGenerationRules.smgl file to increase the mandatory filter setting of 5000 records. This is much too small for our database. I know where the file is but I need to know how to make the change. Does anyone know how to change this?
Thanks
BB