You can seach for objects in all the SQL Server databases within one instance by using the built-in stored procedure: sp_MSforeachdb. For example, let say that you are looking for a stored procedure called: uspGetManagerEmployees but you don’t know in what databases it was created. You can use the following 3 lines to find it: […]
How to search for objects on all the SQL Server databases Read More »
Have you ever faced the problem that you want to see that query or stored procedure that was executed from the front-end application, but you are not able to see it because it’s running in the backend? Well, there is one way: through Microsoft SQL Server Profiler. Microsoft SQL Server Profiler is a graphical user
How to find queries, stored procedures and parameter’s values using SQL Profiler Read More »
To get the list of current running queries, you can use the following script:
How to get the current running queries in SQL Server Read More »
Tables with just one column, which has been specified as identity columns, are not very common, and inserting data into them might be a bit tricky. To do that you need to use DEFAULT value without parenthesis. For example, let’s create the table IdentityTable: To insert data, you need to use the following statement:
How to insert into a one column (identity) table Read More »
