i couldn't get the @@ERROR thing to work... once the EXEC statement failed, the entire batch stopped. but one idea leads to another... try/catch DID work.

and i'm with you on...

so i've come up with a script to do what i want... not the prettiest thing in the world, but hey, it works. my next challenge is error trapping. the...

but i don't want to rebuild ALL indexes in all databases, just certain indexes in certain databases. i know, i know, but those are the rules i have to play...

there's only 1 server... multiple databases... even so, i don't want 1 rebuild task per database because:

1. they could create a new database without telling me

2. i don't want to...

there are a number of ways, but in my case, since i'm using visual studio to develop the reports, i simply repointed the project to the new server and redeployed...

copy this line:

select * from dbo.[db.documents]

paste it into your query window.

run it.

does it work?

i'm only repeating this because every example you give does NOT have the brackets.

use brackets:

select * from dbo.[db.documents]

type the select statement exactly as shown above, with brackets surrounding db.documents. in other words, db.documents becomes [db.documents]

does select * from dbo.[db.documents] work?

this may help you:

http://support.microsoft.com/kb/312839

i'm guessing it worked when you EXECed it as SA in a new window?

to find out who's executing the proc, you could run a profiler trace filtered so that it...

replace ??? with some date ('1/1/1900'). that should add your columns.

awesome... never mind about my last post then... 😉

actually, what i was hoping to find out is whether or not it worked. if it did, that takes the troubleshooting down a whole different path.

it's SUPPOSED to work to...

just for fun, i created a simple test procedure in one session, then executed it in a second session, then executed the original code in a third session:

DECLARE @handle VARBINARY(64)

SELECT...

i would think SA has the rights, so i'd look to make sure the step isn't running as some other user (who doesn't have permissions). what do you get if...