Search results for query: *

That's what I was looking for. Thanks, RiverGuy.

MyTextBox.SelectAll() would accomplish the same. My goal is to NOT have to explicitly call each TextBox control but implicitly call them from the Control class within the loop.

Within a simple validation loop, I need to SelectAll text within a textbox control when invalid, however SelectAll is not available in the Control class. How can I go about this within the current loop? Pardon my ignorance if the answer is obvious. Here's what I have: Private Function...

Thats what I'd like to avoid. I have a couple thousand procedures and functions to update.

Is there any way to return the sub or function name that is currently executing? This is to create a general error trap to write the current form and code the error occured and passed to an ErrorClass [code] Private Sub MySub() On Error Goto ErrHandler 'code Exit Sub...

Thanks for pointing me in the right direction. EM's properties said it was 7.0 compatible, however it's not like Microsost has never been wrong before... I EXEC'd sp_dbcmptlevel 'TableName', 70 and viola! TOP works. Aloha Neil

The TOP keyword no longer works on one specific database. It gives me an "Incorrect Syntax" error whenever I use it. It works on every table but one. Also, in EM, the "Return Top.." menu item is not enabled. Help PLEASE! TIA.

Well I created a job to run every morning at 7AM, and to page me if it fails! Hopefully that'll do the trick! Thanks for pointing me in the right direction! Aloha Neil

I was originally thinking of running it as a scheduled task from NT, however i'm unaware of any utilities to exec sp's from the command line. Does EM or DTS have a scheduler? Neil

BeckahC, I am using EM, specifically the DB Maintenance Plan Wizard to create the maintenance plan. Since it happens randomly and there is no mention of it being reset to single, I don't have a clue as to when it is being tripped. Ideally I would like to exec sp_dboption at 7am just to be...

I have a database that is randomly reset back to single user mode after my maintenance plan execs. I've checked all the logs and they come up clean. Any Ideas? Is there command line utility to reset SQL server in the AM? e.g. exec sp_dboption 'Database_name', 'single user', false Or do i...

balves & arrowhouse TOP! just what I was lookin' for... Thanks Neil

Is it possible in a sub-select to return only 1 record if there may be a posibility of returning multiple records? Is there a function/property similar to MaxRecords in ADO where you can specify the maximum number of records to return? e.g. SELECT c.casename, (SELECT rep(*only return 1 rep)...