I want to host my web site on an ISP hosting provider because my upload speed is not sufficient, however I want the database to be hosted locally.1) Is this possible?2) Does SQL server require good upload bandwidth?3) How much data (just an estimate) would it use to retrieve 20 rows of 10 columns?4) I realise this is not an ASP question so can you direct me to where I should post this if noone wants to answer it?
View 1 RepliesI have some data which is in mySQL, i am not familier with mySQL, i would like to transfer all the data from MySQL to SQL Server database,
View 11 RepliesI have created a sdf database in a mobile application.Now I want to synchronize that database to a sql server database.
View 1 RepliesI have created web pages using VS Web Developer that use a local Developer Edition of SQL server database on my PC with LINQ to SQL. When I deploy my website to a remote web host SQL server, I need for my web pages to be able to use the remote database instead of the local database. So, how do I get the Server Explorer to connect with a remote SQL Server database?
View 6 RepliesI want to copy a database on a development server to my local server. I am not the server administrator but I have rights to the database. Soon after the wizard Executes the SQL Server Agent Job it fails and the error message says:
The job failed. Check the event log on the destination server for details.
Where do I find this log? Also what could be the problem?
I have created database .sql file for create schema with export database. (its .sql file size is 48.2 MB)
View 1 Replieshow to copy data from one SQL Server database to other SQL server database using two connection string...
View 4 RepliesI have built a website using Visual Studio 2008 asp.net 3.5, and data is retreive from a database that is made by SQL Server Management Studio 2008.
The question is: How can I upload the database files to the server? Can you give me a step by step description?!
how to Take External Database Backup file into Local HardDrive.
If I have the appropriate permission, is their a way to access a sql server database on two different servers?
For example if I have a Table A on server 1 and Table B on a different server. How would I join the two tables together, if they each have a column named "PonyId"
If i have created 1 database. then what would be the max size of that database in sql server 2000 & Sql server 2005?
View 3 Repliesconnecting my database to the online server. My server is seekdotnet. But I had been receiving this error code Cannot open database "database.bak" requested by the login. The login failed. Login failed for user '219_nypmecom'.
View 1 RepliesI have created sample database in my SQL server 2005 database.Now i want that database should be password protect when i click on SQL SERVER DATABASE FILE. how to set password when anyone click on my sample database file it will show enter password field to enter into the database.
View 4 RepliesI am using SQL SERVER 2008.
Now I want to access the SQL SERVER 2008 DATABASE on the LAN.
So what was the Connection String and can u give me the Example of that.
copying some data from an existing remote database(SQL2005) to an existing local database.First - I have very little experience in this area. I'm using Visual Web Developer 2008 (VB). Currently if I want to update some data in the local database I do something like this:
Dim conn As Data.SqlClient.SqlConnection = New Data.SqlClient.SqlConnection(ConfigurationManager.ConnectionStrings("CCCdbConnectionString").ConnectionString)
Dim cmd As Data.SqlClient.SqlCommand = New Data.SqlClient.SqlCommand("UPDATE [Orders] Set [OrderStatus]
[code]...
I have a server that doesn't have MSSQL, can I use the default SQLExpress database somehow on the server to store my provider information? Or do I need to use a different databse with custom providers?
View 1 RepliesHow could one set a password on a database in Sql server 2005 & 2008
View 3 RepliesI am considering moving my personal website across from one hosting to another the new hosting will use a SQL Server 2008 Express DB. Is there any easy way of moving the information from MySQL to SQL Server 2008 Express DB.
View 11 RepliesI want to synchronise two databases from two different platforms i.e. MS Sql Server 2000 and MySql. I have two applications one is desktop application which uses Mysql and other is Web application which uses MSSql. When any changes made to MySql from Desktop application, then that changes should get reflected to MS Sql database and vice versa. I am novice for this kind of situation.
View 4 Repliesa script which creates a deadlock in a Sql Server 2008 database?I want to do a trace in a customer environment using a trace flag but first I want to test it in my own environment.
View 4 Repliesi was attaching northwind database with sql server 2005 so while attaching it gives me an error an exception occured while executing a transct -sql statemnet or batch ,unable to eon physical file "C:sql server 2000 sample database orthwnd.mdf"
View 6 RepliesMy website is working but when I host it up, the connection are all screw up. Is it because my connectionString are all linked via SqlDatasource and is for local files only? Whats the coding that I need to put in so that my site will connect to the database via accessing the web.config or server?
View 11 RepliesIf I have a DataTable (in-memory) read by my C# program from a flat file, and I want to create it as a new table in a SQL Server database... what is the simplest way to do that?
It seems like something like SqlBulkCopy with an option to create a new destination SQL server table would be on my line of thinking, but I dont see a way.
How to write a Sql Query for insert, Delete for Image from sql server 2005.
View 2 RepliesI am attempting to write my very first ASP.NET application, it will simply display the contents of an SQL server database table in a Gridview. This is just a first step, my eventual intention is rewrite a set of VB6 applications I wrote some years ago. But I need to walk before I can run.
I have already created an SQL Server database containing all the tables used by the VB6 applications.
How do I link this database to my ASP.NET application. Previously (on another computer) I have simply opened "My Computer" and then navigated to the .mdf file (e.g. northwnd.mdf) and then dragged and dropped it into App_Data in Visual Studio. However when I try that on my own machine, with my own data, I get an "Access Denied" message.
How can I not have access to my own data on my own computer? What am doing wrong?
I am running Visual Studio 2008 on a Windows 7 Ultimate machine, with SQL Server 2005 Compact Edition (or which ever one installs with VS 2008).