Hello, I'm building a .NET CF 3.5 application that will communicate with an server based MS SQL server 2005. The communication will happen trough the devices's WiFi connection. I've been looking for a good O/R mapper and am a bit lost. Most sites/people assume that you're going to work with a local compact database and not with an ex...
Hello, Do you think Microsoft's RAP program worth the money you pay ? Any suggestions ? Thanks ...
I have an SSIS package named Extract.dtsx. I want to deploy it to the file system in F:\SQL2005\MSSQL\Package\Extract. The Package Instllation Wizard does this simply. I only have to choose "File system deployment" and choose the path, then click next a few times and finish. I'm having trouble figuring out if I can do the same this u...
Hi All, We are using SQL Sever 2005 replication for out application. Every thing is working fine without any problems. However, recently we ran into a situation to which I have no solution. We use merge replication with the publisher(sql server 2005) in one geography and the subscribers(sql server 2005 express) in multiple other geogra...
Hi there I have a table OrganisationStructure like this: OrganisationID INT ParentOrganisationID INT OrganisationName VARCHAR(64) 1 | 0 | Company 2 | 1 | IT DIVISION 3 | 2 | IT SYSTEM BUSINESS UNIT 4 | 1 | MARKETING DIVISION 5 | 4 | DONATION BUSINESS UNIT I want to have a query that if the app passing let say OrganisatinID = 1 mean...
I've got a c# class library that I call from an asp.net application. The assembly calculates grades for students and performs calculations using datatables and such. How can I use this assembly in SQL Server 2005 and call it once for each record in a database table? I want to re-use functionality and avoid writing the thing in T-SQL. ...
I have a rather big table named FTPLog with around 3 milion record I wanted to add a delete mechanism to delete old logs but delete command takes long time. I found that clustered index deleting takes long time. DECLARE @MaxFTPLogId as bigint SELECT @MaxFTPLogId = Max(FTPLogId) FROM FTPLog WHERE LogTime <= DATEADD(day, -10 , GETDATE()) ...
All, I'm trying to import a SQLBase database to SQL Server 2005. I select Import Data. For the data source I select the "Gupta SQLBase OLE DB Provider". Then I fill the properties and press "Test Connection". It replies that the connection succeeded. When I go to the next step I get the following error: TITLE: SQL Server Import and E...
Hi Crowd! I'm trying to connect to the sql server 2005 database from *NIX machine: I have the following configuration: Linux 64bit ruby -v ruby 1.8.6 (2007-09-24 patchlevel 111) [x86_64-linux] important gems: dbd-odbc (0.2.4) dbi (0.4.1) active record sql server adapter - as plugin ruby-odbc 0.9996 (installed without an...
Hi Sql Server gurus, I need to perform a query like this: SELECT *, (SELECT Table1.Column FROM Table1 INNER JOIN Table2 ON Table1.Table2Id = Table2.Id ) as tmp FROM Table2 WHERE tmp = 1 I know I can take a workaround but I would like to know if this syntax is possible as it is (I think) in Mysql. ...
I want to load a list of records given a possibly lengthy list of usernames (anywhere from one to thousands of usernames). Disregard how the name(s) are chosen, and assume they cannot be determined from any existing data in the database. This applies to SQL Server 2005. I specifically want to avoid using a single select statement with ...
I want to know what columns where updated during update operation on a triger on first scaaning books online it looks like COLUMNS_UPDATED is the perfect solution but this function actualy don't check if values has changed , it check only what columns where selected in update clause, any one has other suggestions ? ...
I have some computed columns in a table and need to know if I should set Is Persisted to true. What are the advantages? Are there any disadvantages? What does 'Is Persisted' mean? ...
Running sql server 2005 I have database A. I am trying to restore from a backup of A to database B. I want to retain the database A and create a new testing database B from a previous set of data. I tried to create B and restore from the .bak AND restore database to B from management studio. The error is... TITLE: Microsoft SQL Ser...
Hi, I have a very basic LEFT OUTER JOIN to return all results from the left table and some additional information from a much bigger table. The left table contains 4935 records yet when I LEFT OUTER JOIN it to an additional table the record count is significatnly larger. As far as I'm aware it is absolute gospel that a LEFT OUTER JOIN ...
I need an example C# source code that abstracts databases (easy to change from one database to another with minimal code modification). Do you know some sample sites or tutorials with good quality? Specific target databases are as follows: 1. Microsoft SQL Server 2. Oracle 3. MySQL 3. DB2 My specific requirements and encountered issue...
I noticed one of our internal apps was using DAAB, and that it appears to have some sort of connection leak. I thought I remember reading somewhere that when you used the following code: Database db = DatabaseFactory.CreateDatabase("ConnectionString"); IDataReader rdr = db.ExecuteReader("sproc") That the connection was closed for you,...
Does anyone know of any issues (performance or otherwise) associated with a FILEGROWTH setting as a % rather than as a fixed size? What advantage is there to % over fixed increments? ...
hello guys can any one tell me the Real Time Usage of a Web Service by Using the Web Service Task? ...
if you are careful and use TRY-CATCH around everything, and rollback on errors do you really need to use: SET XACT_ABORT ON In other words, is there any error that TRY-CATCH will miss that SET XACT_ABORT ON will handle? ...