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


Top 5 Contributors of the Month
MarieAdela
Imran Ghani
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.

http://weblogs.sqlteam.com/jeffs/archive/2008/10/27.aspx

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:
http://support.microsoft.com/kb/932872

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

  

Hi,

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

------------------------------
ADDITIONAL INFORMATION:

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

------------------------------
BUTTONS:

OK
------------------------------

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

  


Hello

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

How to find Resource Deadlock on the database / server?

  

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


Thanks

 

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

  

Hi,

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'

GO
ALTER DATABASE DBName SET EMERGENCY
DBCC checkdb('DBname')
ALTER DATABASE DBName SET SINGLE_USER WITH ROLLBACK IMMEDIATE
DBCC CheckDB ('DBName')

 

 

2. ALTER DATABASE DBName SET MULTI_USER

 

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

Regards

Kalyan

www.techbubbles.com

 

 

 


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.
Categories: 
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