• Creating database access at runtime for ADO and SQL Server

    I’ve put together some code to create database access at runtime using an ADO database connection. How can I do the same for a SQL Server database?

    SQL Server Ask the Experts2,585 pointsBadges:
  • Difference between Sp_msforeachdb and sp_msforeachtable

    In MS SQL Server what is the difference between Sp_msforeachdb and sp_msforeachtable

    Jaideep Khanduja12,670 pointsBadges:
  • Is it possible to call a stored procedure within another in Oracle?

    In Oracle, would I be able to call a stored procedure from within another procedure? Here's what I have so far: SET SERVEROUTPUT ON; DROP PROCEDURE test_sp_1; DROP PROCEDURE test_sp; CREATE PROCEDURE test_sp AS BEGIN DBMS_OUTPUT.PUT_LINE('Test works'); END; / CREATE PROCEDURE test_sp_1 AS BEGIN...

    ITKE828,840 pointsBadges:
  • Database with Visual C++

    I am learning on Data Base management. I have installed Visual C++ and will use SQL server. But I don't know which component else to install, and how to connect to and use SQL Server. Can somebody help me? Thanks a lot

    Makee15 pointsBadges:
  • Database for OLTP

    Which database is most suited for OLTP? Is it Oracle or Microsoft SQL?

    Akansha150 pointsBadges:
  • How to split a column into SQL data..

    I have table called  country having one column called complete_name (varchar(max)) which is as under   [table style="border-collapse: collapse;" border="0" cellpadding="0" cellspacing="0"> [tbody] [tr] [td style="border: medium none #d4d0c8; padding: 0in 5.4pt; background-color: transparent;...

    Anamika8315 pointsBadges:
  • Cannot Regster remote SQL Server 2000

    I can access remote server by remote desktop and I can ping server also, but fail to register remote SQL Server. Please help.

    Master197015 pointsBadges:
  • SQL Server Fails to Start When Moved to Different Node

    Sql 2008 R2 on Windows 2008 R2 cluster. When I move instance from node 1 to node 2 everything is fine: all resources come online as they should. When I move the instance from node 2 to node 1, all resources except sql server and agent come online. If I delete errorlog and start the sql server...

    Spadasoe5,130 pointsBadges:
  • Copy a SQL Binary Large Object (BLOB) from one database to another

    Is there  a way to find out the name of a Blob stored in a database. I am trying the code below and apparently the name is not correct. SQL> Declare   2   tpsr Blob;   3   spsr blob;   4  Begin   5   Select '8502' into tpsr from ca90joetmp.spec_form_psr where spec_form_id = '90710';...

    Bobf15 pointsBadges:
  • About MCTS 70-432 exam

    Sir, as I'm new to this, I would like to know were would I can get free download for the MCTS 70-432 exam. I also need study material for this and also like to know if I need to go through a training session from an institute for this exam or can I do it myself. Please guide me for the above....

    Fhhdjfhjdhfjhjdfh135 pointsBadges:
  • Database file in Novell GroupWise

    What is a data base file in novell groupwise? Is it associated with each novell file or there is only 1 which contains info for all other file?

    PCVITA15 pointsBadges:
  • How to perform pit recovery

    I cannot find a good doc which describes hot to perform a pit recovery in sql server.

    Michaelkurth5 pointsBadges:
  • Is SQL Server an application that I should run within a VM? Can I monitor it while it is on a VM?

    Is SQL Server an application that I should run within a VM? Can I monitor it while it is on a VM? This question was asked during the Microsoft System Center live chat on IT Knowledge Exchange in January 2010.

    ITKE828,840 pointsBadges:
  • Archiving Exchange 2007 in a SQL database

    How do you set up an SQL database/server to receive and store archiving/journaling for exchange 2003/2007 email.

    Cmoney5 pointsBadges:
  • Export Oracle data to Excel

    Is there sql code to export data from oracle to excel? I can right click on the data set to export but need to include it as part of the code. Any help would be much appreciated! Thanks

    ITKE828,840 pointsBadges:
  • Free Centralize backup solution

    Hi, anyone has idea of any freeware centralize backup solution or low cost best centralize backup solution. i have 12 lcoations with File and print servers. SQl server Database server 2 web serevrs 1 Domain controller i want to backup the files at my central IDC. locations backup has only Excel,...

    Thmohan50 pointsBadges:
  • VB.NET – Can’t insert data into database.

    I used insert command it worked successfully that your data has updated.But it is not showing in the database. Please look in the below code and tell me where I'm wrong: Imports System Imports System.Collections Imports System.Data Imports System.IO Imports System.Xml.Serialization Imports...

    Shaz255 pointsBadges:
  • Convert from MS Access to SQL 2005

    SELECT Format(DTrans.DATE,'dd/mmm/yyyy') AS dated, DTrans.trntype as Expr1 , DTrans.JVNO, 'By ' & FINNACCO.ACCNAME , (select analscode from INCEXPAN where analscode=val(DTrans.CRANALSCODE) and accode=craccode) AS CRANALSCODE, '' , DTrans.AMOUNT, dtrans.craCCODE AS accode,...

    Radhikanutalapati5 pointsBadges:
  • Consolidating SQL Server databases

    How I can consolidate seven SQL Server 2000 and SQL Server 2005 databases to only SQL Server 2005 databases? Both servers are HP and Dell servers.

    SQL Server Ask the Experts2,585 pointsBadges:
  • Backup Performance Compare

    How or what can I use to compare the performance of the backup performed when the database is configured to use the simple recovery model versus the full recovery model.

    Michael Tidmarsh50,275 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