Sure. By altering the view like that you've removed the schemabinding, hence you can now do anything with the base table

???

Create Table Testing (

 Test int

)

GO

Create View vwTest WITH SCHEMABINDING AS

Select Test FROM dbo.Testing

GO

DROP TABLE Testing

GO

The drop table returns

Server: Msg 3729, Level 16, State 1, Line 1

Cannot DROP TABLE 'Testing' because it...

> You CAN modify the table as long as you don't touch the columns included

> in the view. The other columns are changeable...

Ah. *reads fine print in BoL* So...

Create the view WITH SCHEMABINDING

That way the tables (or other views) referenced by the view cannot be modified in any way unless the view is dropped first.

I've had this before, though I don't know what caused it. Looking at the table list in Ent Manager the table had no owner listed. When I checked sysobjects, I...

Might I suggest you post in the SQL Server administration or SQL Server General forums.

More people read those and you are more likely to get an answer.

This forum is...

A covering index on OrderDate, OrderID should do the job.

You'll be surprised how many people don't realise that functions prevent index usage, or don't think about indexes at all....

My pleasure.

DBCC Shrinkfile expects the logical name of the file to be shrunk as the first parameter, not the name of the database.

Run sp_helpdb 'MyTemp' and see what it returns as...

Just one thing. Never start a stored procedure name with sp_

Very much recomended against due to the way SQL resolves names when executing a stored procedure.

sp_ is the prefix that...

You're creating a table named TRENDDATA and inserting into TRENDDATA_

btw, did you test my code? I ran it on the sample data you posted yesterday and got results that look...

If anyone can do this without a cursor, I'd be very interested in seeing it.

Well, this caught my intrest, so I thought I'd give it a quick try. Sorry Remi. );

This appears to work, if I've understood your requirements properly.

CREATE PROCEDURE SumOfMaximum (@Tid INT,...

That assumes that you have an identity column, a timestamp or a datetime field defaulting to getdate()

I've had some fun issues with distributed transactions to the AS/400. In my experience, they're not DTC errors, but problems with the IBM AS/400 OLE DB driver.

Experiment with wrapping the...