Bijay 
Recently, I was working on a project where I was searching for a critical temp table. In this article, I will walk you through all the simple approaches to find temp tables in SQL Server. Where To Find Temp Tables In SQL Server Let us discuss all the approaches individually. Approach-1: Using SQL Server Management … Read more >>
![Cannot find type [microsoft.sqlserver.management.smo.server]](https://databasefaqs.com/wp-content/uploads/2025/01/Cannot-find-type-microsoft.sqlserver.management.smo_.server.jpg)
I was trying to retrieve the SQL edition using a PowerShell script recently. After executing that query, I got this error. In this article, I will discuss the cause and the solution to this error. Cannot find type [microsoft.sqlserver.management.smo.server] I was executing the below query. After executing the above query, I got the error as … Read more >>
In this Oracle tutorial, we will learn how to create a user in the oracle database 21c & 19c. Oracle create user Each organization has a different set of departments handled by professionals. These professionals require access to the Oracle database to perform assigned responsibilities. The username is created for each individual who will be … Read more >>
In this SQL Server tutorial, we will learn about SQL Server stored procedure if exists update else insert. And we will also try to implement some examples related to it. SQL Server stored procedure if exists update else insert A SQL Server table is a shared database object used to store data organizationally. We may … Read more >>
In this SQL Server tutorial, we will learn about the SQL Server function return table. We will illustrate this topic using multiple examples. SQL Server function return table In this section, we will learn how to create a user-defined function in SQL Server that returns table-type data. For this task, first, we need to know about user-defined … Read more >>
Here we will learn and understand how to use the SQL Server EOMONTH function to find the last day of the month from the table by the query. And which will be explained with the help of a demonstrated example. SQL Server Last Day Of Month The SQL Server EOMONTH function is used to return … Read more >>
In this SQL Server tutorial, we will learn about “SQL Server First Day Of Month” where we will discuss how to get the first day of the month from the table. We will understand and learn some examples so that you can understand the concept much better. Here is the complete list of topics that we … Read more >>
In the above section, we have discussed how to access various information in the log files of the SQL Server Instance. You can use the SQL Server Profiler to access the log information. How to find who created a stored procedure in SQL Server You can find the user who created the stored procedure using … Read more >>
This article is about SQL Server stored procedure modified date. In this topic, we will cover various information about the stored procedure creation or modification. For example, who created the stored procedure, when was it created or modified, etc. How to check stored procedure modified date in SQL Server If you want to know about … Read more >>
When someone modifies or alters a stored procedure, the information is stored in logs. By accessing the logs you can know who modified the stored procedure and when. How to find who modified a stored procedure in SQL Server To find who modified a stored procedure in SQL Server, follow the below approaches. But before … Read more >>
Download A 40 pages PDF And Learn Now.