• Experience applying SP4 to SQL 2005?

    Hi, I have a Microsoft SQL 2005 SP3 database server with 2 instances (both patched to SP3.) The one instance (1a) includes 52 small production databases. The other instance (1b) includes 2 large production databases. Now I would like to upgrade the (1b) instance to the new Service Pack 4. The way I...

    CarlMarius15 pointsBadges:
  • Is it possible to randomly select rows in a SQL Server database?

    I've been using SQL Server 2005 and in my database, I have a table labeled "customerNames" which has two different columns (ID and name). It has around 1,000 results. I've been trying to create a function that allows me the capability to select five different customers randomly every time. Would...

    ITKE350,890 pointsBadges:
  • Pulling a list of triggers in a SQL Server database

    I'm trying to get a list of triggers in a SQL Server database with the table name and the table's schema. Here's what I have so far: SELECT trigger_name = name, trigger_owner = USER_NAME(uid),table_schema = , table_name = OBJECT_NAME(parent_obj), isupdate = OBJECTPROPERTY( id,...

    ITKE350,890 pointsBadges:
  • Can we have multiple primary keys in a single table on a SQL Server database?

    For our database, is it possible for us to have multiple keys in a single table? We're using an SQL Server database.

    ITKE350,890 pointsBadges:
  • SQL Server database: How to interpret precision and scale of a number

    We have this column in our SQL Server database: decimal(5,2) but we're not sure how to interpret this. When we're looking at it through SQL Server Management Studio, we can see what it means: decimal(Numeric precision, Numeric scale). What does precision and scale mean in real terms?

    ITKE350,890 pointsBadges:
  • SQL Server database: Inserting a table using the input from another table

    I've been trying to insert a table using the input from one of our other tables. I know this is possible but I'm having trouble with the correct Syntax for the SQL engine of the day. Would anyone know of a silver-bullet syntax coming from a SQL standard that would allow us insert the values without...

    ITKE350,890 pointsBadges:
  • What’s the best way to connect and query my database for a set of C# records?

    I need some big time help with my database. What's the best way to connect and query my database for a set of records in C#? Please note that this is for a SQL Server database. Thank you!

    ITKE350,890 pointsBadges:
  • SQL Server: Creating a view in a database

    I'm fairly new to SQL Server so I'm wondering why I need to create a "View" in it? Wouldn't it make more sense to to just run a normal stored procedure? Thank you very much!

    ITKE350,890 pointsBadges:
  • 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...

    ITKE350,890 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!

    ITKE350,890 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.

    ITKE350,890 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.

    ITKE350,890 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.

    ITKE350,890 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!

    ITKE350,890 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...

    ITKE350,890 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:
  • How can I restore a database from .mdf file?

    How can I restore a database from .mdf file? I only have .mdf backup file.

    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