I am trying a function import, and EF doesn't recognize my procedure. That's it: ALTER PROCEDURE dbo.AddNewTicketFieldOption ( @ticketFieldID INT, @optionID INT ) AS BEGIN INSERT INTO tbTicketFieldOptions (cdTicketField, cdOption) VALUES (@ticketFieldID, @optionID) --only to return something, EF hack SELECT 0 ...
I'm importing an SSIS package into SQL Server 2008 Integration Services . The package name contains dots and I'm getting this error message: The package name, What.No.Dots, contains characters that are not valid. The following characters are not valid: \ / : . * ? " < > | [ ] = Parameter name: What.No.Dots (MsDtsSrvr) ...
When creating a report using VS 2008 there is a typing delay in all the textboxes on the report designer. When I type in a textbox, whether a lone textbox or a textbox within a tablix, the text will not appear until approximately three seconds after I stop typing. I've recently installed SQL Server 2008 and I did not have this problem ...
Hi, I have an application that uses a SQL FILESTREAM to store images. I insert a LOT of images (several millions images per days). After a while, the machine stops responding and seem to be out of memory... Looking at the memory usage of the PC, we don't see any process taking a lot of memory (neither SQL or our application). We tri...
I have to pull a list of integer IDs from a table using only records that match some criteria. For example: Select ProdID From Products Where (ProdType='XYZ'); The catch is that I have to return it as a set of comma separated values so I can use it to select items in a multi-select list: 111,231,554,112 rather than as records. I d...
I am trying to configure SQL Server 2008 filestream in my machine by following the below article :- http://msdn.microsoft.com/en-us/library/cc949109(lightweight).aspx The article says one should disable 8.3 names and the last access for files in windows for performance reasons before proceeding to the SQL Server changes for enabling fi...
Dear GURUs I am running Server Application on Windows Server 2008 with SQL Server 2008, Now My scenario is as Given. I have implemented a custom Connection Pooling (why I did that its another long story). therefore I am not opening or closing connection on each request. Server Application executes more than thousands DBCommand in a m...
Hi, I'm trying to connect to a named SQL instance on the server. There is already default instance of SQL Server 2005 and a newly named one - SQL Server 2008. I'm using the "Network library" property to use TCP connection but for some reason, he try's to connect the default instance and omit an error about login error. If I remove the n...
Me and my colleagues have a question regarding SQL Server 2008 query length and the SQL Server Optimizer. We are planning to generate some stored procedures that potentially have a lot of parameters. Inside of our stored procedure we will simply select some values from a table joining other tables. Our stored procedures will look like ...
I am on SQL Server 2008 and I have a table containing WA metrics of the following form : CREATE TABLE #VistitorStat ( datelow datetime, datehigh datetime, name varchar(255), cnt int ) Two days worth of data in the table looks like so: 2009-07-25 00:00:00.000 2009-07-26 00:00:00.000 New Visitor 221 2009-07-25 00:00:00.000...
I want to Remove Invalid unicode Characters from a field in sql server. How to achieve that? ...
Alright, this is sort of a tough one. I've recently been working on a static content handler project, and this is hitting me hard. I cannot get the images to show up in the browser the same way I could before. The image is correct, and it's impossible because my code pretty much stayed the same. ob_start(); function ImageExistsSql($im...
I've looked into SQL 2008's built-in Full-Text search, and also Lucene.NET.. but I don't think they'll do what I need to do. And I just want to make sure I'm building my program as efficient as possible. So here's the dream. I want to have a single textbox on a page (like google) and allow the user to enter ANYTHING in. And based on ...
Based on this link it looks like I can get date inserted / date modified information "for free" (without the need for triggers etc.) using Sql Server 2008 by simply enabling Change Tracking. I am using Entity Framework to access the data. My question is, how do I access date modified / date inserted information for the database records...
We have a table of transactions which is structured like the following : TranxID int (PK and Identity field) ItemID int TranxDate datetime TranxAmt money TranxAmt can be positive or negative, so the running total of this field (for any ItemID) will go up and down as time goes by. Getting the current total is obviously simple...
hi i install visual-studio 2008, part ot the installation is the sql server 2005 express. how i can manage this sql server ? is there any visual tool for making tables ? run queries ? thank's in advance ...
I'd like to use the Bulk Insert Task using a format file to a target Server/Database/Table. The table may or may not already exist. Is there anyway to have the Bulk Insert Task in SSIS 2008 drop and re-create the table from my SSIS Format File as part of the process? ...
I need to work with several data samples, to say, N. The samples represent similar data but from different origins. For example, history of order in different shops. So the structure of all the samples is the same. To operate with the data I have several possibilities: Use N databases with identical schema, one for each sample Use one ...
Hi all, declare @t table ( id int, SomeNumt int ) insert into @t select 1,10 union select 2,12 union select 3,3 union select 4,15 union select 5,23 select * from @t the above select returns me the following. id SomeNumt 1 10 2 12 3 3 4 15 5 23 How do i get the following.. id srome CumSrome 1 10 10 ...
hi Is there any difference between sql server that comes with visual studio 2008 and sql server express 2008 ? thank's in advance ...