Search Results

Search found 28220 results on 1129 pages for 'sql clr'.

Page 389/1129 | < Previous Page | 385 386 387 388 389 390 391 392 393 394 395 396  | Next Page >

• Sql Server OLEDB provider error. The provider ran out of memory error.

  - by Serdal

  Sorry for my english :). I have a windows service. Service report some excel files weekly. But i got a"OLE DB provider 'SQLOLEDB' reported an error. The provider ran out of memory" Ole Db error. Service use SQl Server 8.00.194 and it link another SQL Server. I do not know why i receive this error. Thanks for help.

  Read the article

• How to read data from SQL database and store it into an XML file ?

  - by Morano88

  I have a Silverlight application that reads its content from an XML file. User can enter data and It'll be stored in SQL database. How can I read the data from SQL database and store it into an XML file ? Thanks,

  Read the article

• Learning SQL & Microsoft Data Services stack - Where to start?

  - by Jim

  I'm trying to learn the Microsoft data / service stack. I want to build a database in SQL Azure and expose it to a c# client application. I've never worked with any SQL database technology. Looking online, everything just seems so confusing -- too many technologies, hard to tell what's new vs what's old. What's the latest technologies to look at, and what (books?) should I be reading?

  Read the article

• How do I reference SSIS on a build machine without installing SQL Server 2008 Client Tools?

  - by freshr

  I need to build SSIS packages on a build machine, and do not want the overhead of installing SQL Server Management Studio on this machine. A SQL Server 2008 SDK would be ideal, but I could not find where to download it. The dlls I require are (for example): Microsoft.SQLServer.ManagedDTS Microsoft.SqlServer.PipelineHost Microsoft.SqlServer.DTSPipelineWrap Microsoft.SQLServer.DTSRuntimeWrap I could attempt to copy them to the build machine individually, but I would rather just use an SDK if possible. Where can I get the SDK, or alternatively, what suggestions are there?

  Read the article

• How to know whether a sql Update statement executed successfully or failed ?

  - by Mike108

  How to know whether a sql Update statement executed successfully or failed ? I use sql server 2005.

  Read the article

• How do I assign different weights to columns in SQL Server Full Text Search?

  - by gcaprio

  I'm using SQL Server 2008 FTS and I'd like to be able to integrate weighted rankings into my search results. However, I'd like to weight the columns that a search term is found in differently. For example, if I have a Title column and a Description column, I want matches fond in Title to rank higher than matches in Description. Is this possible in SQL Server 2008? As far as can I see, I can only add weights to specific terms, not column locations.

  Read the article

• Is there any library to represent SQL queries as objects in Java code?

  - by Pregzt

  I was wondering if there is any library that can be used to represent SQL queries as objects in Java. In the code I have plenty of static variables of type java.lang.String that are hand written SQL queries. I would be looking for library having a nice fluent API that allows me to represent the queries as objects rather than strings. Example: Query q = select("DATE", "QUOTE") .from("STOCKMARKET") .where(eq("CORP", "?")) .orderBy("DATE", DESC);

  Read the article

• How do I view executed queries within SQL Server Management Studio?

  - by Brandon

  I am new to SQL Server Management Studio and am wondering if there is a way to see what queries have been ran against a database. Surely there is a way to see these. In the Activity monitor, there is a "Recent Expensive Queries" but I'm guessing that isn't all of the queries since I'm not seeing the ones I have ran. I am running SQL Server 2008 v 10.0.1600.22.

  Read the article

• SQL datetime LIKE select - why do I need an extra %?

  - by tomsullivan1989

  Can someone explain to me why when I perform a LIKE select in SQL (T-SQL) on a varchar column I can do the following: SELECT * FROM Table WHERE Name LIKE 'Th%' to get names beginning with Th, but when I do the same on a datetime column I need a % before the year, like: SELECT * FROM Table WHERE Date LIKE '%2013%' to get dates in 2013. The datetimes are stored in yyyy-MM-dd hh:mm:ss format. I know I could use a DATEPART style query but I was just interested in why I need the extra % here.

  Read the article

• Will existing DAO code work against a SQL Server?

  - by Craig Johnston

  If I transfer data from a Access MDB into a SQL Server, will DAO code in a VB app work against the SQL Server. I realise there will need to be changes to the initial connection calls but will anything else need to change?

  Read the article

• NullDisplayText in markup or ISNULL(field, 0) in SQL?

  - by abatishchev

  Which approach is better to use: BoundField.NullDisplayText isn't set. NULL-case is foreseen in SQL query, i.e. SELECT ISNULL(amount, 0) FROM table or BoundField.NullDisplayText is set, e.g. "0.00 %". NULL-case isn't foreseen in SQL query, i.e. SELECT amount FROM table What do you think?

  Read the article

• SQL SERVER 2000 is Slow & linked server send an error "Server dosen't exisit or Access is denied"

  - by amin

  Dears , I have a prolblem in my SQL SERVER 2000 , the server is so slow when i made any query and recently i couldn't link with other sql servers the message is "the server dosen't exists or access id denied" in spite of that the linked servers were working well and i can access them remotly & the service pack is SP4... any body can help .. thanks again.

  Read the article

• SSIS 2005 running in SQL Server Agent on local PC connecting to database on remote server produces t

  - by user317178

  Hello, I'm trying to run an SSIS 2005 package from a SQL Server Agent job on my local PC. This package is attempting to connect to a SQL Server 2005 database on a remote server, but it gets the error message, "Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'". What is the problem and how can I solve it? Thank you in advance.

  Read the article

• How to execute LINQ TO SQL within a T4 Template?

  - by NewT4

  Is it possible to execute a SQL (TSQL or Linq To SQL) from within a T4 Template so that the schema information from a table can be used to customized the code generation? Thanks

  Read the article

• SQL Alter Table to Add a Column, does it do anything "scary"?

  - by Pselus

  I need to add a column to an existing table in my live sql database. I know how to use the ALTER command, but what I want to know is the effect this has on the table. For example,, if using SQL Management Studio, it claims that adding a column will "drop and recreate" the table. Will the ALTER table command do that as well? This table is CONSTANTLY accessed and VERY important so I want to make VERY sure of this before going forward.

  Read the article

• How do I perform an accent insensitive compare (e with è, é, ê and ë) in SQL Server?

  - by ilivewithian

  I'm looking to compare two varchars in SQL, one would be something like Cafe and the other Café is there a way in SQL that will allow the two values to be compared. For instance: SELECT * FROM Venue WHERE Name Like '%cafe%' So if there is a venue with the name Big Bobs Café Extraordinaire it would be included in the result set?

  Read the article

• Should I use "User Defined Functions" in SQL server, or C#?

  - by sanity

  I have a fairly complicated mathematical function that I've been advised should be implemented as a User Defined Function in SQL Server so that it can be used efficiently from within a SQL query. The problem is that it must be very efficient as it may be executed thousands of times per second, and I subsequently heard that UDFs are very inefficient. Someone suggested that I could implement the function in C# instead, and that this would be much more efficient. What should I do?

  Read the article

• Can I install a second SQL Server instance on the same location as the first instance?

  - by Yousui

  Hi guys, Can I install a second SQL Server instance on the same location as the first instance? Can that cause some problem? By the way, I'm using SQL Server 2005. Great thanks.

  Read the article

• What are the SQL Server query syntax not supported by MySQL?

  - by ANP

  I am working in a project where we are using SQL Server database currently. But recently a decision has been taken that the database will be changed to MySQL. I am not using any stored procedures, views, triggers, user defined functions, etc. But I think even then some queries written for SQL Server will not be supported by MySQL. Can anyone help: what are the things that I have to check (and change) so that all the queries will work properly for MySQL also?

  Read the article

• On SQL Server 2008, how to find out when was any database offline/online ?

  - by niteshg

  I have to include one report in my application showing offline/online activity of few databases on SQL Server 2008. Could you please suggest how can I collect teh same information from sql server?

  Read the article

• In a C# app, what is the most optimal way to insert many records into sql server?

  - by Otter

  I need to perform a very large sql server insert from a c# application. Somewhere in the range of 20,000 through 50,000 records. What is the fastest way through SQL server to perform the insert? There are several options I know of, but I don't know which is the fastest. insert into MyTable(column1, column2, ..., column*) select 'value','value',...,'value' union select 'value','value',...,'value' VS insert into MyTable(column1, column2, ..., column*) exec('select ''value'',''value'',...,''value''' 'select ''value'',''value'',...,''value''') VS bulk insert from a data file VS Any better way that you know of :)

  Read the article

• Where are the assemblies to interact with Sql Server?

  - by dotnetdev

  Hi, I am running Visual Studio 2010 Ultimate and SQL Server 2008 R2 Nov 2009 CTP. However, I cannot find the .dlls for Sql Server (So that I can add tables, get the databases collection, etc). Can anyone tell me where dlls are based? Thanks

  Read the article

• How to index small words (3 letters) with SQL Full-text search?

  - by Sly

  I have an Incident table with one row that has the value 'out of office' in the Description column. However the following query does not return that row. SELECT * FROM Incident WHERE CONTAINS( (Incident.Description), '"out*"' ) The word 'out' is not in the noise file (I cleared the noise file completely). Is it because SQL Full-text search does not index small words? Is there a setting for that? Note: I'm on SQL 2005.

  Read the article

• Can somebody give me detailed construction how to find table scans with Sql Profiler?

  - by Lieven Cardoen

  I'm using SqlServer 2008. A usefull link is also ok. I've found some links, but since I'm not an expert with Sql Profiler, I can't seem to find how I would do this. By the way, some data is retrieved with Stored Procedures, but others are done with sql in the .NET server layer.

  Read the article

• How do i recreate a trigger in SQL Server?

  - by acidzombie24

  i use the statement drop trigger if exist TRIGGER in sqlite but sql server doesnt like the if statement. (i guess exist is the offending word). I do this right next to my create trigger statement because i want to drop older triggers with the same name so i can replace it with this new one. How do i do this in SQL server?

  Read the article

< Previous Page | 385 386 387 388 389 390 391 392 393 394 395 396  | Next Page >