Search Results

Search found 87875 results on 3515 pages for 'server pool'.

Page 514/3515 | < Previous Page | 510 511 512 513 514 515 516 517 518 519 520 521  | Next Page >

• Hyper-V snapshot backup strategy appropriate for production SQL server?

  - by Chuck

  So SQL Server 2008 in Hyper-V is a supported configuration, and should perform well as long as you use fixed or pass-through disks and increase your processor/memory settings appropriately. My question is can I use snapshots as a reliable backup mechanism, or should I use the tried and trusted maintenance plan to do my backups?

  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

• SQL SERVER Query result in CSV format is possible?

  - by gopal

  Hi, Is it possible to get the query result in .CSV file format from SQL SERVER 2000 and above versions? If so can we use this feature from an asp.net application to get the result in CSV format? If so how can we do this?

  Read the article

• How to execute big SQL files on SQL Server?

  - by Alon

  I have about 50 T-SQL files, some of them are 30MB but some of them are 700MB. I thought on executing them manually, but if the file is bigger than 10MB it throws an out of memory exception on the SQL Server Management Studio. Any ideas?

  Read the article

• how to show only even or odd rows in sql server 2008 ?

  - by Gold

  hi i have a table MEN in sql server 2008 that contain 150 rows. how i can show only the even or only the odd rows ? thank's in advance

  Read the article

• In SQL Server, how do I know what transaction mode I'm currently using?

  - by Yousui

  Hi guys, In SQL Server, how do I know what transaction mode I'm currently using? Such as autocommit, explicit, or implicit. And how can I change one mode to another using tsql? Great thanks.

  Read the article

• 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

• 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

• 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

• 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

• 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

• 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

• 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 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

• 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 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

< Previous Page | 510 511 512 513 514 515 516 517 518 519 520 521  | Next Page >