Is your client machine on the domain? If not you can launch SSMS from command prompt with your domain credentials.
runas /netonly /user:YourDomain\UserName "C:\Program Files (x86)\Microsoft SQL Server\110\Tools\Binn\ManagementStudio\Ssms.exe"

Confirm the server is configured for SQL Server Authentication. You will not be able to login with a username and password unless this is enabled.

This simplified example may explain the issue:
DECLARE @a VARCHAR(8000) = REPLICATE('A', 8000);
DECLARE @b-2 VARCHAR(8000) = REPLICATE('B', 8000);
DECLARE @C VARCHAR(MAX)...

I can sum it up in one word. Passion.

“Passion is the path to the light side. Passion leads to hunger. Hunger leads to knowledge. Knowledge leads to wisdom."

Perhaps this bug:
https://connect.microsoft.com/SQLServer/feedback/details/383878/extended-event-session-hangs

You can simply use the ROW_NUMBER function in your CTE, like this:

Declare @diary TABLE ([Diary Reference] int, [Tenant Code] varchar(7), [Category] varchar(4), [Action Date] date,...

Join to a subquery to find the row you need. You can also use a CTE with the ROW_NUMBER function.

Select a.Vin,aEntry_Date as Entry_Date1,a.Status
from VS_Transaction a

This was resolved 3 years ago.

insert @keywords select 'col1','''Robert''; DROP TABLE Students; --'

Lee Linares (11/24/2015)

I created the test table but when I ran your version of Doran script the ONLY data returned was for the queue_messages_xxxxxxxx internal tables with 'Unique Index' shown...

Actually, in testing I discovered it does not report the correct data. This will find tables that have a unique index with multiple columns as well as another index with...

This is a handy script, however you are only looking at clustered primary keys. I modified the script to remove the filter based on index_id as you can also get...

cyagasa (10/9/2015)

select

,left([IDNumber],2) as year

,SUBSTRING(Idnumber,3,2) as Month

,SUBSTRING (Idnumber,5,2) as day

,SUBSTRING(Idnumber ,7,4) as gender

,substring (idnumber ,10,3) nationality

from...

I'm sure I just saw a DeLorean.