.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
Gaurav Pal
Post New Web Links

Find unused objects in a SQL Server 2000 database

Posted By:      Posted Date: September 27, 2010    Points: 0   Category :Sql Server

Hello All,

I want to know all the objects in a database which are not been used from a long period (Unused in the sense not executed from a long period; example procedures.). Could anyone show be the way of how to get it done.

Thanks in advance.

Pavan Kokkula Infosys Technologies Limited.

View Complete Post

More Related Resource Links

Metadata: Create a Database Schema Repository with Meta Data Services in SQL Server 2000


SQL Server 2000 Meta Data Services is a repository technology that stores and manages metadata for SQL Server. Instead of building database schemas over and over, Meta Data Services allows you to freeze an entire schema for use in other projects. You can also use these schemas for training, testing, or debugging. In this article, the authors will review the various components of Meta Data Services and show how it can be programmed using a Visual Basic client, XML, and XSLT. They will also show you how to manage and manipulate your metadata by generating a simple database schema using a SQL Server repository.

Alok Mehta and Ricardo Rodriguez

MSDN Magazine May 2003

0x80040154 error processing a cube from SQL Server 2008 R2 x64 database engine to OLAP Server 2000 x


I recently upgrade from SQL Server 2000 x32 to SQLServer 2008 R2 x64 but only the database engine not the Analysis Server, I used to use this code to proces the cubes.


but now it do not  work more with the error:
Error at create server:
Error      Source                    Description          HelpFile HelpID
---------- ------------------------- -------------------- -------- -----------
0x80040154 ODSOLE Extended Procedure  Clase no registrada NULL     0

(1 row(s) affected)

I found this article:

It means that I can not process the cube using the same method any more ?

SQL Server 2008 R2 installation error "Could not find the Database Engine startup handle."



I am unable to install SQL Server 2008 R2 Developer Edition (x86) on my Windows 2008 (32 bit) virtual machine. It fails everytime with "Could not find the Database Engine startup handle." error.

Any pointers?

cannot restore sql 2000 database in sql server 2005 in windows 7


cannot restore the databse made in sql server 2000 in sql server 2005 in windows 7 with thw following error message

TITLE: Microsoft SQL Server Management Studio Express

Restore failed for Server 'KHURANA\SQLEXPRESS'.  (Microsoft.SqlServer.Express.Smo)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=9.00.3042.00&EvtSrc=Microsoft.SqlServer.Management.Smo.ExceptionTemplates.FailedOperationExceptionText&EvtID=Restore+Server&LinkId=20476


System.Data.SqlClient.SqlError: The media set has 2 media families but only 1 are provided. All members must be provided. (Microsoft.SqlServer.Express.Smo)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=9.00.3042.00&LinkId=20476



plz help me out

Windows 7 connecting to SQL server 2000 database

Is is possible to connect to a SQL Server 2000 database (running on a windows 2003 server) from a Windows 7 client machine?

Cross database object dependency in SQL Server 2000

Is there a way to figure out cross database object dependency in sql server 2000? (for ex: finding all the objects that a view refers which may reside in the same or different database)

SQL server express 2008 R2 , Could not find the Database Engine startup handle.


when i set the SQL Server database engine to NT AUTHORITY\NETWORK SERVICE the install works correctly but when i set it to NT AUTHORITY\SYSTEM i get a "Could not find the Database Engine startup handle." error , The Database engine services is not installed


The Summary Log File


Overall summary:
  Final result:                  SQL Server installation failed. To continue, investigate the reason for the failure, correct the problem, uninstall SQL Server, and then rerun SQL Server Setup.
  Exit code (Decimal):           -2061893609
  Exit facility code:            1306
  Exit error code:               23
  Exit message:                  SQL Server installation failed. To continue, investigate the reason for the failure, correct the problem, uninstall SQL Server, and then rerun SQL Server Setup.
  Start time:               

Cannot find database after uploading to server



Firstly, here is the software I am using locally (which runs my program perfectly):

  • vista home premium sp2
  • vs2008 sp1
  • sql server 2008 enterprise edition sp1
  • iis 7

The server is using:

  • sql server 2008 enterprise edition rtm
  • iis 6

I encountered a problem days ago that I have so far been unable to fix. The project runs an asp.net web app perfectly locally.  However when I uploaded the solution and the database to the server, it will not connect to the database.  I get the following error:

A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: Shared Memory Provider, error: 40 - Could not open a connection to SQL Server)

Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

SQL Server 2000 Database in "single user mode"


Hi all,

I've an old production database server with SQL Server 2000 SP4, that runs from 6 years. Now sometimes I find that the production database goes in "single user mode". Why? My error logs don't help me.

Does SQL server 2000 database supported on Windows Server 2008?

Does SQL server 2000 database supported on Windows Server 2008 and Windows Server 2008 R2?

How to find Resource Deadlock on the database / server?


How to find Resource Deadlock on the database / server?please help me...



i am using sql server 2008 and my jobs fail due to deadlock so i want to capture the root cause.please help me

SQL SERver 2000 database is in offline\suspect\Emergency mode



I m having sql server 2000 database and 4-5 database is in offline\suspect\Emergency .

I have tried that to take online throgh following step:

EXEC sp_resetstatus 'DBName'

DBCC checkdb('DBname')
DBCC CheckDB ('DBName')





From this command :

but its not coming online and multiuser then i run this command : UPDATE SYSDATABASES SET STATUS=24 WHERE NAME='DBNAME' and it comes online but whenever sql sever services get restarted it again goes into suspect mode.


Please help somebody?


Backing up the Database Objects only in SQL Server 2008 R2 using T-SQL


Hi Team,

I have used DMO and T-SQL  to backup my database objects only in SQL server 2005 working fine. I know DMO script would not work in SQL server 2008 R2. Do you have any equivalent script in SQL server 2008 R2. Can we achieve the same using SMOs in SQL server 2008 R2.

If you want I can post the working 2005 SQL script.

Appreciate your help .

Many thanks







Kalyan Techbubbles.com

Restoring a SQL Server 2000 database having only the .mdf file


Hi all,

SQL Server 2000, I need to restore a database, I've only the .mdf file, note that the database was not gracefully detached, so the sp_attach_single_file_db fails. Is there any other way?

MS SQL Server: Disconnect Users From Database - Kill User Session

If you ever wanted to restore your database from a SQL backup file (.bak), but there are still users connected to your database, the backup operation will fail causing the error: Exclusive access could not be obtained because the database is in use.

Publishing SQL Server Database using Publishing Wizard : Tips & Tricks

We can use SQL Server Publishing Wizard to deploy our local Database to remote hosting server/production server.This feature is available in SQL Server 2008/VWD 2008.

Below is the complete step by step guide of this process.

Connestion string create any database server

This links important to how to create connection string to any data base sever.
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend