The database I'm currently working with is very old and some of the
tables, SP, and views are not being used. I'm looking for a way to
identify what items are no longer in uses, or what items are
currently in use. 4 1437 Ba****@Hotmail. com (Mike Barlow) wrote in message news:<83******* *************** ***@posting.goo gle.com>... The database I'm currently working with is very old and some of the tables, SP, and views are not being used. I'm looking for a way to identify what items are no longer in uses, or what items are currently in use.
SELECT OBJECT_NAME(ID) FROM SYSCOMMENTS
WHERE TEXT LIKE '%TABLENAME%'
SELECT OBJECT_NAME(ID) FROM SYSCOMMENTS
WHERE TEXT LIKE '%SPNAME%'
the easiest one is:) sp_depends Object_Name :)
Mike,
Take a look at Largo SQL Tools ( www.largosqltools.com). It tracks
dependencies with far greater accuracy than SQL Server (which you cannot
rely on for depedency management) and it will tell you which database
objects are not referenced. For example: http://www.largosqltools.com/Dependency.asp.
J.R.
Largo SQL Tools
The Finest Collection of SQL Tools Available http://www.largosqltools.com
"Mike Barlow" <Ba****@Hotmail .com> wrote in message
news:83******** *************** **@posting.goog le.com... The database I'm currently working with is very old and some of the tables, SP, and views are not being used. I'm looking for a way to identify what items are no longer in uses, or what items are currently in use.
"Mike Barlow" <Ba****@Hotmail .com> wrote in message
news:83******** *************** **@posting.goog le.com... The database I'm currently working with is very old and some of the tables, SP, and views are not being used. I'm looking for a way to identify what items are no longer in uses, or what items are currently in use.
Take a look at SQL Profiler. You may have to log a LOT of output, but it
may give you some help.
Hi
Amesing : What a question and what a reply !!!
Thanks for that This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics |
by: Jeff Roughgarden |
last post by:
Does anyone know how to identify the hottest, most active tables in a
database?
We have hundreds of users hitting a PeopleSoft database with hundreds
of tables. We are I/O bound on our SAN, and are thinking of putting
the hottest tables on a solid state (RAM) drive for improved
performance. Problem is: which are the hottest tables? Would like to
do this based on hard data instead of developer/vendor guesses.
Any suggestions are much...
|
by: Brad H McCollum |
last post by:
I'm writing an application using VB 6.0 as the front-end GUI, and the
MSDE version of SQL Server as the back-end (it's a program for a
really small # of users --- less then 3-4).
I'm trying to determine, through the Visual Basic interface, the
permissions of each user that's using the application on his/her
machine.
For example, let's say I'm user "Michael" that's sitting down at my
machine using the app. I've written. The security...
|
by: Roy |
last post by:
Hi all,
My task is to identify duplicate records in 2 tables that each located in
different Access database. These tables have exactly the same structure. My
immediate response was to create two datasets from each table and loop
through one and compare it with another one, but I'm sure there are better
way to this.
Any suggestions is appreciated.
Roy
|
by: carriolan |
last post by:
Hi
I have an MS Access based application almost ready for distribution to
the public and I find that even though I have compiled it into an MDE
file, tables and queries can still be be imported if accessed by
another MS Access database. How can I stop this please?
Regards
Carriolan
|
by: bazzer |
last post by:
im trying to access a microsoft access database from an asp.net
webform. but when i use the OdbcDataAdapter config wizard i get the
following errors:
*Generated UPDATE statement
-could not determine which columns uniquely identify the rows for
"Customers"
*Generated DELETE statement
| |
by: blue875 |
last post by:
Ok, I've tried searching, and haven't found the answer, so it must mean
everyone else but me already knows this. I have an Access 2000 form
that I want to connect to an Access 2000 table in the same database.
What I am able to do is create a connection string, explicitly giving
my admin-level userId and password, and it works. But when I try to
create a connection string that doesn't use this explicit definition, I
get permission issues,...
|
by: Jim Devenish |
last post by:
I have a split front end/back end system. However I create a number of
local tables to carry out certain operations. There is a tendency for
the front end to bloat so I have set 'compact on close'
I think that I have read in some threads (althoug I cannot find them
now) that others place such tables in a local, linked database. I
could do this but I am interested to know what would be the advantages.
And disadvantages, if any.
Any...
|
by: NancyJ |
last post by:
Currently we have a database with a main table containing 3 million
records - we want to increase that to 10 million but thats not a
possibility at the moment.
Nearly all 3 million records are deleted and replaced every day - all
through the day - currently we're handling this by having 2 sets of
tables - 1 for inserting, 1 for searching.
A block of records (10k - 1 million) (distinguished by a client
identifier field) happen on the...
|
by: rdemyan via AccessMonster.com |
last post by:
I have a need to add another field to all of my tables (over 150). Not data,
but an actual field.
Can I code this somehow. So the code presumabley would loop through all the
tables, open each table in design mode and then add the new field and set its
properties.
Thanks.
--
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look !
Part I. Meaning of...
|
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth.
The Art of Business Website Design
Your website is...
| |
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own....
Now, this would greatly impact the work of software developers. The idea...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules.
He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms.
Adolph will...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
|
by: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
| |
by: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...
| |