Hi Everyone, I am connecting to a SQL Server database via LINQ in my ASP.NET application (returning results to a web service). The problem is that it only returns results when I'm running it in debug/test mode - When I publish the service I get an error telling me "Login failed for user 'NT AUTHORITY\NETWORK SERVICE' " So how do I set ...
As part of my role at the firm I'm at, I've been forced to become the DBA for our database. Some of our tables have rowcounts approaching 100 million and many of the things that I know how to do SQL Server(like joins) simply break down at this level of data. I'm left with a couple options 1) Go out and find a DBA with experience adminis...
I'm trying to create a website for my friends and I to keep track of fantasy sports scoring. So far, I've been doing the calculations and storage in Excel, which is very tedious. I'm trying to make it more simplified and automated through a SQL database that I can then wrap a web app around to enter daily stat updates. It's premised...
Hi, I searched in google and also visited the decimal and numeric and SQL Server Helper to glean the difference between numeric , float and decimal datatypes and also to find out which one should be used in which situation. For any kind of financial transaction, which one is prefered and why? e.g. for salary field ...
While installing SQL Server 2005, I unknowingly uninstalled the existing SQL Express(I dont know 2005/2008) , but then I installed sql express 2005. But now the membership api is not able to connect to the sql express database. When I run my application with the Visual Studio 2008 , and try to login into my application I am getting the f...
Hi I edited SQLFile.SQL as "select * from" in order to have a new template when I create a new query. but it seems that still I have a blank window.... what's problem ? ...
I have this table called Online_Transaction and i want to show all the types of transactions and how many where made of each type (completed,rejected,pending for authorization) in a specific month. I have this query until now but I get repeated results any ideas? SELECT DISTINCT TRANSACTION_TYPE_ID , YEAR(CREATED_ON) AS YEAR , ...
Hi I am developing a software with vb6.0 :( . I wanna to know that what the best code for saving a file in SQL server and then reading from it is? I should say that I use ADODB.Stream when saving file..... what is you suggestion? ...
Hi, Can any one out there suggest a microsoft tool similar to Red Gate's sql promt,sql compare,sql data compare etc.Any help is appreciated.Thanks ...
I need to implement a function for moving records up and down (sorting) and saving the sortorder with Linq to SQL. I am using SQL Server 2000 but I might be able to upgrade if there is a solution for it with a newer version of SQL Server. I would love to hear any thoughts you might have on how to do it. ...
anyone know how can i delete duplicate rows by writing new way from script below to improve performance. DELETE lt1 FROM #listingsTemp lt1, #listingsTemp lt2 WHERE lt1.code = lt2.code and lt1.classification_id > lt2.classification_id and (lt1.fap < lt2.fap or lt1.fap = lt2.fap) ...
how can we get the restore in sql server 2000 of sql server 2005 data ...
I'm using Visual Studio 2008. I'm using an .xsd/tableadapters to access a SQL Server 2005 database. One of my tables has a DateTime field. When a record is inserted into the table, the time is automatically converted to the UTC time, which is fine. I just want to know where that takes place. Does SQL Server do the conversion or is .Net d...
I have a set of data in a table named BWHourlyReadings, for example: ServiceID Hour InputOctets OutputOctets ========= ==== =========== ================= 27222 1 383088 804249 27222 2 270529 688683 27222 3 247251 290124 ... up to 24 hours of data 27222...
What is the limit of rows in a table for SQL Server 2005, when SQL query starts getting slower? Is there any way to find out the limit? I understand it will depend upon the data length of a row. This will also depend on how many more data in other tables and the hardware available. ...
i have taken the default asp.net mvc template and customized to work for me. I want to now upload this to my hosting provider. how do i get the sql server database into my server. Do i just upload the ASPNETDB.mdf file. What is this file actually? Does it represent the whole database. Can i simply copy that file around to migrate m...
I have a PRODUCTS table, and each product can have multiple attributes so I have an ATTRIBUTES table, and another table called ATTRIBPRODUCTS which sits in the middle. The attributes are grouped into classes (type, brand, material, colour, etc), so people might want a product of a particular type, from a certain brand. PRODUCTS produ...
I have a stored procedure that does some parameter validation and should fail and stop execution if the parameter is not valid. My first approach for error checking looked like this: create proc spBaz ( @fooInt int = 0, @fooString varchar(10) = null, @barInt int = 0, @barString varchar(10) = null ) as begin if (@fooInt = 0 an...
I have several SSRS '08 reports that look great when viewed as a web page or exported to the various formats. Recently, someone wanted a data driven subscription to go out for the report. No prob. They were adamant that they did not want the report attached to the email or to link to the report from the email. No prob. Unfortunately...
Hi Everyone, This is my first post on stackoverflow, I hope one of many! My question is this: I'm using CTE in a query to detect and remove duplicate records in a table. This query works just fine in SQL Server 2005 / 2008, but in Compact it throws an exception: There was an error parsing the query. [ Token line number = 1,Token...