• What are the best tools for SQL monitoring and SQL diagrams?

    we have SQL 2008, and looking for tools to monitor sql and get sql diagrams. do you know any good tools?

    Persa5 pointsBadges:
  • Error message when creating a stored procedure: SPxxx is created but cannot be saved or restored

    I created a stored procedure on AS/400, the message in return was 'SPxxx is created but cannot be saved or restored '. I am able to view the created stored procedure in the Library but when I call the procedure the error message was 'SPxx was not found with specified parameters". How to resolve...

    bharathtata5 pointsBadges:
  • Export SQL Server to Microsoft Excel with column headers

    In SQL Server, I have a query that has roughly 20 columns and this needs to be exported to Microsoft Excel with the column headers. What's the process to do that? Thanks so much.

    ITKE434,720 pointsBadges:
  • How to connect SQL Server to Microsoft Excel

    I'm looking to connect several reports from my SQL Server database so several end users can view them. Would I be able to connect SQL Server to Microsoft Excel? Thank you very much.

    ITKE434,720 pointsBadges:
  • How to export SQL Server 2012 database with data

    Can I import my SQL Server 2012 database (including the data) to a .SQL file so I can import it into my 2008 server. For some reason, I've never been able to export the data. Only the structure goes through.

    ITKE434,720 pointsBadges:
  • SQL Server memory usage

    I have a situation where a total of 13 GB RAM is being used by SQL server. Is there any way I can break down the 13 GB usage by application?  Is there any data or technique which could be used?

    Cgardel30 pointsBadges:
  • Export SSRS to Microsoft Excel without any headers

    I have a SSRS report that I need to export to Microsoft Excel. But here's the kicker - my header that's on the first page of the report has to be removed from Excel. How can I do that?

    ITKE434,720 pointsBadges:
  • Oracle In Linux

    How can I able to get and work with Oracle in Linux platform. I am using RedHat Linux 9.0.

    Samachar0 pointsBadges:
  • SSIS Server Maintenance running 2 days

    My internal.operations table in the ssis db has over 600,000 rows. Before doing enough research, I changed the retention window and allowed the maintenance job to execute. The job is deleting approximately 10 records every 20 minutes. I want to stop the job; however, I'm afraid of what will happen....

    kmccourt03195 pointsBadges:
  • How to import MySQL database dump to SQL Server

    I currently have a SQL file that's from a MySQL dump. It contains a bunch of things including: Tables, definitions and all the data. Is there a way to convert all of this to a SQL Server database?

    ITKE434,720 pointsBadges:
  • SQL database rollback query

    How do I roll back in case the database changes all data to the same information?

    twatonny015 pointsBadges:
  • Migrate MySQL database to SQL Server

    My MySQL database is already full of data but I need to migrate it all over to SQL Server 2008. Is there a particular script / code I need to do this? I don't want to download any third-party software. Thanks!

    ITKE434,720 pointsBadges:
  • SQL Server: Remove foreign key

    On my SQL Server, I have to remove the foreign key from one of my tables so I can insert different values. What SQL query should I use for this? Thank you very much for your help.

    ITKE434,720 pointsBadges:
  • Restoring SQL Server 2008 database backup over my network

    Does anyone know how I can restore a SQL Server 2008 database backup over my network? Do I have to copy the file locally to the SQL Server? Thanks for the help.

    ITKE434,720 pointsBadges:
  • Compare two table schemas in SQL Server database

    Throughout my week, I have to do random checks between a SQL Server development and release database. Usually - this is a manual process but it's quite slow now. Would I be able to compare my different table schemas automatically? Thank you very much.

    ITKE434,720 pointsBadges:
  • Backup SQL Server 2008 database using C#

    How can I backup my SQL Server database (2008 edition) using C#? Is there a specific code I have to write? Can I use SQLConnection? Appreciate the help.

    ITKE434,720 pointsBadges:
  • Count empty tables in SQL Server database

    In SQL Server, would there be a way for me to count the tables with no rows? Can I use a T-SQL statement? Thank you very much.

    ITKE434,720 pointsBadges:
  • Automate SQL Azure database backup with SQL script

    We're generating millions of SQL scripts per day so we can backup our SQL Azure database. But instead of manually, we need to do it automatically. What's the process to do this? Thank you.

    ITKE434,720 pointsBadges:
  • Copy and rename SQL Server 2008 database

    We currently have a SQL Server 2008 database that needs to be copied and renamed as a new database. We're not too worried about losing data - it's a new database. Basically - we want to keep the same structure as the old database / set a new name to it. What's the best way to do this?

    ITKE434,720 pointsBadges:
  • Best format to store images in SQL Server database

    For my SQL Server database, what's the best format to store images? Would binary be the best bet? Thanks so much.

    ITKE434,720 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