Is the built-in administrator group still part of the sysadmin role??

you could change the authentication method in the registry and relogin that way, change, reset the sa password and you'd...

Today .

Cause I don't remember posting queries, or messages.

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 .