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

    ITKE346,285 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,...

    ITKE346,285 pointsBadges:
  • Exporting a SQL database to MySQL

    I have a MS SQL .BAK database that I need to convert to MySQL. I was able to import the database but not actually export to MySQL. A friend of mine told me to use MySQL Migration Toolkit but it's been replaced by MySQL Workbench. Can I use this tool to migrate the database? Or is there another way...

    ITKE346,285 pointsBadges:
  • Earning Badges Pays Off – Literally!

    We told you that payoffs were coming, and they're finally here! To kick off this exciting new phase of the IT Knowledge Exchange Badge Program, we're doing a site-wide reward for members who have been active within the past 6 months and have earned at least one badge: $10 Amazon.com gift card to...

    MelanieYarbrough6,345 pointsBadges:
  • Indexes and abstracts in SQL Server

    In regards to a SQL Server, what is an index? Also, what is an abstract, and could you please explain the types of both of these items?

    SQL Server Ask the Experts2,585 pointsBadges:
  • Is it possible to replace a string in a SQL Server table?

    We have a SQL Server table which references different paths (UNC or otherwise) but we've just found out that the path is going to change. In our path column, we have many records and we need to change a portion of the path (not the entire thing). We also have to change the string to the new one as...

    ITKE346,285 pointsBadges:
  • Create credential

    I need to create a credential,and a proxy for my Jr. dba to support and troubleshoot production SSIS and SQL jobs. I want to create a credential/proxy that follows best practice and can be implemented as a standard across environments. Can you give me an example of a credential that has sufficient...

    Maura d'ae0 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.

    ITKE346,285 pointsBadges:
  • Clustering in SQL Server 2005

    What's the steps to use (Clustering ) in any SQL Server 2005 System??

    ScorpionSQL10 pointsBadges:
  • Free working space on primary hard disc

    when large files (*.mdb, *.mdf) stored on server are opened on client PC - where do they open - client's memory or server memory? - I check properties of C: to check free space available - but after opening few large files, I do not see any change in property window of C: for free space available....

    Vinodmerch15 pointsBadges:
  • How to mark a DTS package as complete even if it errors.

    I want to be able to mark a DTS package as though it completed, even if a particular task within it errors off. In other words, if a task errors off just because a file doesn't exist, I will email myself (which I know how to do) but I want the package to exit and mark it as 'complete'. The reason...

    MISProg5 pointsBadges:
  • Backing up a SQL Server 2005 database on SQL Server 2000 EE

    I have created a large database in SQL Server 2005 Developers Edition, and I intend to put my backup on SQL Server 2000 Enterprise Edition. Is there an easy way to go about this procedure?

    SQL Server Ask the Experts2,585 pointsBadges:
  • What is the difference between RAM and Cache Memory in SQL Server 2005?

    What is the difference between RAMĀ and Cache Memory?

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

    ITKE346,285 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...

    ITKE346,285 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!

    ITKE346,285 pointsBadges:
  • Setting “SendAs” permission for SSRS

    I need to set the "Send As" permission for Report Server Windows Service so my SQL Server can send reports by email. How is this accomplished?

    rdbarnes5 pointsBadges:
  • How to we keep track of our stored procedures using a source control system?

    We currently use SQL Server at our company and we're looking to find out if we should keep track of our stored procedures / database schema in our source control system. For example, when we make a change to one of our tables, how do the changes get into the source control? Thank you for your help!

    ITKE346,285 pointsBadges:
  • What new features would you like to see on ITKnowledgeExchange.com?

    Members We are always looking for ways to make finding answers and communicating with peers easier on this site. With that said I would love to hear from you on what features you think would make this site better. Some ideas could be to promote users Knowledge points more, allow more senior users...

    ITKE346,285 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!

    ITKE346,285 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