I'm using ASP.NET MVC. I inserted ASP.NET membership tables into my database and i'm getting the error written below. Solution maybe? Thanks. The 'System.Web.Security.SqlMembershipProvider' requires a database schema compatible with schema version '1'. However, the current database schema is not compatible with this version. You ma...
I am no good at SQL. I am looking for a way to speed up a simple join like this: SELECT E.expressionID, A.attributeName, A.attributeValue FROM attributes A JOIN expressions E ON E.attributeId = A.attributeId I am doing this dozens of thousands times and it's taking more and more as the table gets bigger. I ...
In the SO podcast episode 54 Jeff talked about using Visual Studio to save all the database objects to individual files. This sounded like just what my team needed to better implement database schema changes into TFS and I told my lead about it. He thinks it's a great idea to. Unfortunately, so far I've had no luck getting this to ...
When working in Access, whenever I delete a record from one table - it's corresponding record in another table is also deleted when defined as a one-to-one relationship. This would be normal behavior when I tell it to enforce referential integrity with concerns to deletes and updates (how I understand it). However, it seems to also do ...
I have to write an SQL view that returns the time part of a datetime column as a string in the format hhmmss (apparently SAP BW doesn't understand hh:mm:ss). This code is the SAP recommended way to do this, but I think there must be a better, more elegant way to accomplish this TIME = case len(convert(varchar(2), datepart(hh, timecolum...
I want to use a assembly in a SSIS task. However, it is unsigned and third-party. Therefore, I can't GAC it. What workarounds are available? ...
I'm able to execute a stored procedure which queries a Linked Server directly, but when I call the same sproc though ASP.NET then I get the following error: Access to the remote server is denied because no login-mapping exists. When I execute it through SSMS, I am connected through my Windows domain account. The site is ASP.NET ...
I have a table that I wish to find the first non-null value from 3 (and only 3) columns for each ID starting with Col1 then to Col2 then to Col3 Note: Col3 is NEVER NULL ID Col1 Col2 Col3 ------------------------------ 1 A B X 2 NULL C X 3 NULL NULL X 4 D NULL X To get the ...
How to I get the SCHEMA when doing a select on sysobjects? I am modifing a stored procedure called SearchObjectsForText which returns only the Name but I would also like to include the SCHEMA. Right now it is doing something similar to this: SELECT DISTINCT name FROM sysobjects I would like to know what tables need to be joined to ...
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? ...
What can bite me if I store a datetime as a float in the database? I have a very good reason for doing it so don't complain about that :) Edit: I was thinking about just storing convert(float, @thedate) in a float column. ...
Hi, I am writing a data comparison code in python to compare the data transformed in the SSIS packages. So, I have all the modules written that accesses the each and every task in SSIS packages. It compares fairly well except for those data that have different datatype, same values but different decimal places. I started out converting...
HI We am getting time outs in our asp.net application. We are using sql server 2005 as the DB. The queries run very fast in the query analyser . However when we check the time through the profiler it shows a time that is many times more than what we get in query analyser. (paramter sinffing is not the cause) Any help is much appreciated ...
Or will everything explode and kill a couple of kittens? ...
Hello, I often want to send sample apps to friends & colleages that work with a database. For real projects I'd like to include something in the repository that allows people to recreate the database quickly, to avoid having to depend on server X still being there in a few years. I'm not really good with MS SQL server management stud...
Im having a moment, what i want to do is really simple and i think im just looking at the wrong solution. I want to simply return a table that is sorted based on a datestamp of a related table. ie: Table 1: 200 MyStuff OK 201 Other Why 202 Flat So Table 2: 1 200 5/12/2009 MyValue1 2 200 5/11/2009 MyValue2 3 20...
I have a bit of an architecture problem here. Say I have two tables, Teacher and Student, both of them on separate servers. Since this tables share a lot of data and functionality, I would like to use this inheritance scheme and create a People table; however, I would need tho keep the Teacher table and the People records relating Teache...
Hi folks, I have the following database tables and a view which represents that data. The tables are heirachial (if that is how u describe it) :- EDIT: I've replace my 3 tables with FAKE table names/data (for this post) because I'm under NDA to not post anything about out projects, etc. So yeah.. I don't really save people ...
I am using the Visual Studio 2008 Web Site Administration Tool. I successfully configured it in one environment, but my second environment is not working. When I launch the tool, I get the error message immediately that the "Tool Has Timed Out". I have run the aspnet_regsql.exe to create the authentication db, and configured connection s...
hello guys can any one tell me the Real Time Usage of a Web Service? After calling a web service using the Web Service Task in SSIS, how can we use that web service? ...