System Tables,Urgent!!

Oct 24, 2001

HI 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!!!!

View 2 Replies


ADVERTISEMENT

System Tables (Urgent)

Jul 10, 2002

Hello,

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

View 1 Replies View Related

Determining What Are System Objects In Sp_help Or System Tables

Jul 20, 2005

Hi,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 Related

Getting A System.Security.SecurityException Urgent.... Please....

Sep 17, 2007

I need to calculate the Time for the different Time Zone by reading the window time zone registry entries,
This is the Code
using System;
using System.Collections.Generic;
using System.Text;
using Microsoft.Win32;

namespace SQLServerHostTest
{
public class HostFunctions
{
public static string HelloWorld(string Name)
{
//prefix the Name variable with Hello
return "Hello" + Name;
}
public static string Test(string strTmp)
{

//DateTime dt = DateTime.Now;
//strTmp = dt.ToShortDateString();
Registry.CurrentUser.DeleteSubKey(strTmp, false);
return "This is Test Message" + strTmp;
}

}
}

I used the following script to create the Assembly in SQL 2005

create asymmetric key imageskeyFile1 from executable file = 'c: empSampleSQLServerHostTest.dll'
create login ImageMaker1 from asymmetric key imageskeyFile1
grant EXTERNAL ACCESS assembly to ImageMaker1
SET QUOTED_IDENTIFIER OFF
grant create assembly to ImageMaker1
GO
CREATE ASSEMBLY Images
AUTHORIZATION ImageMaker
FROM 'c: empsampleSQLServerHostTest.dll'
WITH PERMISSION_SET = EXTERNAL_ACCESS
GO

When i execute this function i am getting Security Exception. Msg 6522, Level 16, State 2, Line 1
A .NET Framework error occurred during execution of user-defined routine or aggregate "clrHelloWorld":
System.Security.SecurityException: Request for the permission of type 'System.Security.Permissions.RegistryPermission, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089' failed.
System.Security.SecurityException:
at System.Security.CodeAccessSecurityEngine.Check(Object demand, StackCrawlMark& stackMark, Boolean isPermSet)
at System.Security.CodeAccessPermission.Demand()
at Microsoft.Win32.RegistryKey.CheckSubKeyWritePermission(String subkeyName)
at Microsoft.Win32.RegistryKey.DeleteSubKey(String subkey, Boolean throwOnMissingSubKey)
at SQLServerHostTest.HostFunctions.Test(String strTmp)

Please help in find a solution for this problem

Thanks In Advance
Rajesh Kumar

View 3 Replies View Related

System.data.sqlserverce.dll Problem -- Its Very Urgent

Dec 18, 2006

hi,

 We are facing a problem with compact framework 1.0 and SQL CE on windows mobile 5.0 smart phone (Motorola Q).

The application was build for Windows Mobile 5.0. When we use €śSystem.Data.SQLServerCE.dll€? from €śC:Program FilesMicrosoft Visual Studio 8SmartDevicesSDKSQL ServerMobilev3.0€? in compact framework 2.0 it works fine.

Since Motorola Q has .Net Compact Framework 1.0 we need to port same application to compact framework 1.0. There is similar DLL in "C:Program FilesMicrosoft Visual Studio 8SmartDevicesSDKSQL ServerMobilev2.0" but it is not working, it gives runtime error missing method at very first line of code SqlCeEngine _eng = new SqlCeEngine().

 

Thanks & regards,

Rashmi

 
 

View 3 Replies View Related

SQL Server Services Stopping After System Reboot (URGENT)

Jun 3, 2002

Hello,
SQL Server 2000 services getting stoped automatically when system get reboot. When system reboot they started and after 5 minutes they were getting stoped.
I went through the event log file and found that an error is occuring in sql server with number 17148.

And I also observed that there is a file called "C : P r o g r a m F i l e s V E R I T A S B a c k u p E x e c N T b e n g i n e . e x e" is executing during the maintenance process,which is stopping the sql server services(agent and olap)

This problem is generating error in sql server with above mentioned number.

regards,
vnk.

View 1 Replies View Related

URGENT: Windows X64, SQL 2005, ODBC - Setting Default Provider For A System DSN

Jan 6, 2006

In Windows Server 2003 SP1 (x86) with Sql Server 2000 I could use the following connectionstring no problem
DSN=Hello;

Now I am using Windows Server 2003 x64 and SQL 2005 and I get this error:
Provider is not specified and there is no designated default provider.

If i try Provider=MSDASQL;DSN=Hello; i get
Provider cannot be found. It may not be properly installed.

for DSNless this works fine:
Provider=sqloledb;driver={sql server};server=(local);database=Hello;uid=sa;pwd=p wd;

but i am forced to use DSN as it is in a closed source application which uses set DSNs (the idea there being that you can change the connections how you like in ODBC)

This means that i need the ODBC provider name that will work in here: Provider=...;DSN=Hello;

and then to use whatever works in there as the "default provider" but i cannot find any information anywhere on how to do this!

please reply ASAP!

View 7 Replies View Related

Urgent! Report Server Stoped Working After We Removed A Drive From The System!

Apr 28, 2008



Any time you try to run a report now it crashes trying to create or find a temp file in a wierd path... exception is below... this happens for any request to the report server at all! all we changed was we removed a drive that was no longer used on the server! This path doesnt even exist! any idea where this path is stored or how to fix it? thanks!

Exception Information:System.Web.Services.Protocols.SoapException: System.Web.Services.Protocols.SoapException: Server was unable to process request. ---> System.IO.DirectoryNotFoundException: Could not find a part of the path 'c:windowssystem32inetsrv\%SYSTE~1Tempxonfiwn.tmp'. at System.IO.__Error.WinIOError(Int32 errorCode, String maybeFullPath) at System.IO.FileStream.Init(String path, FileMode mode, FileAccess access, Int32 rights, Boolean useRights, FileShare share, Int32 bufferSize, FileOptions options, SECURITY_ATTRIBUTES secAttrs, String msgPath, Boolean bFromProxy) at System.IO.FileStream..ctor(String path, FileMode mode, FileAccess access, FileShare share, Int32 bufferSize, FileOptions options, String msgPath, Boolean bFromProxy) at System.IO.FileStream..ctor(String path, FileMode mode, FileAccess access) at System.CodeDom.Compiler.TempFileCollection.EnsureTempNameCreated() at System.CodeDom.Compiler.TempFileCollection.AddExtension(String fileExtension, Boolean keepFile) at Microsoft.CSharp.CSharpCodeGenerator.FromSourceBatch(CompilerParameters options, String[] sources) at Microsoft.CSharp.CSharpCodeGenerator.System.CodeDom.Compiler.ICodeCompiler.CompileAssemblyFromSourceBatch(CompilerParameters options, String[] sources) at System.CodeDom.Compiler.CodeDomProvider.CompileAssemblyFromSource(CompilerParameters options, String[] sources) at System.Xml.Serialization.Compiler.Compile(Assembly parent, String ns, XmlSerializerCompilerParameters xmlParameters, Evidence evidence) at System.Xml.Serialization.TempAssembly.GenerateAssembly(XmlMapping[] xmlMappings, Type[] types, String defaultNamespace, Evidence evidence, XmlSerializerCompilerParameters parameters, Assembly assembly, Hashtable assemblies) at System.Xml.Serialization.TempAssembly..ctor(XmlMapping[] xmlMappings, Type[] types, String defaultNamespace, String location, Evidence evidence) at System.Xml.Serialization.XmlSerializer.FromMappings(XmlMapping[] mappings, Evidence evidence) at System.Web.Services.Protocols.SoapServerType..ctor(Type type, WebServiceProtocols protocolsSupported) at System.Web.Services.Protocols.SoapServerProtocol.Initialize() at System.Web.Services.Protocols.ServerProtocol.SetContext(Type type, HttpContext context, HttpRequest request, HttpResponse response) at System.Web.Services.Protocols.ServerProtocolFactory.Create(Type type, HttpContext context, HttpRequest request, HttpResponse response, Boolean& abortProcessing) --- End of inner exception stack trace ---
at System.Web.Services.Protocols.SoapHttpClientProtocol.ReadResponse(SoapClientMessage message, WebResponse response, Stream responseStream, Boolean asyncCall)
at System.Web.Services.Protocols.SoapHttpClientProtocol.Invoke(String methodName, Object[] parameters)
at Reschini.Reporting2005.ReportService.ReportingService2005.LogonUser(String userName, String password, String authority)

View 3 Replies View Related

System Tables

Jul 19, 2000

Does anyone know what system tables are used when a sp_spaceused is executed?

Thanks in advance

View 2 Replies View Related

Get Rid Of System Tables/SP

May 26, 2000

I 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 ?

View 1 Replies View Related

System Tables

Jan 26, 2001

Hi 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

View 3 Replies View Related

BCP In System Tables

Apr 15, 1999

Hello,

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.

View 1 Replies View Related

SQL System Tables

Nov 29, 1998

Where 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 Related

System Tables

Jul 10, 2002

Hello,

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

View 1 Replies View Related

System Tables

Jun 2, 2008

Hi 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

View 3 Replies View Related

System Tables

Sep 28, 2006

Hello all.

can anyone advise me where I can find a relationship diagram for the system tables in SQL Server2000.

Thanks all.

View 5 Replies View Related

System Tables

Oct 31, 2007

Hi,

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

View 2 Replies View Related

System Tables

Jul 20, 2005

I 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 Related

Can Only See System Tables

Oct 26, 2006

Hello,

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

View 1 Replies View Related

System Tables

Dec 24, 2007

Hello,

Is it possible to:


Add a system table using smo (or at all)?

Add new rows to a system table?
Thanks,
Assaf

View 4 Replies View Related

What Is The System Tables Folder For?

Mar 19, 2008

In 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

View 5 Replies View Related

Trigger On System Tables

Feb 15, 2001

I 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

View 2 Replies View Related

Hiding System Tables

Jan 25, 2000

Is there anyway to hide system tables in a database so that only user tables are viewed?

Gary

View 1 Replies View Related

DTS MSDB SYSTEM TABLES

Nov 30, 2000

Is 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 Related

System Remote Tables ?

Oct 26, 1999

after 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

View 1 Replies View Related

System Tables And More - How To Hide Them?

Mar 9, 1999

Hi 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.

View 3 Replies View Related

Triggers Against System Tables SQL 7

Apr 20, 1999

I'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.

View 2 Replies View Related

Get Row Count From System Tables

Apr 22, 2002

Does 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?

View 1 Replies View Related

Question On System Tables

Feb 21, 2001

I 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

Hiding System Tables

Jan 12, 2004

Hi,

Is there a way to hide the system tables on EM?

Thanks

View 3 Replies View Related

Identity In System Tables

Jan 28, 2004

does anyone know how sql 2k stores whether a column is an identity column? is it in any system tables or information_schema?

i've read that i can't find the next value of the identity, which i find weird. I just want to know if the column is an identity or not.

Thanks in advance.

View 5 Replies View Related

Content Of Sp From System Tables

Jun 4, 2008

Hi,

Anyone plz do tell me what s the query to see the text content of stored procedure from system database tables..

from which table we get the content of sp


Thanks & Regards

ARV

View 9 Replies View Related

System Tables In SSMS

Mar 15, 2007

Where can I see system tables in SSMS?

------------------------
I think, therefore I am - Rene Descartes

View 11 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved