Tara-1044200

First be happy that your system is responding rapidly to the users needs, and you have the disc space available to continue what you are doing..

If response time slows, or...

Do not believe that...

wwei

Thanks, if you have other questions - come on back.

Here is the code that might do what you require:

--INdex Size Author: CirquedeSQLeil (Jason ) on SCC

Declare @DBName varchar(50)

Set @DBName = 'Yourdatabasename'

Select Db_name(ps.database_id) as DBName,object_name(ps.object_id) as TableName,I.name as...

This bit of code will set the time to be all zeroes.

DECLARE @midnight DATETIME

SELECT @midnight = DATEADD(dd,0,DATEDIFF(dd,0,getdate()))

SELECT @midnight

Here are some items for date/time you might want to add to your...

What tables, if any have you designed so far?

What are the business rules for giving concessions?

How is the data to be added through a user interface, or?

Are the values of...

You might want to use this created by RBarryYoung

CREATE VIEW vwTableInfo

--Author: 16-March-2008, RBarryYoung SSC

AS

SELECT SCHEMA_NAME(tbl.schema_id) as [Schema]

, tbl.Name

, Coalesce((Select pr.name

From sys.database_principals pr

Where pr.principal_id = tbl.principal_id)

, SCHEMA_NAME(tbl.schema_id)) as...

As per Jeff change your final select statement to:

SELECT * FROM equip_output ORDER BY equipnum

--giving you this output

equip_idequipnumpaid

4 44200 ...

Try this

SQL Server 2008 Books Online (November 2009)

http://msdn.microsoft.com/en-us/library/ms190464.aspx

Think it has all that your need.

Heck either way. I've had...

Assuming (and you know what that makes of me = SELECT SUBSTRING('assuming',1,3))

The following code will return all stored procedures that...

Vijji-429978

You will get tested assistance if you post the table definitions, some sample data and what you have attempted. Following the suggestions contained in the first link of my...

Using this site, I think by...

Look at the dynamic managment view to see if it has what you are looking for.

sys.dm_db_index_physical_stats

Used to work for company where the first offense was titled...