• Not able to coonect to SQL Server 2005 from Front End in windows Vista Home Basic

    Im not able to connect to SQl Server 2005 installed in my local PC to .net application.But im able to open SQL server 2005 seperatley & able to create tables.Im getting connection failed error while trying to connect.Please give slution for this.

    Karanam5 pointsBadges:
  • Access 2007 form from a query

    I have an Access 2007 database that lists rules for specific types of systems. I've run the specific query to pull up the rules I need and put it in a form. The rules are un-editable and that is what I need but how do I get 1 field to be editable so the users can answer the questions posted by the...

    V-Ger5 pointsBadges:
  • MS Access conversion to CSV files

    I am using MS Access 07. Whenever I use the control to export the table as a .csv file, it changes all the fields properties, returning to the "text 255 cha" values. I need specifically to keep the same properties. I used to be able to do it and is not working now.

    Hsisan5 pointsBadges:
  • Sending MS Access reports in the body of an email.

    How to send a report in MS Access to the body of an email in MS Outlook.

    Rarto10 pointsBadges:
  • SQL Query

    I created a SQL query to restore several databases from a remote location to a test environment. I would like to add a check in the script so that it will not run if connected to certain servers so production databases are not accidentally overwritten

    Asdemers5 pointsBadges:
  • Need help with FILEAID in BATCH

    I'm new to FILEAID, so I'd be grateful for some sage guidance on FILEAID command syntax's and statement for use in a JCL. My problem is that Ihave a datafile which appears be a VB file type with a leading 2 character string ahead of my data. I'm trying (desperately) to create a work-around in order...

    Jonty Walker105 pointsBadges:
  • upgrade cisco aironet access point 1130 from autonomous to lightweight

    please how to upgrade cisco aironet access point 1130 from autonomous to lightweight , how can i do this step by step

    Cisco solutions5 pointsBadges:
  • open a file in access by clicking button

    I have several directory paths in a list box and I want to highlight one and double click on it and have it open the file

    Rmaylath25 pointsBadges:
  • Building A File Searching/ Tagging System

    Hello...I want to make something in VB (Version 9) that reads multiple data from specified file (Access 2007) and displays content in list box. If file doesn't exist, alert user. More description: My name is Steven, I'm a college student and now I'm running my practical session to complete my...

    Stevio10 pointsBadges:
  • Database Window Stuck Behind Title Bar

    When I open a specific database in Access, the Database Window is helplessly stuck behind the title bar. I've tried everything to get it out including closing and reopening, moving menus, everything. Here is a screen shot to show you what I mean: http://i35.tinypic.com/2mq7zux.jpg If anybody could...

    Makeshiftmonkey5 pointsBadges:
  • Refusal to recognize SQL Server 2005 Express on a client PC

    I have installed SQL Server 2005 Express with about 10 client PCs. I also have Microsoft Access 2003 on the front-end linking to it using System DSNs. On one of the PCs, it refuses to recognize the SQL Server when I try to create a DSN. It does, however, see a different SQL Server that was...

    SQL Server Ask the Experts2,585 pointsBadges:
  • 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:
  • 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:

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