Search Results

Search found 92933 results on 3718 pages for 'server side'.

Page 534/3718 | < Previous Page | 530 531 532 533 534 535 536 537 538 539 540 541  | Next Page >

• How to change this mysql select into sql server select statement?

  - by Pandiya Chendur

  I use this mysql statement for concating description which has a length greater than 30.. select if (CHAR_LENGTH(description)>30,CONCAT(SUBSTRING(description,1,30), '.....'),description) as description from table How to change this mysql select into sql server select statement?

  Read the article

• Is it possible to set a SQL server columns' description using a fluent nhibernate map?

  - by Simon

  I am using my fluent nhibernate mappings to generate my MS SQL Server database. I would like to be able to set a columns' description as part of this generation.

  Read the article

• In SQL Server, how can I execute a piece of tsql against all databases in an instance?

  - by Yousui

  Hi guys, In SQL Server, how can I execute a piece of tsql against all databases in an instance? Great thanks.

  Read the article

• Does SQL Server have any kind of magic undo feature?

  - by Andrew G. Johnson

  Long story short is I tried to quickly update a single row in SQL Server using the Management studio and just typed UPDATE table SET column='value' and forgot the WHERE other_column='other_value' portion. Went for lunch, came back and theres 15 unread emails waiting for me. Happened about an hour ago, waiting for the database guy to come back to see when the last backup was. There's no magic UNDO feature though is there?

  Read the article

• SQL Server - how to set (nolock) hint as a default?

  - by opensas

  is there some way to tell sql server to use the (nolock) hint or every select in a stored procedure? is pretty tiresome to add it to each an every select....

  Read the article

• List of SQL Server errors that should be retried?

  - by Christopher

  Is there a concise list of SQL Server stored procedure errors that make sense to automatically retry? Obviously, retrying a "login failed" error doesn't make sense, but retrying "timeout" does. I'm thinking it might be easier to specify which errors to retry than to specify which errors not to retry. So, besides "timeout" errors, what other errors would be good candidates for automatic retrying? Thanks!

  Read the article

• Detecting remote client name using PHP or Javascript

  - by Felix Guerrero

  Hi. I need the remote client name (aka computer name) to save it into a database, I was looking into $_SERVER variables but it doesn't exist. How can I get this just using another PHP's function or even javascript if it is necessary.

  Read the article

• How to retrieve unicode data stored directly in non-unicode field as varchar format in sql server

  - by Samujjal

  I have to create a C# application which displays unicode data in a textbox. But the SQL server column storage has varchar data which contains unicode data. But since varchar is non-unicode based it displays character strings like "????????". Well the problem i am facing is i cant change the column type as there are other dependent application running on it.

  Read the article

• How to configure your WCF service to work as normal TCP server?

  - by Ole Jak

  How to configure your WCF service to work as normal TCP server? Is it possible, how (how to disable all that binding specific crap so to keep your service URL like http://example.com:4444/service and be able to wirk vith pure HTTP\TCP streams )

  Read the article

• In SQL Server, how to quickly get a general idea of an instance?

  - by Yousui

  Hi guys, If you are a new sql server dba and you just get an account of an instance. What would you do to know the instance and databases? How to quick get a general idea of this instance and databases? Great thanks.

  Read the article

• Why is fulltextsearch for phrase ignored in SQL Server?

  - by cpt.oneeye

  I am executing the following SQL statement on an indexed SQL Server 2008 R2 database. SELECT * FROM mydatabase WHERE (CONTAINS(ColumnA,'"The Apple is red"')) The problem is that it returns too many entries. It also returns entries where 'ColumnA' contains only one of the words ('Apple' or 'is' or 'red'...) and not only the entries which contains the exact phrase. According to MSDN this should be the way to search for a phrase. Thanks cpt.oneeye

  Read the article

• How to install Visual Studio 2008 and MS SQL Server 2008 in Ubuntu ?

  - by Vicheanak

  Hi guys, I would like to install Visual Studio 2008 and MS SQL Server 2008 on Ubuntu OS which I have in my PC, however, I don't know how. May I have some tips please? Thanks.

  Read the article

• what the IIS featuer need to install or change in pc have windows 7 home to work sql server 2005 ss

  - by bassam

  what the IIS featuer need to install in pc have windows 7 home to work sql server 2005 (32 bit) ssrs not work i change all windows featuer in the PC what i need to install in pc

  Read the article

• How do I capture the Application.Exit event in the Home Server Console?

  - by Magnus Johansson

  I have a WHS Addin, and I now want to do some cleanup whenever the Windows Home Server Console is closed. I have tried the Application.ApplicationExit event, but it seems it doesn't get fired. Any ideas?

  Read the article

• how to determine date when service pack was applied to SQL Server instance?

  - by Oliver

  For an instance of SQL Server 2005/2008, how can one determine the date and time when a service pack was applied to the instance? Is there a system table or view that stores that information?

  Read the article

• Does Visual Studio 2010 Beta 2 Include a TFS server?

  - by Russell

  I recently downloaded Visual Studio 2010 beta 2, and was told it included a TFS server. However I am unsure of if it has/can be installed, or how to start it up if it has been. Can anyone shed any light on this for me please? Thanks :) Thanks for your help :) I am downloading the ISO of the separate product instead from msdn.

  Read the article

• When deploying python, what web server options do we have? is the process inefficient at all?

  - by Blankman

  I think in the past python scripts would run off CGI, which would create a new thread for each process. I am a newbie so I'm not really sure, what options do we have? Is the web server pipeline that python works under any more/less effecient than say php?

  Read the article

• How can I handle emailed job control files for SQL Server?

  - by ganesh

  How can I detect control files from any mailbox, scan that file, decrypt it and queue it as a job using job manager in SQL Server?

  Read the article

• How to Create Adobe AIR MJPEG server? (AIR 2.0)

  - by Ole Jak

  So all I want to stream images from my WebCam onto some local adress\port and be able to see them as MJPEG stream. I want server (one that shares MJPEGS) and CLIENT (That sends MJPEGS) be in the same air app. Can you give me link to working opensource project DETAILED STEP BY STEP instructions on what should I do\implement and where to find code examples

  Read the article

• how to format a date in sql server 2008.

  - by Shantanu Gupta

  How to format a date in sql sevrer with format dd-mm-yyyy to some other format without using convert function. Is it there any such function in sql server 2008 or 2005

  Read the article

• How can I connect to a mysql db from a different server ?

  - by HJ-INCPP

  Hello, I have, let's say, a root website with mysql db on a remote server. I want to connect to that particular database (to make queries), from many other little websites (with lower priviledges). Can this be done? Language: jsp,java,php Thank you

  Read the article

• Where does sql server stores the stored proecdure code?

  - by NoProblemBabe

  I once needed the lines of the stored procedures, to be able to trace whether i have a reference to some function, procedure or table, or sometimes to try to find something inside of the sp's code. Where does the sql server stores the procedures's code?

  Read the article

• Is the max limit of 4 GB on sql server 2005 express .mdf + .ldf or for .mdf only ?

  - by HotTester

  Is the max limit of 4 GB on sql server 2005 express .mdf + .ldf or for .mdf only ? Kindly clarify. Thanks.

  Read the article

• What is the best method for Migrating or Restoring Project Server (PWA) to a new environment for tes

  - by JustinB

  I have attempted bringing up a new farm and performing a stsadm backup/restore with no success. I have also tried doing a stsadm export/import with similar results. I need to migrate/copy PWA to another server for testing purposes and I am at a standstill. What is the best method to accomplish this?

  Read the article

• Why does SQL Server 2008 suggest I have the primary key column as an included column in an index

  - by Raine

  SQL Server 2008 is telling me to include the Primary Key in an index in the Included Column field. I thought the PK was automagically returned with all indexes?

  Read the article

< Previous Page | 530 531 532 533 534 535 536 537 538 539 540 541  | Next Page >