I am copying some user data from one SqlServer to another. Call them Alpha and Beta. The SSIS package runs on Beta and it gets the rows on Alpha that meet a certain condition. The package then adds the rows to Beta's table. Pretty simple and that works great. The problem is that I only want to add new rows into Beta. Normally I wou...
Is there a way to programmatically check for database object corruption in Access 2003? My development project has gotten complex enough that it's hard to manually check all the objects after a day of programming to see if some small control, form, report, query, or code object has been corrupted somehow. I already have the data split o...
I'm trying to determine if there's a better way to handle replication than the way we're currently doing things. We're essentially trying to determine 2 things: Is there any way to add an existing column from a table to replication without reinitializing the whole publication Can you just select a specific article to reinit...
I enter a name in textbox eg. "John" and save it in the database which it does, then i again enter "John" which it does not save. But if i enter "john", it saves this again... I need it to not save the john and vice-versa. ok so this is the textbox which is quiet normal: <asp:TextBox ID="TextBox2" runat="server" Width="80%" BorderColo...
Hello, I had to reformat my machine. I had a database working on my previous installation. I also have a web application that connects to this database on the same machine. When I attempt to access the database through the web application, I receive an error. So then I attempted to manually connect to the database. When I attempt to lo...
Hi All, I have what I think is a very basic scenario, but what I've read makes it sound like this is not easy in SQL Server Fulltext. I have 2 columns, First and Last name. I want to support fulltext search on them such that if someone types "John Smith" people with a match on both first and last come up first. Problem is, although i...
Hi, I'm new to Hibernate, I just started to do a mapping to a table, but I'm having some problems when I try to write an object, here's my unit test: [TestFixture] public class FacilityRepositoryTest : DatabaseRepositoryTestsBase { private IRepository<Facility> repository = new Repository<Facility>(); [Test] public void Can...
Using SQL Server 2000, consider a source table with more than 400,000 records. The task is to select each regno entry with an incrementing on-the-fly rowid or sequence number for those with duplicates or multiple entries. For those which do NOT have duplicate entries in the source table, the rowid should simply be null. Here's an exam...
SELECT PB_BANK_CODE, ---- DB ITEM PB_BANK_NAME, ---- DB ITEM TOTAL_AMOUNT --- NON DB ITEM FROM GLAS_PDC_BANKS where PB_COMP_CODE=:parameter.COMP_CODE AND pb_bank_code in(select distinct pc_bank_from from glas_pdc_cheques where PC_COMP_CODE=:parameter.COMP_CODE AND pc_due_dateTIME between :block01.date_from and :block01....
I am using a Common Table Expression for paging: with query as ( Select Row_Number() over (Order By OrderNum ASC) as TableRowNum, FirstName, LastName From Users ) Select * from query where TableRowNum between 1 and 25 Order By TableRowNum ASC Immediately after making this query, I make make an almost identical ...
hi friends, in my sql 2005 , 10 MB of disk space will be allocated for transaction logs. I wand to incease this 10MB to more ... Where is the option for increase this size manually in sql 2005? hoping ur response, ...
hi how i increase my disk space of database in sql server 2005? hoping ur support, ...
Can someone point me in the right direction for handling a PK conflict error in c# .net using Sync Framework. I am trying to sync between sql server 2008 and local data cache database (.sdf) and would like to keep BOTH rows that are conflicting in both server and client and NOT allow either the server or client win? I get a pk confli...
I have already a website and moving that to the new VPS. I have option either to go with MySql database or Sql Server Express 2008 edition database (I do not want to pay for SQL Server as I can't afford as I have other expenses also). I have around 10K hits per day for my knowledge based website. My questions are If I go with ASP.NET ...
I am a complete novice at SQL Server and naively thought that there would be a QUARTER() function, alas there is not and some googling didn't come up with anything useful! Basically what I want to achieve is that for all rows in my database I want a count of those rows grouped by Quarter. If possible I would like to keep all calculatio...
Hi everyone! I have a tricky problem. I have a very complex view in MS SQL 2005 with the following result: | ID | Name | ParentID | -------------------------------- | 1 | Cars | 1 | | 2 | Audi | 1 | | 3 | Toyota | 1 | | 4 | Trucks | 4 | Now I want my view to recogniz...
Hi all, I need some help with a SQL query for SQL Server 2005. Here is an example of the data in the table to be queried: Id PersonId PayrollNum ContractId PayrollFrom PayrollTo --------------------------------------------------------------------------- 1 432642 85110892 1 01/05/2009 ...
How does the SQL Server that comes with Visual Studio differ from the full one? And will I be able to use it to create a simple database for collecting metrics from a tool that I'm writing? What's the easiest way of getting a console up where I can type insert/select/create etc? ...
I have a report that calls 5 stored procedures, 3 of which are used for the display of data. The stored procedures work fine if called from Query Analyzer. However in Preview Mode in Visual Studio 2008 and on the Web Page it would throw an error on the last procedure - GenerateInstallReport. This report takes 4 parameters (customer ...
I'm generating a large script to do a bunch of inserts and updates. When I run it I get some errors, but the error messages don't let me pinpoint the problem - the line numbers are since the last "GO", so I can't find the right line. I'd like to add calls to my script to a function in T-SQL that will just write to the results window, so...