Stack Overflow
Stack Overflow

Questions tagged [system-views]

34 questions
0
votes
1 answer

The table sys.dm_tran_session_transactions is always empty

Hello whenever I select in a new query from the system view sys.dm_tran_session_transactions I get always 0 rows select * from sys.dm_tran_session_transactions But people on some other answers use this table. SQL Server 2005 : map Transaction_ID to…
user8554358
0
votes
2 answers

Extended Events connection_id vs client_connection_id

Hello guys I want to find a way to identify a query executed for Extended Events in Microsoft SQL Server (to filter the Extended Event with only that executed query) If i query the system views in SQL Server like this: SELECT session_id,…
user8554358
0
votes
1 answer

Pre-filtered tables / entities, Systems Views or Stored Procedures in CDS (based on Dynamics CRM DB)

Problem: I have our CRM connected to PowerBI through Common Data service (CDS) but I am not able to pull the views (system or personal) from Dynamics into PowerBI. Tried: Of course, I can just get whole Dynamics Entities through the CDS connector…
ThomasBart
  • 1
0
votes
0 answers

Is there any system table in redshift that gives me all properties of Library objects that i have created

I have created Library object in my Redshift database using below code. Now I want to see in the system tables where all my library properties are saved\stored. CREATE LIBRARY F_URLPARSE LANGUAGE PLPYTHONU FROM 'xxxxx' CREDENTIALS 'xxxxx' REGION AS…
satya
  • 1
  • 1
0
votes
2 answers

Which database stores sys.tables or sys.indexes in SQL Server?

I am not able to figure out where these system tables are stored, your help will be much appreciated.
Shobhit
  • 65
  • 1
  • 1
  • 6
0
votes
1 answer

What is the true sys.all_objects?

I am working with SQL Server 2008 R2 and SQL Server 2016. I have bunch of User-Defined Data Types but they dont show in sys.all_objects. What is the true catalog view which can return all user-defined objects? Thanks
Syed
  • 27
  • 8
0
votes
1 answer

query to sys.server_principals does not return own login

I have the following SQL Server query: SELECT dbp2.name AS nombre FROM sys.server_principals AS sp JOIN sys.database_principals AS dbp ON sp.sid=dbp.sid JOIN sys.database_role_members AS dbrm ON dbp.principal_Id=dbrm.member_principal_Id…
Jairo Ramírez
  • 41
  • 3
0
votes
1 answer

How to change system view icons/style, functionality on android?

How to change view and functionality of multiwindow form(picture 1) like that done samsung(picture 2)? Do we need a launcher (just a specific system change) or do we need to compile a new ROM (if ROM, then where do we need to change the code and…
Doctor Who
  • 43
  • 6
0
votes
1 answer

How can I know the last date I used insert trigger in SQL Server?

I need to get the last datetime I used a particular insert trigger only by system view etc. Pay attention that the date modified of the table isn't correct answer for my question because it includes also table update dates. If you think that I need…
ron
  • 1
  • 6
0
votes
1 answer

How to make changes in system defined views?

Can I make changes in system defined views like I want to add a column that will provide columns name which has been foreign_key applied ? Like, changes in sys.foreign_key_columns. Please provide me script or source.
Deep
  • 1
  • 1
0
votes
1 answer

Missing Full Text Index System View In Sql Server 2008

I've been reading about the system view: sys.dm_fts_index_keywords_by_document on msdn but can't find the view in my 2008 database. Anyone know if it should be there by default?
Andy
  • 7,646
  • 8
  • 46
  • 69
0
votes
2 answers

I want to find column name in my database - is it possible?

My database name is CARE_DynamicsAX and I want to find a column name workerStatus
Rana Ali
  • 71
  • 1
  • 12
0
votes
1 answer

Query full column datatypes MSSQL

I need to query full columns datatype, eventually with length specification. If I use INFORMATION_SCHEMA.COLUMNS or sp_Columns(@tablename) I get type, size, and digits in different columns and I have to decode each datatype with a case statement.…
Radioleao
  • 394
  • 1
  • 4
  • 19
0
votes
2 answers

Finding table and column information from all_tab_cols

I am trying to identify table types based on the columns they contain in a stored procedure. The query I initially came up with is as follows: SELECT CASE WHEN col_one. IS NOT NULL THEN 'COL1' WHEN col_two IS NOT NULL THEN…
Domtar
  • 91
  • 1
  • 1
  • 2
0
votes
4 answers

Where are seed_value and increment_value for IDENTITY columns?

I'm collecting metadata using the sys.* views, and according to the documentation, the sys.identity_columns view will return the seed and increment values like so. CREATE TABLE ident_test ( test_id int IDENTITY(1000,10), other int ) SELECT…
harpo
  • 41,820
  • 13
  • 96
  • 131
1
2
3