Community
- Command Central
- MVP Program
- Monthly Mission
- Blogs
- Groups
- Events
- Media Vault
Products
- Observability
- Network Management
- Application Management
- IT Security
- IT Service Management
- System Management
- Database Management
Content Exchange
- SolarWinds Platform
- Server & Application Monitor
- Database Performance Analyzer
- Server Configuration Monitor
- Network Performance Monitor
- Network Configuration Manager
- SQL Sentry
- Web Help Desk
Free Tools & Trials
Store

select id from cond with (nolock)

Trying to run the query: select id from cond with (nolock) on the ignite repository database but I get the following error:

Msg 208, Level 16, State 1, Line 1

Invalid object name 'cond'.

What am I doing wrong?

Find more posts tagged with

Accepted answers

roballen

You probably just need to specify the schema. For example:

select id from ignite.cond with (nolock)

Or use the setuser command:

setuser 'ignite';

select id from cond with (nolock);

The above queries assume that "ignite" is the name of your DPA schema.

All comments

roballen

You probably just need to specify the schema. For example:

select id from ignite.cond with (nolock)

Or use the setuser command:

setuser 'ignite';

select id from cond with (nolock);

The above queries assume that "ignite" is the name of your DPA schema.

FormerMember

Hi roballen,

I just figured that out myself but now I understand why.

Thanks for the reply!

jay.perry

Just add the full name of the database schema and you should be good

doyekanmi

hello

i'm trying to generate custom reports based on usernames and the SQL they are executing. do you have table details of how i can get this on ignite? i know the CONST_2 table stores the query details but i dont know which table to link it with in order to get the user exectuing the SQL.

mandevil

Here is a custom report for top SQL by user: Custom Report - Top SQL for Database User

Feel free to modify as needed, but it shows the relationship between CONSW, CONST, and CONU (user).