• 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!

    ITKE413,320 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!

    ITKE413,320 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?

    ITKE413,320 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?

    ITKE413,320 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!

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

    ITKE413,320 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?

    ITKE413,320 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!

    ITKE413,320 pointsBadges:
  • Storing passwords in SQL Server database

    What's the best way to store my passwords in a SQL Server database (it's actually for 2008 and 2012)? For the past few years, I've been using a .NET encryption library, followed by storing them in the database. Should I continue with this method or figure something else out?

    ITKE413,320 pointsBadges:
  • Find SQL Server 2008 port

    Over the past few months, I've been running SQL Server 2008 on my machine. My default port is 1433 but it's currently not listening at this port. I still can't find it - I tried SSMS and registry but nothing is working. What can I do?

    ITKE413,320 pointsBadges:
  • Find current SQL Server database transaction level

    How can I find the current SQL Server database's transaction level? Thank you very much

    ITKE413,320 pointsBadges:
  • Recover unsaved scripts after SSMS crash

    Our SSMS just crashed and I have to recover a bunch of unsaved scripts. Is there a way to do that? Any help is appreciated.

    ITKE413,320 pointsBadges:
  • How can I get a list of SQL Server queries that are running?

    Would anyone happen to know if there's a way I can get a list of queries that are currently running on my SQL Server? I noticed that I have a large query that's running on one of my database servers and I have to stop it. Thanks!

    ITKE413,320 pointsBadges:
  • How do I run and import a large .SQL file?

    I've been using RedGate Software for SQL data comparisons and it turns the data into a .SQL file (this is for running on another machine). Here's my issue: It's a pretty large file so copying and pasting won't work and when I try to open it in SSMS, I always get the error message that it's too...

    ITKE413,320 pointsBadges:
  • SQL Server: Store file details in a temporary new table

    I have three tables with foreign key constraints in that I will stored file details and user details but I want to delete the file details and after deleting I want to store that details in temporary new table.

    NitinSolunke5 pointsBadges:
  • SQL paramaters

    How do I input a date for query to an SQL database from Visual Studio.

    Jerrymack25 pointsBadges:
  • Making SQL Server Management Studio composite key

    Can I make a composite key with SSMS (SQL Server Management Studio)? I need to have two INT columns that are needed to form the identity for one of my tables. Thank you so much.

    ITKE413,320 pointsBadges:
  • Check to see if SQL Server login exists

    Can I check if a specific login exists on SQL Server? And if it doesn't exist, I actually have to add it too. Here's the code I found to add it: CREATE LOGIN [myUsername] WITH PASSWORD=N'myPassword', DEFAULT_LANGUAGE=[us_english], CHECK_EXPIRATION=OFF, CHECK_POLICY=OFF GO But how can I check if...

    ITKE413,320 pointsBadges:
  • Set auto increment key in SQL Server database table

    For my SQL Server database table, is there a way I can auto increment the primary key? I tried to go into properities but I'm not seeing anything. A co-worker told me about the identity specification property -> set it to yes but I'm not seeing that at all. Can someone help me?

    ITKE413,320 pointsBadges:
  • Select data from two different servers in two SQL Server databases

    Is there a way I can select data, in the same query, from two different SQL Server databases that are on two different servers? How can I do this?

    ITKE413,320 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