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

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

    ITKE435,855 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!

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

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

    ITKE435,855 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!

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

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

    ITKE435,855 pointsBadges:
  • Find current SQL Server database transaction level

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

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

    ITKE435,855 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!

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

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

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

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

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

    ITKE435,855 pointsBadges:
  • See all active SQL Server 2008 connections

    I'm using SQL Server 2008. I'm looking to see all of my active connections (and their data). This includes: IP address, database connections, etc. How can I do that.

    ITKE435,855 pointsBadges:
  • Disconnect active connections to force SQL Server backup through

    On SQL Server, I noticed that it doesn't restore my backup due to all of the active connections. Is there a way to force it through? If not, how can I disconnect all the active connections?

    ITKE435,855 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