Can We Modify System Tables?
Sep 28, 2007
Hi all,
I am new to SQL Server databases.Here i have a question that can we modify system tables in SQL Server 2000?
Any help would be helpful to me.....:-)
Thanks,
Narsi
ADVERTISEMENT
Modify System Stored Procedures
Oct 31, 2002I am trying to edit a system stored(sp_add_dtspackage) procedure and cannot for the life of me find where to edit. This procedure does a check to keep users from saving changes to a package they do not own. I need users to be able to change the the packages when they are not always the one who created.
View 2 Replies View RelatedCreate/modify File With A System Stored Procedire
Nov 22, 2005Does anybody know how to create/modify a file without using one of the system stored procedures?
Thanks
Determining What Are System Objects In Sp_help Or System Tables
Jul 20, 2005Hi,I have a few things on my databases which seem to be neither true systemobjects or user objects - notably a table called 'dtproperties' (createdby Enterprise manager as I understand, relating to relationship graphingor something) and some stored procs begining with "dt_" (some kind ofsource control stuff, possible visual studio related). These show up whenI use"exec sp_help 'databaseName'"but not in Ent. Mgr. or in Query Analyzer's object browser, and also notin a third party tool I use called AdeptSQL. I am wondering how thosetools know to differentiate between these types of quasi-system objects,and my real user data. (This is for the purpose of a customized schemagenerator I am writing). I'd prefer to determine this info with systemstored procs (ie sp_help, sp_helptex, sp_...etc) but will dip into thesystem tables if needed.Thanks,Dave
View 1 Replies View RelatedUnable To Modify Or Create New Tables...
May 22, 2006Getting this message on my event log:
.NET Runtime Optimization Service (clr_optimization_v2.0.50727_32) - Failed to compile: Microsoft.ReportingServices.QueryDesigners, Version=9.0.242.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91 . Error code = 0x80070002
User That Can Alter And Modify Tables
Feb 7, 2008What do I have to do in order to create a user that can alter and modify some/all tables?
Thank you.
How To Change The Database Context And Modify Tables?
Oct 4, 2007I have 30+ databases in sql 2000.
I want to dynalically loop though each of the databases and alter a column named 'EmpName' for all the 'Employees' tables in that database.
Here is my attempt.use Master
go
declare @SQLString Nvarchar(1000)
declare @DBName Nvarchar(100)
declare @SQL2 NVARCHAR(1000)declare @TABLE_NAME NVarchar(100)
DECLARE curDB CURSOR LOCAL FORWARD_ONLY STATIC FOR
SELECT name FROM sysdatabases
OPEN curDB
FETCH NEXT FROM curDB INTO @dbname
While @@FETCH_STATUS=0
Begin
SET @SQL2 = 'USE ' + @DBNAME + ' ALTER TABLE ' + @TABLE_NAME + ' MODIFY EmpName varchar(100)'
from information_schema.tables where table_type = 'BASE TABLE' and table_name like '%Employees%' PRINT @SQL2
EXECUTE SP_EXECUTESQL @SQL2
fetch next from curDB into @DBName
end
Close curDB
End
When i execute the above script in master, it says 'Query executed successfully' but when i see the all the Employees table in each of the database, the required change is not made.
Can anybody explain this or give an alternate solution?
Joining Two Tables To Modify A Tree Structure With More Information
Jul 30, 2007I’m trying to create a modified catalog tree out from two tables in sql
The catalog is created from two tables.
Table 1 has the lowest level and is showing the connection with the item and the lowest ItemGroup. It also shows the connection with the MainCatalog
MainCatalogId, ItemGroupId, ItemId
Example data:
(sorry for the tabs that won't work)
MainCatalogIdItemGroupIdItemId
715063823
715073824
715093825
715093826
The catalog structure is in table 2. Here are the connections between the different
ItemGroupId, ParentId
Example data:
ItemGroupIdParentId
15061365
15071365
15091364
13641066
13651066
1066NULL
To be able to use create the tree structure and not getting the result set to big, I need it to look something like this:
ItemGroupIdItemIdLevel 2 level 3Level4
1506 3823136510667
1507 3824136510667
1509 3825136410667
1509 3826136410667
I have tried many ways, but I’m not getting the result I want.
Hope this was understandable, and that someone has an idea if this is manageable
Thanks :)
Error In Microsoft Sql Server Management Studio Trying To Modify Tables Or Columns
May 21, 2008I get the error below when trying to modify a table or colum with MSSMS. I can expad out the tree and look at the columns, but I can't change them, view the data in them, or create new ones.
__________________________________________________________________________________________________________________________________
TITLE: Microsoft SQL Server Management Studio
------------------------------
Class does not support aggregation (or class object is remote) (Exception from HRESULT: 0x80040110 (CLASS_E_NOAGGREGATION)) (Microsoft.SqlServer.SqlTools.VSIntegration)
I resintallelled .NET Framework, recommended from another post. I am using .NET 3.5 BETA Frame work, ans SQL Server 2005 V 9.00.139.00
How To Set User Who Can't Modify Any StoredProc And Data In Tables But Can Read Data In Tables And Any StoredProc ?
Jul 13, 2007Please give me advise ครับ
System Tables
Jul 19, 2000Does anyone know what system tables are used when a sp_spaceused is executed?
Thanks in advance
Get Rid Of System Tables/SP
May 26, 2000I want to get rid of systemtables or systemstored procedures which displays when ever i creat new database.
How can I get rid of system tables ?
System Tables
Jan 26, 2001Hi All
I want to know where I can find Object permission detailes, For example
I have table1 and user "abc", I have given permission to user "abc" for table1 to "SELECT" "INSERT", "UPDATE", I want to know where this detail is stored in system table. I was looking at "SYSUSERS","SYSLOGINS",
"SYSPERMISSIONS", "SYSMEMBERS", "SYSOBJECTS" I couldn't find anything, If some one can post your answers that will be great.
Thanks in Advance
Regards
Ram
BCP In System Tables
Apr 15, 1999Hello,
I have succesffuly BCP out system tables(sysdatabases, sysdevices, syslogins, and sysusages). Now I want to BCP those same tables IN to create devices, databases and so on using the BCP utility. I run the same command used to BCP out and only changes the OUT to IN but it did not work.
Can somebody whose done this before tell me how to do it.
Many Many thanks,
Ana.
SQL System Tables
Nov 29, 1998Where can I find a discussion of how to interpret the keys1 and keys2 columns of the sysindexes table? These columns are binary(255) and are supposed to contain a description of the columns to which the index applies. I also need to know how to interpret the status column of the sysconstraints column.
View 1 Replies View RelatedSystem Tables
Jul 10, 2002Hello,
I've one Sybase DBA asking this question, Is this really true, Pls help me.
Due to architectural changes in SQL Server 7.0, you cannot dump the transaction log if a database's system tables are inaccessible (due to media failure, for instance)in 7.0 and later versions. Microsoft recommends that separate devices be used for system tables and user tables to allow a final log backup to take place in the event the data device is inaccessible. The additional exposure incurred by not doing this is possible loss of data for the interval between the last transaction dump and the point of failure.
Thanks
Qinglee
System Tables
Jun 2, 2008Hi Gurus,
select * from sys.server_principals is not working for me on 2000 SERVER.
This works fine on 2005 SERVER..
Where Iam going wrong ..please advice..
Thanks,
ServerTeam
System Tables
Sep 28, 2006Hello all.
can anyone advise me where I can find a relationship diagram for the system tables in SQL Server2000.
Thanks all.
System Tables
Oct 31, 2007Hi,
I'm doing an impact analysis to see what views / stored procedures etc are impacted by a change to columns in a table.
I'm using the system tables to identify these changes, and it is something that I'll have to repeat across all our databases in case the tables are being accessed from elsewhere.
I'd like to make sure I'm doing it the right way so could someone point me in the direction of a good article or code for doing this.
thanks
Sean
System Tables
Jul 20, 2005I dont want to see these at all and cannot find where tospecify a view or modification of a view. can someone throw me abone here and tell me where to make the adjustments if I can make themat allMichael
View 2 Replies View RelatedCan Only See System Tables
Oct 26, 2006Hello,
I have created a linked server XYZ that is linked to server ABC. I am tying to view the tables via XYZ but I'm unable to do so. I can only see the system tables. When I run a select statement, I get the correct results. That means I have the access to the tables, yet why am I not able to see the tables.
Please assist
System Tables
Dec 24, 2007Hello,
Is it possible to:
Add a system table using smo (or at all)?
Add new rows to a system table?
Thanks,
Assaf
What Is The System Tables Folder For?
Mar 19, 2008In SQL mngt studio...what is the system tables folder in the tables folder supposed to be used for? Do I need to use it for anything?
Gater
System Tables (Urgent)
Jul 10, 2002Hello,
I've one Sybase DBA asking this question, Is this really true, Pls help me.
Due to architectural changes in SQL Server 7.0, you cannot dump the transaction log if a database's system tables are inaccessible (due to media failure, for instance)in 7.0 and later versions. Microsoft recommends that separate devices be used for system tables and user tables to allow a final log backup to take place in the event the data device is inaccessible. The additional exposure incurred by not doing this is possible loss of data for the interval between the last transaction dump and the point of failure.
Thanks
Qinglee
System Tables,Urgent!!
Oct 24, 2001HI all,
I need to understand a little bit more about SQL Server built in tables. For example in Oracle if I need to check for tables names under one database. The query will be something like this:
Select table_name from user_tables;
Or to get column_name and table_names:
Select column_name, table_name from user_tab_columns;
How can I do this in sql server 7?
I know there is a table called sysobjects. The sysobject will give me all the objects in the database but how can I specify wether its a table or a column. More over can someone refer me a good book for sql server 7. Both development and administration.
Thank you in advance!!!!
Trigger On System Tables
Feb 15, 2001I need to keep track of changes (delete/modify) in sysusers table. SQL Books Online mentionend that SQL Server 7.0 doesn't support trigger on system tables. What options do I have?
LT
Hiding System Tables
Jan 25, 2000Is there anyway to hide system tables in a database so that only user tables are viewed?
Gary
DTS MSDB SYSTEM TABLES
Nov 30, 2000Is there any way to get the DTS Wizard to see the system tables (sysjobs, sysjobschedules, etc..) in the MSDB or Master database?
View 2 Replies View RelatedSystem Remote Tables ?
Oct 26, 1999after upgrade sql from 6.5 to 7.0 , there are some new system
table in system database , all are begin with sysremote_....
such as sysremote_tables, i can not find any information about
them , does anyone know what these tables for and whether
these tables will affect the new sql7.0 application database ?
thanks in advance .
regards
zg
System Tables And More - How To Hide Them?
Mar 9, 1999Hi everyone,
I've recently installed MSQL Server 7.0 Standart Version and every time I create a new database, system tables are created and are visible also. That means, I instantely get 18 tables, 20 views, 18 stored procedures and so on. Can I hide them??? I mean, my tables are all mixed with the system tables. If I can hide all the system tables and views and so on please tell me! Thanks.
Triggers Against System Tables SQL 7
Apr 20, 1999I'm thinking of building a trigger against a system table(sysobjects) in
database(a) on server(a) that will assist me in updating a table in
database(b)on server(b). What I need to know from table(b)is if a new table
has been added and removed from database(a) on server(a). I want to use a
store procedure to query the table(b). I was thinking of building a trigger
against my sysobjects table that would update table(b) whenever any tables
are added or removed from database(a). Has anyone built triggers against
system tables? I am running SQL 7.
Get Row Count From System Tables
Apr 22, 2002Does anyone know how to get the row count of a user table by using the system tables.
There is no guarantee that these user tables will have any indexes - so I can not use the sysindexes table to count the rows in a clustered index.
Is there another way?
Question On System Tables
Feb 21, 2001I can't see the system tables when I try to pull them up in a linked table view from ACCESS or in a VIEW in SQL Server. I can't adjust my permissions to make them appear in any way that I have tried. Do you know how to do this?
View 1 Replies View Related