• MySQL vs. Oracle

    what is the major two comparison of mysql5.0 and oracle 10g?

    Mysql10 pointsBadges:
  • Service Broker in sql server 2005

    [strong]What is a real life application of service broker architecture in sql and how to use it?[/strong] [strong]Can anybody help me in understanding service broker with real life example?[/strong] Thanks in advance

    Srm20095 pointsBadges:
  • Site outage update

    for more information on the recent site outages please read this blog post Thanks Sean

    ITKE346,360 pointsBadges:
  • MySQL 5.0 advantages and disadvantages

    what is the advantage and disadvantage of mysql 5.0?

    Mysql10 pointsBadges:
  • SQL autonumbering problem

    I have a sequel db of users which is periodically updated by exporting to access, making changes, then re-importing amended table. After re-importing, the records are duplicated, and the autosequence jumps to over 10,000. I only have 682 records. (That is the highest index number used.) Why does...

    Chippy0884,625 pointsBadges:
  • SQL Server datetime

    Hi - When I run this: select cast ('461129' as datetime) i get 2046-11-29 00:00:00.000 instead of 1946-11-29 00:00:00.000 Can you please let me know why and what I need to do in order to get the required results. thx

    DBM10 pointsBadges:
  • Capture SQL Server logged in db User name in Access 2007 Accdb

    I have a SQL Server 2005 backend with an Access 2007 Accdb front-end application.  Security has been established via SQL Server database user groups with associated table-level permissions. I would like to disable certain form functionality based on the logged in user.  Is there a way...

    Ppeterso15 pointsBadges:
  • Can I add a local SQL 2005 instance to a clustered node

    I have a 2 nodes (Active/Active) SQL 2005 Standard cluster. Since SQL STD only support two clustered instances, can I add a local instance to each node? I don't need this local instance to fail over. Is it possible to have the two clustered instances an two local instance one on each node?

    NetWeb70 pointsBadges:
  • AS/400 stored procedures

    Is there a way to list the existing stored procedures on our box ? Those that wrote them are gone and documentation is sketchy. We found some by using any SQLRPG source as a clue but none of these were "create" routines (some were actual procedures). Seems like there ought to be an easier way.

    aceofdelts1,930 pointsBadges:
  • SQLRPGLE – Prepare – Declare Cursor

    I'm using Prepare, Declare SQL cursor in my SQLRPGLE program After Declare statement I receive SQL -312 - Which indicates to me that the SQL statement is not declared correctly. Is it something wrong with my query. I ran this query in SQL editor and went fine. I dun understand why not in the...

    Nutangujar895 pointsBadges:
  • Create a Stored Procedure using CL and RPGLE programs

    I have an RPGLE program called from a CL program for database files overrides. I want to call the same programs from a stored prodecure on SQL Server from within a Web application. I am brand new to SQL Server but am pretty good on the AS400.

    NCharette20 pointsBadges:
  • Merge Replication with express versions

    I am trying to do a merge replication with about 10 pda's and a desktop i do not want to use full blown ms sql due to cost, anyone any alternatives PDA's are running Mobile 6 and sql compact IF need be will change from MS sql to other

    ChrispInk5 pointsBadges:
  • SQL auto increment by group with INSERT..

    Is it possible to define an auto-incremental coloumn which increments by 'group' ? I want to create a version log for an old table (uniquely keyed 'HOWTONO') which contains records with 'How to' data in the form of short code-fields and some long fields with text.  I intend to trigger updates,...

    DanTheDane2,555 pointsBadges:
  • Backup of large amount of data

    I need some suggestions on a backup procedure. Here's what I am backing up to a 3.5 TB fileserver (RAID 5). 200 GB of application and document files from an application server. About 200 GB each on four medical imaging workstations. 100 GB of SQL database files from a SQL Server 100 GB of backed up...

    EyeT35 pointsBadges:
  • SQL Server transactions TSQL question.

    Does a list of Transact SQL statements, that cannot be used within transactions, exist please? Is it available on the Web?

    Fdemid25 pointsBadges:
  • Migrating C code db acess from sybase to sql server 2005 – newbie

    I have to change the db access from a sybase to a sql server 2005 in a c program (i have to keep the C code) I have read lots of technical articles but i'm a bit confused ... with ODBC and the use of sqlcli.h i write a simple C code that access the sql server db but i think it is not the better...

    0949595 pointsBadges:
  • sqlserver2005 on windows vista home premium(32 bit)

    i have sqlserver2005 wid service pack 2 installed,it gives server names as-'user-pcsqlexpress'&'user-pc'. But wen using visualstudio2008,if i give this as the server name during database connectivity it does not recognise and the error msg says that d server doesnt exists.Please give me a solution

    Rishabhshukla5 pointsBadges:
  • Bulk-Logged Recovery Model SQL Server 2005

    If I change the recovery model on the database from full to bulk-logged to run DBCC CheckDB and Rebuild Indexes is changing the recovery model the correct thing to do?

    Rick Martinez585 pointsBadges:
  • following error when logging into SQLPlus

    When i try to log into Oracle SQL*Plus i get the following error ORA-01034: Oracle not available ORA-27101: shared memory realm does not exist I'm using Oracle 9i Personal Edition

    Oracle9995 pointsBadges:
  • SQL Express used for SSIS?

    Can sqlexpress be used for SSIS

    Lianv10 pointsBadges:

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following