Oracle Forms 6i Database Objects
For dynamic sql, the correct name of the package is DBMS_SQL not DBA_SQL.

View Answer   |  March 9, 2009  4:29 PM
Dynamic SQL, Oracle Designer, Oracle development, Oracle Forms 6i, Oracle SQL, SQL

Using an indexer for SQL Server 2005
What old indexer are you using? Why not query the file system indexer directly?

View Answer   |  March 8, 2009  4:02 AM
Indexed tables, Java applications, Java Web application, SQL Server 2005, SQL Server Indexes

tell me why I’m getting the message “The multi-part identifier “134062-DB1.netFORUMSTaging.dbo.Individual.individualKey” could not be bound”
You need to alias the remote table name and use the alias when referring to that object. <pre>select cxa_cst_key, cxa_key, cxa_key from [134062-DB1].netFORUMSTaging.dbo.Individual a LEFT JOIN dbo.co_customer_x_address ON a.individualKey = co_customer_x_address.cxa_cst_key where delete_flag = 0 and source not in (‘MIBNOM1′,’MIBNOM2′) order by add_date asc</pre>

View Answer   |  March 7, 2009  6:41 AM
SQL, SQL error messages, SQL Statement Syntax Errors, SQL statements

SQL Server 2005 Memory
SQL Server will only take the memory that it needs. If it needs 4.5 Gigs it will take 4.5 Gigs no more. The min memory setting is a low watermark. Once SQL Server is using that amount of memory it won’t return memory back to Windows to go lower than that amount.

View Answer   |  March 7, 2009  6:36 AM
SQL Server 2005 administration, SQL Server 2005 memory, SQL Server 2005 performance

IF ELSE in SQL Server stored procedure
The following will definitely work USE [MAINDB] GO /****** Object: StoredProcedure [dbo].[Invoice_Sum] Script Date: 03/06/2009 15:25:05 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER OFF GO ALTER PROCEDURE [dbo].[Invoice_Sum] @Num int AS SET NOCOUNT ON IF @Num=1 Begin SELECT "Sales" AS ReportName, Director AS Field1, SupportTeam AS Field2, Count(OrderNumber) AS ActivityCount, Sum(Revenue) AS Revenue, Sum(COGS) AS [...]

View Answer   |  April 17, 2013  8:44 PM
IF ELSE statement, SQL Server 2005, SQL Server development, SQL Server stored procedures, SQL statements

Copying our disaster recovery database on a SQL Server
There isn’t really an easy way to do this. About the easiest way to do it would be to stop the SQL Service on the DR server, and copy the database files. Then restart the datbase serer. Then attach the copied files as another database name. How quick it backs up will depend on how [...]

View Answer   |  March 6, 2009  1:34 AM
Disaster Recovery, Disaster recovery (DR) testing, Disaster Recovery Database, Disaster recovery planning, Log Shipping, SQL Server, SQL Server databases

SQL Server 2000 backup problem using batch file
Please post your batch file, as well as the error message you are receiving when you try to log into CRE. Without this information it is impossable to guess as to what the problem could be.

View Answer   |  March 6, 2009  1:31 AM
Batch file to backup, Batch files, Cash Register Express, SQL Server 2000 backup, SQL Server development

Linked server problems
Have you configured SQL 2005 to accept remote connections? Are you sure that the instance name is correct? Are you able to connect to the SQL 2005 instance from the other server? Is the SQL Browser running? This <a href=”http://itknowledgeexchange.techtarget.com/sql-server/steps-to-troubleshoot-connections-to-your-sql-server/”>blog post</a> shows how to troubleshoot connections to a named instance.

View Answer   |  March 6, 2009  1:23 AM
Linked Server, Linked SQL Servers, SQL Server 2000, SQL Server 2005

iSeries to SQL Server via SSIS 2005
You can use a script task with SSIS to change the connection string values as well as the values of other objects within the package.

View Answer   |  March 6, 2009  1:18 AM
iSeries Data Source, SQL Server, SSIS, SSIS 2005, SSIS Package 2005

Deciding on a RAID Level for a 64-bit SQL Server 2005
RAM is dependant on the application that you are running. But since you have 4 drives, I would suggest raid 1+0. That would give you 1 TB of disk space. The RAID level that you select will depend on what kind of load you’ll be placing on the database. If you are using a low [...]

View Answer   |  March 6, 2009  1:15 AM
RAID, RAID Level 1, RAID Level 1 +0, SQL Server 2005, SQL Server 2005 (64-bit)

Finding the average of a data type on a SQL Server
I don’t see the AVG operator in your code, in the first place. The message means that you cannot calculate the average of a varchar type field (and you are converting to varchar some of the columns). If that was possible, you could calculate the average for ‘spring’ and ‘summer’, for example. But you cannot [...]

View Answer   |  March 5, 2009  8:57 PM
Data Types, DateTime, SQL Server, SQL Server DateTime, SQL Server errors

help on Bulk insert and xp_cmdshell rename
As for the insert , the problem seems to be that you have defined an incorrect row terminator. You should be using ‘n’ instead of ‘/n’. To rename the file, try something like this: <pre>declare @command varchar(1000) set @command = ‘rename c:table.csv table_old.csv’ exec master.dbo.xp_cmdshell @command, NO_OUTPUT go </pre> With SQL Server 2005 and 2008 [...]

View Answer   |  March 5, 2009  8:05 PM
Bulk Inserts, CSV, SQL INSERT, T-SQL

SQL Server Stored Procedure
Anything that you can do as a normal T/SQL statement can be done via a stored procedure. In some cases you may have to use dynamic SQL do to them however. For example you can’t create a stored procedure from within another stored procedure unless you use dynamic SQL. The big requirement is that you [...]

View Answer   |  March 4, 2009  3:40 PM
SQL Server stored procedures

Log shipping and replication
There is no quick way to fail over a log shipped database to test DR and fail back. Once you make the database writeable there is no way to begin the log shipping again without resetting up the log shipping. Something you could try, and I have no idea if it will work would be [...]

View Answer   |  March 4, 2009  3:31 PM
Data Recovery, Log Shipping

Preparing a report on a SQL Server database
i think in your table lets call it CustomerCalls there is the below fields: CustomerName CustomerNumber DateOfCall and lets say new clients for your company are clients who started calling from Jan 2009 the query will be: select * from CustomerCalls where DateofCall>’01-01-2009 00:00:00.000′ and CustomerNumber not in (select CustomerNumber from CustomerCalls where DateofCall<’01-01-2009 00:00:00.000′)

View Answer   |  March 4, 2009  8:34 AM
SQL Server database, SQL Server Report Builder, SQL Server reporting, SQL Server Reports

How to compare fingerprint images in VB.NET
The following might be useful to you: <a href=”http://biometrics.cse.msu.edu/Publications/Fingerprint/JainUludagRoss_TemplateSelection_AVBPA03.pdf”>A Paper on biometric Templates</a>. The <a href=”http://www.soft14.com/nice_or_free_software/bi/biometric-972.html”>GSA image analyzer</a> is a program used to compare images, this might be useful in your application. <a href=”http://www.exefind.com/biometric/”>An interesting mix of Biometric programs and code</a> <a href=”http://www.filebuzz.com/files/Basic_Authentication/2.html”>More code and software for Biometric projects</a> Good Luck! -Flame <kccrosser> As someone [...]

View Answer   |  March 4, 2009  1:11 AM
.NET development, Authentication, Biometric authentication, Biometrics, Fingerprint authentication, Fingerprint scanning, SQL Server 2000, VB.NET, Visual Basic .NET

Running a query on both SQL Server and Oracle databases
If you are going to run the query from the Oracle database, you would need to use <a href=”http://download-west.oracle.com/docs/cd/B14117_01/server.101/b10764/intro.htm”>Heterogeneous Services</a> and create a database link to the Sql server database. Then you can access Sql Server’s tables by suffixing them with ‘@<database_link_name>’ If you are going to do it from Sql Server, you will need [...]

View Answer   |  March 3, 2009  8:39 PM
Oracle, Oracle queries, SQL Server databases, SQL Server Query

Deny domain administrators to select from sql server tables ( SQL server 2005)
Add your DBAs as members of the sysadmin fixed server role. Then remove the BUILTINAdministrators group from the server. Make sure that you know the password for the sa account before you do this. If you do it in the wrong order you will loose sysadmin access to the SQL Server.

View Answer   |  March 2, 2009  11:45 PM
SQL Server, SQL Server permissions, SQL Server security, SQL Server tables

Processing XML files with SQL Server functions
The XML data type that I used in the article supports up to 2 Gigs of data (~1 billion characters as XML is uni-code).

View Answer   |  March 2, 2009  4:53 PM
SQL Server 2005, SQL SERVER 2005 XML, SQL Server Functions, XML, XML Files in SQL Server 2005

Looping Queries in Oracle using data from SQL Server
Are you looking for a self join? <pre>SELECT a.* FROM HR.TABLES a JOIN HR.TABLES b ON a.parentid = b.sid WHERE a.sid = ‘value’</pre>

View Answer   |  March 1, 2009  8:29 AM
Oracle development, Oracle queries, SQL, SQL queries, SQL Server connectivity