Search results for query: *

I just got a sun storedge multipack (6 hd) and is trying to configure it on my ultra60. It connects to scsi port directly through the back of ultra60. all the led is up on the front panel of the multipack. When it boots with "boot -r", console keep showing following message. warning: invalid...

Is there any way to use INSERT INTO <table name> while overriding MSSQL default action - logging changes first in the transaction log file before committing changes. I'm trying to speed the ETL process. Any hint will be helpful. Thank you!

Does SQL 2000 save the DDL changes history in somewhere? Actually the last modifed date will help also. Thanks in advance. Frank

Is there any way to change the ordinal for existing column using TSQL instead of Enterprise Manager? Is it possible to use one of the system stored procedures to get it done? Thanks in advance, Frank

I tried to create a job containing only one step. In the first time, the T-SQL script is like this: select count(1) from transaction The job was manually triggered and scheduled to run. It run successfully. In the second time, the script to run is like following: use int go update transaction...

What is the minimum database permissions for regular biztalk user? So he/she can manage the queue and monitor the functions.

Microsoft claims SQL 2K only accept 8060 bytes per row. However, I noticed couple of my clients still design their tables way beyond the maximum capacity, sometime 3 to 4 times larger. This makes me pause and think twice. What if the data inserted larger than 8060, does it really broke the SQL...

We have Crystal Report 8.5 and Crystal Enterprise 8 in house, and plan to schedule tons of reports. The challenges we are facing are: 1. Schedule reports in batch; 2. Save the history reports with different file name; 3. Dynamically passing parameters when run the report. It looks like only...