Search results for query: *

Hello - We are in the middle of implementing E9 and I have begun working with the Service Connect Tool. We have several training databases (Train1, Train2, ect.) for specific reasons. When I create a workflow process, it appears to be updating the Train1 database. Can anyone offer some...

Hello All - I have an issue with a YTD measure. Being pretty new to MDX I found several examples and they all look pretty much the same. Here is my code: Sum(YTD([Time].[Year Quarter Month].CurrentMember),[Measures].[Pounds]) When analyzing YTD-Pounds by ProductType July-07 & July-08 in...

All - I would like to be able to determine the stored procedure name from within the procedure itself. Kind of like what I do with the database name: SELECT @DB_NAME = db_name() Anybody know a way to get the procedure name? Ideas? Thanks in advance - Scottie

Hello all, I am attempting to return a row as such: [Order Number, Salesman1, Salesman2] from a table that has 2 columns: Order Number, SalesMan. Data: OrderNum SalesMan 1234 Bob 1234 Mike Both Salesmen share the order and i would like to output on one line...

Hello All - I have a working linked server SQL2005 <--> Informix 10.0 and can use an OpenQuery statement to retrieve data. What I would prefer to do is a "Select * from ServerName.Database.Owner.Table" but this keeps throwing errors. I know almost nothing about Informix and am assuming that...

Hello All - I am coding a utility to write stored procedures based on the field names and data types in any given table. I can get the field-Type and field-Size but if the Type is a Decimal (number), I am hitting a wall when attemping to find out the precision and scale via code. I can only...

Hello All - I am running into a brick wall with a simple SQL Task attempting to return (output) the value from a stored procedure into a global variable. I have tried both OLE DB and ADO.NET connection types and have Googled for hours (finding a lot of complaints) but no solution thus far...

All - We are experiencing an odd issue with our new 2003 Exchange system processing inbound emails with attachments. We use a Barracuda 400 pointing to Exchange (works perfect with our Exchange 2000 box) but when pointed to our Exchange 2003 (R2 - SP2) box, any mail with attachments get queued...

All - I need to move my original Enterprise CA to some new hardware. I have the MS-KB steps to follow but am unsure if the Enterprise Root CA needs to be on a Domain Controller. This is the case at the moment and since the server is offline for a year at a time, it is ALWAYS out of date with...

Hello All - I was wondering if anybody hides their DC's from the browse list? Any reason not to? I was thinking that adding some security by obscurity for the DC's wouldn't be such a bad idea. Thoughts on this? Thanks!

All, I am attempting to return the results of an Exec ('Select..') statement. In short, I am passing in a field name in a UDF and have success executing the sql statement, but can only view the result in the 'results' pane. Here is the statement that works: exec ('SELECT max(' + @FldName +...

All, I have a linked server established between 2005 sql box and network file server holding an access .mdb - select * from linkedserver...tablename works when I am on the actual sql box logged in as SA or myself. Great! When I am at my workstation using SSMS, I have success if I logon as...

Hello All, I am simply attempting to rename or drop one of my UDF's in a database and am encountering the following error: Msg 3729, Level 16, State 1, Line 2 Cannot DROP FUNCTION 'CONVERT_DATE_TO_PERIOD_FN' because it is being referenced by object 'DF__root_INTP__PRD_I__43D61337'. I have no...

Does anybody know of emulation software other than Idokorro's ssh / telnet client. We need the ability to map function keys like f4 and shift f11, ect. Thanks Scottie

All, I am attempting to join 2 tables containing customer number and sales. Table one has current month. Table two is all other months. Anyway, this has always worked with Access, but I can't seem to get SQL to return 1 record for each customer. Any help is appreciated. SELECT STC_CUS_NO1...

All- We have a few users that continue to remove toolbars, columns, ect when mousing, keying, ect. Does anyone know a way to lock these controls on the form, thus preventing the users from removing them? Thanks Scottie

hey everyone, i need to return the top 25 customers for each state. sounds simple enough, but it's not working for me... i am working from a union select statement that joins current month table and remainder of 2004 months. SELECT [UNION SELECT CURRENT YEAR].CURRENTSALES, [UNION SELECT...

It seems that some of my XP Pro clients mapped drives disappear from network places at random times. Anybody else have this happen? Any suggestions? Thanks in advance, Scottie

Just when I thought it was going good, my Exchange 2k server is giving me fits. Too many problems to list, so I was thinking about building another Exch 2k server, moving the users over to it, and removing the current Exchange box. Anybody got suggestions or KB references. I have inbound...

Hello all, In the past few hours, we have been unable to open attachments sent in from the outside. Up till now, everything has been great. message box: "Could Not Open One Or More Attachments" Our inbound filter is not stripping them. The Exchange box is 2000 running Norton Exchange Virus...