Which query??

Maybe one quick optimization..

Select 1 from Table where 1=0

You still get a recordset but at least it's empty.

Then on the app side you only need to extract the return parameter...

You...

Not so invisible anymore .

Do it client side... This is not a job that the server should be doing.

Just for the heck of shooting you down to make sure he never uses this crappy (performing) solution.

Hehe... could be worthwhile if you can have 10 jobs at the time .

INSERT INTO tbl_a (col_A) SELECT cast(col_B as int) FROM tab_b where ISNUMERIC(Col_B) = 1

--for a single object

Select * from dbo.SysComments where id = object_id('ViewName') and text like '%whatever%'

--for any number of views (and what I suppose you are asking)

Select Distinct O.Name from dbo.SysObjects...

Can you post the trigger code too?

This can be optimized a lot.. should stop timing out.

Create a linked server to the database, then query like this

Select * from LinkedServerName...TableName (play with the number of dots if it doesn't work... never did that with access).

Check out my first post on this Thread (final update from (select))

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=8&messageid=189202

Nice resume there... Would like to see Joe Celko answer this one .

Got something even better now (works nice if all the dbs are in the same directory).

--list the database data files found in the directory that are not listed in master...

Yup... but I feel a little more thaughts could have gone into this one .

This is something that you should do at the client if this is for presentation purpusses only.

Why are you trying to do this?