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

    ITKE413,315 pointsBadges:
  • MySQL 5.0 advantages and disadvantages

    what is the advantage and disadvantage of mysql 5.0?

    Mysql10 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.

    aceofdelts2,330 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:
  • Additional SSL SSRS site within 2008 SSRS Integrated mode

    We are installing OCS 2007 R2 that requires a secured (SSL - https) SSRS Site for their Monitoring piece.  We have an existing Windows 2008 Enterprise 64bit - SSRS 2008 Enterprise 64bit site that is integrated to Sharepoint 2007.  Could we use this environment for the additional SSL SSRS...

    DrakeTeran5 pointsBadges:
  • Replication and using EMC Autostart

    I am using EMC Autostart to monitor and mirror an application that uses a SQL 2000 DB. All worked well until I incorporated replication to keep certain tables synchronized with 2 other servers. The Autostasrt uses virtual names and IP's for clients to connect no matter which server is acting as...

    Ecann25 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.

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

Following