• conversion of SQL Server 2008 stored procedure to Oracle 10g

    Can u please give tips on Differences between datatypes, functions, limits,statements etc in both oracle 10g and SQLserver2008 . I need this help for converting Store procedures from SQLserver2008 to oracle 10g

    Oracle10gSQLserver20085 pointsBadges:
  • Cannot INSERT data into table with identity column

    In my program I have an EmployeeRegistry table which holds data of each employee's work attendance. Every attendance record is uniquely distinguished by an IDENTITY COLUMN called "AttendanceID" which has an IDENTITY SEED of 1 and an IDENTITY increment of 1. However when I try to insert an...

    Obhasha0795 pointsBadges:
  • SQL trigger on column

    Table have delete and update trigger. How to identify which columns are affected by this triigers? or  which column have  triggers ?

    Lkjh123415 pointsBadges:
  • table size strange in SQL SERVER

    Hi, I have 2 tables in SQL SERVER * TbUrl INDEX SPACE 12,531 MB ROW COUNT 247505 DATA SPACE 1.965,891 MB CREATE TABLE [TbUrl](     [IdUrl] [Int] IDENTITY(1,1) NOT NULL,     [IdSupply] [Int] NOT NULL,     [Url] [varchar](512) NOT NULL,     [UrlCod] [varchar](256) NOT NULL,    ...

    ens1z10 pointsBadges:
  • Access and sql server wide tables

    Does anyone know how to access sql server wide tables using Access

    Johnatsteeltorchdotcom5 pointsBadges:
  • Creating New Data Source to SQL Server…

    I am going into, Control Panel, Admin Tools, Data Sources (ODBC), under the, User DSN tab I'm choosing "Add...", then choosing SQL Server. Then under server the one I need..well there are two with the same name, how can this be? A follow up question, not all accounts have access to this, but some...

    ITTinker5 pointsBadges:
  • Free IT Book: Demystifying the Virtual Desktop

    Interested in desktop virtualization? This week's free IT book is just what you need. Michael Fox's Demystifying the Virtual Desktop Starting with Desktop Virtualization is a quick read that breaks down the business and technical complexities of virtual desktops. Simply answer one of five questions...

    ITKE352,565 pointsBadges:
  • Exchange 5.5 in a Server 2003 AD Domain

    My company is planning an upgrade of our nt4 PDC's and BDC's to server 2003 standard. We have three different sites and currently our main site has a PDC and the remote sites of BDC's. We are planning to implament 3 new 2003 servers. One here and one at each of our remote sites. The one question I...

    Hamel010 pointsBadges:
  • New Data Field in Stored Procedure

    When I add a new data field in a Stored Procedure, how do I make the new field available to the Crystal Report?

  • Installing a named instance using another edition’s installer.

    I have a SQL Server 2005 standard edition installed with a default instance. I need to install an additional named instance. However I could not find the standard edition installer CD; and my colleague managed to dig out a copy of the Express edition installer. Can i use the Express edition...

    Tamtam5 pointsBadges:
  • Load balance of SQL database

    When my database has grown beyond the performance capabilities of a single SQL Server, what are the ways get increase the system performance?

    RASHMIMB15 pointsBadges:
  • Windows 2003 Static Arp Problem

    I'm currently running 4 Windows 2003 Servers at my workplace. Every month or so a couple people have a connectivity problem connecting to our main file server. Now when I look in the ARP cache for the file server it has one or two STATIC ARP entries for the IP addresses of the computers that are...

    Kmeister0 pointsBadges:
  • SQL 2008 R2 ‘Web Assistant procedures’

    exec sp_configure 'Web Assistant procedures' When I execute above statement in SQL 2008 R2, I get the follwing error message Msg 15123, Level 16, State 1, Procedure sp_configure, Line 51 The configuration option 'Web Assistant procedures' does not exist, or it may be an advanced option. How to...

    As6185 pointsBadges:
  • How can we get shell when dbms is SQL2008 and we found an sql vuln in REFERER field, which revealed version,dbs,tables etc?Sqlmap didn’t work.

    Hello, During my last pen test I found an sql vulnerability in the REFERER field of the headers. This revealed me, using sqlmap with --referer option, the DBMS which is Microsot SQL 2008,all  db names, tables, db users etc. My problem is that I cannot test if a shell can be spawned, since...

    Astathaki5 pointsBadges:
  • Two SQL (2005 and 2008) on the same machine.

    We are planning to install some CRM software and it can only use 2005, however we will be upgrading to SQL 2008, is it possible to run 2 SQL versions (2005 and 2008) and is it a good idea from backup, maintenence and running. Will there be issues?

    HOK5 pointsBadges:
  • Creating clustered index on exiting table

    I have a SQL Server 2005 Enterprise Edition database table that has 768,526 rows in it with no primary key or clustered index. This database's logs are getting shipped to a disaster recovery server on an hourly basis. I need to create a clustered primary key constraint on this table; however when...

    Senyeart5 pointsBadges:
  • SQLRPGLE Cursors and Recursion

    I'm trying to recursively call a PI in my SQLRPGLE program. Problem is, I get an SQLCODE error of -519 and I'm sure it has to do with cursors and the prepare statement in my PI. Here's the code: pprintPrograms    b      dprintPrograms    PI      d...

    Dcantwell470 pointsBadges:
  • How to Upload Image into SQL Server 2005

    Please i need help to upload images into sql server 2005 using vb.net 2008. kindly assist please as i am working on an application that would require users to upload their credentials.

    BrownAsakpa20 pointsBadges:
  • unable to connect sql server 2000 on network

    We have sql server 2000 instance on a machine say "comp1".The problem is when i need to connect to it via another computer on LAN using SSMS it is unable to connect but when i connect to the "comp1" via run and give password then i am able to connect through SSMS Can someone give a solution so that...

    Psingh1630 pointsBadges:
  • Order by clause in SQL Server subqueries

    why the "order by" clause in sub queries must be associated with "top" clause in sql server..??

    Karthikharve5 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