Check out this article hope this will help you out: https://support.microsoft.com/en-us/kb/2688946

To fix SQL Server Login Failed Error 18456 you can take the help of this link: http://www.sqlserverlogexplorer.com/fix-microsoft-sql-server-login-failed-error-18456/

GRANT CREATE TABLE TO UserName

GRANT ALTER ON SCHEMA::AllowedSchema TO UserName

DENY ALTER ON SCHEMA::RestrictedSchema TO UserName

Check out the following article maybe this will help you out: http://social.technet.microsoft.com/wiki/contents/articles/24169.sql-server-searching-all-columns-in-a-table-for-a-string.aspx

You can also take the help of this link to change the default database location for server:

http://sqlandme.com/2013/03/18/sql-server-changing-default-database-location-for-server/

Mount points allow you to mount multiple physical devices under one drive letter, where they look similar to directories. Using mount points is really straightforward.Check out the following article to...

Take a look at this article, hope this will help you out:

https://www.mssqltips.com/sqlservertip/2609/checking-sql-services-status--an-evolution-part-1/[/url]

Simply, yes

Check out this link hope this will help you out: https://support.microsoft.com/en-us/kb/2714785

Exec sys.sp_MSforeachtable ' sp_spaceused "?" '

Check out the following link hope this will help you: https://www.mssqltips.com/sqlservertip/3690/identify-sql-server-database-growth-rates/

run the following command in the database with the login problem, this commands re-map the user's security identifier to match the sql server login's security identifier

ALTER USER...

Ngen.exe causes the SQL Server setup installation process to halt, until shut down

Or it may be an antivirus issue: https://support.avg.com/answers?id=906b00000008nRnAAI

You can take the help of this link: http://sqlserverzest.com/2013/07/31/sql-server-how-to-download-and-install-adventureworks-sample-database/

SELECT column_name(s)

FROM table1

RIGHT OUTER JOIN table2

ON table1.column_name=table2.column_name;