If you want to RUN the query, then hit the query... menu from the same popup screen.

Check this screenshot.

I'm using full VS 2008 pro, but you should still get that menu in express.

Ya the gui will let you make the changes and it will drop the schema bindings.

You need to re-run the scripts to create the views so that you get the...

not quite...

SET SHOWPLAN_TEXT ON

GO

SELECT * FROM dbo.sysobjects

GO

SET SHOWPLAN_TEXT OFF

I'd personnally try with xp_cmdshell (good old dos commands) and try the same steps as above.

I'd also ensure that I'm working on the correct server.

Am I the only one NOT seeing a plan in that excel file??

I'd scale back to pinpoint the error.

Put a test file on G:\ and try deleting that single file.

Then I'd try the same thing using the extension.

Once you're 100% sure your...

Are you sure the path is ok for the delete?

There's nothing else obvious other than not having permission to run that xSP.

Do you get any errors when running it manually?

What...

Did you use a script to do the modification or did you use the gui?

I wouldn't "lose" the schema binding if I were in your place. It's certainly there...

I'm not sure how you created the trigger.

But within the trigger you can use the @@PROCID.

That will give you the obejct_id of the trigger. From there you can track...

You won't be able to do the change on the table untill the schema bound objects have been dropped.

Use ssms and see the script it generates to have an idea...

Chris Morris-439714 (9/27/2010)

---

krishnakumar-293737 (9/27/2010)

---

Select top 20 * from Database1..MY_TABLE (nolock)

Where THE_ID = (Select THE_ID from Database2..MY_TABLE_2 Where OTHER_FIELD = 'VALUE')

Order By MY_COL desc

Now....the subquery is invalid, there is no column...

One more thing in the mix.

I just started playing with VM and I find it extremely usefull how I can simply add or remove power at will on each...

Steve Brokaw (9/22/2010)

---

More info from my SQL DBA group: They claim that the guest account has access to the sample databases, and that can't be taken away. This...

Go in your settings and select 50 posts per page rather than 10. That's take it down to 2 prints!