• 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:
  • 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.

    ITKE409,400 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?

    ITKE409,400 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.

    ITKE409,400 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?

    ITKE409,400 pointsBadges:
  • Editions of SQL Server

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

    shirishaneelam185 pointsBadges:
  • Rename SQL database table

    For my SQL database, I have to rename one of my columns. What's the process to do that? Will a specific query work for this? I just have to change the name.

    ITKE409,400 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?

    ITKE409,400 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:
  • SQL database rollback query

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

    twatonny015 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:
  • Remove last character in T-SQL string

    Is it possible to remove the last character in a T-SQL string? So for example, I have this: STRING I want to have this: STRIN Thanks!

    ITKE409,400 pointsBadges:
  • Remove spaces from SQL Server 2008 string

    For SQL Server 2008, is there a way I can remove all of the spaces from a specific string? I already tried LTRIM but that only removes the spaces in the right / left (not the middle). Thanks!

    ITKE409,400 pointsBadges:
  • Is it a good idea to store images on SQL Server?

    My friend and I are working on a demo site and we're storing images inside an image column using SQL Server. Is this a good thing to do? If not, what should I do? Will it affect performance on the site?

    ITKE409,400 pointsBadges:
  • How can I install SSMS 2012 Express?

    I recently installed SQL Server 2012 Express on my local machine. I'm able to access my database using VS2012RC. Everything is working great but when I tried to install SQL Server Management Studio 2012, the unpack installer has stopped. Why is this happening?

    ITKE409,400 pointsBadges:
  • Query database sizes in SQL Server 2008 R2

    I'm using SQL Server 2008 R2 that has over 500 databases. What would be the easiest and most efficient way to query databases of all sizes. The output should have the following columns:DatabaseNameDataFilesSizeLogFilesSizeThanks for all the help!

    ITKE409,400 pointsBadges:
  • How to script entire SQL Server database

    Does anyone know if there's a possible way to get a script of an entire SQL Server database? I'm taking about columns, tables, stored procedures, etc. Thank you.

    ITKE409,400 pointsBadges:
  • Store IP address in SQL Server

    Is there a specific datatype I should use for storing my IP address in SQL Server? Furthermore, when I select the datatype, will it be easy to filter my IP address?

    ITKE409,400 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