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

    ITKE372,455 pointsBadges:
  • Add SQL Server Agent jobs to Microsoft Excel spreadsheet

    I have a list of SQL Server Agent jobs and I need to add them to my Excel spreadsheet. The problem is that I don't want to do this manually. Is there a T-SQL command that would create this list for me?

    ITKE372,455 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!

    ITKE372,455 pointsBadges:

    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:
  • Export SQL Server database to SQL script

    For my SQL Server database, is there a way to export it to an SQL script? I need something like mysqldump. It would take the database's name, and create a script that will remake the tables, data, stored procedures, etc. Does anyone know of anything like this?

    ITKE372,455 pointsBadges:
  • Trigger email alerts on Windows Server 2008

    In Windows Server 2oo8, can I trigger it to send out an email alert when our logical disk partitions become low on space? We currently have two SQL Servers that are running out of space. It's due to log files. Thank you.

    ITKE372,455 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!

    ITKE372,455 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:
  • 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:
  • SQL Server 2014: Automatic update trigger if the record is duplicate

    I am using SQL 2014 and want to insert and update a lot of records within a Stored Procedure, and then have a trigger to rollback the record if it already existed and then update just after the rollback. Is there a better way of doing this?

    edwinjhoffer3,045 pointsBadges:
  • Auto calculation of Valuation per unit in SQL Server

    Sir/mam, I have a Table of different product of mutual fund its valuation(nifty level change) is to be calculated. Each product has a different formula which takes input of some variable parameter and some static. How do I calculate row by row formula? (including Average function for eg,...

    ojha1235 pointsBadges:
  • Getting this error while installing SQL server failover cluster instance

    I checked CNO permissions, the CNO had "Read all properties" and "Create Computer objects". The user that create the instance is an domain administrator and local administrator. Can someone help me?

    edwinjhoffer3,045 pointsBadges:
  • SQL Server login problems

    I am using Access as a front end to SQL Server 2014 backend database using DSN-less connections to tables and for pass-thru queries. All works fine. I have recently created a second database within the same instance of SQL Server, and believe I have set log in credentials the same for both, but am...

    DataSense35 pointsBadges:
  • Best 3rd party monitoring software for SQL?

    What's the best 3rd party monitoring software for SQL?

    Fran5 pointsBadges:
  • SQL Server: Update a table using SELECT

    I understand that in SQL Server, it's actually possible to insert into a table using the SELECT statement. But would it be possible to actually update via SELECT? We have a table that contains values and we need to update another table with those exact same values. Thanks.

    ITKE372,455 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.