User can not connect remotely to SQL Server

Problem:

An user can not connect remotely to SQL Server, but he can connect in the server machine.

Solution:

Check that TCP/IP is enabled in SQL Server Configuration Manager --> SQL Server Network Configuration --> Protocols for MSSQLSERVER:

sp_change_users_login

sp_change_users_login @Action='update_one', @UserNamePattern='itai', @LoginName='itai'

GO

Maps an existing database user to a SQL Server login.

@Action can be:

• Auto_Fix - Links a user entry in the sys.database_principals system catalog view in the current database to a SQL Server login of the same name.
• Report - Lists the users and corresponding security identifiers (SID) in the current database that are not linked to any login.
• Update_One - Links the specified user in the current database to an existing SQL Server login.

http://msdn.microsoft.com/en-us/library/ms174378(v=sql.90).aspx

Change The Logical Name of SQL Server DB file

ALTER DATABASE DBName 

MODIFY FILE (NAME=N'Current_Logic_Name', NEWNAME=N'New_Logic_Name')

Get UTC datetime in MSSQL

-- UTC datetime:

SELECT GETUTCDATE()

-- UTC datetime (long datetime, like SYSDATETIME):

SELECT SYSUTCDATETIME()

Note: in order to get the time zone offset:

http://copypastenet.blogspot.com/2011/08/get-time-zone-offset-in-mssql.html

Get the time zone offset in MSSQL

SELECT SYSDATETIMEOFFSET()

-- return datetime + time zone offset.

Delete multiple objects in one statement

DROP TABLE StamTableItai1, StamTableItai2

GO

DROP PROCEDURE SP1,SP2

GO

DROP FUNCTION F1,F2

GO

sys.dm_db_index_usage_stats - indexes usage

SELECT * FROM sys.dm_db_index_usage_stats

Returns counts of different types of index operations and the time each type of operation was last performed.

http://msdn.microsoft.com/en-us/library/ms188755.aspx