Search results for query: *

Yeah, I went through the options for the database and the server. I don't see anything I can set to turn it off or on. Does anyone know how this behavior can be different between the two?

Thanks George. I read the post, but don't see anyway to turn it off/on. If there a way to do this? I'm interested in finding out why it errs in one environment, but not the other. Both are running the exact same version of SQL Server 2005. The parrallel environment was even created by...

Can someone shed some light on this? I imagine it's just a setting somewhere, but it has me a little worried. I have a dev environment, running on a virtual server. I created a proc on it and ran the proc. All is well, so I move the proc up to our parallel environment, not a virtual server...

Does anyone know where I can find a table containing the P-Values of the Correlations used in the Probt function?

Thanks! I figured out a way to do it by stepping up each level until I got to the mailbox, but this is much cleaner...

I'm trying to write a COM add-in for Outlook 2003 in VB.Net. I need figure out the full path to a selected email. Basically, if it's in the Inbox>Projects>Current Projects>Project 1 sub folder, I would like to be able to grab all that info. From there, I want to set a variable equal to...

Thanks! I think that and a stored proc to remove the data once I export it will do the trick. I'll have to look it over more and try it out.

Does anyone know the best way to dump large amounts of data from SQL Server to a text file, automatically? Here's the scenario: I have a web application written in ColdFusion, with a SQL Server backend. The application reads 7 mainframe files each morning. This information contains data on...

What I was meaning was how do I make sure that the key field"s" aren't already there. I had just been in here too long yesterday. Once I looked at it this morning, it was obvious... where KeyField1 is null and KeyField2 is null ... Thanks for the help! All seems to be working well now.

However there is not a single ID field. Is there a way for me to use simliar SQL using multiple fields to identify what is in there or not? Thanks!

Thanks SQLSister I'll try that tomorrow when I get back in. The reason there are two files is the Order table denotes when Orders are placed on an account, while the Usage table actually denotes Usage on that account. If there is not any usage for an account that month, it simply won't show up...

I have two data files that I need to merge into one table in SQL Server 2000. The layouts are below, * denotes key fields. File 1 (Order): State* Type* Cust #* FileDate* Customer Info Account Type (B or D)* Order (Y or N) File 2 (Usage): State* Type* Cust #* FileDate* Customer Info Account...

Does anyone know of a good VB to JAVA conversion plug-in/tool? I've looked around and found one at www.diamondedge.com, but was wondering if anyone has used any others.

Sys.dual is a single row dummy table. It has one column Dummy VarChar2(1) with a value of 'X'. It's often used for testing items (such as a sequence :-)), pulling the date (select SYSDATE from Dual), etc.

Yup, a Sequence in Oracle will fulfill your SQL Server Identity need. Here's some more info on it: CREATE SEQUENCE YourNumberSequence INCREMENT BY 1 START WITH 1 MAXVALUE 99999999 (or NOMAXVALUE) MINVALUE 1 (or NOMINVALUE) CYCLE (or NOCYCLE - the default) CACHE n...

Thanks! I think that will pretty well cover it. I'm sure there will be a few changes (users always change their minds :-)) before it's all done, but that does what we need at the moment. Thanks! Doug

I have an Oracle table that contains information on the control cards on our mainframe. The data in it looks like this: ROW_ID State Cust Type ID DETAIL_DESC ------ ----- ---- ---- --- ------------------------------------- 347621 AR COA A 10 SIGNON ESF=YES...

Thanks SM, I actually tested the same thing before I left yesterday. Once I got to looking at it, this row isn't a part of the actual key. We use it as a logical index so we know which record to update when moving data from our test environment to live (in the same way, regardless of table...

I'm finalizing a HUGE group Oracle project and noticed some of my fellow developers created some of their tables using non-standard data definitions when they created their tables. Since allot of data has been entered in these tables, simply dropping and recreating them is not an option. So...

I'm new to JAVA programming and especially Eclipse. I have a small program that runs fine, if I run it outside of Eclipse. However, when I run it from within Eclipse, I get this error: java.lang.NoClassDefFoundError: org/apache/log4j/Logger at java.lang.ClassLoader.defineClass0(Native...