Search results for query: *

Hi I'm currently looking for an option to select the first 50 rows from a table. Within MSSQL the appropriate query would be: SELECT TOP 50 * FROM table But as i have Pervasive 7.9, this is not supported. Does anybody has a workarounde? Thanks very much

Hello my company is using a very very old dos-base system which runs on a pervasive sql database. Now i have to provide dataexports for migration into a new system. On the DB-Server itself i've tried whithin the "Pervasive SQL Control Center" to use the export function. I can see all tables...

Hi all we use BAB 11.1 (Windosw) and have three backup jobs every night. One morning, two of this three jobs displayed within the Status column "corrupted". Also the DB-Backup after the job could (and still can) not be done. Then i did the following: - Run dbcheck utility, everything ok. -...

Hi all, i have following problem: - I created a linked server to a Oracle DB. - I created a MSSQL view with a query to a linked OraDB Table. The linked Server as well as the view is working correctly. - then i created a MSSQL table with an insert trigger, which has a query on the created view...

Hello all, we have an MSSQL 2000 SP4 on a W2K Server SP4. For a few weeks now we have troubles with the MSSQLSERVER Service, which shut down once or several a day. It comes up again suddenly by itself, but i cannot see what the reason is. For the same time periode the server also reboots itself...

Hi, we use BAB 11.1 SP1 on W2k with GFS rotation job. Till now everything went fine but suddenly it came up with this error. The weekly job still runs fine, only the daly makes trouble. The strange thing is that in the media prediction report it predicts the right tape number and method daily...

Hi all, i have a table relA with a datetime column ADate. this column can contain a value or NULL. Now, i would like to sort the rows as follow: SELECT * FROM relA ORDER BY ADate; Now, the rows with an NULL date appear on the top. How can I change it to appear rows with NULL date value at...

Hi all, some time ago, we have installed BAB 11.1 on a wk2 server machine. At the same time we also added a second SDLT Tape Drive to the second SCSI adapter and added this device to the same group. Now we hade an error in the backup job-log that he was not able to write to the second tape. In...

Hi All, - Win2000 server environment - Arcserve 9.0 (Build 2010) - SLDT1-320 Tape my problem is, that arcserve from time to time (to every day) stops backup and asks for a new blank tap as follow: "Unable to find this media or a blank media. MEDIA=F-LUE-THU-07.04.05, SEQ=2" If the backup job...

hi all, within the last two month, we have the problem that the monthly backup job failed. actually we don't know why exactly. The "job log is not available" and in the "Activity Log" the Media Name is N/A and the Media ID is 0000. Although the prediction report told to insert the right tape by...