Is it possible, in Microsoft Access 2007, to allow a user to select and update data only when they are editing via a form? I have a form which contains a datasheet of a foreign table (which in turn has another subtable). I want the users to only edit their own content via the datasheet in the form. Running a SQL backend, so stored proc...
I have a partitioned fact table on a SQL Server 2005 (Ent, Ed., 32 bit, SP2) that I am constructing a partition for (the fact table is a snapshot type). The process builds the data in a separate table, applies appropriate indexes and then switches the partition into the table. This has worked in the past The table structures are ident...
Oracle has SQL commands that one can issue so that a transaction does not get logged. Is there something similar for SQL Server 2008? My scenario: We need Tx logs on servers (Dev, QA, Prod), but maybe we can do without them on developer machines. ...
I have this query: SELECT web.KONTO, LAGKART.VARENUMMER, LAGKART.GRUPPE, LAGPRIS.PRIS, LAGKART.VARENAVN1, LAGPRIS.LXBENUMMER, LAGPRIS.ENHED FROM LAGKART INNER JOIN LAGPRIS ON LAGKART.VARENUMMER = LAGPRIS.VARENUMMER INNER JOIN DEBWEBVARER web ON web.VARENUMMER = LAGPRIS.VARENUMMER WHERE LAGPRIS.ENHED = web...
I have an automated daily import where I am running a SQL Server Integration package programmatically. The error message it reports is "Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding." I believe this is the same message reported when ADO.NET commands timeout. I have lo...
I'm getting the error: "This report requires a default or user-defined value for the report parameter '*'. To run or subscribe to this report, you must provide a parameter value." very occasionally from my reporting server even when the value '*' is being populated. Any ideas or leads that might allow me to track it down. Some points. ...
(no responses from my identical post on the MySQL forums, so I'm hoping to have better luck here) I'm trying to migrate a MS SQL database for a friend. I do not have physical access to the machine, nor do I have admin access -- just a read/write user. Using "SQL Server Management Express" in XP, I can easily login using IP/user/passwor...
Hi, I have a 2008 SQL Server Express installed on one of my machines and I'm attempting to establish a remote connection... when I use the MS SQL Server Management Studio I can log into the database without any problems at all (with the same credentials), but when I try to create a connection string in my C# application I get an excepti...
I have two tables that holds inforamtion for SKU. Log table has datetimefield 2008-10-26 06:21:59.820 the other table has datetimefield 2008-10-26 06:22:02.313 I want to include this datetime fields in join for these 2 tables. Is it possible to join to tables with datetime fields that has difference not more than 3 seconds? What is the ...
I'm working with an application that adds a new row to the database, based on the last row meeting a certain criteria. Is there a standard pattern for dealing with this type of problem, or do I simply need to lock the table? Here is an over-simplified visualization: A1 A2 A3 B1 B2 Using the visualization above, a web page loads up th...
I am getting started with ASP.NET MVC. Is it easy or even possible to use the ReportViewer in MVC as you can with webforms? If not, what can be done? ...
Hi, I'm trying to create a SQL 2005 query to retrieve and combine records from 3 SCCM Data Views. The first view contains records of valid PC's; the second contains logon-information containing: PC-id, username, timestamp, etc; the third contains PC-id, IP-address. The 1stview only contains a single, nique record per PC; the 2nd view ca...
Symptom: Sending an attachment using msdb.dbo.sp_send_dbmail results in the following error: File attachment or query results size exceeds allowable value of 1000000 bytes How can I increase that value? ...
I would like to export a ad hoc Select query result sets from SQL Server to be exported directly as Insert Statements. I would love to see a Save As option "Insert.." along with the other current available options (csv, txt) when you right-click in SSMS. I am not exporting from an existing physical table and I have no permissions to cre...
Do any versions of SQL Server support deferrable constraints (DC)? Since about version 8.0, Oracle has supported deferrable constraints - constraints that are only evaluated when you commit a statement group, not when you insert or update individual tables. Deferrable constraints differ from just disabling/enabling constraints, in that...
Currently In our database design we have an circular reference between two entities. In other words, we have foreign keys in each table that reference each others primary key. In order to insert records in these tables we need to perform a deferred constraint checking. Is this possible in SQL Server 2008? I know Oracle DDL has specia...
I tried to set the parameter value to system.dbnull.value but got some errors. thanks. ...
When reading about SQL I've come across the term 'slot'. For example, in a DBCC error message you may get something like this which references slot 0: Page (1:157), slot 0 in object ID 2121058592, index ID 0, partition ID 72057594038517760, alloc unit ID 72057594042515456 (type "In-row data"). Column "col2" value is out of range for da...
Question: If I install the Report Server webservice on machine A and I put the Report Manager web application on machine B ... do I need two licenses or just one? In other words, what constitutes installing SSRS 2008 on a given machine? Does the Reporting service = SSRS -OR- does any part of an SSRS install = SSRS with regards to lice...
I am working on SQL Server 2005 SP3. From Activity monitor, I notice a lot of processors were locked in suspended mode. do you know how to find who locks my processes? ...