AR server
In SQL Server 2000 the only way to store data out of row is by placing the data in a column with the datatypes of TEXT, NTEXT or IMAGE.

View Answer   |  September 20, 2008  11:13 PM
AR server, CLOB, SQL, SQL Server 2000

must Access be installed to use Analysis Server
Shouldn’t need to have access installed, but it may not be pointing to the correct place.

View Answer   |  September 20, 2008  11:03 PM
Analysis Manager, Database, Microsoft Access, SQL Server

Microsoft Access in a Server
You would need to write some data replication functions into the local access databases to replicate the data. The odds of getting this done correctly without errors and without data collisions are slim. I would recommend upgraded the database from Microsoft Access to Microsoft SQL Server, or MySQL, or Oracle. This way you don’t need [...]

View Answer   |  September 20, 2008  9:31 PM
Access 2003, Client-server, Microsoft Access, VB, Visual Basic 6

Checking for a transaction isolation level in SQL Server Profiler
Look for the “SET TRANSACTION ISOLATION LEVEL” command in the profiler trace.

View Answer   |  September 19, 2008  6:11 PM
Isolation level, LINQ, SQL Server Profiler, SQL statements

Importing Data GAL entries into Access 2007
Not an entire answer, but a way to get you GAL into Access. Check <a href=”http://www.howtogeek.com/howto/database/access/export-exchange-global-address-list-to-access/”>here</a> and <a href=”http://www.tech-recipes.com/rx/2194/access_2007_import_global_address_exchange_server”>Here</a> for two options. GoodLuck ****************************************************************************

View Answer   |  September 18, 2008  6:53 PM
Access 2007, GAL, Global Address Lists, Microsoft Access

PERFORMANCE ISSUE while inserting bulk data in a blank table from 2 different tables
What does the execution plan look like? I would assume that you are missing an index on either or both tables. How do the indexes look like for these tables?

View Answer   |  September 18, 2008  6:43 PM
INSERT statement, SQL Server performance tuning

backup and recovery
While there are tools to convert one DB structure to another, The difficulty of doing so, or even the possibility of being able to do it at all would depend on both the version and type of DB software you are working with. <test> Good Luck *********************************************************************************

View Answer   |  September 18, 2008  3:08 PM
Backup & recovery, Database backup and recovery, Database migration, Oracle import/export

How can I define a flat file in RPGLE?
Here is an example. It is based on a file which has the same file/record/field name. This happens when you create the file with the CRTPF and a length value. <pre> Fmyfile uf e disk rename (myfile : myRecord) F prefix (m_) D mystring s 15 C read myfile C eval mystring = %subst(m_myfile : [...]

View Answer   |  September 17, 2008  4:32 PM
Flat files, RPG, RPGLE

Recovering the MySQL database
If you do now have a backup of the database you can restore the database is gone with no way to recover it. If the data in the database is important enough to you, data recovery companies may be able to get back some or all of the data, but they are very expensive.

View Answer   |  September 16, 2008  11:47 PM
MySQL, MySQL Query Browser, Recovery, SQL Server

SAP Career Advice
For beginers SAP BI is a good module to start with

View Answer   |  September 16, 2008  4:23 PM
Career development, IT careers, SAP careers

MS access Program / module
You could convert the entered number to a text string, and scan it from right to left, putting each number on the desired text box, starting from the units, tens, hundreds, and so on. Maybe somebody else can help with the string manipulation functions syntax in access. *********************************************

View Answer   |  September 16, 2008  3:22 PM
Database programming, Microsoft Access

Export to CSV or dump file
You can export both, database or specific tables to a dump file with the EXPORT utility. You could use this syntax: exp <username>@<host_string>/<password> file=<target_file_name> [tables=<comma_separated_list_of_Tables>] for example: – exports the complete database exp scot@test_db/tiger file=database_backup.dmp or – export specific tables exp scot@test_db/tiger file=database_backup.dmp tables=table_a,table_b,table_c Many more parameters exist for the EXPORT utility. You might want [...]

View Answer   |  September 16, 2008  2:28 PM
CSV, Export, Oracle 10g

Writing a specific query involving primary keys in SQL
You can use a query something like this to get the result you are looking for. <pre> SELECT TOP 1* FROM ( SELECT TOP (5) * FROM YourTable ORDER BY SomeColumn DESC ) a ORDER BY SomeColumn ASC</pre> SomeColumn is what ever column, or columns you need to use in order to get the values [...]

View Answer   |  September 16, 2008  12:16 PM
Primary keys, Query, SQL, SQL Query

securing sql server database object
Create a new login in the SQL Server, and give that login only the rights needed for the access project to work. For example if everything is done via stored procedures only grant the login execute rights to the stored procedures. If it needs select and insert access but not update and delete access to [...]

View Answer   |  September 15, 2008  8:41 PM
Microsoft Access, SQL Server database, SQL Server security

Cisco course and Networking job market outlook
It would be good if you post you current education qualification and the area where you are residing. As far as qulified and skilled network profesionals are concerned there is a huge demand for them. If you specialised in Voice, Switching and routing as well as security then there are plenty of oppurtunities.

View Answer   |  September 14, 2008  8:14 AM
Certifications, Cisco, Cisco certifications, IT careers, Networking careers, Networking certifications

IT career advice on CCNA and Masters degree
Well masters is always a better choice, it adds value to CCNA. When you have chance to join Masters I would prefer to do .

View Answer   |  September 14, 2008  8:11 AM
Career development, CCNA, Certifications, Cisco certifications, IT careers, IT education, IT jobs, Networking certifications

CCNA
CCNA has its value in the market if you are looking for a job into Networking field, if you want persue your career into sales field there are some certifications from Cisco specifically for sales guys. You can access more details from www.cisco.com With CCNA you can be a juniuor network administartor. Cheers Yasir

View Answer   |  September 14, 2008  7:45 AM
CCNA, CCNP, Certifications, Cisco certifications, IT careers, IT jobs, IT salaries, Networking certifications

Host Credentials
Unless Oracle is configured to use Active Directory it wants the Oracle credentials not your OS credentials.

View Answer   |  September 13, 2008  10:26 PM
Enterprise Manager, Host credentials, Vista compatibility

Common User Interface SQL Serve Management Console
SQL Server 2008 supports the use of a central management server. You can also export and import the server list from one machine and send it to others. I’ve often found that people are most productive when they organize the servers in a way which makes the most sense to them.

View Answer   |  September 12, 2008  11:06 PM
DBA, SQL Server 2000, SQL Server Enterprise Manager, SQL Server Management Console

SAP Consultant with 3 years experience
You will want to check a site such as Monster.com or Salary.com. They provide some regional salary data by job title. Salary information is hard to respond to online as salaries can vary widely depending on country and region within the country as cost of living varies as does the job market.

View Answer   |  September 12, 2008  2:31 PM
IT careers, IT salaries, SAP careers