Click here to Skip to main content
Rate this: bad
good
Please Sign up or sign in to vote.
See more: SQL-Server
Hi,
How we can execute sql statement on the server.....right now i am executing the sql statement on local host, but now, i want to execute it on server. I m using sql server 2008. any one guide me, how we execute it on the server......
Posted 26-Nov-12 21:26pm
Rate this: bad
good
Please Sign up or sign in to vote.

Solution 1

  Permalink  
Rate this: bad
good
Please Sign up or sign in to vote.

Solution 2

When you execute any SQL query, you are executing it on a SQL server instance. For development, you are using an instance on your own computer - hence the "localhost" part of the connection string.
 
To execute it on the production server, you just need to change the connection string to address the correct SQL server instance.
Oh, and make sure you have the database on the production server as well! Laugh | :laugh:
  Permalink  

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



Advertise | Privacy | Mobile
Web01 | 2.8.140926.1 | Last Updated 27 Nov 2012
Copyright © CodeProject, 1999-2014
All Rights Reserved. Terms of Service
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100