sql-server

How to connect to SQL Server with asp.net

I want to connect to SQL Server with ASP.NET. Can any one give me some sample program to do so? ...

Transfer data from partner continuously

I’ve been tasked with a implementing a system for continuously receiving large amounts of data from a partner. The data schema on the partners’ side is different from ours, so some transformation has to take place when the data is received and imported into our database. What’s the best approach to solve this task? I have some control ...

Handling Timeouts inside stored procedures

I have a stored procedure that executes a couple of queries. Each query might fail because of a timeout. I still want to continue to execute the other queries. Is this possible? Does a try catch work for timeouts? I can offcourse have different sps for each query, but that would make the application more complex. ...

stored procedures with sqlAlchemy

How can I call stored procedures of sql server with sqlAlchemy? ...

query with string manipulations

I need a query for the following problem. Table1 specifies the mandatory input fields. I will fetch the fields with inactive = 'No' and mandt field = 'yes' So i have 4 records with fields as sev,sev1,cde,frt. Table1: Fields Inactive mandt_field sev no yes sev1 ...

sql server 2000 instance specific setting to cause varchar to int error

Hi I am having an inconsistent issue being produced on one of my servers whereby I have the following Select * from SomeVarcharTable v join SomeIntTable i on i.MyInt=v.MyVarchar Where v.Id = SomeID The "MyVarChar" column is surprisingly of type varchar, and "MyInt" is of type int. Whats curious is that when I run this on my develop...

Is there any way to access inverted index on sql server full text search

I would like to get "content" () of full text search index as described in http://en.wikipedia.org/wiki/Inverted_index and http://en.wikipedia.org/wiki/Microsoft_SQL_Server#Full_Text_Search_Service. Content - name of word and occurences This question is related with my previous question without answer http://stackoverflow.com/questions/...

Cannot insert duplicate key in object (GetReparentedValue / hierarchyid)

Hello guys/girls, Using examples I found on the web I have created a function which reparents children using the GetReparentedValue. However when I have ran the code I get the following error: Cannot insert duplicate key in object. I understand why (because I am trying to reparent the children and the new parent already has children s...

Free Sql Server database documentation tool

Is there any free software to automate documetnation process Sql Server DB. Creating Reports smth like this: TableName: (TableDescription) ColumnName, ColumnType, ColumnDescription, IndexInformation thanks. ...

sql query distinct

My database record is as below:- cartid orderid foodid qty ============================== 92 107 5 1 93 107 5 1 94 107 5 1 95 107 11 1 96 107 5 1 97 108 5 1 Can it be arrange into this form? Assume that the max sum(qty)=3 f...

What is a good practice/tool for MSSQL database design and versioning?

We work with a small development team and a system engineer who deploys the software at certain times. At the moment we don't have any leading document for database changes. Changes are done in the staging database and added manually to production when the system engineer deploys a new release. We started to work with DBDesigner Fork t...

Intermittent slow query on SQL Server 2008

I am developing a system which periodically (4-5 times daily) runs a select statement, that normally takes less than 10 seconds but periodically has taken up to 40 minutes. The database is on Windows Server 2008 + SQL Server 2008 R2; both 64bit. There is a service on the machine running the database which polls the database and genera...

.Net - accessing multiple sql server groups / databases

My program (WCF service programed in C#) has to access multiple sql server groups and the databases within those groups (sql server). It looks like linq 2 sql definitely doesn't support this unless I create multiple dataclasses per database, and it looks like the entity framework is in the same boat. How would you go about setting up yo...

SSIS fails to create a package programmatically: No description found

Hey, Out of ideas and about to start pulling my hair out. Maybe someone out there can help: I'm getting the following error when I try to create an SSIS package from C#: Microsoft.SqlServer.Dts.Runtime.DtsRuntimeException: No description found ---> System.Runtime.InteropServices.COMException: No description found at Micr...

SQL Server 2008 100% CPU but not using a fraction of the memory it can

Suddenly our SQL server is using 100% CPU but only using a fraction of the memory it can use (16 GB available). We're using web edition and allocated a maximum amount of ram. Like i say this has just suddenly happened without us changing anything. Need some ideas desperately as it's crippling us ...

determining histogram bin size

I'm looking to create a histogram in SQL (which in itself isn't too tricky), but what I'm looking for is a way of splitting the bins so that each bin / band has the same proportion of the data included within. For example if I have the sample data (the value column) and I want to divide it into 5 bins, I know that I can work out the num...

What is the use of a transaction log on a read-only database?

In Sql Server, I find that, when I mark a database as read only, its existing large transaction log remains. To fix this I have to set it back to writeable, then dbcc shrinkfile on the log file, then set it read-only again. What is the use of a transaction log if the database is read only? Is there a reason it doesn't just get deleted/f...

How do I save an image in a SQL Server Database?

I want to save images that are uploaded with httppostedfilebase into a database. How do I do this? How do I structure the database fields? What code do I write to save it to the database? ...

SQL Server ANSI_Padding

If I right click on a table in SQL Server Management Studio and select 'Script table as > Create to > New Query Editor Window' the code that appears contains: SET ANSI_PADDING ON .... create the table ... SET ANSI_PADDING OFF So, I guess, whether ANSI_Padding is on or off affects the whole database and it is turned on to create a tab...

Upgrading the SQL Server upgrade, any dependencies?

I want to upgrade the SQL Server 2000 on Windows Server 2003 (sp1) to newer version (2005 or something better) Can it be done?, also what should i know more on that? ...