SQL Server : Finding DB objects

By -

@name varchar(120),
@type varchar(5)
as
begin
declare @Sql varchar(500)
set @Sql = 'select * from sysobjects where name like ''%' + @name +'%'' and type = '''+@type+''' order by name'
print @sql
Exec (@sql)

Comments

Post a Comment

Popular posts from this blog

Index Clean-Up Scripts

By -
dropping un-used ones, adding missing ones, and fine-tuning the ones I already have. I thought I’d share some of the scripts I’ve been using to accomplish this. Un-Used Indexes Script Declare @dbid int     , @dbName varchar(100);   Select @dbid = DB_ID()     , @dbName = DB_Name();   With partitionCTE (object_id, index_id, row_count, partition_count)  As (     Select [object_id]         , index_id         , Sum([rows]) As 'row_count'         , Count(partition_id) As 'partition_count'     From sys.partitions     Group By [object_id]         , index_id )    Select Object_Name(i.[object_id]) as objectName         , i.name         , Case              When i.is_unique = 1          ...
Read more

Cleanly Uninstalling Stubborn SQL Server Components

By -
Image
Problem There are scenarios where SQL Server is difficult or impossible to uninstall, upgrade, or replace (and these can block you from installing a new version or using a specific named or default instance): An expired Evaluation Edition: Evaluation period has expired. For information on how to upgrade your evaluation software please go to http://www.microsoft.com/sql/howtobuy An expired Management Studio: Your Microsoft SQL Server Management Studio evaluation period has expired. You can get a key to extend your trial by registering this copy of Microsoft Management Studio online. You may also purchase a key to activate the product. Unsupported operating system (after an OS upgrade): The operating system on this computer does not meet the minimum requirements for SQL Server xxxx. Missing MSI files, e.g.: Slp: Target package: "C:\...\sql_engine_core_inst.msi" Slp: InstallPackage: MsiInstallProduct returned the result code 2. ...
Read more

Leetcode - Blind75 - P1 - Arrays

By -
Image
"Arrays are like the socks in your drawer; there’s always one missing when you need it the most!" We covered the arrays(lists) in python earlier in this article . Building upon that, let's take a look at the list of Blind75 questions that are based on arrays and related concepts. This blog is part of my leetcode journey blog and you can access the complete list here . Mind Mapping the Algorithmic Challenge - Blind75 Why Every Developer Should Use LeetCode Leetcode - Blind75 - Easy Arrays are a fundamental concept in programming, serving as a cornerstone for storing and manipulating collections of data. They are defined as a linear data structure that holds elements of the same data type in contiguous memory locations. The simplicity of arrays lies in their ability to access elements directly through indices, which are typically zero-based, meaning the first element is at index 0. Here's a quick overview of Lists/Arrays in python: In the context of coding in...
Read more