Search results for query: *

Here is my test procedure: Create proc usp_ReturnValueErrorTest AS DECLARE @x int SET @x = 1/0 GO So I'm not setting any return value, but it returns -6. On a test server we had procedure return -7 because the transaction log file was full even though the procedure didn't specifically...

Really just a Friday afternoon curiosity. A co-worker executed a stored procedure and received a return value of -7. They asked me what that meant. When needed I've checked return values to make sure they are zero or non-zero for success, but never really cared what the actual value is...

Nevermind. Turns out a colleague mis-communicated the server name. We where running the restore on a backup server that doesn't have the drives partitioned. Oops. Thanks Mike Reigler Melange Computer Services, Inc

That's the problem, the restore wizard is not recognizing T:\ as a valid local drive. IF I use "with move" I get: Msg 5133, Level 16, State 1, Line 1 Directory lookup for the file "T:\dbname_log.ldf" failed with the operating system error 3(The system cannot find the path specified.). Mike...

I have a Windows 2003 Standard Edition Server with a 2 drive raid 1 configuration. The logical drive is partitioned into 4 partitions (C:\, F:\, T:\, and X:\). One of the hard drives failed. After replacing the drive and getting the server back up and running, SQL server 2005 no longer sees...

@StringIn and @BoolIn are never empty (at least when called by me). All the output parameters are initialized to null. I've been doing some additional searches and found references to FTMONLY being used by ADO, which I'm using to call the stored procedure on my server. But the only place I...

We have a pretty basic interface set up with numerous vendors. We set up a linked server based on their company name. They create a stored procedure on their server that has the correct name and parameters. There are about 20 potential vendors that could be set up, but at any given location...

Check your sql server instance name. By default SQL Express installs with an instance name of SQLEXPRESS, but your ODBC connection defaults to MSSQLSERVER. When you add your connection you may need to include the instance name as well as the computer name for the datasource of your connection...

Steve, I've been working on a project that requires two timers on a form and haven't had any problems. Mike Reigler Melange Computer Services, Inc

Just curious, I haven't used VFP 9 much for reports, but it's my understanding that there is a checkbox to "save printer environment" (that is off by default) which was added to the report form setup to prevent this very problem. Was that option checked? If so you may want to uncheck it so...

Earlier Dave suggested you move the thisform.release() to the end of the code block. Did you do that? All the code after the thisform.release shouldn't even run. Mike Reigler Melange Computer Services, Inc

Does anyone have any thoughts or recommendations on MS SQL programming related sites on the web? I've been looking at signing up for a membership at sswug.org. Mike Reigler Melange Computer Services, Inc

I'm trying to select the commandId attributes (as bigint)out of an XML document without knowing the name of the element the attribute belong to using XQuery, but being new to both XML and XQuery, so far I haven't had much success. Any help would be greatly appreciated. For example return...

Or if the two fields are not the same data type (which doesn't look the case here) Order by Case @OrderbyCriteria When 1 then first_name when 2 then last_name when 3 then city End, Case @OrderbyCriteria when 3 then last_name End Mike Reigler Melange Computer...

That will teach me not to check my answer. If your column in table2 is a datetime then why are you converting to a vachar. The conversion back to a datetime is when you get the error because of the 103 format. For example: works print convert(datetime,convert(varchar, GETDATE(), 103), 103)...

My guess is you haven't qualified the size of the varchar in your convert function. Mike Reigler Melange Computer Services, Inc

Thanks vongrunt, that did it. Mike Reigler Melange Computer Services, Inc

I'm trying to programmatically script out the default constraints from tables in one database to update copies of those tables in another database. I have the table name, column name, and constraint name from syscolumns and sysconstraints, but I haven't been able to find where the default value...

How about a self join? select A.employid, B.Plan_1_Beg_date, B.Plan_1_End_Date From A left join (select employid, plan_1_beg_date, plan_1_end_date FROM A WHERE plan1 IS NOT NULL) B ON (B.employid = A.employid) Mike Reigler Melange Computer Services, Inc

Just a thought. If it's critical to know for sure that the report did hit paper you can always prompt the user and ask (that's what windows does when you print a test page. Mike Reigler Melange Computer Services, Inc