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

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

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

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

    ITKE435,985 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 /...

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

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

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

    ITKE435,985 pointsBadges:
  • Disable SQL Server foreign key restraints

    For SQL Server, is there somehow I can disable the foreign key restraints? If not, is my only option to drop / re-create the restraints? Thanks so much

    ITKE435,985 pointsBadges:
  • SQL Server browser won’t start

    For some reason, I can't start my SQL Server browser from SSCM 2008. I can't find a way to start it at all (no options available to me). As of right now - it says it's disabled. Can I restart the service?

    ITKE435,985 pointsBadges:
  • Backup and restore SQL Azure database

    I have a SQL Azure database that's roughly 40 GB and when I'm backing it up and restoring it, it takes roughly 6-8 hours. Is there a way to make it faster? If so, what's the process?

    ITKE435,985 pointsBadges:
  • Reset password for SQL Azure account

    I just created a new SQL Azure account. I'm able to get into the 'manage' page as an administrator but there's one big issue: I forgot the password to one of the databases! I'm looking to reset that password - is there a way to do that? Thanks!

    ITKE435,985 pointsBadges:
  • Copying SQL Azure database to development machine

    I'm looking to copy my SQL Azure database to my local development machine. I already have a development database in the cloud but don't want to pay for it anymore. I have copied by production database to the new development database but I need that same one on the local machine. How can I go about...

    ITKE435,985 pointsBadges:
  • Oracle 10g CONTINUE keyword for T-SQL stored procedure migration

    I'm looking to migrate a T-SQL stored procedure to PL/SQL but I'm constantly running into one particular issue. I noticed that there isn't a CONTINUE keyword for Oracle 10g. Is there a workaround for this? My friend told me to just upgrade but I can't do that right now.

    ITKE435,985 pointsBadges:
  • Three ways to login in to SQL database server?

    Does anyone know what are the three ways to login in to SQL database server?

    melbourne5 pointsBadges:
  • How to take a table-level backup in SQL Server 2008

    Does anyone know how to take a table-level backup in SQL Server 2008? Can we use the backup database command? Thank you!

    ITKE435,985 pointsBadges:
  • Deleted SQL Server 2005 database

    Hi, actually I know the importance of backup, but I don't have the back up in any-how condition. Accidentally the database deleted by me. How do I recover it? How to use the transaction.log file to restore deleted database in SQL Server 2005?

    Lalit35 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