Search Results

Search found 87304 results on 3493 pages for 'speech server'.

Page 302/3493 | < Previous Page | 298 299 300 301 302 303 304 305 306 307 308 309  | Next Page >

• SQL Server stored procedure line number issue

  - by George2

  Hello everyone, I am using SQL Server 2008 Enterprise. I met with issue which says line 9 of stored procedure foo is meeting with dead lock issue. My question is how to find exactly the 9th line of the stored procedure? My confusion is because of coding format issue, how to locate 9th line correctly. thanks in advance, George

  Read the article

• SQL server datetime column filter on certain date or range of dates

  - by MicMit

  There is an example for today here http://stackoverflow.com/questions/2583228/get-row-where-datetime-column-today-sql-server-noob I am primarily interested in 2008 only. For today it looked like SELECT (list of fields) FROM dbo.YourTable WHERE dateValue BETWEEN CAST(GETDATE() AS DATE) AND DATEADD(DAY, 1, CAST(GETDATE() AS DATE)) What literal value of date(s) or functions ( I need a format ) should I place there to make it work independent of local settings.

  Read the article

• SQL Server 2008 on windows 7 Cannot logon

  - by WingMan20-10

  I am using SQL server 2008 on windows 7 Machine and when i try to logon using local user i get error message login failed cannont login, i am administrator on my machine. Any Ideas?

  Read the article

• MS Access Database Check Box List Filters Missing On SQL Server back end

  - by pghcpa

  When I connect Access 2007 to SQL Server (whether by ADO recordset or by linked table) I no longer get check box lists (of available filter values) in the datasheet column filters. Is this feature available only with MDB/ACCDB and/or DAO?

  Read the article

• When/Why to use Cascading in SQL Server?

  - by Joel Coehoorn

  When setting up foreign keys in SQL Server, under what circumstances should you have it cascade on delete or update, and what is the reasoning behind it? This probably applies to other databases as well. I'm looking most of all for concrete examples of each scenario, preferably from someone who has used them successfully.

  Read the article

• How to decrypt a password from SQL server?

  - by sef

  I have this query in sql server 2000: select pwdencrypt('AAAA') which outputs an encrypted string of 'AAAA': 0x0100CF465B7B12625EF019E157120D58DD46569AC7BF4118455D12625EF019E157120D58DD46569AC7BF4118455D How can I convert (decrypt) the output from its origin (which is 'AAAA')?

  Read the article

• Import MySQL database into a MS SQL Server

  - by marionmaiden

  I have a .sql file from a MySQL dump containing tables definitions and the data to be inserted in this tables. How can I convert this database represented in the dump file into a MS SQL server database?

  Read the article

• C# Sql Server 2005 Bulk XML Delete?

  - by Goober

  I know you can do bulk XML inserts into SQL Server 2005 tables from your C# code using datasets/datatables. Is it possible to do the same but as a delete?

  Read the article

• Update Multiple records in SQL Server

  - by Yongwei Xing

  Hi all Here is my situation: I use the SqlCommond to update some records in the SQL Server in a ASP.NET web site. Users can choose which records they want to update. Sometimes they may choose 40 or 60 records to update at a time.Is there any good way to do it? I do not want to do like it foreach(string ID in List) { Update here } Best Regards,

  Read the article

• SQL server 2000 how to find transaction history for a table/row

  - by Stan

  How do you find the modification history for a certain table / row in SQL server 2000? Thanks.

  Read the article

• what is deadlock in sql server?

  - by VenkatReddy.Ravu

  What is deadlock in sql server and when it arises? What are the issues with deadlock and how to resolve it?

  Read the article

• Creating a simple java hash server

  - by Blankman

  Is it possible to create a simple server in Java that returns a response based on a given key? So it would be a simple program, that stores a hashmap and returns the result based on a key provided by the client. What would be the fasted implementation, to have it over HTTP or a socket? The client will be a web based application.

  Read the article

• SQL Server identity counterpart problem

  - by Guru

  Hi there, I'm using SQL Server and I want to use identity constraint in it I know how to use it in following manner create table mytable ( c1 int primary key identity(1,1); ) the above code works fine but what if i want the identity column to have values as EMP001, EMP002,... instead of 1,2.... Thanks in advance, Guru

  Read the article

• Hosting a web server through an image

  - by tipu

  Is it possible that, on my Windows machine, I get the vmware player and an ubuntu image and host a web server from that image?

  Read the article

• SQL Server 2008 2mb Limit for XML??

  - by Nai

  I am trying to output a long XML result from SMSS. When I right click on the results and 'save results as...', I can only get a 2mb file? I have changed the settings in SMSS via Tools - Options - Query Results - SQL Server - Results to Grid, for XML data to be unlimited. Forever, it still seems to be truncating my XML results? So, how can I bypass this problem and output my XML result to a file? Thanks

  Read the article

• Difference between SQL Server and Oracle 'User'

  - by BeginnerAmongBeginners

  Are there any differences between a user in SQL Server and one in Oracle? If so, what are they? Thanks in advance.

  Read the article

• SQL Server 2000 pivot without temporary tables?

  - by Apocatastasis

  Hi. I'm trying to pivot some data in SQL Server 2000, but the user that runs the application only have read/write permissions. I've looked the solutions posted here, but all involving create/destroy temporary tables.

  Read the article

• Sql Server Management Studio Express (2005 or 2008) - Save Password Doesn't work

  - by hamlin11

  I always click "Remember Password" when connecting to a database server. Sometimes when I come back into SSMS, it has it remembered, sometimes not. More often it does not. I regularly connect to about 4 different servers, it's fairly random when it works for which servers. How can I get this to work all the time?

  Read the article

• Embedding SQL Server into a .NET application

  - by Leszek Laszka

  Hey, I've just finished writing a VB.NET application. Now I want to package the executable and the database ofcourse into a single installer file. I tried using QSetup, InstallShield to make SQL Server embedded into the setup file, and finally after hours of try&fail I have no idea. Anyone?

  Read the article

• Help with random - sql server 2008 query

  - by Gold

  hi i have 4000 records, and i need to pick randomize 500 records. i need that 500 records will insert to GoodTable and the rest 3500 records will insert to BadTable how to do it using sql-server 2008 query ? thank's in advance

  Read the article

• show data from sql server in blackberry using .Net

  - by Cuil

  Hi all, i want to ask about development in blackberry. I have background in .Net winform. If i want to develop an application to show data from Ms.SQL server 2008 database in blackberry. what should i learn and what should i do ? thank you for your advice.

  Read the article

• how do i do very fast inserts to SQL Server 2008

  - by CharlesO

  I have a project that involves recording data from a device directly into a sql table. I do very little processing in code before writing to sql server (2008 express by the way) typically i use the sqlhelper class's ExecuteNoneQuery method and pass in a stored proc name and list of parameters that the SP expects. This is very convenient, but i need a much faster way of doing this. Thanks.

  Read the article

• How can i access to sql server from windows batch

  - by cagin

  Hi there, I want to connect to Sql server and running some sql queries. How can i do that? Thank you for helps..

  Read the article

• How to reverse a string(SQL SERVER 2005, SET BASED)

  - by Newbie

  E.g. Declare @str varchar2(20) Set @str = 'A Student' Select Reverse(@str) Output: tnedutS A Expected being: Student A The output(using Reverse) is as expected. But my requirement is the one described. Help needed with SET BASED. I am using SQL SERVER 2005

  Read the article

• How to reverse a string (SQL Server 2005, SET BASED)

  - by Newbie

  E.g. Declare @str varchar2(20) Set @str = 'A Student' Select Reverse(@str) Output: tnedutS A Expected being: Student A The output(using Reverse) is as expected. But my requirement is the one described. Help needed with SET BASED. I am using SQL Server 2005

  Read the article

< Previous Page | 298 299 300 301 302 303 304 305 306 307 308 309  | Next Page >