One of my Application server has been restarted yesterday, we would like to know how to find the login information and the IP details of the server. Please help me how to get the information who did restarted SQL services! Thanks in advance, DBA DBAQuestion is quite confusing, if your sq...
In the SSCM, clickSQL Server ServicesunderSQL Server Configuration Manager (Local), you could find list times likeSQL Server (<InstanceName>), the<InstanceName>is exactly what we need to find, instance name. If you install multiple instances on the server, you will see more than oneSQL Ser...
username_database— insert thename of the SQL server databaseto be used mssql.database.servername.tld— insert thehostname or IP address of the serverto connect to 1433— insert the port that you'll use for the MSSQL connection; change this number only if your default port isn’t1433 ...
Replace <IP address> with the actual IP address of the server. This will display the NetBIOS name table, including the hostname2. These methods should help you find the TCP/IP hostname of your Windows server. If you need further assistance, feel free to ask!
Microsoft Access/Jet databases are more prone to corruption than SQL Server for a number of reasons. Since Access/Jet uses a file share model, all users are concurrently holding active connections to data. If any one of those users unexpectedly loses the connection, the database can become cor...
In this post I’ll be sharing the steps to find the details of user who drop the database. Method-1 Connect the SQL Server instance using management studio Right-click on the instance and select “Reports”—“Standard Reports”—“Schema Changes History” ...
In order to communicate with and through the host, you must also configure the firewall on the host server for the containers. Open the firewall for all ports that the SQL Server container exposes for external communication. In the previous example, this would be ports 135, 51433, and 5100...
In my first article I wrote how to recover deleted data from SQL Server. I received queries inquiring, if it is possible to recover the deleted data, is it also possible to know who deleted it and when ? Let me explain it with simple example : Create Table tbl_Sample ([ID] int ...
But the better way to run server side trace. You can export trace definition and run the script to do that. I’m not going to focus on the details how to set it up – you can find information in Books Online. So let’s see what information that trace produces. Let’s run the blo...
1. Find a YouTube Tutorial If you’re looking to learn SQL as fast as possible, YouTube is a great place to start. Rather than completing a lengthy course, you can find a tutorial that simplifies the language into its core concepts. ...