Prophet 21 Database Dictionary

Is there a data dictionary for the prophet 21 database? I am looking to create applications that use data stored by prophet 21 software. Is there available software to interface with prophet 21 data?

Carlosburkle5 pointsBadges:

SQL Server 2008 Restore error message

I get this error when trying to restore a 30 mg database "Callback:SQL Server 2008: Out of memory on restore" and then get the error ""There is insufficient system memory in resource pool ‘internal’" Anyone have any ideas?

Kmmc1122334455665 pointsBadges:

server temporary freezing

I have Dell poweredge 700 with Dell CERC SATA 1.5/6ch Raid controller card in RAID 5 I have about 20-30 stations connected to it at any moment. The disk queue is small below 1 from time to time people will experience desconnection problems such as i will try to access file and server will stop...

Dimchik0 pointsBadges:

Indexing in Microsoft SQL

What is an index in Microsoft SQL? What types of indexes are available in SQL Server 2005? Do I need to know about this to create and deploy a database?

TeachMeIT975 pointsBadges:

SQL Server 2005 maintenance plans

I have several maintenance plans setup in SQL 2005, but if the backup fails I am not alerted in any manner how can I fix this? Will I need to script something or is this a built in feature?

TeachMeIT975 pointsBadges:

Kerberos unconstrained delegation for MS SQL svc account

Can an MS SQL service account run non-SQL services if "trust this user for delegation to any service (Kerberos only) has been enabled?

Calicdaj5 pointsBadges:

Crystal Reports XI – SQL table fields that fail all compare tests

I have an SQL table with a field that Crystal XI displays as string 300, call it mytable.mystring. If I create a formula field (myformula) such as... if {mytable.mystring} = "test value" then 1 else 2 This is what happens during execution...  when the the preceding test is true, Crystal returns a...

BTod50 pointsBadges:

Error Message when restoring a SQL server DB in SQL Server Express 2008 R2

This error received and cannot determine resolution: System.data.Sqlclient.Sqlerror:Create Database or Alter Database failed because the resulting cumulative database size would exceed your licensed limit of 10240MB per database. The DB.bak file is 1.67MB

Trackster209515 pointsBadges:

dba deleting data

Is part of a DBA's job to delete production data using SQL scripts?

Biker015 pointsBadges:

SQL Work Files

In the FOCUS programming language, you can retrieve data and hold that data for further processing at some point later in the program.  What is the best technique for doing this in SQL?

Rhansard5 pointsBadges:

Receiving result sets in RPG (prior to release 7.1) from an SQL SP

I have read through the IBM manual "Stored Procedures, Triggers, and User-Defined Functions on DB2 Universal Database for iSeries" for information related to returning a result set(s) from a stored procedure into an RPG program. The manual states that a Global Temporary table must be used for this...

MapleLeafDeveloper5 pointsBadges:

Connect to remote SQL server from MySQL

we have read only access to a remote sql server. the requirement is to read few tables from sql server and load to mysql tables (installed on Unix box). Please suggest the possible ways of achieving this.

Nitibansal5 pointsBadges:

Service Broker downside

I have service broker up and running accross 2 instances. If data is entered/updated on table A in instance A, it will send a message to the target queue and a stored procedure is used to read in the message and perform the update to table B on instance B. Once service broker is up and running,...

Ndoan5 pointsBadges:

How does exchange 2010 email archiving work?

How does exchange 2010 email archiving work? Imean techincally speaking, does it stub? What do the users see, what is on the backend, a SQL database? I can't find any articles on how exchange server 2010 email archiving works under the hood?

Tuck15 pointsBadges:

What is a linear recursive query in SQL?

What is a linear recursive query in SQL?give me an example.Is there any nonlinear recursive query??

Gomsbk35 pointsBadges:

Problems running AS400 stored procedure from SQLServer 2005 SSIS execute SQL task

I need to run a stored procedure (with two input parameters ) that has no output, on an AS400. When I try using the IBM DB2 UDB for iSeries IBMDA400 OLE DB provider, I get the following error [Execute SQL Task] Error: Executing the query "CALL TPSDTA50GQ.PMCTESTTP('PETER', 4)" failed with the...

PeterJC15 pointsBadges:

SQL problem: Adapting code fragment

How do I adapt the fragment of code below to show: a) Two columns - the Filipino Population and the Total Population  b) The Filipino Population as a percentage of the total population  SELECT DISTINCTROW POPDATA.CITYNUM,  COUNT(*)FROM POPDATA  WHERE POPDATA.ANCNUMBER=720  GROUP BY...

Mentos5 pointsBadges:

Database Security: SQL Server 2005 security login

Like Oracle Logins how can we create Logins in Sql Server 2005? Please help me..........

Madhavi0maadem0oss0012345678905 pointsBadges:

Using mdf file in website

When you've developed e website with vis stud, including an aspnetdb.mdf file and a database file for the webcontent, how can you use these mdf files on the isp server where sqlserver 2005 is running? A normal connectionstring in the web,sonfig file gives an error about the attachdbfilename being a...

Makoe5 pointsBadges:

Updating SQL express to SQL 2008 R2 on server 2008 with sharepoint 2007

At present we are running a Windows 2008 Server which has Sharepoint 2007 installed and houses our exchange server.  Apparently only the Express version of SQL server was installed initially and now the 4GB database limit is affecting our intranet. Have been advised that we need to update to SQL...

Weboneau5 pointsBadges: