Search Results

Search found 88553 results on 3543 pages for 'hp mediasmart server'.

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

• How do I add a record only if it doesn't already exist in SQL Server?

  - by menacheb

  Hi, I have a project in C# with a Sql-server Database. In that database I have a table named 'Process' and columns named 'process_name', 'Full_Name' and 'Version' (all of the type:nvarchar(50)). I want to write a query wich will add the new process, only if it doesn't exist in the table yet. How can I do that? Many thanks,

  Read the article

• Do I need to translate (local) in a sql server connection string?

  - by DanDan

  When connecting to sql server, I have the hardcoded string "(local)". Is this a string I need to make available for localisation? ie, does (local) always work no matter the current language settings?

  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

• Looking for a tool that can return SPs doing a DML on a table in SQL Server 2008

  - by Kiran

  I am working on a big application on SQL Server 2008 with 60 000 stored procedures and over 10 000 tables. Is there a tool through which I can do impact analysis to find out all SPs doing a DML on a table?

  Read the article

• Can i make SQl Server 2005 Table Column accept only letter and numbers ?

  - by Space Cracker

  When we have a column that will store a username that will only accept letters and numbers we always do validation on this input field using javascript or even server validation from code .. but i want to know if is there any way that can allow me make this validation on the Table column itself even some one try to enter data from any place it don't accept and throw exception ?

  Read the article

• In SQL Server 2008 is there a way to generate a report as to how much space on disk each table takes

  - by Matt

  IN SQL Server 2008 is there a way to generate a report as to how much space on disk each table takes? I can do it one by one by checking the storage properties, but I was wondering if there was a way, maybe even a query to generate such a report.

  Read the article

• How to set user environment variables in Windows Server 2008 R2 as a normal user?

  - by likm

  In older versions of Windows, it was just open the Control Panel, select the System applet, select the Advanced tab, and then hit the Environment variables button. As a normal user, you could edit the "User variables" but not the "System variables". In Windows Server 2008 R2, if I try to hit the Advanced System settings option in the System applet, it prompts for the Administrator password.

  Read the article

• run threads on server side & show progress on client side possible???

  - by Aizaz

  I want to run a thread pool on server side & want to show threads work progress on client side. Is this possible. If so kindly guide me. thanx in advance

  Read the article

• Is there any SQL Server database designer software like MySQL workbench?

  - by newbie

  I need to design database for SQL Server, is there any MySQL workbench like software for that? I have access to MSDN, so it can also be commercial product that can be found form MSDN.

  Read the article

• How can I estimate server costs for creating an app?

  - by G Dottin

  Im writing up a business plan and im having some trouble with the finance part. I put an estimate on the cost of developers, web designers and everything but server costs. Im not a programmer so I dont know all the details. But how much would you think servers are going to cost for a complex app. I cant get into too many details but it keeps track of user preferences, stores data about the user and there is quite alot of back-end to it.

  Read the article

• Should I use "User Defined Functions" in SQL server, or C#?

  - by sanity

  I have a fairly complicated mathematical function that I've been advised should be implemented as a User Defined Function in SQL Server so that it can be used efficiently from within a SQL query. The problem is that it must be very efficient as it may be executed thousands of times per second, and I subsequently heard that UDFs are very inefficient. Someone suggested that I could implement the function in C# instead, and that this would be much more efficient. What should I do?

  Read the article

• In SQL Server, how can I separate a large number of tsql statement into batches?

  - by Yousui

  Hi guys, In SQL Server, how can I separate a large number of tsql statement into batches? Should I use the GO statement in stored procedures or functions? Should I use the GO statement in explicit transaction management situation(between BEGIN TRANSACTION and ROLLBACK TRANSACTION or COMMIT TRANSACTION)? Are there some best practice about this topic? Great thanks in advance.

  Read the article

• How can I return a substring of a LINESTRING in SQL Server 2008 Spatial?

  - by sabbour

  Say I have a LINESTRING defined as LINESTRING(-122.360 47.656, -122.343 47.656, -122.310 47.690, -122.310 47.670, -122.300 47.630) And I want to get a substring from POINT(-122.360 47.656) to POINT(-122.310 47.690) How can I return a substring of a LINESTRING in SQL Server 2008 Spatial?

  Read the article

• Is there a way to have SQL server validate object references in Stored Procs?

  - by Scott Weinstein

  The following code executes fine in SQL Server create proc IamBrokenAndDontKnowIt as select * from tablewhichdoesnotexist Of course if I try to run it, it fails with Invalid object name 'tablewhichdoesnotexist'. Is there any way to compile or verify that Stored Proc are valid?

  Read the article

• Can anyone recommend a java FOSS server that does all the typical protocols (ssh etc).

  - by mP

  I would like to add the ability for users to telnet into my app where by they can type in commands etc. I would like a simple Java Telnet server whereby i can provide the authentication strategy.

  Read the article

• How can upload image URL in SQL server and retrieve in grid view using ASP.NET?

  - by kalaiselvi

  How to upload image URL in SQL server and retrieve in grid view using ASP.NET? Can you point me to any tutorials and/or sample code?

  Read the article

• How do I make a TCP connection between 2 servers if both can start the connection ?

  - by DeeD

  I have a defined number of servers that can locally process data in their own way. But after some time I want to synchronize some states that are common on each server. My idea was that establish a TCP connection from each server to the other servers like a mesh network. My problem is that in what order do I make the connections since there is no "master" server here, so that each server is responsible for creating there own connections to each server. My idea was that make each server connect and if the server that is getting connected already has a connection to the connecting server, then just drop the connection. But how do I handle the fact that 2 servers is trying to connect at the same time? Because then I get 2 TCP connections instead of 1. Any ideas?

  Read the article

• How to turn string into readable by php server way? (?#)

  - by Ole Jak

  So I know that my server on real form submit turns %CE%EB%E5%E3+%DF%EA%F3%F8%EA%E8%ED into ???? ??????? . How to peform string transfer from ???? ??????? into %CE%EB%E5%E3+%DF%EA%F3%F8%EA%E8%ED using C#?

  Read the article

• How can I set default seed for all identities within a SQL Server database?

  - by Brandon DuRette

  Is there a way to tell SQL server to use specific default seed value for IDENTITY columns - assuming the (to be run) CREATE TABLE statements do not specify one? I don't really care about altering existing data or altering the seed values for specific IDENTITY columns. I want the same seed for all newly created identity columns. Assume I cannot modify the individual CREATE TABLE statements in any way.

  Read the article

• Webservice for Watching a Table in SQL server and populating it.

  - by GayaMani

  Can we write a web service to watch a table in sql server. whenever the corresponding table is populated with new records, the new records should appended to the another table which has the same structure of the old one. Is this is possible using webservices if not how to perform this.

  Read the article

• How the clients (client sockets) are identified?

  - by Roman

  To my understanding by serverSocket = new ServerSocket(portNumber) we create an object which potentially can "listen" to the indicated port. By clientSocket = serverSocket.accept() we force the server socket to "listen" to its port and to "accept" a connection from any client which tries to connect to the server through the port associated with the server. When I say "client tries to connect to the server" I mean that client program executes "nameSocket = new Socket(serverIP,serverPort)". If client is trying to connect to the server, the server "accepts" this client (i.e. creates a "client socket" associated with this client). If a new client tries to connect to the server, the server creates another client socket (associated with the new client). But how the server knows if it is a "new" client or an "old" one which has already its socket? Or, in other words, how the clients are identified? By their IP? By their IP and port? By some "signatures"? What happens if an "old" client tries to use Socket(serverIP,serverIP) again? Will server create the second socket associated with this client?

  Read the article

• In SQL Server 2005, how can I use database_b, do something, then use the old db database_a in TSQL?

  - by Yousui

  Hi guys, In SQL Server 2005, how can I use database_b, do something, then use the old db database_a in TSQL? The following is my code but there is some problem with it. Who can help me to identity the problem? Great thanks. DECLARE @old_database_name VARCHAR(200) SET @old_database_name = db_name() use mydatabase create table t1(id int identity(1,1)) use @old_database_name

  Read the article

• How to get total number of hours between two dates in sql server?

  - by Pandiya Chendur

  Consider two dates 2010-03-18 22:30 and 2010-03-19 03:30 .... How to get the number of hours in between the two dates in sql server.....

  Read the article

• Need to run a processing demanding application on a .NET server.... any tips?

  - by mouthpiec

  Hi, I need to run an image processing application on a .NET server. Do you have any tips what I should/can do? I implemented the code in a webservice, but performance is very slow (at least 10x slower than when executed in a windows application). Any help will be greatly appreciated. thanks

  Read the article

• How do I remove database name from SQL Server generated script?

  - by bucha

  Anytime I use 'script table as' - 'Insert To' (or other command), the script generated automatically places the database name in the script. Such as: INSERT INTO [DatabaseName].[dbo].[tblToBeInserted] ... While not a huge problem to just delete it, it has slipped by a few times and the script breaks if run on a different server with a different database name but has the same schema. (Such as running on [DatabaseName.Test]) Is there an option I can change, or can I modify the output in any way to remove this?

  Read the article

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