• T-SQL script for list of SQL Server 2008 R2 databases and user privileges

    Does anyone know if there's a T-SQL script that would list all of our SQL Server 2008 R2 databases and the roles / privileges for one specific user? Thank you very much.

    ITKE413,725 pointsBadges:
  • Data migration from SQL Server to Oracle

    For my job, I have to move over data (particularly table data) from SQL Server to Oracle. This usually happens on a weekly basis. What's the best way to do it automatically / repeatedly? Thank you.

    ITKE413,725 pointsBadges:
  • Select permissions for user on SQL Server 2008 database

    I have to create a new user on our SQL Server 2008 database with only select permissions. This user will have read-access only. Is there a way to do this? Thanks.

    ITKE413,725 pointsBadges:
  • SQL Server 2012 error message when restoring database

    I keep getting this odd error message in SQL Server 2012 when I'm trying to restore a backup that was made from a previous version. Here's the error message I'm getting: System.Data.SqlClient.SqlError: Directory lookup for the file "C:\PROGRAM FILES\MICROSOFT SQL...

    ITKE413,725 pointsBadges:
  • PowerBuilder 11 in SQL 2008

    We are seeing performance issues with our PB 11 app after SQL 2005 DB was migrated to SQL 2008. We did not change any code just the connection profile. From: [Profile APP] DBMS = SNC SQL Native Client(OLE DB) Database=database UserId= DatabasePassword= LogPassword= ServerName=SQLServerName LogId=...

    Lstadler15 pointsBadges:
  • Create new SQL Server 2008 Express database without SSMS

    Is there a way for me to create a new database with SQL Server 2008 (Express) but not using SSMS? Do I have to use SP1 for this? Thanks again.

    ITKE413,725 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.

    ITKE413,725 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.

    ITKE413,725 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.

    ITKE413,725 pointsBadges:
  • PostgreSQL to SQL Server database migration

    Our department has a PostgreSQL database that we need to move over to SQL Server. That includes both the schema and all the data. It's becoming a very slow process manually and we need something automatically. What should we do here? We're currently moving over the tables one-by-one.

    ITKE413,725 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.

    ITKE413,725 pointsBadges:
  • Insert large amount of data into SQL Server

    On my SQL Server, I have to insert roughly two million rows from one of my text files. When I'm doing the insert, I also have to create several other master tables. Is there an easy way to insert such a big set of data into SQL Server? Thanks.

    ITKE413,725 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.

    ITKE413,725 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.

    ITKE413,725 pointsBadges:
  • error message I was trying to send out e-mails

    the error message stated " the connection to microsoft exchange server is unavailable outlook must be online or connected to complete this action"

    Newmiko390 pointsBadges:
  • Finding SQL Server database string

    In my SQL Server database (which was given to me by a co-worker), I have to find one, specific string. Here's the issue: I have no idea where it is (don't know the name of the table / column). How can I go about doing this?

    ITKE413,725 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.

    ITKE413,725 pointsBadges:
  • Find SQL database table in Java

    I'm using both SQL and Java. Now, in Java, is there a way I could find out if a table exists in my SQL database? Do I have to write a query for this?

    ITKE413,725 pointsBadges:
  • Editions of SQL Server

    What are different types of editions available for different versions in SQL Server?

    shirishaneelam185 pointsBadges:
  • Ipnat.sys related error on Win2003 Server

    Happy 2006 to you all! One of my customers is getting a strange error since someone disabled (deleted actually!!) the Terminal Server service on their Windows 2003 Server SP1. The error that pops up is: "Windows Firewall cannot run because another program or service is running that might use the...

    Hedgehog0 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