Search Results

Search found 31421 results on 1257 pages for 'entity sql'.

Page 492/1257 | < Previous Page | 488 489 490 491 492 493 494 495 496 497 498 499  | Next Page >

• SQLUG Events - London/Edinburgh/Cardiff/Reading - Masterclass, NoSQL, TSQL Gotcha's, Replication, BI

  - by tonyrogerson

  We have acquired two additional tickets to attend the SQL Server Master Class with Paul Randal and Kimberly Tripp next Thurs (17th June), for a chance to win these coveted tickets email us (sqlfaq@torver.net) before 9pm this Sunday with the subject "MasterClass" - people previously entered need not worry - your still in with a chance. The winners…

  Read the article

• ADO.net, Check if ObjectContext is writeable

  - by user287107

  I have an embedded database in an asp.net mvc project. If I try to write to the file, I sometimes get a write failed exception because the SQL Server can't write to the file. How can I check an ObjectContext, if its writeable, without actually writing something to the database?

  Read the article

• SQL Script to Assign All Items to ALL Sites with Dynamics GP

  - by Ryan McBee

  v\:* {behavior:url(#default#VML);} o\:* {behavior:url(#default#VML);} w\:* {behavior:url(#default#VML);} .shape {behavior:url(#default#VML);} Normal 0 false false false false EN-US X-NONE X-NONE …

  Read the article

• ASP.NET Membership and Roles separation relationship

  - by Saif Khan

  Hi, I have an ASP.NET project where I want to keep the membership (SQL Provider) in a separate database and the Roles/Profiles will be per application. Question What is the KEY that relates between the Membership database and the Roles/Profile database? Is it the UserID or UserName? I opened up the tables in separate expolrer and notice the…

  Read the article

• EF4: ObjectContext inconsistent when inserting into a view with triggers

  - by user613567

  I get an Invalid Operation Exception when inserting records in a View that uses “Instead of” triggers in SQL Server with ADO.NET Entity Framework 4. The error message says: {"The changes to the database were committed successfully, but an error occurred while updating the object context. The ObjectContext might be in an inconsistent state.…

  Read the article

• How to delete multiple records in enitity framework without looping using LINQ?

  - by VJ

  Hi I want to delete multiple records in enitity framework without using a for loop or any other loop using LINQ. Something that we can do it in SQL is there any way to delete multiple records in enitity framework

  Read the article

• SSAS: Using fake dimension and scopes for dynamic ranges

  - by DigiMortal

  In one of my BI projects I needed to find count of objects in income range. Usual solution with range dimension was useless because range where object belongs changes in time. These ranges depend on calculation that is done over incomes measure so I had really no option to use some classic solution. Thanks to SSAS forums I got my problem…

  Read the article

• La préversion du pilote ODBC SQL Server pour Linux disponible, avec des outils pour SQLCMD et pour importer et exporter des données

  La préversion du pilote ODBC SQL Server pour Linux disponible avec des outils pour importer, exporter des données et exécuter des requêtes et scripts Comme l'avait annoncé Microsoft lors de son salon Pass Summit 2011, la préversion (CTP1) de son pilote ODBC (Open Database Connectity) SQL Server pour les systèmes d'exploitation Linux…

  Read the article

• What is the preferred tool/approach to putting a SQL Server database under source control?

  - by msigman

  I've evaluated RedGate SQL Source Control tool (http://www.red-gate.com/products/sql-development/sql-source-control/), and I believe that Team Foundation Server 2010 offers a way to do this as well (as touched on here http://blog.discountasp.net/using-team-foundation-server-2010-source-control-from-sql-server-management-studio/). …

  Read the article

• Unable to determine the provider name for connection of type 'System.Data.SqlServerCe.SqlCeConnectio

  - by Hobbes1312

  Hi, i am using the Ado.Net Entity Framework with Code Only (Tutorial at: ADO.NET team blog) and i want to be as much database independent as possible. In my first approach i just want to go for Sql Express and Sql Compact databases. With Sql Express everthing works fine but with Sql Compact i get the exception mentioned in my…

  Read the article

• Why am I getting warnings about missing DLLs when adding a node to a WSFC?

  - by Stuart Branham

  We're getting the following two errors when adding a node to our WSFC. The node was added successfully, but the 'SQL Server Availability Group' resource type could not be installed on it. Unable to find 'hadrres.dll' on any of the cluster nodes. The node was added successfully, but the 'SQL Server FILESTREAM Share' resource…

  Read the article

• Cannot find one or more components. Please reinstall application

  - by Chris

  I am running Windows 8, 64 bit and have SQL Server 2012 installed. I downloaded the client tools, looked in the directory for SQL Server Management Studio, and see it's there. When I try to run SQL Management Studio I receive the error message: "Cannot find one or more components. Please reinstall application". This…

  Read the article

• ASP.NET/.NET: Method to determine whether string is or contains HTML entity

  - by ChrisIsTheBomb

  Is there a method anywhere in the .NET framework or System.Web that will tell me whether a string contains an HTML or is one? Should I just Server.HtmlEncode(myString) and see if its length is longer than myString's length before encoding?

  Read the article

• Restore DB - Error RESTORE HEADERONLY is terminating abnormally.

  - by Jordon

  I have taken backup of SQL Server 2008 DB on server, and download them to local environment. I am trying to restore that database and it is keep on giving me following error. An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo) …

  Read the article

• Linq to SQL - LoadWith used to load multiple child tables.

  - by Adam Walsh

  Here's what I'm doing: opts.LoadWith<Job>(j => j.Questions); opts.LoadWith<Job>(j => j.Categories); I keep getting an error that "Specified cast is not valid." However, if I do either of the alone, it works!

  Read the article

• The remote server returned an unexpected response: (413) Request Entity Too Large

  - by user1583591

  If anyone can help me figure out why I am getting the following error when making a call to my WCF service I would be eternally grateful. The maximum message size quota for incoming messages (65536) has been exceeded. To increase the quota, use the MaxReceivedMessageSize property on the…

  Read the article

• How can I stop SQL Server Reporting Services 2008 going to sleep?

  - by Nick

  I have SSRS 2008 set-up on a server. All works fine except that if left inactive for a length of time the next time a request is made to the server it takes a long time for it to service it. I think this is to do with the worker process being shutdown after being idle for a certain length of…

  Read the article

• FluentNhibernate IDictionary<Entity,ValueObject>

  - by Miguel Marques

  I had a mapping for a IDictionary<StocksLocation,decimal> property, this was the mapping: HasMany<StocksLocation>(mq => mq.StocksLocation) .KeyColumn("IDProduct") .AsEntityMap("IDLocation") .Element("Quantity", qt => qt.Type<decimal>()); …

  Read the article

• Can Sql Server BULK INSERT read from a named pipe/fifo?

  - by Peter

  Is it possible for BULK INSERT/bcp to read from a named pipe, fifo-style? That is, rather than reading from a real text file, can BULK INSERT/bcp be made to read from a named pipe which is on the write end of another process? For example: create named pipe unzip file to named pipe read…

  Read the article

• How to mass insert/update in linq to sql?

  - by chobo2

  Hi How can I do these 2 scenarios. Currently I am doing something like this public class Repository { private LinqtoSqlContext dbcontext = new LinqtoSqlContext(); public void Update() { // find record // update record // save record ( dbcontext.submitChanges() } …

  Read the article

• How many inserts can you have in a sql transaction.

  - by Mav

  I have a task to do that will require me using a transaction to ensure that many inserts will be completed or the entire update rolled back. I am concerned about the amount of data that needs to be inserted in this transaction and whether this will have a negative affect on the server. …

  Read the article

• Execute Backup-SqlDatabase cmdlet remotely

  - by Maxim V. Pavlov

  When I run the following script line locally on an SQL Server machine, it executes perfectly: Backup-SqlDatabase -ServerInstance $serverName -Database $sqldbname -BackupFile "$($backupFolder)$($dbname)_db_$($addinionToName).bak" $serverName contains a short name of the SQL Server…

  Read the article

• Map NHibernate entity to multiple tables based on parent

  - by Programming Hero

  I'm creating a domain model where entities often (but not always) have a member of type ActionLog. ActionLog is a simple class which allows for an audit trail of actions being performed on an instance. Each action is recorded as an ActionLogEntry instance. ActionLog is…

  Read the article

• JPQL / SQL: How to select * from a table with group by on a single column?

  - by DavidD

  I would like to select every column of a table, but want to have distinct values on a single attribute of my rows (City in the example). I don't want extra columns like counts or anything, just a limited number of results, and it seems like it is not possible to directly…

  Read the article

• T-SQL XML Query, how to seperate matching nodes into individual rows?

  - by FlySwat

  I have a table that has a column full of XML like: <parent> <child> <name>Sally</name> </child> <child> <name>Bobby</name> </child> </parent> I'm trying to extract all of the names of…

  Read the article

< Previous Page | 488 489 490 491 492 493 494 495 496 497 498 499  | Next Page >