• Why is SQL Server Management Studio taking so long?

    We're trying to do some offline maintenance work on one of our development databases but the "Take Offline" command (through SQL Server Management Studio) is working very slowly. We have no idea what might be causing it to run so slowly. There are no open connections too. Any ideas why this is...

    ITKE352,420 pointsBadges:
  • Checking if a view exists in our SQL Server database

    We have some SQL code that will only be executed if a certain view exists in our SQL Server database. How can we actually check if the view exists? Thanks!

    ITKE352,420 pointsBadges:
  • SQL Server database: Checking which locks are held on table

    I know this an older version but I'm using SQL Server 2005 and I'm trying to check what database locks are applied on rows against a query batch. Is there some tool that will help me highlight table row level locking in real time? Appreciate the advice.

    ITKE352,420 pointsBadges:
  • What’s the best way to check if a database exists on SQL Server

    I understand they're probably different ways to do this but I'm looking for the best way to check to see if a database exists on a SQL Server using T-SQL. Thanks for the help.

    ITKE352,420 pointsBadges:
  • How can we store hours and minutes in a SQL Server database?

    My partner and I would like to store times in our SQL Server database but we only need to store hours and minutes. We already know we could use "DATETIME" and ignore the rest of the data but is there an easier way to do this? Thanks so much.

    ITKE352,420 pointsBadges:
  • Can I version my SQL Server database?

    I'm trying to get several of my SQL Server databases under version control. Would anybody have some advice on how I should do this? Basically, I'll want a large collection of generated test data for performance management. Thanks so much!

    ITKE352,420 pointsBadges:
  • SQL map error message

    Hello there, on my college website, I got a vulnerable link which is a link of a photo. When I use SQL map with this link, everything works correct. I get to see database and dump even file,but after some time like 5 mins, I get a error like this....

    atulblackshell125 pointsBadges:
  • Database counters in performance in SQL Server

    Hi, This is praveen and I'm working as a performance tester. I am using Windows 7 OS. By default I got the .NET counters in performance, assuming that while installation of LR these will come, but I'm unable to find SQL server counters in performance. If we install SQL Server in my system, will I...

    Manchu5 pointsBadges:
  • How can I open the database of Microsoft SQL Server 2005?

    Actually I have a system and I use the Microsoft SQL Server 2005 for the Database. Can anybody help me. Thanks.

    Gregtf5 pointsBadges:
  • Do extra spaces affect disk space size?

    I currently have over 147 columns in a SQL Server database (with the majority of them as VARCHAR). This data is imported from our agency and for extra fields, they all include spaces in the field instead of entering an empty string / NULL. I just ran a script that would covert all those columns to...

    ITKE352,420 pointsBadges:
  • Errors in creating database in SQL Server

    While creating a database in SQL Server I got error as: an exception occured while executing a transact-sql statement or batch microsoft.sqlserver,express.connection-info create database permission denied in database master Can anyone tell me how to proceed?

    velankinipriya5 pointsBadges:
  • SQL Server 2000 Database Table Limit?

    Is there a limit to how many tables a single database can hold in SQL 2000?

    Xarly25 pointsBadges:
  • Running a query on both SQL Server and Oracle databases

    How do I run a query that queries a SQL Server database and an Oracle server database, on two different servers, and uses all the data?

    SQL Server Ask the Experts2,585 pointsBadges:
  • Backing up SQL Server 2005 databases to a tape drive

    I am currently running SQL Server 2005 and I’ve set up a maintenance plan that backs up my databases to the disk. I'd like to change that and backup my databases to a backup tape drive that's attached to a backup server. Can this done, and if so, how?

    SQL Server Ask the Experts2,585 pointsBadges:
  • Script to restore database permissions during a migration to SQL Server 2005

    We are in the process of migrating from SQL Server 2000 to SQL Server 2005, and I'm searching for a script that can transfer and restore the database permissions of all accounts from SQL Server 2000 to SQL Server 2005. I used sp_help_revlog to restore the logins, but I still have to restore the...

    SQL Server Ask the Experts2,585 pointsBadges:
  • How to connect my application using Visual Studio 2005 to a SQL Server database?

    how to connect my application using visual studio 2005 to a database using sql server?

    MissVeryLittleKnowledge5 pointsBadges:
  • Recovering a deleted database in SQL Server 2005

    I've accidentally deleted a database on SQL Server 2005, and I do not have a backup. Is there any way to recover it?

    SQL Server Ask the Experts2,585 pointsBadges:
  • Improving performance on a large SQL Server database

    We have a very huge SQL Server database, with approximately 700GB of data. Due to this, queries are running very slow. Could you please suggest few tips to improve performance?

    SQL Server Ask the Experts2,585 pointsBadges:
  • Acquiring the AdventureWorks database for SQL Server 2005

    How can I get the AdventureWorks database for SQL Server 2005 SP1?

    SQL Server Ask the Experts2,585 pointsBadges:
  • Merging the MDF and NDF files of SQL Server databases

    How can i merge the MDF and NDF files of SQL Server databases?

    SQL Server Ask the Experts2,585 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.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following