Which versions of SQL Server does LINQ to SQL support?
Can SQL Server 2000 be used as the database for LINQ to SQL? Does LINQ to SQL rely on a specific version of Microsoft SQL Server? ...
sql-server
Get result columns from a StoredProc without exec it, using Microsoft.SqlServer.Management.Smo
I want to get a list of result sets and columns that i can expect from a SP. I have been able to get at the parameters, script... but i don't know where to get at the result sets and column names. using Microsoft.SqlServer.Management.Smo; using (SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["mydbconn"].C...
Hiberate problems, jdbc IDENTITY_INSERT is set to OFF
I am getting JDBC error when I attempt a commit through hibernate to SQL Server Cannot insert explicit value for identity column in table 'Report' when IDENTITY_INSERT is set to OFF I am using mappings generated by netbeans that contain, <class name="orm.generated.Report" table="Report" schema="dbo" catalog="DatabaseName"> <id...
Exceptionally slow database response time on Linq query
I have written what I thought to be a pretty solid Linq statement but this is getting 2 to 5 second wait times on execution. Does anybody have thoughts about how to speed this up? t.states = (from s in tmdb.tmZipCodes where zips.Contains(s.ZipCode) && s.tmLicensing.Required.Equals(true) ...
SQL Complains that Management Tools are not installed, but they are
Hi All, When I try to create a new Maintenance Plan in SQL Server, I get the following warning: The action you attempted to perform on a remote instance of SQL Server has failed because the action requires a SQL Server component that is not installed on the remote computer. To proceed, install SQL Server 2005 Management ...
Big difference in execution time of stored proc between Managment Studio and TableAdapter.
How could a stored procdure run in 10 seconds via Management Studio, but take 15 minutes via a TableAdapter for the same inputs? It is repeatable, meaning I have run it at least three times in each environment, and Management Studio is consistently about 100 times faster. I'm using .net 2.0 and SQL Server 2000 In SQL Server Management...
SSAS cube design, semi-additive measures, and running totals.
I have what is to me a bit of a tricky design issue in my SSAS cube. The question is related to general accounting practices, I have a fact table containing financial transactions (i.e. a ledger) and each of those transactions is tagged with a transaction date and a period. The period does NOT related directly to a day, or a series of ...
Inserting multiple rows in a single SQL query?
data is like 4 persons in each row their ids and office region. person id office in 3 columns ...
ASP.NET Web application security in VDS hosting
We are designing asp.net web application in wcsf. Web application will be deployed to Windows Server 2003 shared VDS hosting. Web site will be used for b2b, monthly service fee and credit card transactions used in web application so it must be secure site. I want to consider what must be done before deployment and i need an answer to a f...
Can Paradox 4.5 be set up on a server?
I have established a link using Netbeans and Paradox driver and can query the database. Can Paradox 4.5 (Borland) be set up on a server so that the database can be queried remotely? Please point me in the right direction. Thanks! ...
Visual Studio vs. SQL Server Management Studio - Your Pick
Just to preface: I work in a small company that does ASP.NET development and uses SQL Server 2005 for all of our database needs. I was curious as to what were the pros and cons of using Visual Studio or SQL Server Management Studio for our development on the database side (i.e. table creation, stored procedure writing, etc.). Right n...
What is the best way to publish c# app with PreLoaded Sql Server Express Database
I would like to distribute my C# application along with SQL Server Express 2005 and the apps corresponding database. When installed SQL Server Express 2005 needs to have my sample database automatically loaded with data, not just table structures, when it is installed. How can I accomplish this. Is there a way to do this with the Visu...
SQL Server Log File Confusion
Hey all I'm looking for some clarity on the SQL Server log file. I have a largish database (2GB) which lately wasn't backed up for whatever reason. The log file for the database grew to around 11GB which from my understanding is all the transactions and statements that occurred in the database. My questions: What causes the database...
Authenticating a Windows Mobile 6 Device
I have an application that runs on Windows Mobile 6 Professional PDA devices. The application is installed by browsing a url from the device and downloading a cab. Users capture information in the application and this is then replicated back to a SQL 2005 server using merge replication and IIS v6. Although the user needs to log into th...
SQL Retrieve historical sensor values at specific date times
Hello, I have a database that has a vessel pressure that is trended every 30 seconds. I would like to be able to retrieve a recording at a specific time of day for a number of days in the past. I am not able to base this on the server as a Stored Procedure or a View – I only have read access. I have created a routine that works for 17 da...
Remove autogenerate GUID column from Add Entry pages in Dynamic Data Web Application
I have a Dynamic Data Entities Web Application that uses a database with GUIDs as primary keys for tables. All of the GUID fields have the default value set to NEWID() so SQL Server will generate a new GUID for any record. However in my dynamic data web site, in the insert new entry pages the GUID field shows up and it is expected for th...
multiple resultsets in c# MVC
I am using Asp.NET MVC as a basic webservice for several searchengine type asp/ jquery sites. Database searching is straightforward: Model - Sql Server FullText Sproc returning XML View - N/a Controller - Authorise user/ Parse input return Content (Model.XML) The returned XML contains four resultsets - item list, category breakdown,...
Is there a quick way to report database metadata in SQL Server 2005?
Are there any system stored procs to report the stats and metadata of a database itself in SQL Server 2005? What I need is a quick way to output a list of tables, the size of each table, the number of rows in each table and so on. Stored procs for individual tables and metadata would also be useful. Advice appreciated. ...
How to use a slowly changing dimension in Sql Server Analysis Services
In a data warehouse, I want to have a fact table which tracks certain metrics of a university application (average score on a standardized test, for example) and also the status of applications during different times of the year. For simpliciy, let's say a given application progresses through 3 states: New Being Assesssed Assessed an...
Selecting a large number of rows given the primary key
I need to select a large number of rows from an even larger table which is keyed on an autoincrement identity column. I have the primary key values for each of the rows that I'm trying to select, but it could be very large. Often, but not always, the rows that are being selected are contiguous, so I implemented a mechanism that convert...