In one of the recent scenarios we noticed that a user database was deleted and customer wanted to which user has dropped the database. We know that multiple user had full access on that database. In this post I
how to find the all databases sizes in sql server 2000 ? How to find the last execution time of stored procedure sql server 2005 How to find the most expensive operation in an execution plan - need to read xml and sort on calculated field How to find the space taken by Schema wise i...
Read our disclosure page to find out how can you help Windows Report sustain the editorial team.Read more Of course, it’s frustrating to discover a corrupted database on your SQL Server for apparent reasons. You can’t access the information, and your work stops. However, you can fix thi...
右键单击“SQL Server 对象资源管理器”中的“Trade”数据库,然后选择“刷新”。 请注意,新的 Fruits 表已添加到该数据库中。 创建新的函数 使用以下代码替换当前 Transact-SQL 编辑器中的代码: 复制 CREATE FUNCTION [dbo].GetProductsBySupplier ( @SupplierId int ) RETURNS @returntable TABLE ( [Id] int...
Explore the benefits of DBaaS and learn how to leverage managed database services for PostgreSQL. Discover key insights on cloud migration, find the right cloud service provider, and optimize your Postgres database with ease. Contact Us Technical Guides and Articles on Cloud Migration ...
How to Repair Database in Suspect Mode in SQL Server. There are times when you connect to an SQL Server Instance you will find the database being marked as SUSPECT. In such a scenario, you will not be able to connect to the database to read and write dat
The dbid column in the sysdm_exec_sql_text may contain null value. So using it to filer the queries executed against a specific database in not reliable. Other Options One option to find the last few executed queries is by using server-side trace for a short time and collect the SQL st...
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,...
In this post, we are going to learn how to find out if the table is used in a Stored Procedure. we have multiple ways to do that. This System Stored Procedure will return you list of table/views used by the Stored procedure/View. You can pass the view name or Stored Procedure as ...
SQL Server indexes are copies of the data that exist in the table, ordered and filtered in different ways to improve the performance of executed queries.