Search Results

Search found 62701 results on 2509 pages for 'sql function'.

Page 419/2509 | < Previous Page | 415 416 417 418 419 420 421 422 423 424 425 426  | Next Page >

• whats best practice for Log Truncation in SQL Server?

  - by kacalapy

  i have a production DB in SQL server and wanted to put the final touches after the functionality is completed. prior to shipping it out i want to make sure i have some clean up in the SQL server DB and truncate and shrink log files? can i have a nightly job run to truncate logs and shrink files? this is what i have so far: ALTER proc [dbo].[UTIL_ShrinkDB_TruncateLog] as -- exec sp_helpfile BACKUP LOG PMIS WITH TRUNCATE_ONLY DBCC SHRINKFILE (PMIS, 1) DBCC SHRINKFILE (PMIS, 1)

  Read the article

• Is it possible to specify a SQL Server schema name in a Rails ActiveRecord migration?

  - by Brian Sullivan

  The current convention where I work is to use SQL Server schemas like namespaces (e.g. Company.Employees, Company.Branches, etc.) Is it possible to get an ActiveRecord migration to use anything other than the default "dbo" schema in SQL Server?

  Read the article

• 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

• 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 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

• 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 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

• 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

• 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

• 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

• 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

• 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

• 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

• 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 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

• 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

• 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

• 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 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 | 415 416 417 418 419 420 421 422 423 424 425 426  | Next Page >