Click here to Skip to main content
13,145,794 members (74,766 online)
Rate this:
Please Sign up or sign in to vote.
See more:
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
Please Sign up or sign in to vote.

Solution 1

Rate this: bad
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:

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

  Print Answers RSS
Top Experts
Last 24hrsThis month

Advertise | Privacy |
Web01 | 2.8.170915.1 | Last Updated 27 Nov 2012
Copyright © CodeProject, 1999-2017
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