Search results for query: *

OK - I found the answer in the following article: thread962-892622

I have a SQL job on a specific database that only does Integrity checks - which fails However - when I run DBCC CheckDB, I do not find any errors. I have rub dbcc checkdb(xxxx,REPAIR_ReBUILD) successfully, but the SQL job keeps on failing. On other databases it runs fine. How can I determine...

I have 2 databases running on Oracle 8.1i. Do I only need 1 license or 2 licenses.

Yes, they are checked, and set for 8 day(s).

In our backup strategy, we have set up to remove files older than 8 days. However - old backup files ARE NOT deleted. We also got this problem at one of our clients. Are we doing something wrong?

In our backup strategy, we have set up to remove files older than 8 days. However - old backup files ARE NOT deleted. We also got this problem at one of our clients. Are we doing something wrong?

Since We have moved from domains, Our SQL Servers is taking a full 2 seconds to make a connection. NT Users created on the Domain controller can also not been seen from the SQL Server. What we have done is to simple join the SQL Server to the New domain. Can anyone guide me on how to resolve...

I have the following function create function MaxOf (@Value1 sql_variant, @Value2 sql_variant) RETURNS sql_variant AS BEGIN DECLARE @MaxValue sql_variant select @MaxValue = max(valu) from (select @Value1 valu union select @Value2) t RETURN @MaxValue END When I run this select...

IF you are using SQL 2000, you can try to convert your stored procedure to a function which will output the results as table. You can then use this output in a following stored procedure.

You can develop in any language that support ADO or DAO. Examples are delphi and java. Note that you can also develop in EXCEL, but I think you need a VBA license to sell any applications with VBA coding. The reason your company is restricting ACCESS licenses is because they anly have a...

Post this question on the SQL Forum...someone there can help you.

Just before running the application, run the following statement to see how many locks there are select count(*) from master..syslocks You can save this somewhere to look at the value the next day.

Any other bypass which I can execute myself (hard reset, hidden key combination etc)

I have a Palm V - how can I reset the digitiser. The problem is that it so out of sync, that I cannot even reconfigure the digitiser.

It might be that you do not have the ADO (or the correct version) of ADO installed. Go to project \ references and see what version of ADO are you project referencing. Try changing to a different version of ADO (I had problems with ADO 2.7, when I have changed back to 2.6, my problems disappeared)

A very excellent (and free) guide to API calls using VB, can be found at www.allapi.net This is the best help tool I have used up to date. It saved me millions of times figuring something out. MSDN is not always that helpful.

Refer to SQL books online.

Does Power Management features work in Windows NT installed on a notebook. The reason I ask is because I am unable to find any power options in the control panel or anywhere else.

It sounds like the SQL statement passed to your Stored procedure is missing a parameter. Q1: The LanguageID, what is the type of this global Q2: Have you monitored your database to see what is the exact statement that come through. Try to use the DBCC INPUTBUFFER statement to determine what...

Just to get things straight... ...do you want to fill the array with the string value "7F", or do you want to fill the array with chr(&7f), thus an array of string, of which all the strings are len=1.