Database

Mycroft Holmes wrote:

And the practical difference between a ident and a sequence is?

Mycroft Holmes wrote:

I spend a lot of time chasing down problems in the data

PIEBALDconsult wrote:

Sequences aren't tied to a particular table. You can get a value from a sequence without adding a record

saud_a_k wrote:

<Connection Name="UserID" Value="user" />
<Connection Name="Password" Value="pwd" />

using System;
using System.Data.SqlClient;

static class SqlTester
{
  public static int Main (string[] args)
  {
    using (SqlConnection con = new SqlConnection(args[0])
    {
      try
      {
         con.Open ();
         Console.WriteLine ("Connected succesfull, your ConnectionString is correct :)");
      }
      catch (Exception ex)
      {
         Console.WriteLine ("Something went wrong:\n" + ex.ToString ());
      }
    }
  }
}

• an account with given UserID (should be in the same place as the 'sa')
  
• allowed mixed mode access (not just Windows-authentication)
  
• whether the servers' name is correct (express versions are called different than full servers, and they might even be using a named instance)
  

I are Troll

Eddy Vluggen wrote:

an account with given UserID (should be in the same place as the 'sa')

allowed mixed mode access (not just Windows-authentication)

whether the servers' name is correct (express versions are called different than full servers, and they might even be using a named instance)

saud_a_k wrote:

I checked all these options but I still get the same error

Data Source=myServerAddress;Initial Catalog=myDataBase;User Id=myUsername;Password=myPassword;

saud_a_k wrote:

I also gave the location of another server but still the page shows up on the server but not on the client

I are Troll

Delete from mytable
where ID not in (select top 100 from mytable order bt ID desc)