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

    ITKE345,295 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.

    ITKE345,295 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.

    ITKE345,295 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.

    ITKE345,295 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!

    ITKE345,295 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...

    ITKE345,295 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:
  • 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:
  • 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:
  • Issues rebuilding system database on SQL Server Express 2005

    I am having some trouble rebuilding the system databases on my SQL Server Express 2005 instance. While I have had a total system failure, the backups have been good. I have restored the operating system but obviously there are no SQL system databases present (they were open at the time of the...

    SQL Server Ask the Experts2,585 pointsBadges:
  • Java Code to Copy AS400 file to SQL Server database/table

    I need Java code to access and copy an AS400 file to SQL Server database/table. It must also copy a specific amount of records from the SQL Server side. 

    IRob5 pointsBadges:
  • Create a database in SQL Server 2005

    Create a database in sql server 2005 but database name passed as parameter into a stored procedure

    Let5 pointsBadges:
  • Connecting to SQL Server from an Oracle procedure

    We need to pull data from a SQL Server database, and our database is Oracle. How would I connect to SQL Server from an Oracle procedure?

    SQL Server Ask the Experts2,585 pointsBadges:
  • SQL Server 2005 database mirroring over a VPN router

    Can SQL Server 2005 database mirroring work if the mirror server is to be in another building with the networks connected via VPN router?

    SQL Server Ask the Experts2,585 pointsBadges:
  • Notification change in SQL Server 2008

    Now, I have an application in SQL Server 2008 that consists of a database and several services. One of the services adds information to the database (which is triggered by a user).Another service queries the databases for changes and uses the new data for processing.I used a configurable timer that...

    ITKE345,295 pointsBadges:
  • Query database sizes in SQL Server 2008 R2

    I'm using SQL Server 2008 R2 that has over 500 databases. What would be the easiest and most efficient way to query databases of all sizes. The output should have the following columns:DatabaseNameDataFilesSizeLogFilesSizeThanks for all the help!

    ITKE345,295 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