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

    ITKE1,004,635 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!

    ITKE1,004,635 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...

    ITKE1,004,635 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.

    ITKE1,004,635 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...

    ITKE1,004,635 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?

    ITKE1,004,635 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?

    ITKE1,004,635 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.

    ITKE1,004,635 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?

    ITKE1,004,635 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.

    ITKE1,004,635 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?

    ITKE1,004,635 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!

    ITKE1,004,635 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?

    ITKE1,004,635 pointsBadges:
  • T-SQL command to make SQL Server sleep

    Would anyone happen to know if there's a T-SQL command that would make SQL Server sleep for some time (particularly several hours)? We're working on a web service that we want to test - to see if asynchronous pattern is scalable. For that to happen, we have to call a SQL Server with a script /...

    ITKE1,004,635 pointsBadges:
  • Convert SQL Server 2014 database to 2012

    Does anyone know of a way to convert SQL Server 2014 database to 2012? I tried the Generate Script but I have too much data and SSMS didn't go through with it. Thank you very much

    ITKE1,004,635 pointsBadges:
  • SQL Server database list of name for tables

    On SQL Server, is there a way I can get the list of names for all of my tables in a specific database? Please note that this is for SQL Server 2008 or 2012. Thanks!

    ITKE1,004,635 pointsBadges:
  • Clearing SQL Server transaction log

    We currently have a testing database in SQL Server (there's not much in it - just a bit of data). However, our transaction log is pretty large. How can we clear that out? Thanks!

    ITKE1,004,635 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