SQL Access Query
I am using the book SQL for Microsoft Access. and the below statement is from the book and for some reasone I am getting a sytex error on the  word “Udate”     Why would that be?  CREATE TABLE Manufacture ( ManufactureID INTEGER CONSTRAINT ManfID PRIMARY KEY, ToyID INTEGER NOT NULL, CompanyName CHAR (50) NOT NULL, [...]

Answer Question   |  February 16, 2010  11:00 AM
Access Datasheet, Access query, Microsoft Access, SQL, SQL Access, SQL Query

a question about IMPORT/EXPORT from the SQL 2005 Migration
In our original SQL 2000 DTS jobs, we call Stored Procedures and run BCP commands to Import/Export clients files. In our new environment we can not have the Admin right and permission for BCP. We tried to use BULK INSERT login from a special SSIS login name, but that login name is not our regular networking [...]

Answer Question   |  February 16, 2010  4:58 PM
SQL 2005, sql 2005 Migration

SQL 2008 stored procedures and execution plans
Hi, Is it any significant difference in performance between stored procedure with many parameters (some of them can be null sometimes) and creating many stored procedures that will contains only subset of this parameters ? Thx,  

Answer Question   |  February 16, 2010  4:04 PM
SQL Server 2008, SQL Server 2008 extended stored procedures, SQL Server stored procedures

Multiple databases on a server – SQL
My queries Can PostgreSQL(as database for a Jboss application) and MS SQL(as database for a tomcat application).Are there any known conflicts/issues ? Best regards

Answer Question   |  February 15, 2010  5:23 AM
PostgreSQL, SQL, SQL Database, SQL Server databases

about oracle with Java
What is future of Oracle with Java regarding jobs for freshers and distance learners. Why I am asking this because I am learning oracle from SQL star tutorial in delhi and doing MCA from Sikkim Manipal University in distance learning.

Answer Question   |  February 15, 2010  7:52 PM
Java, Oracle Careers, Oracle developers, Oracle with Java, SQL, SQL Plus

sql server 2005 service will not start
I have a new server running server running windows 2003 and sql server 2005. when I turn on allow remote connections and restart sql service the service fails to start. If I turn off allow remote connections the sql service starts with no problems. I have been unable to find any potential solution to this [...]

Answer Question   |  May 26, 2011  10:16 PM
SQL Server 2005, SQL Server 2005 connectivity, SQL Server connectivity

varchar(max) size limit
I have defined a table field with datatype of varchar(max) but it only stores upto 8k characters, I thought (max) upped this limit to 2g character. How can I get it to store more than 8k characters?

Answer Question   |  February 12, 2010  4:49 PM
SQL Server, VARCHAR

Adding and removing disk space for SQL2000
The scenario:SQL_SVR_A (2000)has x amount ‘too much’ SAN disk space that they want to reclaim/use to allocate to SQL_SVR_B (2000)- which doesn’t have enough space. What is the best method to 1)remove the disk space and keep all db’s in-tact (backup/recovery?, or another way??) and 2)how to add the new space to the server B, [...]

Answer Question   |  February 11, 2010  4:35 PM
SQL Server 2000

Query paging per second in SQL Server
Hi, Just wondering if there is anyway to query the number of paging per second through SQL Server, some kind of system tables, etc. Thanks

Answer Question   |  February 11, 2010  1:44 AM
SQL Server

Linking Visual Basics and SQL database
I wish to know a code that can enable me to link visual basis and SQL database in an organisation.

Answer Question   |  February 9, 2010  1:52 PM
SQL Database, Visual Basic

SQL SERVER 2005 Performance Monitoring
Hello, is there a free software tool to monitor sql server 2005 similar to Quest FogLight? Quest FogLight is just too expensive for my budget. I am an independent consultant and I want to be able to monitor my client’s sql server.

Answer Question   |  January 6, 2012  6:40 PM
SQL Server 2005, SQL Server performance, SQL Server Performance Monitoring, SQL Server performance tuning

difference between t- and pl sql lang
in both t-sql and pl/sql we can use if/else condition and jump into other statements..then actually what makes the difference between t- and pl sql lang?

Answer Question   |  February 10, 2010  4:23 AM
PL/SQL, T-SQL

Procedure cache ratio calculation in SQL Server?
Hi, Does anyone know how to calculate the procedure cache ratio in SQL Server 2005 by selecting specific table in SQL Server? Thanks.

Answer Question   |  February 11, 2010  2:21 AM
SQL Server, SQL Server 2005, SQL Server stored procedures

Alter Column Drop Identity in T/SQL?
Is it possible to alter a column definition to remove its identity property?

Answer Question   |  February 6, 2010  3:26 PM
SQL Column Headings, SQL Server 2008, T/SQL

The IT Blog Top 10: Feb. 4, 2010
Here are the most popular blog posts on the ITKnowledgeExchange network this week. Read the rest of the top 10 on the Community Blog, or apply for your own blog by e-mailing me at Michael@ITKnowledgeExchange.com. 1. How to allow the root user to log in to VMware ESX Server with SSH David Davis’ how-to on [...]

Answer Question   |  February 4, 2010  4:49 PM
AS/400, Channel, CIO, CRM, Database, DataCenter, DataManagement, Development, Exchange, ITKE, Linux, Lotus Domino, Microsoft Windows, Mobile, Networking, Oracle, SAP, Security, SQL Server, Storage, Virtualization, VoIP

SQL Server – SSIS
what is SSIs in Sql Server?

Answer Question   |  February 18, 2010  6:03 AM
SQL Server 2005, SSIS

SAP UPGRADATION PROJECT PHASES ?
Hi, Pl give some idea regarding the phases in sap upgradation project . For sap implementation there are 5 phases involved in it ,on similar basis is there any such phases involved during the upgradation of project .what are the pain areas & what are basic requirements from functional side to go for the upgradation [...]

Answer Question   |  February 2, 2010  4:04 PM
Execution Plan, SAP upgrades

The most-watched IT questions this week: Feb. 2, 2010
Tick tock, tick tock. What’s that sound?  The countdown for the Nexus One Challenge. What? You’ve moved on? Well

Answer Question   |  February 2, 2010  3:36 PM
AS/400, Channel, CIO, CRM, Database, DataCenter, DataManagement, Development, Exchange, ITKE, Linux, Lotus Domino, Microsoft Windows, Mobile, Networking, Oracle, SAP, Security, SQL Server, Storage, Virtualization, VoIP

AS/400 to SQL Server Data Migration
What are the steps involved in migrating data from AS/400 to SQL Server. Could you please elaborate as I’m pretty new to such migration work?

Answer Question   |  February 3, 2010  1:09 PM
Data migration, SQL Server, SQL Server Data Migration

sql server 2000 in server
Hi, We have a server in which windows 2003 is installed and we have created users in the domain (eg – aaa). The server is installed with sql server 2000 and data is stored in the database. The user name for the server is administrator. The problem is when we login from the user computer [...]

Answer Question   |  February 2, 2010  5:19 AM
SQL Server 2000, SQL Server administration, Windows Server 2003