We recently began testing our new SQL2008 servers running in Compat mode 100 and one of our .NET applications has stopped running and returning the error: The EXECUTE permission was denied on the object 'My Stored proc', database 'My Database', schema 'dbo'. Now I have already made sure that the login this application is making the c...
Is there any one using the management studio that comes with SQL Server 2008 R2 to manage an SQL server 2005 SP3 instance?. Are there any issues to watch out for? Any recommendations? Thanks. ...
Hello, My small team used asp.mvc 2.0/entity framework 4.0(model first approach)/Windows Server 2008r2/Sql Server 2008 r2 stack in out web site project. We've already complete developing process, and come to the web deployment stage. In this stage we are faced with the problem - ok we'll use vs2010 features for initial server/db deploy,...
I have a ASP.NET MVC website in IIS 7 running against a SQL Server 2008 R2 database, in which I have a linked server set up. The linked server is set up so that a SQL account from my database is linked to a SQL account on the linked server. All works fine until I recompile my website, and then it can't connect to the linked server anym...
In SQL Server 2008 R2 Reporting Services, we are developing our own custom data processing extension, using IDbConnection and friends, and we plan to add our own custom query designer, using IQueryDesigner. That all works fine, so far. However, we want to enable the use of the connection string "Edit..." button on the Data Source and S...
Hi, I developed an Asp.net application that uses Entity framework to connect to a Sql Server 2008(not R2) database. The client run the db script against a Sql server 2008 R2 database and it executed successfully. When the application is executed an exception is thrown: 'Sysutcdatetime' is not recognized as a built in function. After chec...
read many sites, guides, etc note :- cannot test what i am asking as do not have two computers :) so asking.. table partitioning simply means that the table is logically divided, such that a particular range is handled by a particular partition only there by reducing load and also allowing parallelism. there is a mention of partitions...
We have a large real-estate of existing SSRS 2008 reports that we are still maintain in production. However we are evaluating SSRS 2008r2 and would like to start developing reports that take advantage of the new features such as shared datasets etc. The problem is that AFAIK installing the tools for 2008R2 upgrades the Visual Studio 200...
hi, i want to know which approach is better to saving Webpage content to database for caching? Using ntext data-type and save content as flat string Using ntext, but compress content and then save Using varbinary(MAX) to save content (how i can convert flat string to binary? ;-)) An other approach which you are suggest to me UPDATE ...
Hi I'm trying to create a new "Local Database Cache" item in Visual Studio 2010 to sync against a local Sql Server Express 2008 R2 database. When the wizard pops up though the "Use SQL Server change tracking" checkbox is disabled. Any ideas? I tried running ALTER DATABASE MY_Database SET CHANGE_TRACKING = ON but that had no effect. ...
We are using the SQL Server Data-tier application and I'm having a hard time finding out what the current version a database is at. Is there a way to find it in SQL Server Management Studio Via an SQL statement From .net code ? Thanks Mark ...
I wuld like to do som automatic tagging of incoming text in our system and I was wondering if a full-text index is capable of providing a a ranked list of words given an indexed row. If not, do you have any suggestions on how to do this? We already have a system in place for auto tagging but its fairly brute-force (aka. slow) in its met...
Hi, I was working on reporting and analysis using the Data Mining Add ins for Excel 2007 using SQL Server 2008. Does any one have any idea if there is something comparable/similar which can be used for data analysis and reporting provided by Oracle?? Let me know if you do and a link would be very helpful :) Thank you, J ...
My problem is that I am receiving a "Configuration system failed to initialize." error every time I try to open or create a Business Intelligence Project in Business Intelligence Development Studio. I am on a fairly new install of Windows Server 2008 R2 Enterprise in which I first installed SQL Server 2008 R2 Enterprise (with the Busine...
I'm getting the error below when I try and access SSRS on SQL Server 2008 R2 I'm not sure how many others have started using SQL 2008 R2 SSRS, but I am having an issue with getting the error below when I try and access the reports server url "User does not have required permissions. Verify that sufficient permissions have been granted ...
Has anyone managed to get the transfer mechanism working with FILESTREAM columns? My code is as follows: Transfer transfer = new Transfer(sourceDatabase); transfer.CopyAllObjects = true; transfer.DropDestinationObjectsFirst = true; transfer.CopySchema = true; transfer.CopyData = false; transfer.CopyAllTables = true; transfer.Options.W...
Hi guys, Whenever i try to access SSRS 2008 R2 through a URL i.e after being published on the net it always shows a login prompt when accessing the report. The problem does not appear on the developement enviroment. how do i prevent this login prompt from showing whenever i try to access a report. at present we are solving this proble...
I am setting up my development machine and I am wondering if I should install SQL Server 2008 R2 (for Developers) or SQL Server 2008 (for Developers) on my machine. All of the databases that I work with are on SQL Server 2008 (not the R2). So I am torn. Should install what I am currently using? or should I be a bit forward looking an...
I need to search in a table for items which have all of my desired values in a column i.e. I have table : ID : 1 2 3 3 2 2 2 1 1 3 VALUE : 5 6 5 3 6 7 2 1 9 0 I want to give a StoredProc a list of values for example ("6,7,2") and it returns me all IDs that have all the given values in this case it would only returns 2 If I wanted ...
Hi all, is it possible to obfuscate or scramble a column in SQLServer 2008 R2 without having to use encryption or some highly ineffecient custom made function that does substrings ? :) greetings, Tim ...