Sys.objects

Sep 21, 2007



Anyone know how to grant a user (who is not a sa) to see all data in sys.objects view?

Thanks.

View 1 Replies


ADVERTISEMENT

Putting Names Of Objects To Control-flow Loop Creating Objects

Dec 27, 2006

please help newbieI need to create a lot of objects the same type (let's say: schemas)I wish to use paramerized block in loop to do so.- how to put names of my objects to such control-flow?belss you for help

View 5 Replies View Related

SQL Server 2012 :: Select Data From XML - Objects Within Objects?

Nov 20, 2013

passing serialised objects to a stored procedure for the purpose of data inserts. I see this as being a way to handle multiple row inserts efficiently.

However, in my limited use of XML data I am not so sure how to link the data when I have a dependency on another "object" within the serialised XML.

Below is a code snippet showing what I have so far.

The first insert statement works fine - but how to retrieve the identifier created by the DB - I want to use an SQL statement that finds the record in the table based on the XML representation (of the PluginInfo), allowing me to insert the ConfigurationInfo with the correct reference to the PluginInfo

DECLARE @Config NVARCHAR(MAX)
DECLARE @Handle AS INT
DECLARE @TransactionCount AS INT
SELECT @Config = '
<ConfigurationDirectory >
<ConfigurationInfo groupKey="Notifications" sectionKey="App.Customization.PluginInfo"

[code]....

View 1 Replies View Related

OLE Objects

Aug 27, 2001

Hi, there,

I use VB to make an dll file and register on my local PC, then use sp_OACreate to create OLE object on local SQL server, it works fine. But when I register that dll on other SQL server, it dosen't work, anybody have idea about this? Thank you.

Tony

View 1 Replies View Related

How To Use Objects??

Jul 17, 2000

I see these type of objects in Books on Online. I was just wondering
if anyone knows how to use these objects, seems to have lot of good
information. Could these objects be called in VB?

--------------------------------
CreateDate Property (SQL-DMO)
The CreateDate property indicates the date and time the referenced SQLServer object was created.

Applies To
Database Object Table Object
DBObject Object TransactionLog Object
Default Object Trigger Object
Rule Object View Object
StoredProcedure Object


Syntax
object.CreateDate

Part Description
object Expression that evaluates to an object in the Applies To list


Remarks
The string returned is formatted by using the locale setting of the workstation.

Data Type
String

Modifiable
Read-only

Prototype (C/C++)
HRESULT GetCreateDate(SQLDMO_LPBSTR pRetVal);
--------------------------------------------------------

View 1 Replies View Related

Sys.objects

Sep 21, 2007



Anyone know how to grant a user to see all data in sys.objects view?

Thanks.

View 1 Replies View Related

COM Objects Under 64-bit?

Jan 25, 2007

Hi everyone,
 
Primary platform is Framework 2.0 under 32-bit
Production platform will be Framework 2.0 under 64-bit.
 
I'm concerned about what object should I use in order to launch DTS 2000/7.0 from our .Net service.
 
Currently it tested fine from a 32-bit environment (sql server 2005 as backend).
 
Reference: "Microsoft DTSPackage Object Library"
Physical file:  dtspkg.dll
 
My wonder,  is there any limitation when it's gonna to work on 64-bit?
 
Generally speaking, any limitation/issue/drawback for COM objects under 64 bit??
In my project properties appears Any CPU, x86, x64. I've got now Any CPU.
 
Thanks for your advices,
 
 

View 13 Replies View Related

Closing ADO Objects

Apr 4, 2007

I know it's "best practice" to dispose ado.net objects, but does it make a big difference if just the connection is closed? In other words, is the code below good enough or should the DataAdapter & Command be explicitly closed?using (SqlConneciton  cn = new SqlConnection(connstr)){ SqlDataAdapter da = new SqlDataAdapter(sql,cn);DataSet ds = new DataSet();da.Fill(ds); SqlCommand cmd = new SqlCommand(someOtherSql,cn);cmd.ExecuteNonQuery();  } 

View 2 Replies View Related

Objects In SQL Server

Jun 16, 2008

Hi,
I am a Database called "Cache"  user and in it and when creating a new table I can create a column of type Object.
So basically, I can create an object eg. Address that have the following items StreetNo, StreetName, PCode somewhere in my database; then create a table called eg. Employees that have a column called EmployeeAddress of type Address (as my Address Object). Can this be done in SQL Server!?
 
 
Thanks. 

View 4 Replies View Related

Managed Objects

Mar 21, 2006

Hello people :-)I'm doing some development work with Visual Studio 2005 and SQLServer 2000. My SQL DB is running on a Windows 2000 Server box in the office, and I'm doing the development on my XPPro workstation. Now I've been trying to connect to the Win2000 box though VS and although I can see the server and the DB when I hit ok I get this error"The SQL server specified by these connection propertise does not support managed objects"What the heck does that mean?any help would be great :-)

View 1 Replies View Related

Protecting Objects From Even The SA

Feb 22, 2001

I am currently writing a VB app based around a SQLserver2000 database. I have used stored procedures wherever possible to select/update/delete data. I am planning to distribute this app and wonder whether there are any tricks out there for encrypting/setting security so that even the SA account would be unable to read my stored procedures, but obviously be able to execute them?

There are two scenarios - one is where I want to let someone borrow a laptop just for a few days for a demo. Presumably I just give them an unprivileged user account without interactive logon possibilities, by which I mean Enterprise Manager and the other SQLserver Client tools [can I do this?] and control all access from the app.

The other scenario is when the app is purchased and I no longer have control of the SQL Server nor the SA account.

Any pointers would certainly be very useful indeed. Thanks.

View 1 Replies View Related

Export Objects

Jan 2, 2002

Hi all, I know we can use DTS package to export or import objects from one db to another. Now I need to write a procedure that will perform similar functionality. Any thoughts on this? Thank you!

View 2 Replies View Related

Transfer/Objects

Jul 26, 2000

Hi,
I am in the process of upgrading database in sql server 6.5 to 7.0.
For that i am following one computer upgrade.
For creating dev environment in my computer i am using Transfer/Objects in 6.5
for transferring database from remote(production) computer to my computer.

Do i need only to transfer Userdatabase alone or do i need to Transfer Master and other ?
Or Is it better to restore dump ?


Thanks

View 4 Replies View Related

Hiding Particular Objects

Aug 1, 2000

Hey guys,
Is there any way to hide a particular object(table,sp,tr etc) from
a particular user?

we are developing softwares for the clients..and Once we install our product we dont want the clients site guys to go and delibrately view the data from sql server but through the front end. Is there anyway that i can do that...?

For Eg..the front end codes are capsulated as DLLs so that no can view the code.. Like that for SQL Server..can we do that kinda stuffs to prevent them?

View 5 Replies View Related

Script Objects

Aug 14, 2000

Is there a way to schedule the creation of script to create database objects?
I am using DTS to transfer data between two 6.5 servers, but I need a way to
sync the stored procs. I thought I could schedule the creation of a script to create all the
procs and then run it every day.
Thanks

View 1 Replies View Related

Script Objects

Aug 14, 2000

Is there a way to schedule the creation of script to create database objects?
I am using DTS to transfer data between two 6.5 servers, but I need a way to
sync the stored procs. I thought I could schedule the creation of a script to create all the
procs and then run it every day before everyone needs the systems.
Thanks

View 1 Replies View Related

Open Objects Value

Jul 31, 2000

SQL server 6.5 stopped responding. The last error messages in the SQL Server Error Log / NT Event log suggested that I increase the Open Objects / Open Databases values. I rebooted the server, increase the configuration values, and rebooted the server again for the new configuration to take affect. I suspect that the front-end application does not release the objects properly when it should; therefore increasing Open Objects / Databases configuration values will only be a temporary fix until they reach the new maximum in some time. However to prove that I need to be able to determine how many open objects / databases are on the server at a point of time. Is there a procedure or a method to determine how many open objects / dtabases are on server?

Any comments or suggestions are greatly appreciated.

Thank you
Marina Somers

View 1 Replies View Related

CHanged Objects

Dec 7, 1999

Is there a way to produce a query to look at when and who changed database objects last?

View 1 Replies View Related

Copying Objects

Mar 5, 2003

Is it possible to copy tables/indexes/data from one db to another (on the same server) while specifying a new owner & w/o logging?

View 11 Replies View Related

Transfer Of Objects

Aug 3, 1998

This should be simple. I am transfering one database from box A to the same database structure on box B. Straight transfer with the transfer utility. All objects, all defaults. The problem is that now, not all the objects are transfering. There are about 20 tables that are not being populated. The table gets dropped and recreated, but not populated. There is plenty of disk space and the log is empty. (or so reported) Why are not all the tables going over. I can manually repopulate the tables and no problems. ANY hints are greatly appreciated.

Thanks,
Peter Cwik

View 3 Replies View Related

No SQL Objects In Perfmon

Mar 17, 1999

I am not showing any sql objects when trying to monitor my sql server through perfmon. This is the situation when running NT perfmon or SQL perfmon locally on the server or from a workstation through the network. I have found some tech net articles but they all say that the ojects should exist locally on the server. Any ideas?

Thanks David

View 1 Replies View Related

No SQL Objects In Perfom

Mar 12, 1999

I have a strange situation occuring. Our SQL server (BDC on resource domain) loses rpc connectivity after 90 minutes. After that time we cannot log on to the server. Get "System Cannot Log You on C0000017 error. Technet says this is due to a memory leak. THe only thing running on this server is SQL. Recently I changed security from mixed to standard and back to mixed as a test, bumped user connections from 500 to 1000 and moved two new databases to this server. THe strange thing is that after rebooting and ablitly to log on I see the sqlservr.exe process take up 64 mbs of data. But there does not seem to be any other memory indications.
Any ideas?

View 1 Replies View Related

Copy Db And All Its Objects

Sep 3, 2001

how can i copy a data base created in sql server2000 to another server (sqlserver2000)without replication because they're distant and not connected i have tried the DTS but it does'nt copy stored proc ,views,triggers,diagram,...
help please

View 1 Replies View Related

Sizing Db Objects

Dec 28, 2004

Hello, I'm looking for a sizing Excel (or any other format) file, that permits me evaluate the size of my sql server database, actually I have one excel file for Oracle, where I only put the expected # of rows, the average size of the columns, and other few data, and I can get the size (in Megabytes) of a table or an Index.

Could you provide me something similar??

Thanks !

View 1 Replies View Related

How To Transfer All Objects

Mar 30, 2015

I have an upgrade to do from Sql-Server 2005 to Sql Server 2014. how I would do the upgrade! Should I install 2014 on another box or the same box (or do I just upgrade over the 2005 version - which seems risky)? How do I transfer all of the objects from 2005 to 2014? I'm referring to the tables/ sprocs/ views/ etc already on 2005?

View 9 Replies View Related

Looping Through Sys Objects

May 12, 2008

I want to apply the same query for 250 tables (see below).
It would be very painful to code 250 individual queries.
Is there a way to loop through all 250 tables using "sysobjects WHERE type = 'U'", and applying the below code for each table (users table would remain constant)?


select co.*
from company table_type
where not exists(select * from users u
where (u.users_id = type.rn_create_user) or (u.users_id = type.rn_edit_user)
)

View 11 Replies View Related

I Don't Want To See Systems Objects

Jun 14, 2006

I don't wich choice should I made to avoid have to see the systems objects, for intance, when I open the tables of any Data Base I have like 50 that I havenĀ“t create, so if any one can help me, I will be gratefull, it might sound like BOBO, but I jist don't know. Thanks


informatics

View 2 Replies View Related

Where Are System Objects

Aug 28, 2007

Hi,

I m new for sql 2005.I intalled it successfully.But i m not able to see system objects in table folder in master database.I have installed competibility package too.
any other idea.

thnx in advance

View 1 Replies View Related

Compare SQL Objects

Jul 23, 2005

Is there a stored procedure to allow me to compare twoSQL objects? In my case for example I want to comparetwo stored procedures on two different databases?If there is no SP that does comparison, would there beany code in SQL DMO that does this?How does someone learn SQL DMO? Does SQL Server2000 have by default DMO learning material or I have tosearch for books?Thank you

View 3 Replies View Related

Store Db Objects In *.ndf Vs. *.mdf??

Sep 25, 2006

I am new to SS2005, and I've just started working on a small test/devdatabase.I recently read that one should store things like tables, views,constraints, etc. in the *.ndf file rather than in the *.mdf file.Does this make it any easier to transfer/copy files or databases orother items from test/dev to production??If I have a database already with items in the *.mdf file, how do Itransfer things like tables, constraints, views, etc. to an *.ndf filein another database??I also read that one can make it the default in SS2005 to store thingsin the *.ndf file, how is this done??Thank you,Tom

View 5 Replies View Related

Script Out Objects

Jul 20, 2005

Is there any command to script out tables/stored procedures?I want to make a process to script out tables every night.thanks,

View 3 Replies View Related

Selective Objects

Oct 20, 2007

I'm in the current mode of migration from WIn2k and I 'm trying to setup user where they are only allowed access to one table.

If I grant thenm read /write access to the db they can obviously see all of the db due to the size of the db I do not wish to go down the root of denying every table as there is over 100. Is there an easier way??

View 4 Replies View Related

Obsolete Objects

Apr 23, 2008



Hello,

I need to find all of the SQL Server objects, (tables, procs, functions, etc.) that my application is NOT using, so they can be removed from the system. Does anyone know how to accomplish this?

Thank you,

Dave

View 2 Replies View Related







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