• Is share point an alternative / more than SQL Server?

    I m poor in using MOSS Microsoft Office Share Point. I have web application in ASP using IIS and SQL Server 2005. Now if I have no licence for SQL Server 2005 can I use MOSS as an alternative for SQL Server 2005? Is it possible to create / attach data base in MOSS / MOSS related SQL...

    SQLServer200810 pointsBadges:
  • CLR Assembly in MS SQL 2008

    I have a problem with COM-objects which i create in CLR-assembly in VB.NET via CreateObject. When I compile this assembly as console project and run loging under any account on server, it works ok. But when i run this file from MS SQL, it can not create object. What may be reason for this?

    dalex35 pointsBadges:
  • Aren’t correlation IDs ok in MSSQL for an UPDATE statement?

    I'm getting the following error with the attached SQL statment on MSSQL: UPDATE IMMUNE I

    DeloeranGuy55 pointsBadges:
  • 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

    ITKE342,185 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:
  • seeking formal definitions of the software ‘ilities’

    anyone where I can source a definitive list of defintions for the software 'ilities' e.g. scabaility, reliability, availability, stability, security, performance thanks

    Gcronin5 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,850 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:
  • Function to find greatest numeric value across different fields

    In a row of data with multiple numeric fields, how can I easily find the greatest value using simple function like GREATEST(Attribute1, Attribute2) as for Oracle SQL?

    Kevling5 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