• 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,365 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,365 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,365 pointsBadges:
  • Editions of SQL Server

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

    shirishaneelam185 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:
  • 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,365 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,365 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,365 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,365 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,365 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,365 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,365 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,365 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,365 pointsBadges:
  • SQL Server 2008: Maximum number of characters for NVARCHAR

    In SQL Server 2008, I just declared one of my columns as type NVARCHAR (Max). What would be the maximum number of characters for the NVARCHAR? Thanks!

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