dbafox

DBA Technical Information

Skip to content
  • Ray Fox’s Blog
  • Database Article Links
    • Oracle Articles
    • Microsoft SQL Server
    • NetApp
  • Operating System
    • Linux
    • Windows
  • Linux – Useful Commands
    • Linux Monitoring
  • Useful SQL for Microsoft SQL Server
  • Links from IE

Post navigation

← SQL Server – Display Running Tasks
Powershell – Recursive Search for Strings in Files →

SQL Server – Translate object_ids/object_names

Posted by Ray Fox
-- Get object_id from object name
select OBJECT_ID('[dbo].[testobject]')

-- get object_name from object id
select OBJECT_NAME(213575799)

Posted in Linux, MS SQL Server, Oracle Technical, PowerShell, Uncategorized

Jun·25

Post navigation

← SQL Server – Display Running Tasks
Powershell – Recursive Search for Strings in Files →

Categories

Blogroll

  • Documentation
  • Plugins
  • Suggest Ideas
  • Support Forum
  • Themes
  • WordPress Blog
  • WordPress Planet

Visitor Map

Tags

2016 automic workload repository AWR cluvfy Dataguard Deadlock Diagnostics Direct NFS disk full Extended Event flashback FlexClone Linux mariadb Microsoft SQL Server migrate MobaXterm mRemoteNG mtu multicast mysql nagios NetApp nrpe.cfg Oracle phpMyAdmin postgresql powershell Putty Python RAC SnapManager sql server SYSAUX sysnative TOAD for Oracle udp Windows X-Win32 XMing

Categories

  • Cameras
  • Hadoop
  • Links
  • Linux
  • Microsoft Excel
  • MS SQL Server
  • Network
  • Oracle ASM
  • Oracle Cloud Infrastrucure (OCI)
  • Oracle Multitenant
  • Oracle RAC
  • Oracle Technical
  • Oracle Virtualization OVM
  • phpMyAdmin
  • postgresql
  • PowerShell
  • Python
  • Uncategorized
  • Windows

Recent Posts

  • Host your own WordPress Website for Free on Oracle Cloud Infrastructure
  • Use VLC to Stream Hikvision Camera Feed (RTSP)
  • Execute AD Users and Computers
  • Bernune2
  • Windows – add .NET Framework
Privacy & Cookies: This site uses cookies. By continuing to use this website, you agree to their use.
To find out more, including how to control cookies, see here: Cookie Policy

Search

Main Menu

  • Ray Fox’s Blog
  • Database Article Links
    • Oracle Articles
    • Microsoft SQL Server
    • NetApp
  • Operating System
    • Linux
    • Windows
  • Linux – Useful Commands
    • Linux Monitoring
  • Useful SQL for Microsoft SQL Server
  • Links from IE

Categories

  • Cameras
  • Hadoop
  • Links
  • Linux
  • Microsoft Excel
  • MS SQL Server
  • Network
  • Oracle ASM
  • Oracle Cloud Infrastrucure (OCI)
  • Oracle Multitenant
  • Oracle RAC
  • Oracle Technical
  • Oracle Virtualization OVM
  • phpMyAdmin
  • postgresql
  • PowerShell
  • Python
  • Uncategorized
  • Windows
Proudly powered by WordPress | Theme: Reddle by WordPress.com.

Privacy Policy