4 Product is officially called "SQL Server" - and not MSSQL, MS-SQL, MS SQL or anything like that....
source | link

Find a string in MSa SQL Server database

I have an application which has logged an error like

Object <obj id> generated an exception.

The application store all its information in MSSQLa SQL Server database which contains 100+ tables. For

For sure somewhere there must be a table which contains all the objects of this type and I'm sure obj id is the key column there.

How can I find this object  ? Do I have to create 100+ SELECT queries to query each table or maybe there is a more convenient solution?

Find a string in MS SQL database

I have an application which has logged an error like

Object <obj id> generated an exception.

The application store all its information in MSSQL database which contains 100+ tables. For sure somewhere there must be a table which contains all the objects of this type and I'm sure obj id is the key column there.

How can I find this object  ? Do I have to create 100+ SELECT queries to query each table or maybe there is a more convenient solution?

Find a string in a SQL Server database

I have an application which has logged an error like

Object <obj id> generated an exception.

The application store all its information in a SQL Server database which contains 100+ tables.

For sure somewhere there must be a table which contains all the objects of this type and I'm sure obj id is the key column there.

How can I find this object? Do I have to create 100+ SELECT queries to query each table or maybe there is a more convenient solution?

    Tweeted twitter.com/#!/StackDBAs/status/307754864480505856
3 added 2 characters in body
source | link

I have an application which has logged an error like

Object <obj id> generated an exception.

The application store all its information in MSSQL database which contains 100+ tables. For sure somewhere there must be a table which contains all the objects of this type and I'm sure obj id is the key column there.

How can I find this object ? Do I have to create 100+ selectSELECT queries to query each table or maybe there is a more convenient solution?

I have an application which has logged an error like

Object <obj id> generated an exception.

The application store all its information in MSSQL database which contains 100+ tables. For sure somewhere there must be a table which contains all the objects of this type and I'm sure obj id is the key column there.

How can I find this object ? Do I have to create 100+ select queries to query each table or maybe there is a more convenient solution?

I have an application which has logged an error like

Object <obj id> generated an exception.

The application store all its information in MSSQL database which contains 100+ tables. For sure somewhere there must be a table which contains all the objects of this type and I'm sure obj id is the key column there.

How can I find this object ? Do I have to create 100+ SELECT queries to query each table or maybe there is a more convenient solution?

2 added 104 characters in body
source | link

I have an application which has logged an error like

Object <obj id> generated an exception.

The application store all its information in MSSQL database which contains 100+ tables. For sure somewhere there must be a table which contains all the objects of this type and I'm sure obj id is the key column there.

How can I find this object ? Do I have to create 100+ select queries to query each table or maybe there is a more convenient solution?

I have an application which has logged an error like

Object <obj id> generated an exception.

The application store all its information in MSSQL database which contains 100+ tables. For sure somewhere there must be a table which contains all the objects of this type and I'm sure obj id is the key column there.

How can I find this object ?

I have an application which has logged an error like

Object <obj id> generated an exception.

The application store all its information in MSSQL database which contains 100+ tables. For sure somewhere there must be a table which contains all the objects of this type and I'm sure obj id is the key column there.

How can I find this object ? Do I have to create 100+ select queries to query each table or maybe there is a more convenient solution?

1
source | link