I figured it out. Within SQL Management Studio you have to right-click on the database -&gt; Properties -&gt; Files -&gt; Owner field. Change this field to the login name/account that you want associated with the &quot;dbo&quot; username for that database. Please keep in mind that the login name/account you choose must already be setup in the sql server under Security -&gt; Logins

If you are trying to remap a login to a db user you can use sp_change_user_login

exec sp_change_user_login &#39;Update_One&#39;, &#39;user&#39;, &#39;login&#39;

PhantomTypist gives a good answer using the GUI.  For achieving the same result with TSQL, you can use this code:

    USE [My_Database_Name]
    GO
    EXEC dbo.sp_changedbowner @loginame = N&#39;domain\abc&#39;, @map = false
    GO



This is a Windows login, not a SQL Server login, so you cannot &#39;change&#39; the login name since it is linked to the user account in Active Directory. 

Create a new Server Login (Windows) mapped to the new windows user (and remove the old one if necessary). Then in login&#39;s Security &gt; User Mapping, permission that login to the appropriate database as user &#39;dbo&#39; (or assign to the db_owner role)

I have been looking for a logging framework for .net (c#) and decided to give log4net a go after reading up on a few question/answer threads here on stackoverflow. I see people mentioning over and over that they use a wrapper class for log4net and I am wonder what that would look like.

I have my code split up into different projects (data access/business/webservice/..).
How would a log4net wrapper class look like? Would the wrapper class need to be included in all of the projects? Should I build it as a separate project all together? 

Should the wrapper be a singleton class? 

What would a Log4Net Wrapper class look like?

What is the difference between the following 2 ways to allocate and init an object?



    AController *tempAController = [[AController alloc] init];
    self.aController = tempAController;
    [tempAController release];

and

    self.aController= [[AController alloc] init];


Most of the apple example use the first method. Why would you allocate, init and object and then release immediately?

Object allocate and init in Objective C

I have a database with user &#39;dbo&#39; that has a login name &quot;domain\xzy&quot;.  How do I change it from &quot;domain\xzy&quot; to &quot;domain\abc&quot;.

Sql Server 2005 how to change dbo login name

<p>I have a database with user 'dbo' that has a login name "domain\xzy".  How do I change it from "domain\xzy" to "domain\abc".</p>


In Oracle, I can re-create a view with a single statement, as shown here:

    CREATE OR REPLACE VIEW MY_VIEW AS
    SELECT SOME_FIELD
    FROM SOME_TABLE
    WHERE SOME_CONDITIONS

As the syntax implies, this will drop the old view and re-create it with whatever definition I&#39;ve given.

Is there an equivalent in MSSQL (SQL Server 2005 or later) that will do the same thing?

SQL Server equivalent to Oracle&#39;s CREATE OR REPLACE VIEW

I have never clearly understood the usage of `MAXDOP`. I do know that it makes the query faster and that it is the last item that I can use for Query Optimization. 

However, my question is, when and where it is best suited to use in a query?



What is the purpose for using OPTION(MAXDOP 1) in SQL Server?

I am currently investigating how to make a connection to a SQL Server database from my Java EE web application using Windows Authentication instead of SQL Server authentication. I am running this app off of Tomcat 6.0, and am utilizing the Microsoft JDBC driver. My connection properties file looks as follows:

    dbDriver              = com.microsoft.sqlserver.jdbc.SQLServerDriver
    dbUser                = user
    dbPass                = password
    dbServer              = localhost:1433;databaseName=testDb
    dbUrl                 = jdbc:sqlserver://localhost:1433

I have zero problems with connecting to a SQL Server database in this fashion when using SQL Server authentication.

Is there any way I can retrieve the credentials of the user&#39;s Windows Authentication and use __that__ authentication for SQL Server?

__UPDATE__: I know in ASP.net there is a way to set up Windows Authentication for access to the webapp, which is exactly what I am looking for, except I want to pass that token off to SQL Server for access to the database.

Can I connect to SQL Server using Windows Authentication from Java EE webapp?

How do I in SQL Server 2005 use the DateAdd function to add a day to a date




SQL Server 2005 Using DateAdd to add a day to a date

I would like this to be the ultimate discussion on how to check if a table exists in SQL Server 2000/2005 using SQL Statements.

When you Google for the answer, you get so many different answers. Is there an official/backward and forward compatible way of doing it?

Here are two possible ways of doing it. Which one among the two is the standard/best way of doing it?

First way:

    IF EXISTS (SELECT 1 
               FROM INFORMATION_SCHEMA.TABLES 
               WHERE TABLE_TYPE=&#39;BASE TABLE&#39; 
               AND TABLE_NAME=&#39;mytablename&#39;) 
       SELECT 1 AS res ELSE SELECT 0 AS res;

Second way:

    IF OBJECT_ID (N&#39;mytablename&#39;, N&#39;U&#39;) IS NOT NULL 
       SELECT 1 AS res ELSE SELECT 0 AS res;

**MySQL** provides the simple 

    SHOW TABLES LIKE &#39;%tablename%&#39;; 

statement. I am looking for something similar.



Check if table exists in SQL Server

How can I have a dynamic variable setting the amount of rows to return in SQL Server? Below is not valid syntax in SQL Server 2005+:

    DECLARE @count int
    SET @count = 20
    
    SELECT TOP @count * FROM SomeTable



Dynamic SELECT TOP @var In SQL Server

I want to return top 10 records from each section in one query. Can anyone help with how to do it?  Section is one of the columns in the table.

Database is SQL Server 2005. I want to return the top 10 by date entered.  Sections are business, local, and feature.  For one particular date I want only the top (10) business rows (most recent entry), the top (10) local rows, and the top (10) features.

Select top 10 records for each category

I have months stored in SQL Server as 1,2,3,4,...12. I would like to display them as January,February etc. Is there a function in SQL Server like MonthName(1) = January? I am trying to avoid a CASE statement, if possible.

Convert Month Number to Month Name Function in SQL

What are the key differences between Microsoft&#39;s SQL Server 2005 and SQL Server 2008?  

Are there any compelling reasons for upgrading (any edition, as I have a customer with multiple editions)? Or is there a website with either a chart or bullet point comparison of the two servers?

Also, is there anything noteworthy in the [Express][1] editions of either version?

  [1]: http://en.wikipedia.org/wiki/SQL_Server_Express


Advantages of SQL Server 2008 over SQL Server 2005?

Will content requested over https still be cached by web browsers or do they consider this insecure behaviour?  If this is the case is there anyway to tell them it&#39;s ok to cache?

Will web browsers cache content over https

What are the best workarounds for using a SQL `IN` clause with instances of `java.sql.PreparedStatement`, which is not supported for multiple values due to SQL injection attack security issues: One `?` placeholder represents one value, rather than a list of values.

Consider the following SQL statement:

    SELECT my_column FROM my_table where search_column IN (?)

Using `preparedStatement.setString( 1, &quot;&#39;A&#39;, &#39;B&#39;, &#39;C&#39;&quot; );` is essentially a non-working attempt at a workaround of the reasons for using `?` in the first place.  

What workarounds are available?


PreparedStatement IN clause alternatives?

When sending data over HTTPS, I know the content is encrypted, however I hear mixed answers about whether the headers are encrypted, or how much of the header is encrypted.

How much of HTTPS headers *are* encrypted?

Including GET/POST request URLs, Cookies, etc.

Are HTTPS headers encrypted?

What is the series of steps needed to securely verify a ssl certificate?  My (very limited) understanding is that when you visit an https site, the server sends a certificate to the client (the browser) and the browser gets the certificate&#39;s issuer information from that certificate, then uses that to contact the issuerer, and somehow compares certificates for validity.  

   * How exactly is this done? 
   * What about the process makes it immune to man-in-the-middle attacks?
   * What prevents some random person from setting up their own verification service to use in man-in-the-middle attacks, so everything &quot;looks&quot; secure?

How are ssl certificates verified?

When comparing an HTTP GET to an HTTP POST, what are the differences from a security perspective? Is one of the choices inherently more secure than the other? If so, why?

I realize that POST doesn&#39;t expose information on the URL, but is there any real value in that or is it just security through obscurity? Is there ever a reason that I should prefer POST when security is a concern?

**Edit:**  
Over HTTPS, POST data is encoded, but could URLs be sniffed by a 3rd party? Additionally, I am dealing with JSP; when using JSP or a similar framework, would it be fair to say the best practice is to avoid placing sensitive data in the POST or GET altogether and using server side code to handle sensitive information instead?

Is either GET or POST more secure than the other?


I&#39;m looking for a way to authenticate users through LDAP with PHP (with Active Directory being the provider). Ideally, it should be able to run on IIS 7 ([adLDAP][1] does it on Apache). Anyone had done anything similar, with success?

* Edit: I&#39;d prefer a library/class with code that&#39;s ready to go... It&#39;d be silly to invent the wheel when someone has already done so.

  [1]: http://adldap.sourceforge.net/

Authenticating in PHP using LDAP through Active Directory

How can I validate a username and password against Active Directory? I simply want to check if a username and password are correct.


Validate a username and password against Active Directory?

I have a simple task of authenticating against Active Directory using Java. Just verifying credentials and nothing else. Let&#39;s say my domain is &quot;fun.xyz.tld&quot;, OU path is unknown, and username/password is testu/testp. 

I know there&#39;s a few Java libraries out there that simplify this task, but I wasn&#39;t successful at implementing them. Most examples that I&#39;ve found addressed LDAP in general, not specifically Active Directory. Issuing LDAP request means sending an OU path in it, which I don&#39;t have. Also, the application that issues LDAP request should be already bound to Active Directory in order to access it... Insecure, since the credentials would have to be stored someplace discoverable. I would like a test bind with test credentials, if possible - this would mean that account is valid.

Last, if possible, is there a way to make such authentication mechanism encrypted? I know that AD uses Kerberos, but not sure if Java&#39;s LDAP methods do.

Does anyone has an example of working code? Thanks.

Authenticating against Active Directory with Java on Linux

What are the differences between LDAP and Active Directory?

I&#39;m currently researching methods for storing user roles and permissions for .NET based projects. Some of these projects are web based, some are not. I&#39;m currently struggling to find the best method to achieve what I&#39;m looking for in a consistent, portable way across project types.

Where I&#39;m at, we&#39;re looking to leverage Active Directory as our single point of contact for basic user information. Because of this, we&#39;re looking to not have to maintain a custom database for each application&#39;s users since they are already stored in Active Directory and actively maintained there. Additionally, we don&#39;t want to write our own security model/code if possible and would like to use something pre-existing, like the security application blocks provided by Microsoft.

Some projects require only basic privileges, such as read, write, or no access. Other projects require more complex permissions. Users of those applications might be granted access to some areas, but not others, and their permissions can change across each area. An administration section of the app would control and define this access, **not** the AD tools. 

Currently, we&#39;re using integrated Windows Authentication to perform authentication on our intranet. This works well for finding out basic user information, and I&#39;ve seen that ASP.NET can be extended to provide an Active Directory roles provider, so I can find out any security groups a user belongs to. But, what seems like the downfall of this method to me is that everything is stored in Active Directory, which could lead to a mess to maintain if things grow too big. 

Along this same line, I&#39;ve also heard of Active Directory Lightweight Directory Services, which seems like it could extend our schema and add only application specific attributes and groups. Problem is, I can&#39;t find anything on how this would be done or how this works. There are MSDN articles that describe how to talk to this instance and how to create a new instance, but nothing ever seems to answer my question.

**My question is:** Based on your experience, am I going down the right track? Is what I&#39;m looking to do possible using just Active Directory, or do other tools have to be used?

----------

**Other methods I&#39;ve looked into:**

 - Using multiple web.config files [[stackoverflow][1]]
 - Creating a custom security model and database to manage users across applications


  [1]: https://stackoverflow.com/questions/176338/customer-configurable-asp-net-web-site-security-for-fine-grained-control-of-page

Content Type	Original Author	Original Content on Stackoverflow
Question	410	View Question on Stackoverflow
Solution 1 - Sql Server	410	View Answer on Stackoverflow
Solution 2 - Sql Server	Thad	View Answer on Stackoverflow
Solution 3 - Sql Server	Mike	View Answer on Stackoverflow
Solution 4 - Sql Server	user21576	View Answer on Stackoverflow

Sql Server 2005 how to change dbo login name

Sql Server Problem Overview

Sql Server Solutions

Solution 1 - Sql Server

Solution 2 - Sql Server

Solution 3 - Sql Server

Solution 4 - Sql Server

Object allocate and init in Objective C

What would a Log4Net Wrapper class look like?

Attributions