• Querying database tables with their descriptions

    I want to query an SQL server database for specific tables and their descriptions. How do I do that? Is there a special tool needed to do this?

    Sheni5 pointsBadges:
  • empty fields in a query

    I have a column with answers that people responded to different questions about themseleves. I have another column with the question id that the answer corresponds to. i want to display the answers in separate columns based on which question it corresponds to. Each column should be filled with the...

    Bananahead60 pointsBadges:
  • SQL Server 2005 and Powerbuilder 6.0

    We currently use Powerbuilder 6.0 with SQL Server 2000. We want to upgrade to SQL Server 2005. Does anyone know if SQL Server 2005 is compatible with Powerbuilder 6.0?

    Jfel5 pointsBadges:
  • What are the steps involved in copying the website from production to preproduction server

    what are the steps involved in copying the website from production to preproduction server

    Sangeeth30 pointsBadges:
  • DATEDIFF – 1 year off

    I need to figure out age from a birthday. When I use the DATEDIFF function for year, the number of years is one year ahead if the birthday hasn't passed yet for this year. How can I get the accurate age based on the day and month of the birthday.

    Bananahead60 pointsBadges:
  • split column

    i need to take a column in my database and split it into different columns based on a question id. Basically i want to write a whole bunch of sql statements that are non related for one grid - a whole bunch of sql statements each with their own where statement

    Bananahead60 pointsBadges:
  • SAP SQL database cluster

    Hi Our sap configuration include two nodes on win 2003 cluster/ The cluster using us for SQL 2005 . I need to upgrade the hardware. It is possible to add two new nodes to the cluster ? It is downtime necessary if i want to replace one of the nodes ? it possible to install the sap software when the...

    Sabi1330 pointsBadges:
  • SQL order by Issue

    Please help me write this. I need a SQL where the order by is done based on a variable passed to the query.SELECT * FROM (SELECT distinct gl.group_id, gl.group_name, gl.group_description, gl.status_code, gl.member_count, (SELECT grpp.group_name FROM test_group_relationship grel JOIN test_group grpp...

    Rohit331225 pointsBadges:
  • Different Results on Insert Select than Select

    I'm struggling, along with others, where I'm getting different results when doing an Insert select verses just the select. Lots of joins to get data from various tables. Only want the first record from the uniqfield table so created the tmp_uniqfieldid table with that item fielded, creation_ts...

    Bem35 pointsBadges:
  • Create report using Reportingservice, from a selected record from Datagrid

    Is it posible to bind the data from a record to a report, by clicking on that record in a Datagridview. Please some example code. Thanks, Matthew

    Spin5 pointsBadges:
  • How do I limit my SQL output to one record per student?

    Current resuls: Student ID: Guardian 2 Joe 2 Mary 3 Goldie 4 JIm Needed results: Student ID: Guardian 2 Joe 3 Goldie 4 Jim

    Richieg5 pointsBadges:
  • Substract two fields SmallDateTime at SQL Server

    Hii.. IT Professional Helper, may i asked 1 question and hope IT Professional Helper can help me to answer my question? The Question is : Cm.CommandText = "Update Reminder Set IsDatang = 0, IsValid = 1 Where TglReminder - TglDatangKembali > 7" Cm.Execute If i get the error : Arithmetic overflow...

    Suryanto5 pointsBadges:
  • Developer Access to Sql2005 Management studio

    In sqlserver 2005, many tools were integrated into the management studio. How do you limit access to portions of the manaagement studio, such as only allowing devleopers access to the query analyzer, while allowing Administrators full access to all tools?

    Justadeveloper5 pointsBadges:
  • How can I reduce the size of an LDF file?

    How can I reduce the size of an LDF file?

    SQL Server Ask the Experts2,585 pointsBadges:
  • Tuning and viewing SQL Server reports

    I have developed several reports and deployed on the remote server. While running reports on a browser, it takes about 20 to 30 seconds, but when i browse the same on the remote server, reports get displayed in 5-8 seconds. Do I need to tune my server to enhance its performance, and how should I do...

    SQL Server Ask the Experts2,585 pointsBadges:
  • Import AS/400 files into SQL server

    Hi I would like to know how to create a job to transfer all the files (data) from AS/400 to SQL server 2005 (keep as backup)

    Yenyen5 pointsBadges:
  • SQL Server

    Thanks Carlosdl! You understand mychallenge. But i dont understand how to store the documents in the file system, and store the document’s path in a varchar field in the database. Please can you help by a step wise solution because i'm a starter. Thank you.

    Phunmie10 pointsBadges:
  • Oracle 10g process each record exactly on time multiple processes

    I have over 400 records added to a table in a minute. A processed flag is set in each record as they are processed. I want to process each record exactly one time. I want to process the records in small groups with multiple processes; that may run on disparate machines. It is desirable to process...

    Wileecanislatrans15 pointsBadges:
  • Small network setup

    Is there any good tutorials for a novice user to set up networking with sql server.I had 1 server running server 2003 and 2 vista workstations.

    Renulaks135 pointsBadges:
  • My DTS package runs normally, but hangs when run as a SQL Job

    Hi, I'm trying to run an Ms Access .mbd file through a MS SQL 2003 Server. The package runs normally and works when I start the job, but simply hangs when I run the package as a a scheduled job. I've designed a DTS local package as follows:...

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