Jul 8, 2016 · I am getting this error while trying to connect to the SQL Server. Microsoft SQL Server Error: 18456 Can anybody tell me what the error code means?

I have this query with MySQL: select * from table1 LIMIT 10,20 How can I do this with SQL Server?

Apr 11, 2017 · After installation you need to connect to Server Name : localhost to start using the local instance of SQL Server. Once you are connected to the local instance, right click on …

Jan 21, 2019 · I am using SQL Server 2008 Enterprise. I want to see any active SQL Server connections, and the related information of all the connections, like from which IP address, …

Sep 18, 2013 · I am going to get the list of all users, including Windows users and 'sa', who have access to a particular database in MS SQL Server. Basically, I would like the list to look like as …

Apr 6, 2017 · 97 I have downloaded the SQL Server Management Studio (SSMS) 2016 to recover a huge .bak file which is an old backup of a database. But first of all I need to connect to a DB …

Yes I read this How to find the port for MS SQL Server 2008? no luck. telnet 1433 returns connection failed, so I must specify other port. I tried to use netstat -abn but I don't see sqlservr...

Is there a way to list the queries that are currently running on MS SQL Server (either through the Enterprise Manager or SQL) and/or who's connected? I think I've got a very long running …

Nov 9, 2012 · How can I send an email using T-SQL but email address is stored in a table? I want to loop through the table and be able to send email. I cannot find a good example of doing this …

Aug 26, 2013 · I need to know if a given Job is currently running on Ms SQL 2008 server. So as to not to invoke same job again that may lead to concurrency issues.