Search Results

Search found 30300 results on 1212 pages for 'temporal database'.

Page 500/1212 | < Previous Page | 496 497 498 499 500 501 502 503 504 505 506 507  | Next Page >

• MSSQL 2005 config file path of databases loaded

  - by Michael

  I need to find the path of the database (MDF) or at least the database logs loaded but for some reasons I cannot login through the MSSQL server so I need to know if you know any file/config file that keeps the path of the databases or log file .

  Read the article

• SQL most executed query?

  - by Esabe

  Hi everyone, I have a database in SQL Server 2008, and there are a lot of machines making queries against it. I know there is a SQL Server profiler, but I don't know very well how to use it. Is there any way to know what are the most common queries executed in the database? Through the profiler or not, it doesn't matter. Thank you very much in advance!

  Read the article

• domain name vs ip address, same server, but different speed

  - by bn

  I have two similar sites: - two of them have almost exactly the same codes, and running on the same server - both sites are the same, they just use different language. - database of the slower site is populated (maybe only the user table) the other tables for site content is the same - the faster uses root to access database one of the sites is not released yet, so it uses IP Address to access the site instead of domain name the site that is using IP address is faster (lot faster) the site that is using domain name is slower do you know why is this happening what could be the reason?

  Read the article

• Component for processing cube

  - by Sreejesh Kumar

  how do we process a cube or access OLAP database through ASP.Net with C# code? what is the component to be used, in C#.Net for connecting OLAP database or process actions in anaysis Services ?

  Read the article

• How to do bulk update of views?

  - by Shaul

  My database has about 30 views, most of which have a reference to another database on this server (call it DB1). Now, without going into the reasons why, I need to update all those views to DB2, also on the local server. I would hate to have to do this manually on each view. Is there some SQL query I can run that will replace all occurrences of the string 'DB1' with 'DB2' in all my views?

  Read the article

• Copy from Mac OS X does not copy to iPhone Simulator

  - by PARTH

  Hi Guys, In my iPhone app, I have many ASCII arts which I need to insert into the database. I am using the simulator and pasting the textpic in the textview to insert the ASCII art to database. Here the clipboard of simulator once pastes the art properly but when I copy another art then too it pastes the previous art into textview. How to solve this problem? Is there a work around for this or any better approach? Please Help and Suggest Thanks

  Read the article

• access 2007 locked

  - by Jack

  I m connecting the access 2007 database from 5 different machines. (C#.Net) I m having this error message: The database has been placed in a state by user 'Admin' on machine XXXXX that prevents it from being opened or locked

  Read the article

• Is there a Veil-like plug-in for MySQL?

  - by Kevin

  We have a MySQL database and would like to have row-level security implemented at the database level. I have been playing with the Veil plug-in for PostgreSQL and like what it does. Is there something similar for MySQL so we do not have to convert over to PostgreSQL?

  Read the article

• How do I add a record only if it doesn't already exist in SQL Server?

  - by menacheb

  Hi, I have a project in C# with a Sql-server Database. In that database I have a table named 'Process' and columns named 'process_name', 'Full_Name' and 'Version' (all of the type:nvarchar(50)). I want to write a query wich will add the new process, only if it doesn't exist in the table yet. How can I do that? Many thanks,

  Read the article

• update in the php

  - by DAFFODIL

  I wrote a code to insert data .When ,i enter the value in the form and click submit ,the data is getting into database. Now,i should make all those data to edit from from end and,if i click update button,it should be updated in database. Give a snippet for performing this task.

  Read the article

• not case sensitive query in mysql

  - by Mac Taylor

  hey guys i need to query my database and find results : mysql_query("select * from ".ALU_TABLE." where username like '%$q%' or name like '%$q%'"); if i have a name in my table such as Book and i enter book in search box it wont show the Book i need to query my database as not to be case sensitive.

  Read the article

• ajax security ?

  - by Tony

  When I look back my codes that written earlier time, I found something terribly bad. Whenever I want to delete a record in the database, I did like this : $.post("deleteAction.do",{recordId:10}); I cannot prevent a malicious user visit my database operation url directly : deleteAction.do?recordId=10 What's the solution for this kind of problem ?

  Read the article

• .net Studio Server-Explorer crash

  - by testerwpf

  Im programming a small databased application. It worked fine, but now when i want to add a new table, the Server - Explorer freezes and my .net Studio too. If i try to make a new app with database, - wpf application with .net studio, -ADD Local Database - then try to add Table, my Database1.sdf disconnects and again freeze! I am using Windows7 professional.

  Read the article

• (Python/Django): How do I keep my production db in sync (scheme and data) and with dev pc db?

  - by Emilio

  Hello, newbie here. i have a local Postgre database which will be filled with data (daily) on my local development machine. What is a good solution to transfer/sync/mirror this data to a production postgre database. For what it's worth I'm developing in Python using Dajngo. Thanks!

  Read the article

• how to create image thumbnails using django running on jython?

  - by Nitin Garg

  Hi guys, I am a newbee to django and jython. I need to create and save image thumbnails in database. I am using django running on jython and mysql database. I was exploring python imaging library, but the i found out that i wont work with jython. How do i create image thumbnails using jython and then save them in mysql db?? Any kind of help will be appreciated. thanx

  Read the article

• How to connect the PHPMYADMIN DB to create DB

  - by NewDev

  hi All, I am trying to create the batch file which will create the table in Jommla Database, Phpmy admin, I am trying to connect DB with mysql -uroot -ptest conf but it is not connecting to the database. regards NewDev

  Read the article

• How does timezone really work in relation to PHP and MYSQL?

  - by Rick

  I am getting very strange results in terms of timezones. I am currently using Wordpress and everytime I register a new user, I see the wrong datetime in the database. Ok so I am suspecting it is picking up the server time. So then I then set in php.ini to have date.timezone = "America/Los_Angeles" but again the time is still not correct in the database...And yes I have also set the timezone in Wordpress correctly. So how can this be done?

  Read the article

• How to create a "copy" of SQL Server transaction log file

  - by Salman A

  I want a copy of SQL Server transaction log file for "raw" analysis. What is the safest way to get a copy of that file without shutting down the database and disturbing the existing log/backups/backup schedules and just about everything. FYI, Its a SQL Server 2000 database server and I can see the log file (its about 4GB in size) and I cannot copy it as is; I get the "access denied" error when copying from explorer or command line.

  Read the article

• weekly Automatic running sql server script

  - by AmRoSH

  I have sql server script and i want to automatic run it on the database every week. any help. i tried sql server agent job but i have alot of data bases on my server and i should make step to every database and it will run in the same day and same time.

  Read the article

• Want to check fields for data fast.

  - by Tom

  We have a database setup that consists of two parts: a static structure, and dynamic additions. For each database, the dynamic can be different, and sometimes we don't have data for all the dynamic fields. Rigt now, we check for empties by looking at the total count of records in the entire table, but we want to move to a more refined method of checking for empties if possible. Is it possible to quickly check through several hundred fields and see which ones are empty and which ones are populated?

  Read the article

• Externalize BIRT queries

  - by shikarishambu

  Hi, Is there a way to externalize report queries for BIRT reports. We need to support multiple database engines and so our queries are different depending on the underlying database. I would like to use a config parameter to tell BIRT report to use a specific query file

  Read the article

• How to prevent users to change url parameter in PHP?

  - by Sachin

  I am developing a site where I am sending parameters like ids by url. I have used urlencode and base64encode to encode the parameters. My problem is that how can I prevent the users or hackers to play with url paramenters Or give access only if the parameter value is exist in database? I have at least 2 and at most 5 parameter in url so is this feasible to check every parameter is exist in database on every page? Thanks

  Read the article

• button submit with 2 different behaviour

  - by kawtousse

  hi, how could i set a variable with a submit button in order to differenciate 2 behaviours, so first time the same submit button will insert in database and in second time it updates database values. Thanks.

  Read the article

• MYSQL: Copying a table from a snapshot into production

  - by ming yeow

  Hi folks, i have a snapshot of the database that I took before i did some data migration. The data migration messed up, so I want to retrieve the data from the snapshot to migrate over to the production database. Question: How do i access the snapshot, and how do i retrieve the available data? Thanks!

  Read the article

• How to automatically reseed after using identity_insert?

  - by Earlz

  Hello, I recently migrated from a PostgreSQL database to a SQL Server database. To switch the data over I had to enable IDENTITY_INSERT. Well come to find out that I get all sorts of strange errors due to duplicate identity values(which are set as primary keys) upon doing an insert in any of the tables. I have quite a few tables. What would be the easiest way of automatically reseeding the identity of every table so that it is after max(RID)?

  Read the article

< Previous Page | 496 497 498 499 500 501 502 503 504 505 506 507  | Next Page >