how to shift remote database(database in other system) to local system in sql server ?
108436
As m1rr0r explained it all depends on the server you are using.  The process would be something like this:\nExport Database and save it locally.  Import database in to local server. Repoint software to locally instead of remote location.\n\nIf your using MYSQl then you can use PhpAdmin To export the database.\n\nPlease put more details if you can.
1164930
Go to enterprise, and click on the database in which you want and right click on stored procedures and create new...\nIs that what u want?
888756
You can use a freeware version of SQLyog tool from http://www.webyog.com/.\n\n1. You have to first register both you production server and the development server.\n\n2. Make a connection to both servers\n\n3. Create a blank database on prodction server (in case there is no database on production server).\n\n3. Right click on the production server database and select the 'Copy databases to different Host/DB...'
312379
If you're trying to authenticate with Windows authentication, and you're not logged in to the remote server, your login will fail.\n\nIf you are trying to use SQL authentication, and there is an error in your connection string to the remote DB, your login will fail.\n\nIf your remote DB only accepts logins from trusted sources or named pipes, and you are not connection from a trusted source or a named pipe, your login will fail.
815265
The PostgreSQL database server provides a reliable, robust database solution at no cost. Here's a link which will clearly expalins how to do it\n\nhttp://www.builderau.com.au/program/dotnet/soa/Integrate_PostgreSQL_with_NET/0,339028399,339267580,00.htm
550473
To have a distributed database system, first, you need to make sure that each individual database has the same structure and layout as all the others, ie the same columns, type, etc.  \n\nSecond, you need to make sure that no data is duplicated from one pc's database to the next.\n\nFinally, if both the first and second criteria are met, and all database tables are in 3rd normal form, I would use a client/server system, and each PC would be just a client, rather than trying to tie all PC's together as a though they were one massive server.
768463
You get database libraries for the 'C' language. For eg. SQL server has such a library, you can find some examples also. You can use standard API like ODBC, JDBC also.
510194
let take a example you are having small network in that  different systems are present.\nif you want to tranfer the files (data) from the remote system to your system or wise versa then following commands\nin the command prompt type ftp 1.1.1.1 (1.1.1.1 is the ip address) then one window is to be opened.\nin that window u find all the sharred folders of the remote system then u copy the respective file and get that file to your system
1124098
In VS.NET Xpress u can connect with databases using \n1.SqlClient, 2. OleDb, 3. Odbc\nThese classes hav inbuild methods that makes everything simpe and sweet.\n\nFor indepth coverage on these topic visit microsoft's MSDN, Also go thru sqljunkies.com, dotnetjunkies.com\n\nOleDb Code Sample\n************************************************\n\n\nusing System;\nusing System.Data;\nusing System.Data.OleDb;\n\nclass Sample\n{\npublic static void Main()\n{\nOleDbConnection nwindConn = new OleDbConnection("Provider=SQLOLEDB;Data Source=localhost;Integrated Security=SSPI;Initial Catalog=northwind");\n\nOleDbCommand catCMD = nwindConn.CreateCommand();\ncatCMD.CommandText = "SELECT CategoryID, CategoryName FROM Categories";\n\nnwindConn.Open();\n\nOleDbDataReader myReader = catCMD.ExecuteReader();\n\nwhile (myReader.Read())\n{\nConsole.WriteLine("&#92;t{0}&#92;t{1}", myReader.GetInt32(0), myReader.GetString(1));\n}\n\nmyReader.Close();\nnwindConn.Close();\n}\n}\n\nOdbc Code Sample\n************************************************\nusing System;\nusing System.Data;\nusing System.Data.Odbc;\n\nclass Sample\n{\npublic static void Main()\n{\nOdbcConnection nwindConn = new OdbcConnection("Driver={SQL Server};Server=localhost;" +\n"Trusted_Connection=yes;Database=northwind");\n\nOdbcCommand catCMD = new OdbcCommand("SELECT CategoryID, CategoryName FROM Categories", nwindConn);\n\nnwindConn.Open();\n\nOdbcDataReader myReader = catCMD.ExecuteReader();\n\nwhile (myReader.Read())\n{\nConsole.WriteLine("&#92;t{0}&#92;t{1}", myReader.GetInt32(0), myReader.GetString(1));\n}\n\nmyReader.Close();\nnwindConn.Close();\n}\n}
720081
with a remote software like remote administrator
834034
go to start run type "mstsc"\nput there the ip of the other pc\n\nbut be shure to activate remote assistance on the other pc,..\ngo to my computer propertys remote assistance\n\nor try the program called radmin
1167306
The short answer is that you have to have an external (remote) database setup, then you can use odbc to connect to it.
368518
This is one of many ways to do it. This is the most straight forward and assumes you know sql syntax & that you know your connection string:\n\nDim cn as New System.Data.SqlClient.SqlConnection()\nDim cmd as New System.Data.SqlCommand()\n\nTry\n     'set your sql connection string here\n     cn.ConnectionString = ""\n     cn.Open()\n     cmd.CommandText = "delete from [MyTable] where [MyRowID] = 123"\n     cmd.ExecuteNonQuery()     \nFinally\n     If cn <> Nothing AndAlso cn.ConnectionState = System.Data.ConnectionState.Opened Then\n        cn.Close()\n        cn.Dispose()\n     End If\nEnd
144781
I can't say I even undertand the question.\n\nIn Windows XP Professional and higher, you can right click on a file (EXEs included) and change the permissions in the "Security" tab, adding and removing users of the local system or NT domain...
116143
You absolutely can through an ODBC connection.  Are you using DB2 on an AS/400?\n\nSee the following instructions:\nhttp://support.businessobjects.com/library/kbase/articles/c2016569.asp
1132417
Skip calling the stored proc and use a cursor to grab the rows directly and insert them into the second table.\n\nExample cursor:\n--------------------------\nDECLARE @col1_value VARCHAR(100)\nDECLARE @col2_value VARCHAR(100)\n\nDECLARE cc CURSOR FOR\nSELECT col1, col2\nFROM table1\n\nOPEN cc\n\nFETCH NEXT FROM cc INTO @col1_value, @col2_value\n\nWHILE @@FETCH_STATUS=0\nBEGIN\n\nINSERT INTO table2 (column1, column2)\nVALUES @col1_value, @col2_value\n\nEND\n\nCLOSE cc\nDEALLOCATE cc\n--------------------------
698617
SQL Server 2005, by default, does not allow remote connections. You'll need to change that using the SQL Server 2005 Surface Area Configuration tool: