• Designing Table Layout

    Hi, I am doing very simply frequencies and descriptives but wondered if I can design the layout of the output table myself rather than exporting to Excel and copy pasting a million times...can anyone help?

    CMS5 pointsBadges:
  • VB.net download once per month

    I currently have a label that displays the current month as an int i.e July = 7. I have a database with a username primary key and field 1 - 12 for each month. Each field either has a 0 or 1. I can use a detailsview to with a datasource to view all of the months data belonging to the logged in...

    N7.green5 pointsBadges:
  • datamining SQL with access

    I have been asked by the sales department to datamine our SQL database and pull the names and e-mails of all our guests for the last few years for a contact list. I am new to SQL but have worked with access in the past. Using access, how do I set things up so that access will see the database...

    Daiishi0 pointsBadges:
  • Linked Servers????

    Hi everybody, I'm an IT student and i'm doing professional practices. A simple project was assigned to me. This company uses SMS to collect information of all his PC's and stores this information in a MSSQL database. A manager checks this information and fills another database located in another...

    EVX5 pointsBadges:
  • Creating and importing data into a relational database

    I just started programming six months ago. I have a project to import data into a relational database. I have data in an Excel file that I need to import into a database. The application is recruiting software, for government jobs. I have a list of applicants and the jobs they applied for. First, I...

    SQL Server Ask the Experts2,585 pointsBadges:
  • Optimizing Query

    Hi, I am having a table which is having around 170 Columns(Don't blame me but my Developer) and there are only 989 records in the table.I created all sorts of Indexes but still the query (Select * from Table) takes almost 2 mins to display 989 records.I need all the columns to be displayed.Is there...

    Sachin VCO15 pointsBadges:
  • Archiving databases on SQL Server 2000

    Could you help me to estimate how long it takes to archive 400 GB records from one of our test databases located on SQL Server 2000? Also, what would be the best approach?

    SQL Server Ask the Experts2,585 pointsBadges:
  • Database migration from SQL Server 2000 to SQL Server 2005

    I am attempting to migrate a database from SQL Server 2000 to SQL Server 2005; the size of the database is almost in terabytes. During migration, I would like to interact with the database on the SQL 2000 server. Is it possible to achieve migration without detaching the database from SQL 2000? If...

    SQL Server Ask the Experts2,585 pointsBadges:
  • Backing up and restoring a LIVE database in SQL Server 2000

    I am using SQL Server 2000, and I backup and restore my LIVE database to a new backup server every night. Do you have any ideas as to why my restored database runs slow when compared to the LIVE database? Do I need to rebuilding indexes? Is there any way of backing up indexes as part of the main...

    SQL Server Ask the Experts2,585 pointsBadges:
  • Looking for a database name query in SQL

    Is there a query in SQL that could return me the name of a database, or whether it is connected to SQL Server or Oracle?

    SQL Server Ask the Experts2,585 pointsBadges:
  • SQL Server 2005 within MS Access VBA

    I have am MS Access (VBA) program where I need to create a table on a SQL Server database then append data to the table. I have the code that generates the update query but I need the ADO code that creates the connection to the SQL Server 2005 database then I need the code that will execute the...

    Rjwilcox45 pointsBadges:
  • Including a primary key in a nonclustered index in SQL Server 2005

    The query optimizer for SQL Server 2005 is suggesting that we include a primary key as part of a nonclustered index. Is it OK to include that to increase SQL performance?

    SQL Server Ask the Experts2,585 pointsBadges:
  • DSN and DSN-Less Connection

    What is difference between DSN and DSN less Connection? Which is better to use and Why?

    Mkaaa15 pointsBadges:
  • Additional TAB in AD Service for Automation

    Do we have a way in that While adding a group for a user in active Directory it should pick a Mail from the Lotus notes as a proof and as a reason for adding that group to a user, it should store the details in one of the common attributes in AD service (like General Tab, Member Of, Organisation...

    Krishp10 pointsBadges:
  • Progress/400 with DB2/400

    Firstly I would like to thank to all that helped me on my doubt with AS/400. We migrated of Progress/400 version 9 for Progress/400 version 10, and now the access to the db2/400 is from ODBC. Can I improve the performance of AS/400 knowing that the tables generated by Genexus version 9 doesn't have...

    SILVARB440 pointsBadges:
  • Trouble opening an inaccessible table in SQL Server 2005

    A client of ours is running SQL Server 2005 with PS2 on Windows Server. His database size is about 5 GB. Every now and then something happens and one table (the most important) becomes inaccessible. When we try to open the table, it gives a “SQL time out” error. This sometimes happens twice a...

    SQL Server Ask the Experts2,585 pointsBadges:
  • Echo a variable in PHP which displays as a link

    hi, I have a number of variables that i pull from a mysql database. I want 1 of the variables to show as a link to a web page. i have tried the following code, which displays everything fine, except for the $url bit echo "<p>$djname $genre $biography <a href='/$url'> Profile</a>";...

    Whiteyoh15 pointsBadges:
  • Replication

    Is there any tool that can make some documents replicate faster than the others on the server.The issue overhere is that we have to trigger replication before the appointed time because of some particular documents.Is it possible to make replication faster on that such documents on the server?

    BELLS20 pointsBadges:
  • XML-INTO

    I'm trying to use XML-INTO with %XML to convert an XML document into a DB2 database file. The XML file has four levels of data with elements from each level that need to be used for the database record. Naturally, the relationships between the level are important, too. The levels are Header...

    GLinds0125 pointsBadges:
  • MDE to updating table in backend database

    I inherited a few databases which were created in Access 2000. I only have Access 2003 and I needed to make a new MDE file, I converted to Access 2003 then created the new MDE file. Now the problem is this, the new MDE won't write to the backend database.

    Herdine30 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