Search Results

Search found 87891 results on 3516 pages for 'server migration'.

Page 848/3516 | < Previous Page | 844 845 846 847 848 849 850 851 852 853 854 855  | Next Page >

• SQL WHERE.. IN clause multiple columns

  - by ala

  i need to implement the following query in SQL Server select * from table1 WHERE (CM_PLAN_ID,Individual_ID) IN ( Select CM_PLAN_ID, Individual_ID From CRM_VCM_CURRENT_LEAD_STATUS Where Lead_Key = :_Lead_Key ) but the WHERE..IN clause allows only 1 column. How to compare 2 or more columns with another inner select?

  Read the article

• Use Azure Appfabric on a local system

  - by Mimefilt

  Hi there, we want to use the azure appfabric for our software. But not every customer wants to buy an expensive azure account. Is it possibile to define and use an azure interface in our software but to connect the server and client local? Mimefilt

  Read the article

• How to pass parameters for OPENDATASOURCE

  - by Rapunzo

  I can connect to a linked server with this: SELECT testNo, soruTuruId, soruNo, cevap , degerlendirenTcNo, degerlendirilenTcNo FROM OPENDATASOURCE('SQLOLEDB', 'Data Source=192.168.150.42;User ID=readerUser;Password=1').akreditasyon.dbo.tblPerfCevap But I have to pass the password as parameter. and I try like this: SET @connectionString = 'Data Source=192.168.150.42;User ID=readerUser;Password='+@pw SELECT testNo, soruTuruId, soruNo, cevap , degerlendirenTcNo, degerlendirilenTcNo FROM OPENDATASOURCE('SQLOLEDB', @connectionString ).akreditasyon.dbo.tblPerfCevap and SELECT testNo, soruTuruId, soruNo, cevap , degerlendirenTcNo, degerlendirilenTcNo FROM OPENDATASOURCE('SQLOLEDB', 'Data Source=192.168.150.42;User ID=readerUser;Password='+@pw ).akreditasyon.dbo.tblPerfCevap but didnt work:S does anyone have an idea?

  Read the article

• how to load a file into a blob without loading into RAM first?

  - by Ace Grace

  Hi, I am using C# and I am having trouble loading large files into a binary field use byte arrays. Basically, if I load a file that is too large, I get memory problems. Is there a way to load a file into a binary field without using large amounts of ram, i.e. avoid loading the file into memory first? If it helps, I am using Advantage Database Server and this is using a winforms app not a web app. Regards

  Read the article

• Auto-complete editor for SQL statement

  - by Stan

  Is there any plugings or text editor to auto-complete SQL statement? I am using SQL Server Management Studio (ssms) 90% of time, but most of time I have to type SELECT FROM WITH(NOLOCK) WHERE blahblah. Trying to find a more efficient way. Thanks.

  Read the article

• Import Data Wizard Does Not Like Data Type I Choose For A Column

  - by Haoest

  Does anybody else have this same problem, when you import data from Excel file to MSSQL Server 2005, if some column contains mostly numeric data, but even if you set the column type to varchar, the wizard fails to import those fields that fail to parse as numbers?

  Read the article

• SQL Profiler and Tuning Advisor for Reporting Services - what events should be selected?

  - by chris

  I've used the SQL Profiler to generate a trace file, and tuning advisor to take that trace file and provide some recommendations on db updates. However, the SQL Profiler doesn't seem to track the queries when running against a Reporting Server, the profiler doesn't seem to be capturing any of the queries. I'm logging the defaults (SQL:BatchCompleted and Starting, RPC:completed, and Sessions - Existing Connections) What events should I be capturing in SQL Profiler in order to run the tuning advisor?

  Read the article

• modrewrite to another server if file/image is not found

  - by Traveling_Monk

  Hi I am working on a locally served copy of a remote site and I don't want to have to download all the images rtelated to the site so I thought i could come up with a mod_rewrite rule for to grab images from the remote server if the are not found this is the code that i have <IfModule mod_rewrite.c> RewriteEngine On RewriteCond %{REQUEST_FILENAME} -f [NC] RewriteRule ^/(.*\.(png|gif|jpg|jpeg)) https://www.exmple.com/$1 [NC,P,L] </IfModule> The page is still giving me 404's for images that are on the remote server, so this rule is not working. I do know that the htaccess is being processed because rules later in the IfModule mod_rewrite.c block are being used. (i simplified my code sample but this is the first rule in the IfModule mod_rewrite.c block)

  Read the article

• Adding a clustered index to a SQL table: what dangers exist for a live production system?

  - by MoSlo

  Right, keep in mind i need to describe this by abstracting all possible confidential info: I've been put in charge of a 10-year old transactional system of which the majority business logic is implemented at database level (triggers, stored procedures etc). Win2000 server, MSSQL 2000 Enterprise. No immediate plans for replacing/updating the system are being considered :( The core process is a program that executes transactions - specifically, it executes a stored procedure with various parameters, lets call it sp_ProcessTrans. The program executes the stored procedure at asynchronous intervals. By itself, things work fine. But there are 30 instances of this program on remotely located workstations, all of them asynchronously executing sp_ProcessTrans and then retrieving data from the SQL server (execution is pretty regular - ranging 0 to 60 times a minute, depending on what items the program instance is responsible for) . Performance of the system has dropped considerably with 10 yrs of data growth: the reason is the deadlocks and specifically deadlock wait times. The deadlock is on the Employee table. I have discovered: In sp_ProcessTrans' execution, it selects from an Employee table 7 times (dont ask) The select is done on a field that is NOT the primary key No index exists on this field. Thus a table scan is performed. 7 times. per transaction So the reason for deadlocks is clear. I created a non-unique ordered clustered index on the field (field looks good, almost unique, NUM(7), very rarely changes). Immediate improvement in the test environment. The problem is that i cannot simulate the deadlocks in a test environment (I'd need 30 workstations; i'd need to simulate 'realistic' activity on those stations, so visualization is out). I need to know if i must schedule downtime. Creating an index shouldn't be a risky operation for MSSQL, but is there any danger (data corruption in transactions/select statements/extra wait time etc) to create this field index on the production database while the transactions are still taking place? (although i can select a time when transactions are fairly quiet through the 30 stations) Are there any hidden dangers i'm not seeing (not looking forward to needing to restore the DB if something goes wrong, restoring would take a lot of time with 10yrs of data).

  Read the article

• Server-side Audio Editor

  - by Kristen

  I am looking for an audio editor that we can use server side (ASP + IIS) We want users to be able to upload an audio file, and then offer a 10 second teaser clip to other users for download. Ideally I would like our application to be able to specify Input and Output Filename, Start and End time (or Duration), and be able to fade-in and fade-out, and equalise the volume. Maybe some audio editors have a batch edit facility, and it would just be a question of installing on the server? All the keywords I have tried putting into Google have led me on a wild goose chase, hopefully someone can help me with suggestions. Thanks.

  Read the article

• need help to solve the sql error.

  - by hina

  i want to send SMS using SQL server 2008 express, and using the video tutorial for help. i found an error while testing, i.e. ERROR: Microsoft SQL native client: communication link failure. kindly tell me how to resolve this error. i used the SQL command: "sqlcmd -S np:\127.0.0.1\pipe\MSSQL$SQLEXPRESS\sql\qurey"

  Read the article

• Long time to load first sql connection in .NET

  - by Shrage Smilowitz

  For some reason it takes 7 seconds to open a connection to a sql server database for the firt time, subsequent connections takes a second. any idea what could be the reason? I'm using C# and asp.net Its after compilation, i essence every time i restart the site, which means every time it needs to actualy create the "first" connection. i understand that setting up connection pooling has overhead, but i have never seen that i should take 7 second to set it up.

  Read the article

• What pixel format does X server use?

  - by Kristopher Ives

  What pixel format (RGBA, ARBG, BGRA) does the X server use? If any specific format at all

  Read the article

• Socket server for 2D MMORPG

  - by Alejandro

  I'm starting a 2D browser multiplayer game consisting of a city with many kinds of transports (metro, buses, tunnels), players using those transports and having some interaction between them. I have started the client side in Actionscript, server side in PHP (but now i'm moving to Java) and persistence in MySQL. Which socket server (non commercial) will be preferable, RedDwarf (former DarkStar), Red5, ... ? Those servers are Flash Remoting (AMF) capable ? Those servers manage all the object's game persistence? Then there's no need to create a database ?

  Read the article

• Understanding omission failure in distributed systems

  - by karthik A

  The following text says this which I'm not able to quite agree : client C sends a request R to server S. The time taken by a communication link to transport R over the link is D. P is the maximum time needed by S to recieve , process and reply to R. If omission failure is assumed ; then if no reply to R is received within 2(D+P) , then C will never recieve a reply to R . Why is the time here 2(D+P). As I understand shouldn't it be 2D+P ?

  Read the article

• how to send database data to a MySQL server to update the server database.

  - by haisergeant

  Hi everyone, I am developing Smoking counter and I need to send all the smoking record (about the time user smoking) to database on the server. The server database is MySQL database. I knew that I must have send data to PHP page/script, and this page/script will run on the data to insert record to database. I would like to know: is there another way to update database, because I don't have knowledge about PHP. I used to work on java and c/c++/objective-c. If you know another way to do this task, please let me know. Any help would be appreciated.

  Read the article

• would changing domain name affect all the emails under current domain name?

  - by skyhigh

  Hi my friend wants to change his current website domain name to a new one and stays with the same web server company yahoo. what happens to all the emails data under the current domain name if I change to a new domain name? How do i retrieve it back? Thanks

  Read the article

• Background task in mobile phone to access a secure element and a web server

  - by Splryxx

  Is it possible in a GSM mobile phone OS (e.g. Android, Win Mo, Symbian, etc.) to have some kind of background task or application able to exchange data at the same time with a web server and a secure element of the mobile? The purpose if for the web server to be able to push APDUs to the secure element (an retrieve response APDUs) without activating the IHM of the mobile. NB: I know that this is possible when the secure element is the one managing the GSM baseband, for example using BIP as described in Ulysse specifications. My question is only when using another secure element (e.g. Java Card in a microSD).

  Read the article

• Remote Control Software with queue for multiple users?

  - by jakob

  Is there a remote control software or a http-server available, which has a queue implemented, so that one after another client has the chance to control the screen on the host? Thanks a lot

  Read the article

• JQuery Active Refresh Not Working After Server-Side Redirect

  - by Ömer Faruk AK

  I have a page which is refreshing actively every 5 second. But when i click a button from the page which is redirect to itself at server-side and then it's not refreshing. What can i do? JQuery Code; <script type="text/javascript" charset="${_response_encoding}"> // Reload the whole messages panel var refresh = function() { $('#thread').load('@{room()} #thread', function() { $('#thread').trigger('create'); }); } var create = function(){ $('#thread').trigger('create'); } // Call refresh every 5 seconds $(document).ready(setInterval(refresh, 5000)); </script> Server-Side Code; public static void served(Long servingID) { Serving serv = Serving.findById(servingID); serv.isServed = true; serv.save(); index(); }

  Read the article

• VBScript Writing to Server Text File

  - by Keyfer Mathewson

  I have created a VBScript which pulls the service tag, username, and computer name from a computer. What I need to do now is compile this information in a text document. How it's set up is as follows: We have an Active Directory Server, with a folder for login scripts. I have created a batch file to run this .vbs script, and the script works well so far. What I now need is for a file on the AD server, called "logging.txt", to be populated with the information that is created with the .vbs script. This is the script I have so far: 'Get Dell Service Tag Info set ProSet = GetObject("winmgmts:").InstancesOf("Win32_BIOS") Set ProSet1 = GetObject("winmgmts:").InstancesOf("Win32_SystemEnclosure") For each Pro in ProSet For each Pro1 in ProSet1 ServiceTag=Pro.SerialNumber wscript.echo ServiceTag exit for Next exit for Next 'get username and computername, could also be asked in a batch Set oShell = WScript.CreateObject("WScript.Shell") Set oShellEnv = oShell.Environment("Process") sComputerName = oShellEnv("ComputerName") sUsername = oShellEnv("username") wscript.echo sComputerName & " " & sUsername Thank you very much in advance!

  Read the article

• Stored Procedure could not be found

  - by Beatles1692

  We use SQL server 2008 as our RDBMS and we have a database that has a different user rather than dbo as its owner. The problem is in one machine a stored procedure can not run unless its owner is mentioned. If we connect to our database using this user and try to execute the following : exec ourSP we get a "could not find ourSP" error but this works fine: exec user.ourSP Does anybody knows what can lead to such a strange behavior?

  Read the article

• How do I execute a stored procedure once for each row returned by query?

  - by Ryan

  I have a stored procedure that alters user data in a certain way. I pass it user_id and it does it's thing. I want to run a query on a table and then for each user_id I find run the stored procedure once on that user_id How would I write query for this? SQL SERVER

  Read the article

• save jQuerry changes to css file on server

  - by KrisRogo

  I'm developing a system that allows for changing some of the css parameters without accessing the code. To achieve that I have jQuerry objects like sliders and draggers which influence how the site looks user side, eg. $("#MainContent").css("width", "55%");. Now I need a way to append those changes to a .css file on the server. Let me clarify that this is sort of a CMS system, and only administrator of the system would have this option, not the visitors of user-end site. I realise that .css is one for all users. Ideal solution would connect to the server every time user makes a change, and replace only one line of css code. But I have no idea how to do it efficiently or if it at all possible.

  Read the article

• Display list of websites on local IIS server in a web page

  - by TGuimond

  Hey Guys, I am currently trying to figure out a way to list all of the websites that are running on a local IIS 6 server at the office and display links to each site with their descriptions so we can always find our development sites with ease. The way that the server is currently set up is I add a DNS record for a new site. eg: newsite.company.local and then add it to IIS. This way all the users in our office can access this site via their browser and developers can test, admins can review etc etc. What I want to do now is automatically generate a webpage with a list of all of the sites running on iis and have it be available across the network. I have never looked into this before and have no idea where to start.. help! Thanks :)

  Read the article

< Previous Page | 844 845 846 847 848 849 850 851 852 853 854 855  | Next Page >