Search Results

Search found 64482 results on 2580 pages for 'sql source control'.

Page 212/2580 | < Previous Page | 208 209 210 211 212 213 214 215 216 217 218 219  | Next Page >

• Source Browsing in FireFox

  - by lavanyadeepak

  Source Browsing in FireFox Just casually observed this a few minutes back with my Mozilla Firefox 3.6.3. When you do a view source of any  page in Internet Explorer it just renders as editable inoperative HTML. However in Firefox the hyperlinks are shown clickable and active. When you click on any hyperlink the most obvious and expected output…

  Read the article

• How Do I Escape Apostrophes in Field Valued in SQL Server?

  - by Mikecancook

  I asked a question a couple days ago about creating INSERTs by running a SELECT to move data to another server. That worked great until I ran into a table that has full on HTML and apostrophes in it. What's the best way to deal with this? Lucking there aren't too many rows so it is feasible as a last resort to 'copy and paste'. But, eventually I…

  Read the article

• SQL Server Command Timeouts Timeout expired. The timeout period elapsed prior to completion of the o

  - by user104295

  Hi there, we've had a ASP.NET web application deployed for a number of years now.... last week we migrated to a slightly slower server to save some money. Now we're frequently getting command timeouts: Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding This is understandable in that…

  Read the article

• Turning on multiple result sets in an ODBC connection to SQL Server

  - by David Griffiths

  I have an application that originally needed to connect to Sybase (via ODBC), but I've needed to add the ability to connect to SQL Server as well. As ODBC should be able to handle both, I thought I was in a good position. Unfort, SQL Server will not let me, by default, nest ODBC commands and ODBCDataReaders - it complains the connection is…

  Read the article

• GridView will not update underlying data source

  - by John Christensen

  So I'm been pounding on this problem all day. I've got a LinqDataSource that points to my model and a GridView that consumes it. When I attempt to do an update on the GridView, it does not update the underlying data source. I thought it might have to do with the LinqDataSource, so I added a SqlDataSource and the same thing happens. The aspx…

  Read the article

• My SQL query is only returning I need the parent aswell

  - by sico87

  My sql query is only returning the children of the parent I need it to return the parent as well, public function getNav($cat,$subcat){ //gets all sub categories for a specific category if(!$this->checkValue($cat)) return false; //checks data $query = false; if($cat=='NULL'){ $sql = "SELECT itemID, title,…

  Read the article

• SQL Server 2008 spatial index and CPU utilization with MapGuide Open Source 2.1

  - by Antonio de la Peña

  I have a SQL Server table with hundreds of thousands of geometry type parcels. I have made indexes on them trying different combinations of density and objects per cell settings. So far I'm settiling for LOW, LOW, MEDIUM, MEDIUM and 16 objects per cell and I made a SP that sets the bounding box according to the extents of the entities…

  Read the article

• How to create select SQL statement that would produce "merged" dataset from two tables(Oracle DBMS)?

  - by Roman Kagan

  Here's my original question: merging two data sets Unfortunately I omitted some intircacies, that I'd like to elaborate here. So I have two tables events_source_1 and events_source_2 tables. I have to produce the data set from those tables into resultant dataset (that I'd be able to insert into third table, but that's irrelevant). …

  Read the article

• Can't see *all* databases in a remote SQL Server instance

  - by George

  Yesterday I posted a related question on StackOverflow. This problem involved not being able to see a SQL Server 2008 instance on another PC. I am not sure why adding the port number enabled me to see a SQL Server that I could not otherwise see, since the port number that I specified was, after all, the default port. Now I notice…

  Read the article

• Tax Deducted At Source (TDS) for India Localizations

  - by LuciaC

  Do you have questions about TDS (Tax deducted at source) for India Localizations or want to know the latest information about this functionality? See Doc ID 1546099.1 TDS Tax Deduction at Source for India - Master Troubleshooting Guide. The document includes sections with the following information: …

  Read the article

• How can I drop a table if it exists in SQL Server 2000?

  - by Keng

  I have a DTS package that drops a table then creates it and populates it but sometimes something happens and the package fails after the drop table. If it's rerun it fails cuz the table hasn't been created yet. Is there something like "if exists" for SQLServer 2000 like in MySQL? thanks. Edit Thanks everyone! I went with…

  Read the article

• Where does a Server trigger save in SQL Server?

  - by Mostafa

  A couple of days ago , I was practicing and I wrote some triggers like these : create trigger trg_preventionDrop on all server for drop_database as print 'Can not Drop Database' rollback tran go create trigger trg_preventDeleteTable on database for drop_table as print 'you can not delete any table' rollback tran But the…

  Read the article

• How to control dojo widget classes, or how to get fine-grained control of style

  - by djna

  I am creating a UI with dojo that is emulting some aspects of an existing thick client application. I need to programatically put two different menu bars on the same page. I have successfully created the two menu bars using new dijit.Menu(); new dijit.MenuItem(); and so on. Now I want to give them slightly different…

  Read the article

• Can I add a delay to sql server transactional replication ?

  - by Brann

  I've got transactional replication configured from a database called DBProd to another database called DBWarehouse ; everything works fine, and transaction are usually replicated instantaneously to the warehouse .... which is my problem. I'd like to add a slight delay to the replication (something like 10 minutes), so…

  Read the article

• Possible to get PrimayKey IDs back after a SQL BulkCopy?

  - by chobo2

  Hi I am using C# and using SqlBulkCopy. I have a problem though. I need to do a mass insert into one table then another mass insert into another table. These 2 have a PK/FK relationship. Table A Field1 -PK auto incrementing (easy to do SqlBulkCopy as straight forward) Table B Field1 -PK/FK - This field makes the…

  Read the article

• SQL Server: How do I convert all varchar(max) columns to text type?

  - by bakerjr

  How do I convert all varchar(max) columns to text type? I know varchar(max) is recommended but I still want to use type text because CakePHP doesn't automagically convert varchar(max) to textarea (HTML form). How do I do it? Thanks in advance

  Read the article

• Enkive: Open Source Email Archiving

  Real-time search and recovery of email Open source - Programming - Languages - Directories - Python

  Read the article

• Custom Web Control - ParseChildren & Resource Objects

  - by Raybiez

  I hope someone can help me. I have the following custom server control: [ParseChildren(true)] public class MyControl : WebControl, INamingContainer { [PersistenceMode(PersistenceMode.InnerProperty)] public string MyProperty { get;set; } } It works perfectly with the following mark-up: …

  Read the article

• SQL: without a cursor, how to select records making a unique integer id (identity like) for dups?

  - by Dr. Zim

  If you have the select statement below where the PK is the primary key: select distinct dbo.DateAsInt( dateEntered) * 100 as PK, recordDescription as Data from MyTable and the output is something like this (the first numbers are spaced for clarity): PK Data 2010 01…

  Read the article

• SQL exclude a column using SELECT * [except columnA] FROM tableA?

  - by uu?????s

  We all know that to select all columns from a table, we can use SELECT * FROM tableA Is there a way to exclude column(s) from a table without specifying all the columns? SELECT * [except columnA] FROM tableA The only way that I know is to manually specify all the columns and exclude the unwanted…

  Read the article

• SQL Server Error: maximum number of prefixes. The maximum is 3.

  - by Ian Boyd

  Trying to run a cross-server update: UPDATE cmslive.CMSFintrac.dbo.lsipos SET PostHistorySequencenNmber = ( SELECT TransactionNumber FROM Transactions WHERE Transactions.TransactionDate = cmslive.CMSFintrac.dbo.lsipos.TransactionDate) Gives the error: Server: Msg 117, Level…

  Read the article

• iSafePDF : the open source PDF signature tool

  iSafePDF is an open source software to sign, timestamp and encrypt PDF documents

  Read the article

• How can I format Custom Data and display in autocomplete when source is an DB

  - by Andres Scarpone

  so I'm trying to get some info in the auto-complete widget like it's shown in the JQuery UI demo Demo, the only problem is they use a variable that they fill with the data they want to show, I instead want to access the data and the different description and stuff using a Data Base in MySQL, for this…

  Read the article

• SQL Reporting 2008: easy way to share look and feel of reports?

  - by Gerrie Schenck

  What is the way to go to share a look and feel of a report among other reports in the same project? I want to share the layout, colors, etc. Thanks

  Read the article

• .NET app - Should we use SQL Server and duplicate some reference data from an external Oracle DB? Or use Oracle and have a DB link?

  - by Daventry

  We're looking to migrate some existing Excel/Access processes into a new system which will provide the users with a Silverlight frontend to run and view the reports instead of using MS Access. The initial idea was to have SQL Server 2008 as RDBMS. The problem is that we've got some static data such…

  Read the article

< Previous Page | 208 209 210 211 212 213 214 215 216 217 218 219  | Next Page >