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!

Remove data in the db or compress the backup.

Option 1 may look ridiculous but sometimes you don't need to keep data as far back as 10 years... maybe 2 is...

I'm with you here. There's no point to have them on prod servers but there's definitely a possible need for them on dev server (especially if you're learning BI).

As...

GilaMonster (9/21/2010)

---

Didn't miss it, but was trying to get out to usergroup meeting.

I wouldn't recommend changing compat level. Could cause queries to change behaviour or break. However, what people often...