How To Kill Session Without ALTER SYSTEM Authorization

18 Dec by dbtut

How To Kill Session Without ALTER SYSTEM Authorization

  Application developers may want to kill long-running queries. However, since application developers do not have ALTER SYSTEM privileges, they cannot execute the kill session command. Also, this authorization should not be given to users who are not dba. There is a way for application developers to kill sessions without ALTER SYSTEM authorization. We may […]
18 Dec by dbtut

How To Create a SQL Server Job

  You can create jobs on SQL Server to do certain operations at certain intervals. For example, if you want to run a script every half an hour or you may need to get backups every night. We can duplicate samples. In this article I will describe how to create a job. Right-click Jobs under […]
17 Dec by Ekrem Önsoy

Unable to open the physical file “xxx.mdf”

  ERROR MESAGGE: “Unable to open the physical file “xxx.mdf”. Operating system error 5: “5(failed to retrieve text for this error. Reason: 15105)”. (Microsoft SQL Server, Error: 5120)” EXPLANATION: You may encounter an error message when you want to attach a database by using SQL Server Management Studio (SSMS). SOLUTION: You may receive this error […]
17 Dec by Ekrem Önsoy

Unexpected EOF encountered in BCP data-file

  ERROR MESAGGE: “[Microsoft][SQL Native Client ]Unexpected EOF encountered in BCP data-file” EXPLANATION: You may encounter an error message when trying to transfer data to your database with the BCP tool from a CSV format file. SOLUTION: The reason for the problem is that the delimiters used in your CSV file are different from the […]
17 Dec by Ekrem Önsoy

Property Owner is not available for Database

  ERROR MESAGGE: “Property Owner is not available for Database ‘[database_name]’. This property may not exist for this object, or may not be retrievable due to insufficient access rights. (Microsoft.SqlServer.Smo)” EXPLANATION: For example, you may see this error message when you try to look at the properties of a database in SQL Server Management Studio. […]
17 Dec by Ekrem Önsoy

Database ” is in warm-standby state (set by executing RESTORE WITH STANDBY) and cannot be backed up until the entire load sequence is completed

  ERROR MESAGGE: “Database ‘<database_name>’ is in warm-standby state (set by executing RESTORE WITH STANDBY) and cannot be backed up until the entire load sequence is completed.”</database_name> EXPLANATION: You may encounter an error message when you back up your database. SOLUTION: If your database is a Secondary database, for example, in a Log Shipping scenario, […]
17 Dec by dbtut

Error 1017 received logging on to the standby

  If the logs are transmitted and not applied to the standby side, if you get the error in the “alert log” file as follows, the only reason is that the orapw file differs with standby because of the sys password change of the database. [crayon-5c1934423a93d260211783/] The solution is very simple. It is necessary to […]
17 Dec by dbtut

How To Filter SQL Server Error Log(Like or Not Like)

  The SQL Server Error Log file is one of the first places each DBA looks at in order to understand and solve the problem. In this article, we will examine the below scenarios. How to read the entire Error Log file without a filter How to read Error Log file by filtering.   As […]