When you run the klist.exe tickets its not supposed to return the service account, its gonna return the ticket from the server if its using kerberos, if you connect to...

Klist.exe tickets

doesn't require domain admin privileges, open cmd as admin, these are the tickets the AD assigned to your user.

If you can't see the Listener entry when...

when you connect through the listener, try doing klist.exe tickets and try and find your ticket in cmd.

find the one that belongs to the listener and tell us what it...

What it looks like your database is doing is the recovery after restarting the service/recovering the database, this phase can take quite a while if you don't backup your transaction...

Yes, it shouldn't be a problem to have different versions on the same machine.

There was a post not long ago regarding the same issue.

https://www.sqlservercentral.com/forums/topic/tempdb-full-14#post-3743539

it's not the most accurate post regarding tempdb issues but it might help even a little.

Check it out...

You could also right click the object in this case the table, properties and go to storage and see the 'Row Count'

If you have a column with an identity value and is a clustered index you could select max(id) from the table.

You can also use this script to check the row...

1st) You gotta be quick otherwise you won't be able to connect to the instance (even though it should only support query editor connections) and would need to stop the...

In the documentation at the bottom says to change - with these / in CMD.

this one worked for me tcroninlifepoint:

"C:\Program Files\Microsoft SQL Server\MSSQL13.MSSQLSERVER\MSSQL\Binn\sqlservr" /s MSSQLSERVER /m"Microsoft SQL Server Management Studio...

• This reply was modified 4 years, 5 months ago by  Alejandro Santana.

I truly didn't knew that Frederico, thanks.

hi,

The parameter -m is to start the SQL Server engine service in single-user mode, it doesn't work with SSMS.

I think you are mistaking one thing with the other and its...

I don't think you can do it natively but using xp_cmdshell and writing some script using the IP Address to get the PC information from the network, else i would...

Yes there's a way, you can use the sys.dm_exec_connections DMV to see the local_net_address, if the IP in there is the IP of your instance and not the listener, then...

It's cool, here it is again in case you need it:

The issue was that before, when you  needed to create, or extend a data file in SQL Server, it would...