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...

Paul - thanks for taking a look. Here is the MDX for my YTD-Pounds measure: Sum(YTD([Time].[Year Quarter Month].CurrentMember),[Measures].[Pounds]) scottie

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...

doh! thanks again!

well, that appears like the perfect answer, yet for me, i return null for the object_name. select * from sys.procedures shows the sproc by name and object_id, but the object_id <> @@procid. ?? thanks for the reply. i will keep kicking it around.

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

Actually there could be anywhere between 1 and 4... still working out some ideas

Excellent! Thanks for the help. I knew this could be done but was WAY off on my approach. thanks again !

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...

Perfect!! ADO is the answer. Thanks for the reference chart too! (I missed the footnote) Scott

Perfect!! ADO is the answer. Thanks for pointing me in the right direction. Scott

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...

Hey Keithmyers, did you figure this out? We are experienceing the exact same problem. TweakMYbox - can you elaborate on which directories in Exchange that should be excluded? Thanks! - Scott

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...

Thanks for the reply Lukasz - your last point is one that I had not considered: 2k3 offline past tombstone life. I may need to consider removing the subordinate then the root from the DC and start over with an stand-alone server model before pushing up to 2003. Does anybody have any advice on...

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 +...