Search Results

Search found 5375 results on 215 pages for 'sqlserver 2005'.

Page 143/215 | < Previous Page | 139 140 141 142 143 144 145 146 147 148 149 150  | Next Page >

• Inserting a null value into the database.

  - by J Harley

  Good Morning, Say I have an insert statement: Insert INTO tblTest (fieldOne,FieldTwo,fieldThree) VALUES ('valueOne','valueTwo','null') This statement doesn't seem to want to insert a null value into the database... I have also tried to insert the word "nothing". Has anyone any ideas how to make this work? I am using SQL server 2005.

  Read the article

• Migrated SQL Server database suddenly in "Restoring" state

  - by Pete Montgomery

  I backed up a SQL Server 2005 database and restored it to a new SQL 2008 instance. The restore was quick and successful. Everything was fine for an hour or so. Suddenly, the database is now stuck in "(Restoring...)" state in Management Studio and has a green arrow icon, and my application login is failing! Any advice? :-)

  Read the article

• unchecked the store only latest version in VSS for a project?

  - by SCM

  Hi I have an issue in VSS 2005, there is a project in VSS, having multiple folders files in it, and most of the files around 2000 having their property "Store only latest version" is checked. I don't know how it is set. I want to change those around 2000 files property "Store only latest version" to unchecked, so that VSS retain all those files previous version. can it be done through a single command to unchecked this option for all those files in project recursively? Thanks

  Read the article

• SSIS Lookup component only returns matching rows when using partial mode

  - by Myat Htut

  I am attempting to use a lookup transformation in my data transformation package and all of the other lookup transformations went well but one component returns the matching rows only when I enable the partial cache mode. If I use the full cache mode, all data is routed to the error path. I am using SQL 2005 SSIS. Any help appreciated..

  Read the article

• Physical size of MS SQL Table.

  - by jitm

  Hello, How to find what the physical size of table in MS Sql 2005? Is it possible using sql query or not? Thanks.

  Read the article

• Developing Forum in website using .net(C#)

  - by bachchan

  i m using MS.NET 2005/2008 with framework 1.1/3.1. currently i m developing a forum, from msdn web site. can any one help me??

  Read the article

• Deploy Window mobile application on Emulator 6.1

  - by mickey mouse

  Hi, I want to deploy my windows mobile application on windows Mobile 6 emulator, so that there is no dependency on Visual Studio 2005/2008. I require this for testing and demo purpose. Thanks, Mrinal Jaiswal

  Read the article

• How to edit a cell in DataGridView ?

  - by informative

  I am working in .NET 2.0 with C# and database is SQL SERVER 2005. I am using DataGridView. I had enabled "Enable Editing" Checkbox. Eventhough, I am not able to edit any cell.Please, give me a solution.

  Read the article

• Testing Sharepoint 2010 Beta

  - by jobless-spt

  Hi, I have a Virtual Machine with MOSS 2007 (Enterprise), VS2008 and SQL 2005. I want to start exploring 2010. I need to know what I need to get started. Can I donwload 2010 beta from Microsoft Site? Can I just install it without any conflicts with existing setup? Thanks.

  Read the article

• What Unit Testing Framework does gflags use?

  - by leeand00

  I'm trying to run the unit tests from the gflags project, and I'd like to know how to run them and what unit testing framework it is using to do this. I'm using Visual Studio 2005.

  Read the article

• VC++ and C# how to write managed DLL or unmanaged DLL?

  - by 5YrsLaterDBA

  If I need to provide a DLL by using C++ or C# to somebody. How do I know if my code is managed or unmanaged code? If I use VC++6.0, that means unmanaged and if I use .Net Visual Studio 2005 or later it will be managed code?

  Read the article

• Problem with sql like

  - by phenevo

  Hi, I'm writing sql query to my SqlCommand, and some part of them looks like: WHERE Path like N'+(select top 1 path from [Paths] where objectcode=@objectCode and objecttype=@objectType)+%' order by path desc,objecttype desc I get no records , bu when I wrote the same in sql server 2005 i have plenty rows... where path like (select top 1 path from [Paths] where objectcode='eg' and objecttype='0')+'%' order by path desc What's wrong ?? @objectType is 'eg'

  Read the article

• display selectedItems in a label

  - by Cecilia

  I need to display the selecteditems in a label I am using VB 2005 I set the selection mode to multi-extended It did work selecting only one item with the following code: me.xresultslabel.text= me.xlisttextbox.text.selectedItem.tostring But when I tried to display more than one item using the following code: me.resultlabel.text= me.xlisttextbox.text.selectedItems, I get the following string on the label: system.windows.forms.listbox+selectedobjetcollections. any help will be highly appreciate

  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

• Coping Indexes from old database to new one?

  - by AmRoSH

  Hi, I converted an old sql server database from 2000 to 2005 and forgetten to add old indexes to the new db. is there any way to copy the old indexes to the new db? any help?

  Read the article

• Sql string adding problem

  - by Woland

  SELECT a.one + ' test ' +b.two from table1 a right join table1 on a.id =b.id The problem is that when one is null then it the whole string is null, is there some kind of trick to bypass this problem msSQL 2005

  Read the article

• SQL Server Text type v.s. varchar data type

  - by George2

  Hello everyone, I have variable length character and want to store in SQL Server (2005) database. I want to learn some best practices about how to choose TEXT SQL type or choose VARCHAR SQL type, pros and cons in performance/footprint/function. thanks in advance, George

  Read the article

• DES?AES?RC4, which encryption method should I use for cellphone Encode and Decode?

  - by Mike108

  I have an asp.net web app storing user's cellphone number in Sql Server 2005. I want to use C# to encode cellphone number for security reason. Which encryption method should I use for cellphone Encode and Decode? DES?AES?RC4 or something else?

  Read the article

• Shrinking database

  - by user301751

  I have been tasked to shrink a SQL server 2005 database. This ia a live database and is runing at about 35gb. How do I shrink a database? Can this be done while that database is live? How big will that database bw when it has been shrunk? Thanks in advance.

  Read the article

• How to generate script/stored procedure to copy data from one database to another

  - by aein

  I had to restore may database to 1 day erlier, so My database is missing data from a day before, and this databse has been used by users since the restoration. How do I generate script/stored procedure to copy just the missing data from the backup database into my current database. There are PK and FK relationships that need to be considering. I'm using SQL server 2005 Thanks for your help. Aein

  Read the article

• I need to programmatically remove a batch of unique constraints that I don't know the names of.

  - by Bill

  I maintain a product that is installed at multiple locations which as been haphazardly upgraded. Unique constraints were added to a number of tables, but I have no idea what the names are at any particular instance. What I do know is the table/columnname pair that has the unique constraints and I would like to write a script to delete any unique constraint on these column/table combinations. This is MSSQL 2000 and later. Something that works on 2000/2005/2008 would be best!

  Read the article

• How can I connect to Sybase with Perl?

  - by Mike

  I'm trying to a good Perl module to use for connecting to a Sybase database. My Googling has led me to see sybperl as a possible choice, but it hasn't been updated since 2005.

  Read the article

• "Ambiguous column name" error on one particular server

  - by jazbit

  This simple query throws the "Ambiguous column name TaskID" error on one db-server only. This is ridiculous. We tested this with the same database structure on different servers and different versions of ms sql (2005/2008), and it's only THIS particular client's server that throws the error. I'm actually frustrated. SELECT Tasks.TaskID FROM Tasks INNER JOIN TaskHelpers ON TaskHelpers.TaskID = Tasks.TaskID order by TaskID Yes, I know I can put "Tasks.TaskID" into the order by clause, but for some reasons I can't.

  Read the article

• iPhone connect to SQL server

  - by immuner

  Since i am new to iphone and mac dev, which is the suggested way to connect your application to an sql server/sql server express 2005 database (in my case to sync data with sqlite)? Thank you

  Read the article

• how to send mail in asp.net

  - by program-java

  hii i m trying to send mail through coding of asp is there any external APIs to send mail like JAVA give some hints if possible sample code!! I m using vs 2005 as well as vs 2008

  Read the article

< Previous Page | 139 140 141 142 143 144 145 146 147 148 149 150  | Next Page >