• How to create SQL Server database programmatically

    How can I go about creating a SQL Server database programmatically? I don't want to use SQL Server Management Object API. Is there another way to do it?

    ITKE435,985 pointsBadges:
  • Compare columns in two SQL Server tables

    I just did a SQL Server migration from an old version to the newest one but I've run into a few issues. Is there a query out there that could compare columns in two different tables? I have to compare the actual columns - not the data. Can someone help me?

    ITKE435,985 pointsBadges:
  • Error message when entering data into SQL Server database

    For the past few days, I've been trying to enter my data into my SQL Server database but I keep getting this error: Invalid column name. Is there any reason why I'm getting this error?

    ITKE435,985 pointsBadges:
  • 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.

    ITKE435,985 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.

    ITKE435,985 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.

    ITKE435,985 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...

    ITKE435,985 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.

    ITKE435,985 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.

    ITKE435,985 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.

    ITKE435,985 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?

    ITKE435,985 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?

    ITKE435,985 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:
  • Find biggest tables and rows in SQL Server database

    I'm using SQL Server and I'm trying to find the biggest objects in my database. Basically - I have to find the largest tables, followed by which rows (in that table) are the largest. Is there a tool to do this? Can I run some sort of query?

    ITKE435,985 pointsBadges:
  • How to split and later reunite a large MS SQL table

    Sir I am stuck in a logic. I have dynamic tables. Let's say one large data Big_Table is stamped with profile 1,2,3,....n So I create table profile1, profile2,... profilen (example profile1 :- select * from Big_Table where rule = profile1) table data example :- table_profile1 transaction_id profile...

    AshishMishra95605218565 pointsBadges:
  • System and user defined databases

    One of my user defined database (test1) is showing with system databases. How do I delete it or move it from system databases?

    fahimg5 pointsBadges:
  • Update table in Database through linked server

    I want to update my TableA on my ServerA by using linked server which is on serverB.I have successfully created the linked server but i am a little bit confused. Actually i have to update a columnA of TableA from the data coming from columnB(TableB) of linked server on the basis of the matched...

    hussainahmad15 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