Search Results

Search found 31357 results on 1255 pages for 'database indexes'.

Page 207/1255 | < Previous Page | 203 204 205 206 207 208 209 210 211 212 213 214  | Next Page >

• Database concurrency issue in .NET application

  - by MC.

  If userA deleted OrderA while userB is modifying OrderA, then userB saves OrderA then there is no order in the database to be updated. My problem is there is no error! The SqlDataAdapter.Update succeeds and returns a "1" indicating a record was modified when this is not true. Does anybody know how this is supposed to work, thanks.

  Read the article

• Use AJAX to watch SQL database for changes.

  - by Jacob Huggart

  I have a column in my database that will be updated randomly. Whenever that column is updated I need to refresh content on my page. How can I use AJAX + jQuery to perform an action only on DB changes?

  Read the article

• Find out how much storage a row is taking up in the database

  - by Vaccano

  Is there a way to find out how much space (on disk) a row in my database takes up? I would love to see it for SQL Server CE, but failing that SQL Server 2008 works (I am storing about the same data in both). The reason I ask is that I have a Image column in my SQL Server CE db (it is a varbinary[max] in the SQL 2008 db) and I need to know now many rows I can store before I max out the memory on my device.

  Read the article

• Corrupt Database

  - by user250545

  I am Looking For Best Way or Software To Recover Corrupt Database in SQL 2000/2005/2008 . looking for Ur help .......................................

  Read the article

• How do to massively alter primary keys to tables in sql server database

  - by shuxer

  Hi Is there any way to massively alter primary keys(uid) to all tables with no primary primary keys in sql server database ? I have a lot of tables and most of them don not have primary keys. Thanks in advance.

  Read the article

• Use database dynamically

  - by Redi

  This execution it is giving me an error! Any hints of what am I missing? declare @dbname varchar(500) set @dbname='master' Exec (' Use ' + @dbname + ' go create PROCEDURE [dbo].[krijo_database] @dbname nvarchar(2000), @Direktoria varchar(4000) AS BEGIN declare @stringu nvarchar(100) set @stringu = ''CREATE DATABASE '' + @dbname exec (@stringu) End ')

  Read the article

• Compact and Repair Database programatically

  - by Smashery

  How can I call Access's Compact and Repair Database utility from within C++? I'm already using ADO and ADOX, so a solution using either of those would be handy.

  Read the article

• Connecting to remote mysql database with API

  - by Ajay

  I am designing a desktop application in C#, which needs to be connected to my online mysql database. I tried to give access in control panel a "%" which means from any IP, but it is not working. May be the hosting provider (bigrock) not allowing that. Alternatively, I am trying to write some code in online on PHP which will get the "sql" as parameter and returns the output as JSON format using json_encode. Is there any alternate methods which is better approach.

  Read the article

• SQL Server 2008 - create database script (schema + data) with command-line

  - by dynback.com

  In SSMS when click on database "Tasks - Generate Scripts" I get an output script. How to make the same with non graphical tool?

  Read the article

• Connecting GPS coordinates taken from a database in Android using Overlay

  - by LordSnoutimus

  I am currently building an application that allows users to track where their phone has been on a Google Map. At the moment, when the onLocationChanged() method is called, the application stores the current GPS longitude and latitude in a database and calls the animateTo() method to the current position. Using SDK 1.5, how would I go about connecting these points with a coloured line drawn on the MapView using an Overlay?.

  Read the article

• Sql Query to list all views in an MS SQL Server 2005 database

  - by Matthias

  I need an sql query to enumerate all views (I only need the view names) of a specific database in MS SqlServer 2005. Thanks in advance!

  Read the article

• Import Excel spreadsheet columns into SQL Server database

  - by roy0911

  I have an excel spreadsheet that I want to import select columns into my database table. the wiz didn't offer that option. any easy code options? Thanks newbie

  Read the article

• How can seam-gen customized to support another database

  - by stacker

  I would like to create an application from a database schema using seam-gen, unfortunatly informix isn't supported out of the box. Where can I add another db?

  Read the article

• Loading from pickled data causes database error with new saves

  - by hibbie

  In order to save time moving data I pickled some models and dumped them to file. I then reloaded them into another database using the same exact model. The save worked fine and the objects kept their old id which is what I wanted. However, when saving new objects I run into nextval errors. Not being very adept with postgres, I'm not sure how to fix this so I can keep old records with their existing ID while being able to continue adding new data. Thanks, Thomas

  Read the article

• Get list of surrounding buildings based on coordinates from open database on Web

  - by Pentium10

  I would like to get a list of well-known buildings(museums, castles etc..) within X meters radius of the current coordinate. I would like to query them in PHP. Do you know any such database that can be queried?

  Read the article

• Using pg_dump to only get insert statements from one table within database

  - by Roland

  I'm looking for a way to get all rows as insert statements from one specific table within a database using pg_dump in postgres. eg I have table A and all rows in table a I need as INSERT STATEMENTS, it should also dump those staements to a file Is this possible?

  Read the article

• How to use DataPager with Database Paged

  - by Fujiy

  I am using ListView/DataPager. For performance reasons I page my results at database, using ROW_NUMBER(SQl2005). At my C# code just comes one page at time. How can I say to DataPager that I have more rows that really are at my List?

  Read the article

• How do I generate site map from MySQL database

  - by mathew

  Hi all I am new to Php and working on a project which needs to generate sitemaps from URLS which stored in MySQL database. how can I do this?? Is there any one have any idea?? site maps can be in php extension too and only requirement is list of sites display in each page

  Read the article

• jQuery datepicker calendar - call to function updates database

  - by erbaker

  So I'm using the datepicker plugin to make an availability calendar. Here is my javascript: http://pastebin.com/H7D9PcAg When dpSetSelected() is called it is also calling dateSelected() which triggers the AJAX call to my PHP script. I need a way to only update the database if the date is clicked on and not pre-loaded. When I pre-load the dates they are sent to the PHP page and subsequently removed.

  Read the article

• Adding to the schema of a subscribing database.

  - by NTDLS

  Transactional Replication on SQL Server 2005 Enterprise x64 (SP3). I need to add check constraints to a databases that is the target for a replication, but I cannot add the check constraints to the publishing database. The Problem is that the replication process keeps removing my constraints. How do I prevent this?

  Read the article

• Sharepoint content database user

  - by Dante

  Hi all, Somebody knows how to change the user account and authentication method sharepoint uses to connect to its content database? It is now setup to connect using Windows Integrated Authentication but I want to change that to a local user account. Is it even possible to do this? Thanks in advance

  Read the article

• Transfer table from one database to another?

  - by Mahmoud

  Hey all i am working at my project where it collects information from two database, one is supplied by the program lets name it DB Y and the other supplied by the user lets name it DB X , now i have an query that depends on companies which is on DB x so i want to transfer this table from DB x to DB y at run time and also checks if there is new updates in DB x and transfer them but i am confused

  Read the article

• how to upload a file from database without user interface in php

  - by hardworker

  Help!!! i want to upload a file from database(or from local m/c) to server in php without user interface. Is it possible. Please Suggest.

  Read the article

• Rails model without database

  - by FlipFlop

  I want to create a Rails (2.1 and 2.2) model with ActiveRecord validations, but without a database table. What is the most widely used approach? I've found some plugins that claim to offer this functionality, but many of them don't appear to be widely used or maintained. What does the community recommend I do? Right now I am leaning toward coming up with my own solution based on this blog post.

  Read the article

• XML array from SQLite database

  - by Aarron

  I am using SQLite to store school classes. I want to fill in a Spinner with the classes that get stored in the database. How would I grab all the classes in the DB and load them into a spinner?

  Read the article

< Previous Page | 203 204 205 206 207 208 209 210 211 212 213 214  | Next Page >