Kodyaz Development Resources

HI,I am having full text search enabled column in my table, I want to search special characters in it (e.g. &)SELECT * FROM Text WHERE Contains(Data,'"*&*"');This query return without any resultsHow can i make this query work?Thanks in advance.Regards,SID

Is it possible to export SQL table to .XLS file on SQL Server 2005 64-bit edition? I understand I need to have 64-bit Excel ODBC driver installed on server hosting SQL Server 2005 but I can't find 64-bit version anywhere (can't even find 32-bit version). I'd like to save it in Excel 2003 format.Can anyone sched some light on this issue? Maybe I should use different approach.

This is actually really a question of best practice and paradigms and such, so hopefully I won't start too spirited a flame war with it...  I really just want some quality information.I've only been a .NET developer for about a year now.  I always considered routinely catching exceptions to be a sign of poor code, with the idea that if your code was often entering an exception block, you probably should have checked for it and avoided it instead of catching it.  However, here's a particular scen... [read more]

I'm looking for guidance/suggestions to increase the efficiency of how my application code can insert multiple records into a table.  The environment/constraints are as follows:   SSE2005, connected via TCP/IP over LAN application code uses ADO & OLE DB Provider for SQL Server   I have a table with a column definition like:   RowIdx(PK, smallint) ColIdx(PK, smallint) MeasVal(float)   I have a stored procedure to add a record to this table which takes all the above fields as params.   The applic... [read more]

Hi,I'm not sure, that this is the right forum, but I've a problem.I use SQL Server 2005 Express Edition, hibernate 3.1.3. and the MS jdbc driver. I can create the database schema, but I cannot import any data in DB. I get this error, when I try to import any data:[ERROR] [2008-08-27 09:53:26] (event.def.AbstractFlushingEventListener) Could not synchronize database state with session[java] org.hibernate.StaleObjectStateException: Row was updated or deleted by another transaction (or unsaved-value... [read more]

We are using a third party application, which  uses ODBC to connect to SqlServer. The Client application is setting the ODBC Command property :  CommandTimeout , to 20 seconds and this is embedded inside the code of the application. Is there anyway to intercept this property from inside the SqlServer and modify it to a higher value , so that some of our queries won't timeout ?   Thanks,      

  Hi,        I am Software Developer and  just want to know which language is good to use c# or vb.net in .Net framework.     Pls tell me with Technical reason asap

Hello Helpers Please i need help linking my Visual Basic 6.0 Application with SQL Server 2005 Express alongside Package and DEployment Wizard. Please i am planning to move to Dot Net but would need assistance on clearing my clients doubts on how to deploy my application without my presence. Please what i mean is how to incorporate SQL Server 2005 Express with Package and Deployment Wizard where it installs the Target machine automatically together with my Application and Database Attachment. Ple... [read more]

I have found that Access (2007 and previous) has this error when a date format is specified in the WHERE clause of an OpenForm or OpenReport method in VB, the date will get converted differently in the SQL WHERE clause that is sent to the SQL server by ODBC. Using SQL Sever trace shows the date format in ODBC seems to be always assumed to be US format MDY unless that doesn't convert and then the Regional setting format of DMY is used when that fails to convert.   Date entered into Access OpenRep... [read more]

Hi Folks,   i am missing some thing in the script which is not giving me a Dataset   Below is the script Create Table  AIG_TTSSIVA (  omsref                             varchar(16) null , moddate                            datetime null ) SET NOCOUNT ON begin  Insert into   AIG_TTSSIVA  SELECT   '0',''  Insert into   AIG_TTSSIVA  SELECT   SUBSTRING(a.uniquemsgref, 1, 16) AS omsref ,max(a.moddate) as moddate   FROM tmsg_status a  where  cONVERT(CHAR(10), a.moddate , 101) =  '08/05/2008'  Grou... [read more]

Hi,I have a view which has a union of two tables. But i want to have one more column for the row which acts like a unique value Column(auto incrementing column). My View is like thisCreate view vwGetMemberNotes as SELECT     NoteId as NoteId,    Member_Party_PartyId as MemberId,        CreatedBy as Author,     DateCreated as [Date],    UnStructuredNote as Note,     CAST(0 as bit) as IsStructuredNote,          [Private] as [Private]FROM     MemberUnStructuredNote  UNION ALLSELECT     NoteId as No... [read more]

  Hi,   Accessing SQL Server Using HTTP   I am exectly following the steps from Books Online and Online Net resources but still has an error what could be the reason.  I also tried SQLXML 3.0.   Can any one help in this case?   Thanks

Hi,   I am using Windows Vista as OS, VS2005 is IDE and SQL SERVER 2005(Destop Edition ie (SQLExpress)) as Database, when i am trying to connect through asp.net coding i am unable to connect the database. its throwing an error as "Could not open a Connection to SQL Server", i faced the same problem in my friend machine that is XP but i read some of the articles and corrected that problem its working fine. but mine is Vista Home Premium its the same error when i fixed same kind of things its not ... [read more]

 An existing system written in ASP uses UTF-8 in Web page, and stores the data as SQL_Latin1_General_CP1_CI_AS in SQL Server 2000. It can display the chinese on web page properly. Now I am developing a Java programe to read the data from that system's database directly. What a pity, the chinese cannot display on the web page correctly.After trying convert the data by using all charset listed in Java encoding, I find "CP1252" is most likely to work, like new String(origStr.getBytes("CP1252"),"UTF... [read more]

Hi Can someone help me out with the connection string to connect to SQL Server 2005 on a computer running Windows server 2003 from a Windows Vista machine via Visal Basic for Applications (VBA) code.   I have the following line in my code conn.ConnectionString = "Provider=SQLOLEDB;Data Source=SQLSERVER\SQLSERVER;Initial Catalog='ADO_Monthly';Integrated Security = SSPI;" The windows 2003 server and the sql server 2005  are both named SQLSERVER The error message is [DBNETLIB][ConnectionOpen (Conn... [read more]

I recently installed Visual Studio 2008 Express edition. The download went OK. What I am not sure about is whether I need to configure the sql server. What's missing are the visual tools that allow you to manage the tables and export data tables from excel. Are these tools only available in the trial version, or can they be configured to run with the express version. 

Hello. In a C# .NET program, I have to make some operations in database (in Sql Server 2005 - see below for more details info) with different "SqlConnections". These operations are made in the same .NET "System.Transactions.Transaction". Sometimes when one of the SqlConnection is opened, I have the following exception: "Transaction Context In Use By Another Session".This seems to happen randomly. The problem seems to be due to the fact the connections are opened almost "simultaneously" in differ... [read more]

The problem is that everytime i open an xlsx file it comes up with the error "The External table is not in correct format".I have worked out that it is the currentfile string, it doesnt appear to like it(comes from an openfiledialog). I entered the address of the file in the connection string manually and it worked. I have also compared the connection strings, the one used when i open the file myself, and the one when i entered the address into the code... they looked exactly the same :S, but th... [read more]

Hi ,    Unable to create linked server between SQL server 2005(64-bit )(already oracle 9i client tools installed) to Unix Oracle server  since no appropriate ODBC drivers for oracle exist OS - Windows 2003 server Enterprise edition 64bit Service pack 2 Processor - AMD opteron(tm)   Could not find ODBC drivers for oracle server but the drivers exist in SQL server 2005 32-bit version   Answers highly appreciated :)  

 I've got a large sql file (500meg) and I want to execute it.  How can I do that?  Sql Server Ent Manager will not load such a big file.

Ok so not everything for SQL Server 2008 is available yet, Report Builder is going to have a lag, you can find RC 1 here. This should work with RTM SQL 2008. Here are some of the changes from the last RC; Easy to use wizards for creating table, matrix and chart data regions. Support for directly opening and editing reports stored on the report server. Support for using server resources such as shared data sources. A query designer for Microsoft SQL Server data sources. Enhancements to ... [read more]

Get it here. That should not be all the pieces of SQL Server 2008 available.

I am trying to export a table from MS SQLServer 2000 to PostgreSQL 8.3 (Windows) using a SqlServer DTS which is using the PostgreSQL Unicode ODBC Driver (same problem aith ANSI). The table is 9 million rows and the DTS starts OK but when I get to about record 819201 It blows up with the error "Error at destination row number 819201. Errors encountered so far in this task: 1. Out of memory while reading tuples."I am able to copy it OK from sqlserver to sqlserver and also to MySQL using the MySQl ... [read more]

Hi,   Since I have to work from home today, I decided to use my home machine that has a VPN connection that allows me to connect to a network at my work.  I also have a local installation of a SQL Server 2005 on my home machine. When I try to register a new SQL Server on my home machine using Windows Authentication, I get this dialog box where User name: and Password: text boxes are grayed out and populated with my local machine credentials.  Is there a way to make User name and Password text bo... [read more]

Hi all,I got to give a possible solution to a costumer and i need the following information about MS Access or SQL Server express edition.Are MSAcess Linked tables refresh automatically? In one first option solution i need to constantly count the number of records of a linked table and then do a SELECT from other linked tables.The other option that i'm thinking is use SQL Triggers on SQL Server, but have some question.Can i use a SQL Trigger based on a linked Server Table? The trigger should det... [read more]