Search Results

Search found 13925 results on 557 pages for 'ms office 2007'.

Page 137/557 | < Previous Page | 133 134 135 136 137 138 139 140 141 142 143 144  | Next Page >

  • MS SQL Index Scripting

    - by Fouad Masoud
    I'm using MS SQL 2008. Is it possible to create a script to loop over all tables in a database generating a set of index drop scripts and create scripts separately? What I have to do is drop all indexes on a set of databases to run a heavy data load process but then I want to re-enable all the indexes. I don't want to have to go through each table and script an index drop and then index create. Thanks!

    Read the article

  • MS SQL share identitiy seed amongst tables

    - by Net Citizen
    In MS SQL is it possible to share an identity seed across tables? For example I may have 2 tables: Table: PeopleA id name Table: PeopleB id name I'd like for PeopleA.id and PeopleB.id to always have unique values between themselves. I.e. I want them to share the same Identity seed. Note: I do not want to hear about table partitioning please, only about if it's possible to share a seed across tables.

    Read the article

  • joining null in MS SQL server, Oracle and informatica

    - by jest
    hi! I've two tables to join with a column(say emp_id)..if emp_id in both the tables have null values, how'll MS SQL server and Oracle treat??? Coz, i read that informatica will neglect the NULL rows when joining..if i handle the null, by substituting -1, a cross-join will happen which i don't want.. what can i do here? I cannot completely neglect the rows which has NULL. Thanks

    Read the article

  • How do I read Unicode characters from an MS Access 2007 database through Java?

    - by Peter
    In Java, I have written a program that reads a UTF8 text file. The text file contains a SQL query of the SELECT kind. The program then executes the query on the Microsoft Access 2007 database and writes all fields of the first row to a UTF8 text file. The problem I have is when a row is returned that contains unicode characters, such as "?". These characters show up as "?" in the text file. I know that the text files are read and written correctly, because a dummy UTF8 character ("?") is read from the text file containing the SQL query and written to the text file containing the resulting row. The UTF8 character looks correct when the written text file is opened in Notepad, so the reading and writing of the text files are not part of the problem. This is how I connect to the database and how I execute the SQL query: ---- START CODE Connection c = DriverManager.getConnection("jdbc:odbc:Driver={Microsoft Access Driver (*.mdb, *.accdb)};DBQ=C:/database.accdb;Pwd=temp"); ResultSet r = c.createStatement().executeQuery(sql); ---- END CODE I have tried making a charSet property to the Connection but it makes no difference: ---- START CODE Properties p = new Properties(); p.put("charSet", "utf-8"); p.put("lc_ctype", "utf-8"); p.put("encoding", "utf-8"); Connection c = DriverManager.getConnection("...", p); ---- END CODE Tried with "utf8"/"UTF8"/"UTF-8", no difference. If I enter "UTF-16" I get the following exception: "java.lang.IllegalArgumentException: Illegal replacement". Been searching around for hours with no results and now turn my hope to you. Please help! I also accept workaround suggestions. =) What I want to be able to do is to make a Unicode query (for example one that searches for posts that contain the "?" character) and to have results with Unicode characters receieved and saved correctly. Thank you!

    Read the article

  • WPF tooltip in MS datagrid

    - by klawusel
    Hi I show my business objects in a MS datagrid, containing "country", "city", "street", for example. I can set a tooltip for each column showing its content using a style, so I get the "country" as tooltip when hooverinmg over the "country" column and so on. But I did not succeed 1) to show the content of "country" when hoovering over "city" 2) to show the content of some other property (not even displayed in the datagrid) when hoovering the datagrid Any clues? Regards

    Read the article

  • How do you use MS Deploy with VS2010?

    - by JL
    I have VS2010, and I've opened up a web site. How can I now use MS Deploy to deploy to a zip file, which can be installed in a remote IIS site? I've searched through all the menu options, but can't seem to find out where to get started. Thanks in advance

    Read the article

  • ms sql server identity counterpart problem

    - by Guru
    hi there, I'm using MS Sql Server and I want to use identity constraint in it I know how to use it in following manner create table mytable ( c1 int primary key identity(1,1); ) the above code works fine but what if i want the identity column to have values as EMP001, EMP002,... instead of 1,2.... Thanks in advance, Guru

    Read the article

  • Outlook 2007 receives html mail as source with headers, others MUAs work fine. Why?

    - by Adriano Varoli Piazza
    I have a couple of simple forms that send an html-only email. Most clients (Gmail, Lotus Notes 8, hotmail/live, windows live mail, outlook express) receive the emails just fine, but Outlook 2007 does not. The code looks like this: $data=" <html> <body> <strong><u>$sub</u></strong><br><br> <strong>Name:</strong> {$_POST["nombre"]}<br><br> <strong>Phone:</strong>{$_POST["telefono"]}<br><br> <strong>Email:</strong> {$_POST["email"]}<br><br> <strong>Subject:</strong> {$_POST["asunto"]}<br><br> <strong>Question:</strong> {$_POST["consulta"]}</strong> </body> </html>"; $header = "Reply-To: $from\r\n"; $header .= "From: \"".$_POST["nombre"]."\" <$from>\r\n"; $header .= "MIME-Version: 1.0\r\n"; $header .= "Content-Type: text/html; charset=iso-8859-1\r\n"; $enviado = mail($destino,$sub,$data,$header); ($from is the only part of the message validated) The message received by the customer looks like this: Content-Type: text/html; charset=iso-8859-1 From: Consulta de "Boss" <[email protected]> Reply-To: [email protected] X-Mailer: PHP/ <strong><u>Solicitud de envío de recetas - CLIENT</u></strong><br><br><strong>Nombre y Apellido:</strong> Boss<br><br><strong>Email:</strong> [email protected]<br><br><br> Any ideas?

    Read the article

  • Showing bug count or CI build on a TV in the office

    - by Matt Frear
    I recently saw a blog post showing off different displays that some software development shops use for showing their bug count or CI build status on a nice TV in the office. I can't for the life of me find it now, and I can't find it on google either. Anyone know what I'm talking about? (I don't think this belongs on superuser or serverfault either) -Matt

    Read the article

  • Tools, scripts for working with MS SQL 2008

    - by hgulyan
    Hi, While working with DB, I find useful using some tools, that help me to solve DB problems. Some of them are: 1) Insert generator 2) A tool that can execute a script on a list of DB's 3) Finding a text in stored procedures and functions. 4) DB Back up scripts My question is, what are most useful tools, scripts(anything else), that help you to work with MS SQL? Thanks in advance.

    Read the article

  • How do I delete a signature from an Excel document using Office automation

    - by Guy Marom
    Hello, I have a signed Excel workbook and I want to delete the signature from it. The problem is that when I try to delete the signature there's a prompt for confirming the deletion and I want the process to be fully automatic. Here's a code sample, the prompt appears when the last line executes: Dim source As String = "c:\temp\signed.xlsx" Dim app As New Application() app.Visible = True Dim book As Workbook = app.Workbooks.Open(source, UpdateLinks:=0) app.ShowToolTips = False Dim sig As Microsoft.Office.Core.Signature = book.Signatures.Item(1) sig.Delete() Thanks

    Read the article

  • C# : MS Chart : SeriesCollection -> InvalidCastException?

    - by HeinrichStack
    What is the correct way to get the Series of a char in PPT 2010. I tried PowerPoint.SeriesCollection mySeriesCollection = (PowerPoint.SeriesCollection) myChart.SeriesCollection(1); throws the following exception Exception Type: System.InvalidCastException Further, What is the correct call in C# to get the series of a chart ? If I try this way: PowerPoint.Series mySeries = (PowerPoint.Series)myChart.SeriesCollection.Item(1); I get the following compile error : error CS0119: 'Microsoft.Office.Interop.PowerPoint.Chart.SeriesCollection(object)' is a 'method', which is not valid in the given context

    Read the article

  • How to convert MS doc to pdf

    - by magh
    How to convert doc to pdf using java api. where document contains various formats such as tables in ms word. when converting to pdf using iText. where actual document looks different to converted pdf. please provide any api not an exe installed for converting . must be an open source

    Read the article

< Previous Page | 133 134 135 136 137 138 139 140 141 142 143 144  | Next Page >