0
There is no way to view this information by way of SQL Server Management Studio.
You could write a stored procedure against the SYSObjects tables to gather the information. You can also obtain information regarding the create / last accessed|used date of many objects from the same resources.
Wiki User
∙ 13y ago
Add your answer:
Earn +20 pts
What has the author Louis Davidson written?
Louis. Davidson has written: 'Pro SQL Server 2005 Database Design and Optimization' 'Pro SQL server 2008 relational database design and implementation' -- subject(s): Client/server computing, SQL server 'Pro SQL Server 2005' 'SQL Server 2000 Stored Procedures Handbook (Expert's Voice)'
Which tool is available in sql server 2005 that lets you stop or disable unused components?
sql server management
You created a stored procedure in sql server 2005 database and you called through aspnet page with connection then you are getting error as - Could not find stored procedure 'GetLoginInfo' solve pls?
The connections bruk.
Can we use javascript in SQL stored procedure?
Transact-SQL in an internationally standardised method to create, modify and delete databases and tables, as well as insert, retrieve, modify and delete data stored in a database. With Microsoft SQL Server 2005 you can also author procedures in any managed language such as C# or VB. This is because it is integrated with the CLR which allows you write powerful programs inside stored procedures. All functionality of the .NET Framework BCL (Base Class Library) is available to your stored procedures. This means that developers have access to thousands of pre-built classes and routines which can be accessed. The BCL includes classes that provide functionality for improved string functioning, advanced math operations, file access, cryptography, and more.
Difference between sql server 2003 sql server 2005?
There is no such thing as SQL Server 2003. Microft released SQL Server 2005 as the next version of SQL Server 2000.
Describe IDE of SQL Server 2005?
An IDE for SQL Server 2005 refers to an Integrated Development Environment for SQL Server 2005. This is a tool that can be used by a programmer to create and maintan a SQL server database. Some commonly used IDE tools for SQL Server 2005 are:SQL Server Management StudioTOAD for SQL ServerTOAD for Data Analysts
What are the release dates for Get Ed - 2005 Procedures 1-16?
Get Ed - 2005 Procedures 1-16 was released on: USA: 6 February 2006
What is Trigger is SQL Server 2005?
A trigger is a SQL procedure that initiates an action when an event (INSERT, DELETE or UPDATE) occurs. Triggers are stored in and managed by the DBMS.Triggers are used to maintain the referential integrity of data by changing the data in a systematic fashion. A trigger cannot be called or executed; the DBMS automatically fires the trigger as a result of a data modification to the associated table. Triggers can be viewed as similar to stored procedures in that both consist of procedural logic that is stored at the database level. Stored procedures, however, are not event-drive and are not attached to a specific table as triggers are. Stored procedures are explicitly executed by invoking a CALL to the procedure while triggers are implicitly executed. In addition, triggers can also execute stored procedures.Nested Trigger: A trigger can also contain INSERT, UPDATE and DELETE logic within itself, so when the trigger is fired because of data modification it can also cause another data modification, thereby firing another trigger. A trigger that contains data modification logic within itself is called a nested trigger.
When was SQL Server Management Studio created?
SQL Server Management Studio was created in 2005.
When was Subsonic - media server - created?
Subsonic - media server - was created on 2005-02-10.
Where can one get SQL Server 2005 downloads?
The best way in order to get an SQL Server 2005 installation package would be to go to the related Microsoft SQL Server 2005 download page. The "Express" edition is free of cost and can be redistributed with own applications - all other versions of Microsoft SQL server can only be legally purchased.
Where is the mileage stored on a 2005 Chrysler Sebring?
It is stored in both the body and engine computers.
