• How to open SQL Server 2008 after completing installation

    I have installed SQL Server 2008 R2 and how can I start with it after this?

    chinchu5 pointsBadges:
  • How do I restore my SQL .bak file over the existing database?

    How do I restore my SQL .bak file over the existing database? Do I need to delete what is there already? On a new Windows installation I need to restore our production SQL database from a .bak file. What steps do I need to take? Can I overwrite data or do I need to restore to a fresh database?

    ITKE435,940 pointsBadges:
  • Call a stored procedure on a SQL Server from my RPGLE source using JDBCR4 service program.

    Something is going wrong while setting up the connection environment (ZBCCNNPF). Can someone explain me which parameters have to be set in which way to make this process work? Kind regards, Ton Konings.

    TonKonings196215 pointsBadges:
  • Visual Basic: Get SQL error output from Web Browser

    I tried to create an application with Visual Basic that gives me information about gaps in my websites and how to secure it. I want to create a program that check if an SQL error exist, if it's injectable or not and it's proportion of gravity. After searching in Google and found a similar program...

    Nashab20155 pointsBadges:
  • SQL Server

    What is a tempDB in SQL Server?

    Sai5 pointsBadges:
  • How can I get the queries history in SQL Server?

    Is there a way I can get the queries history in SQL Server?

    balachandr5 pointsBadges:
  • What’s the size of my SQL Server database?

    My apologizes for the short question but can I find out what the size is of my SQL Server database? This would include tables, logs, etc.

    ITKE435,940 pointsBadges:
  • How to rename SQL Server database?

    I am working on SQL Server 2014 and I have some older projects where my database name is different and same database I am using in my other projects. So how can I change my database name?

    edwinjhoffer3,365 pointsBadges:
  • I am using SQL Server 2005 and the following error keeps being reported in the Domain Controller Logs:”There are multiple accounts with name MSSQLSvc/…..”

    I am using SQL Server 2005 and the following error keeps being reported in the Domain Controller Logs: "There are multiple accounts with name MSSQLSvc/....."

    Tizi30 pointsBadges:
  • Find missing numbers with SQL

    In a large logfile I have records containing the field INVNO (invoice-number). The lowest and highest values are easy to find, BUT it looks like some numbers in between are not there. Anyone got a trick with SQL, which can tell which numbers are missing within the numberrange (step 1) ?

    DanTheDane2,555 pointsBadges:
  • Delete all tables in SQL Server database?

    How to delete all tables of a database in SQL Server?

    Prcvjr220 pointsBadges:
  • Rename SQL Server 2008 instance

    I'm currently using SQL Server 2008 and I need to rename an instance. Is that possible? Thanks!

    ITKE435,940 pointsBadges:
  • Backup schema in SQL Server 2005

    Would there be a way to backup just the schema in a SQL Server 2005 database? I don't need records, just the structure. Thank you!

    ITKE435,940 pointsBadges:
  • SUB-QUERIES

    Hi, Good you give me an best real example for using the sub query, correlation of sub query & Top analysis using subqueries. Thanks in Advance.................

    134915 pointsBadges:
  • Update a subquery with different tables

    I am trying to update a table and use a subquery for the argument. I think I have both queries correct but since but since they are from two tables I am not tying together correctly. Can you tell me what I need to do? update MVXJDTA.MITMAS set MMSTAT ='01' where MVXJDTA.MITMAS.MMITNO =...

    Bartbart50 pointsBadges:
  • How can I restore a database from .mdf file?

    How can I restore a database from .mdf file? I only have .mdf backup file.

    SQL Server Ask the Experts2,585 pointsBadges:
  • Convert Oracle Database to SQL Server with Cascade Updates.

    I am trying to convert Oracle database to SQL Server. Ten years ago I converted this same database from Access to Oracle. The database had a lot of cascade updates in it and some are not always downward flow. Sometimes they go up. I used after update triggers with deferred foreign key constraints....

    dpmcateer5 pointsBadges:
  • Remove duplicate rows from a large table in SQL Server

    For SQL Server, does anyone know the best way to remove duplicate rows from a large table? Here's what I have so far: MyTable ----------- RowID int not null identity(1,1) primary key, Col1 varchar(20) not null, Col2 varchar(2048) not null, Col3 tinyint not null Thanks!

    ITKE435,940 pointsBadges:
  • Can’t repair MyoVision Access database

    One of my clients has a 130MB Access MDB which contains thermo image scans from an application called MyoVision. Recently, the database became corrupt and MyoVision is offering no support to fix it. What I'd like to attempt is Repair the database as it seems to be corrupted. Create a new MDB file...

    DavidCum7775 pointsBadges:
  • Calling COBOL program from native DB2 stored procedure

    Can we call COBOL program from native DB2 stored procedure? Or can we call external COBOL stored procedure from native DB2 stored procedure?

    Tanmay2115 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