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 [...]
Answer Question | July 8, 2008 3:45 PM
Access 2003, Microsoft Access, SQL Server 2005, SQL Server Express
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?
Answer Question | July 8, 2008 8:57 AM
Database design, Microsoft Excel, tables
can any one help me what is the difference between external described datastructure and program described data structure and what is the use of external data structure and, can i use variables of external data structure in another program
Answer Question | July 8, 2008 8:28 AM
AS/400, Data structures, RPGLE
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 [...]
Answer Question | July 7, 2008 6:32 AM
Database, detailsview.findcontrols(), VB.NET, VB.NET 2005, Visual Basic .NET
I have a .dbf file from my dental software (FOXDENT V7.0B) MS DOS program that allows the printing of a standard 1994 American Dental Association form. HIPPA is now requiring the 2006 format- Mostly the government and Medicaid forms. Can anyone help me with this conversion as this software has worked perfectly for me since [...]
Answer Question | August 9, 2008 9:05 PM
Database, FoxDent, FoxPro, FoxPro 2.6, HIPAA, Printing
Greetings all, As my orgaization begins the planning phase of a data warehouse implementation, I’d imagine it would be a true benefit to have a roadmap of an actual DW implementation in order to make certain all areas are addressed. Does anyone have a complete DW in MS Project form? Many thanks! Da Celt
Answer Question | June 23, 2012 12:56 PM
Business Information Warehouse, Data management and storage, Data warehouses, Data warehousing applications, Database engineering, DataManagement
Working with Analysis Manager Version: 8.00.194, my Sales cube looks good until I try to browse the data that comes from Foodmart 2000.mdb. Is this because Access is required?
Answer Question | September 20, 2008 5:10 PM
Analysis Manager, Database, Microsoft Access, SQL Server
I am using an append query to add data to a table. The query works except I have an autonumbering field and am not including it in my query because I want to continue the autonumbering in the table I am adding data to. The only problem is, is that the autonumbering is beginning from [...]
Answer Question | July 8, 2008 7:32 PM
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 [...]
Answer Question | July 3, 2008 3:44 PM
Microsoft Access, SQL Database, SQL Server 2005
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?
Answer Question | July 4, 2008 5:49 PM
Database, Query, SQL, SQL Query, SQL Server
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?
Answer Question | July 2, 2008 5:36 PM
Index, Primary keys, SQL performance, SQL Server 2005
Hello all .. I am doing an Internship with a company in Nashville that does community branding. Recently I received a project to design a database which would house all of the information that we would need to show to potential clients to gain their business. Such as particular information about different years growth statistics [...]
Answer Question | July 31, 2008 5:33 PM
Data analysis, Data Junction, Data management and storage, Data warehousing applications, Database design, Database issues
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 [...]
Answer Question | July 4, 2008 3:52 PM
Database backup and recovery, Indexes, LIVE database, SQL Server 2000
If I try and DROP a table that does not exist the RUNSQLSTM will fail. Is it possible to monitor for this in the RUNSQLSTM so it won’t fail?
Answer Question | May 3, 2010 10:03 AM
DROP, RUNSQLSTM, tables
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 [...]
Answer Question | July 2, 2008 3:59 AM
Active Directory, Lotus Notes, Lotus Notes 6.x, Schema, Windows Server 2003, WSH scripts
Is there a quick way to find the total size of each database on SQL Server 2000 and SQL Server 2005? I have tried running “sp_spaceused”, but I do not want to run it manually for each database. Do you have any ideas?
Answer Question | July 1, 2008 8:09 PM
Database, SQL Server 2000, SQL Server 2005
I have a follow-up question to the article Navigate hierarchies using recursive common table expressions. I have an employee hierarchy that follows a similar pattern to the article, but I need to be able to sort my data alphabetically within each level. Do you have any advice on how to accomplish this?
Answer Question | September 9, 2008 8:02 PM
Hierarchy data, Sorting, SQL Server 2005
When i link tables with a ODBC driver then some table won’t give me any records (I link into microsoft access. But I do see the column headings. I the record fields I get: #Name? Is this an AS400 problem, ODCB or Access ?
Answer Question | May 3, 2010 4:14 PM
AS/400 errors, Microsoft Access, ODBC
Does anyone have BizTalk interview Questions available?
Answer Question | July 13, 2008 10:25 AM
BizTalk, Career development, Interview questionaire, IT careers
i have done MCSE but now a days IT feild its good for longer so i would lik to join sap classes which ever best for me im from networking feild
Answer Question | July 2, 2008 4:08 AM
IT careers, SAP careers, SAP certifications