Title says it all. I want to be able to work with system stored procedures (sp_helpXXX etc) through generated Linq-To-SQL or Entity Framework wrappers. Problem is, system sprocs are not listed in the generation wizards. I have also tried running sqlmetal.exe manually, but no system stored procedures show up. ...
I need to determine the number of days in a month for a given date in SQL Server. Is there a built-in function? If not, what should I use as the user-defined function? ...
I have two databases: Oracle 10G and SQL Server 2000. Inside the Oracle database, I have several MS Word documents stored as BLOBs. What I need to do is extract the files from Oracle and place them into SQL Server. I am curious as to how I do this? I have heard something about DTS but not sure if that is something to look into. ...
Regarding Update and Insert triggers for MS SQL Server, is there a way to make them atomic? In other words, if an error occurs during the trigger, is it possible to automatically roll back the original insert or update? ...
Dear All, I'm working on a Python project that retrieves an image from MSSQL. My code is able to retrieve the images successfully but with a fixed size of 63KB. if the image is greater than that size, it just brings the first 63KB from the image! The following is my code: #!/usr/bin/python import _mssql mssql=_mssql.connect('<ServerIP...
Can a Sql 2005 database that uses the xml type be accessed with ODBC? ...
I've seen lots of questions regarding moving data from Access to SQL Server, but I'd like to go the other route. Here's why: I've been working on a sizable project with a SQL Server 2008 back-end and Access 2007 front-end. I'd like to be able to do some work on the front-end from home over the weekend, but I don't have access (VPN or ...
I am using the SQL Server Report Server from Microsoft SQL Server 2005. In the report server report viewer control, there is a CSV download option. The CSV download option is currently downloading a Unicode CSV file, which does not load into Microsoft Excel with the correct column formatting. If I save the Unicode CSV file and convert...
I am creating a website that I want to offer as a service. Each customer will have their own database, and each site requires two databases. If I have 100 active customers and they are all working in their sites, I could have 200 distinct connection strings. How do I find out how many is too many? I don't want to wait until I encounter...
Hi to all, we're working on an application that digs data from an Oracle DB and a SQLServer one. In need for a (possibly free) ORM solution, I'd like to use Entity Framework, but it does not support Oracle. Any suggestion? Thanks ...
Hi, We are developing an intranet web application on .NET 2.0 platform. The application is using Integrated Windows Authentication for Single Sign On. The users are authorized to use diffent modules according to the Active Directory Groups they are in. Up to the point where authentication and authorization is accomplished everything w...
I want to do something like this in TSQL (SQL Server 2005): IF (Column1 = x) { --CTE statement } ELSE { --SQL statement } Any help is appreciated. ...
Hi, I'm trying to build a report that will look like this: jan feb mar apr may jun jul ago sep oct nov dec food 0 1 1 2 0 0 3 1 0 0 1 1 car 1 0 0 0 1 2 1 0 1 2 3 4 home 0 0 1 2 2 2 5 1 2 4 0 0 other 0 0 0 0 0 0 0 0 0 0 0 0 I have two...
I have the following tables (and example values): user: user_id (1, 2, 3) username (john33, reddiamond...) password (pass1, pass2...) session: session_id (4,5, 6) user_id (1, 2, 3) activity activity_id (1, 2) name (running, walking...) user_activity user_activity_id (1, 2, 3, 4, 5) session_id (4, 5) activity_id (1, 2) All columns wi...
This is a pretty vague question and getting it answered seems like a long shot, but I don't know what else to do. Ever since I made my website live every now and then it will just freeze. You click on a link and the browser will just site there looking like its trying to connect. It seems the freezing can last up to 2 minutes or so, th...
My site (ASP.NET/C#/MS-SQL 2005) has multiple sections that allow for comments (User profiles, image pages, videos, etc). I want to store everything in a single comments table. My issue is linking the comment back to its parent. The user profiles' primary keys are uniqueidentifiers, while the images and videos use ints. I'd like to ha...
I implemented a full text search "searching in tags", using SQL server 2005, I want to describe for the client what i did, what what full text search means by simple examples? My Client is not a programmer but a good internet user. ...
I have a SQL server database (Tables, Views, SP...). I need to convert this database to Oracle 10g. How can I do it? ...
Hello, I'm working on an application that uses a third-party component, and this component returns a value that is of type UInt32. I need to store this UInt32 in a Sql Server table. I was thinking about just use a simple int column and insert the value like this: int value = (int)(cs - int.MaxValue); But I'm not sure if this is the b...
Hi, I am trying to install and configure SSRS on SQL 2005. When I click "Reporting Services Configuration", I get a message saying "No report servers were found on the specified machine" - Details Invalid namespace. How can I resolve this? Thanks ...