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

    ITKE827,860 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?

    ITKE827,860 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?

    ITKE827,860 pointsBadges:
  • Find current SQL Server database transaction level

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

    ITKE827,860 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.

    ITKE827,860 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!

    ITKE827,860 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...

    ITKE827,860 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.

    ITKE827,860 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...

    ITKE827,860 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?

    ITKE827,860 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?

    ITKE827,860 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.

    ITKE827,860 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?

    ITKE827,860 pointsBadges:
  • Truncate SQL Server log file

    My boss asked me to empty our LDF file before I send it to one of our clients. Is there a way I can force SQL Server to truncate my log? Thank you very much.

    ITKE827,860 pointsBadges:
  • SQL Server 2008 condition in case

    Hi, I have a condition (with a parameter named @Par1=IS NOT NULL) in query like this select * from table1 where Numeric field1 IS NOT NULL. It runs okay but where numeric field1 =@Par1 it, it doesn't work. Another example: @A= '>0' and @invcode = 1 @InvCode INT, @A nvarchar(20) SELECT GoodCode,...

    saeedtalebi5 pointsBadges:
  • Change column from VARCHAR to NVARCHAR in SQL Server

    Would it be possible for me to change a SQL Server column from VARCHAR to a NVARCHAR? Is there a specific SQL command to do this?

    ITKE827,860 pointsBadges:
  • How can I rename a column in a SQL Server 2008 table?

    In one of SQL Server 2008 table columns, I have to go ahead and rename it. How can I do that? I've tried this but it didn't work: ALTER TABLE table_name RENAME COLUMN old_name to new_name; Thanks!

    ITKE827,860 pointsBadges:
  • Move table into schema in SQL Server 2008

    I'm currently using SQL Server 2008 and here's my issue - I'm trying to move my table into a specific schema using T-SQL. I can't figure out how to do it. Can someone help me?

    ITKE827,860 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