Search results for query: *

Thankyou, For your feedback. I will exhaust all avenues, however if not satisfied i'll be back with avengeance.

Hello all, Is there a way to use the right mouse button to select an object from within a java program and select the required properties i have created. At the moment i am able to left click the object i have created which highlights the object, then i need to right click to select the...

Fantastic, You hit the nail on the head. Thanks for your contribution to this thread. Thankyou,

Hello, Can someone please explain the benifits of Sql Servers, Meta Data Repository. How would this benfit a data warehouse. Thanks in Advance

Thanks for your response. Ive managed to purchase a great read "Professional SQL Server 2000 DTS (Data Transformation Service)" which has most of the unanswered questions I require. Kishleo, can you elaborate on your ODS interms of design. Is it a mirror of your Data Warehouse or a...

Hello, Id like to know the simplest way to create a Database Schema from within SQL Server, or techniques to adopt. Thanks in Advance.

Hello, Id like to knows of any loading techniques or has recources on the topic of populating tables from operational data sources. Thanks in Advance.

Thankyou very much JGIRL. Your post has definately filled the void in my knowledge, of OLAP cubes.

Hello all, Ive been unsuccessful in finding any informative info on OLAP cubes. Can anyone please direct me to recources they found usefull defining what the function of an CUBE is. Thanks in Advance

Hello all, Ive been to BOL and looked at this area in depth and cannot make any sense of it. Can anyone outhere please explain the advantages and or purposes of full-text catalogs as opposed to not having them installed. Thanks in Advance,

Hello all, Has anyone been able to view reports from CE8 eportfolio which access both a lotus notes nsf database and cobol isam vision files. If so please reply to this thread as to how you have been able to retrieve data in a report format. It seems i can only view reports that access an SQL...

Surely, there must have other sites out there that have encountered this issue? I Demand Answers!

Hello all, Are there any special considerations in Crystal Enterprise CE) when reporting against Cobol isam vision files and Lotus Notes databases? Please reply with any personal experience in this area or soloutions to this query. Thanks in Advance.

I have managed to modify the code supplied by MeanGrean, and have it in a manageable state. The following is the modified code. select substring(cast([COLUMN HERE] as varchar(255)),4,10) as [NEW_COLUMN_NAME_HERE] from [DATABASE HERE] Thanks for you help guys!

The Datatype is integer. MeanGreen, the following statement returned: Server: Msg 1035, Level 15, State 10, Line 1 Incorrect syntax near 'cast', expected 'AS'. I am unfamiliar with the Casting function. Can you please take a look at this. Thanks in Advance!

Hello all, I have a column in a table with about 3000 rows. I need to truncate the values in this column to remove the first 3 values eg. 345753 = 753 Is there anyone who can help with this request. Thanks in Advance.

The following script, will shrink either the log or database file. If in doubt, try it on you test environment before hand. Remove comments that return line.Here you go, SET NOCOUNT ON DECLARE @LogicalFileName sysname, @MaxMinutes INT, @NewSize INT -- *** MAKE...

Burgovision, Do I need to created the DSN names in the ODBC on the webserver for the reports to locate the data source? Thankyou,

Hello all. Since the beginning of the my contract, this server has continuously emitted the following error, on an intermittent basis, frequency monthly. C:\..SYSTEM32\KERNEL32.dll failed. The process is terminating abnormally. I have tried registry hacks to increase the size of the Desktop...

Hello all! I am in the process of an application upgrade on one of our many application Servers. I would like suggestions on the types of file bakups i could perform on the server for a quick recovery for the system critical files. In NT4 i would only backup " \System32 ", &quot...