I'm trying but no sucess someone can help me how i can fix this code for update Master Query Azanalizer Sql Server.Quote:
namespace WindowsFormsApplication1
{
public partial class Form1 : Form
{
private SqlConnection Cnn;
private SqlCommand sqlCommand;
public Form1()
{
InitializeComponent();
}
private void button1_Click(object sender, EventArgs e)
{
Cnn = new SqlConnection(@"Data Source=127.0.0.1;Initial Catalog=master;User Id=OBDC_DK;Password=123456");
Cnn.Open();
sqlCommand = new SqlCommand("UPDATE master, Cnn);
sqlCommand.Parameters.Add("@Query", textBox1.Text);
sqlCommand.ExecuteNonQuery();
MessageBox.Show("Update SucessFully");
}
}
}
I make this code for he update on this sp_addlinkedserver
EXEC sp_addlinkedserver 'Server','','MSDASQL',NULL,NULL,'DRIVER={SQL Server};SERVER=localhost;UID=;PWD=;'






