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

    ITKE409,490 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 /...

    ITKE409,490 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

    ITKE409,490 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!

    ITKE409,490 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!

    ITKE409,490 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

    ITKE409,490 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?

    ITKE409,490 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?

    ITKE409,490 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!

    ITKE409,490 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...

    ITKE409,490 pointsBadges:
  • PowerBuilder 11 in SQL 2008

    We are seeing performance issues with our PB 11 app after SQL 2005 DB was migrated to SQL 2008. We did not change any code just the connection profile. From: [Profile APP] DBMS = SNC SQL Native Client(OLE DB) Database=database UserId= DatabasePassword= LogPassword= ServerName=SQLServerName LogId=...

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

    ITKE409,490 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!

    ITKE409,490 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:
  • Changing password on SQL Express 2008

    I recently installed SQL Server Express 2008 and I'm signing in using Windows authentication. But after that, I can't do anything. Is there a way I can change the password so I can have access? I'm also using Windows 7.

    ITKE409,490 pointsBadges:
  • How can I change SQL language and date format?

    I'm using an older version of SQL Server (2005 to be exact). So when I try to execute, DBCC USEROPTIONS, it's giving me a foreign language and the date format DMY. I need the language to be in English / format in MDY. Is there a way to change this? Thank you very much

    ITKE409,490 pointsBadges:
  • Can I restore my SQL Server 2012 database backup to SQL Server 2008?

    This probably isn't possible but can I restore my SQL Server 2012 database backup to SQL Server 2008? I'm assuming I can only go forward, not backup.

    ITKE409,490 pointsBadges:
  • Free online practice exercises on SQL/Oracle

    I would like to know is there any website which offers free practice exercises on SQL/Oracle queries? Preferably advanced level queries. Thanks, Kruti

    Kpatel0 pointsBadges:
  • Opening SQL Server ports

    I'm looking to open up my SQL Server port through a Windows firewall but I'm struggling with the process. Is there a way I can find the ports that SQL is running on so I can open them?

    ITKE409,490 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