The main thing is making sure you have installs for all your applications in 64-bit. Most installers are only for 32-bit and will not work on a 64-bit machine. Just making sure you can install all the programs you need is the first step. The second would be checking the vendors website or contacting their [...]
View Answer | November 2, 2010 1:54 PM
Active Directory, SQL 2005, Windows Server 2003, Windows Server 2003 32-bit, Windows Server 2008, Windows Server 2008 64-bit, Windows Server Migrations and Upgrades, Windows Server Upgrades
Insert requires values of the correct type for all fields except those that allow nulls. It can use the default column sequence or you can include the column list. All fields of the primary key must have values and they must provide a unique key. Any other file constraints, foreign keys, unique keys and other [...]
View Answer | November 2, 2010 1:15 AM
AS/400, DB2/400, SQL Server, SQL Server 2005
This seems to be a very basic question. You need to look at the IBM manual for CL commands to get all the information You specify the From file and the to file You have options to add or replace records in the to file. You can select only certain records ffrom the from file. [...]
View Answer | May 13, 2013 7:03 PM
AS/400 Spool Files, CPYF, CPYSPLF, Database Files, RPG
Put the Standard DVD back in the drive and open the installer and manually install the client tools. If you didn’t have them installed before they wouldn’t have been upgraded.
View Answer | October 30, 2010 4:04 PM
SQL Server, SQL Server 2005 Standard Edition, SQL Server administration, SQL Server Express 2005, SQL Server Upgradation, SQL Server upgrades
To use the Exchange Management Console to configure deleted item retention for a mailbox database 1. Open the Exchange Management Console. 2. In the console tree, expand Microsoft Exchange, then expand Server Configuration, and then select Mailbox. 3. On the Database Management tab in the work pane, expand the storage group that contains the mailbox [...]
View Answer | October 29, 2010 5:45 PM
Data Retention Policy, Deleted Items Retention Policy, Exchange 2007, Exchange policy management, Standard Edition
All you need to do is detach the databases from the existing server, then attach them to the SQL Server 2005 instance. They will be upgraded automatically when they are attached.
View Answer | October 29, 2010 4:45 AM
Array, SQL Server 2000, SQL Server 2000 migration, SQL Server 2005, SQL Server migration, SQL Server Upgrade
This is a question rather than an answer. I need to do exactly the same thing. I can update data on my server from the remote 400 but cannot move data from the server to the remote 400.
View Answer | October 28, 2010 5:17 PM
AS/400, DB2/400, Linked servers, SQL Server, SQL Server 2005
based on the second screenshot you’ve got a lot of database tuning that needs to be done. This will require making index changes to improve your query time. This will reduce the SOS_SCHEDULER_YIELD and will probably reduce the disk IO access.
View Answer | October 28, 2010 5:13 AM
SQL, SQL performance, SQL Server, SQL Server 2005, SQL Server 2005 SP3, SQL Server Enterprise Edition
Your best bet would be to use a regular expression through a SQL CLR procedure.
View Answer | October 27, 2010 9:31 PM
EXTRACT, Field-Level keywords, SQL 2005, SQL 2005 Database, SQL Server 2005
That looks fine. Just make sure that all the components are on the VMware Hardware Compatibility list.
View Answer | October 27, 2010 9:27 PM
ESXi, SQL Server, Virtual Machines, VMware ESXi, Web servers, Windows Server 2008
None will give you the best performance because no page verification is done. However if there is a corrupt page the database won’t find it until it tries to process the data within the page. The other values will do a set of checks which the pages are read looking to database corruption.
View Answer | October 27, 2010 9:25 PM
SQL, SQL Database, SQL Server, SQL Server 2005, SQL Server 2005 Database
If you don’t have AWE then SQL Server can only use 2 Gigs of memory. With AWE the SQL Server can use the rest of the memory for the buffer cache. The private memory and procedure cache will stay within the first 2 Gigs.
View Answer | October 26, 2010 6:26 PM
SQL, SQL 2005, SQL Server, SQL Server 2005, SQL Server memory
Shillu13: Thanks for the link to the reminder email. ————————————————————————————- Hi everyone, Just a friendly reminder that TOMORROW is the live chat from 11am-2pm EDT. <b><a href=”http://itknowledgeexchange.techtarget.com/VMware-chat/”>Virtualizing Business-Critical Applications</a></b> will be LIVE with VMware experts. You’ll learn about application performance considerations, best practices and use cases for deploying Tier 1 applications on VMware. <a href=”http://itknowledgeexchange.techtarget.com/VMware-chat/”>Click [...]
View Answer | October 25, 2010 2:22 PM
Exchange Server, Infrastructure, Oracle, SAP, SQL Server, Virtualization, Virtualization and hardware, Virtualization how-tos, VMware, vSphere, Windows Server 2008, x86
No, none of that data is logged.
View Answer | October 23, 2010 11:48 PM
SQL 2005, SQL stored procedures
You will need to restore the most recent full backup, then the log backups from the time the full was taken until the time you want to stop at.
View Answer | October 23, 2010 11:46 PM
SQL Server 2005, SQL Server administration, SQL Server Database Rollback, SQL Server Rollback
First u have install Oracle as well as java. I guess u know how to install & configure them both. after successful u insert the code below in ur java code. U must create a database in oracle to which u connect with java :- Connection connection = null; // Load the JDBC driver try [...]
View Answer | October 21, 2010 9:36 AM
Java 1.6, Java Database Connectivity, MySQL admin, SQL Server
SSRS 2008 doesn’t support anonymous authentication. There are some work arounds to make it work, but they aren’t supported.
View Answer | October 21, 2010 2:12 AM
SQL Server, SQL Server authentication, SQL Server Reporting Services, SQL Server Reporting Services 2008, SSRS 2005, SSRS 2008
Do you have AWE enabled? If so it is normal for task manager to show the wrong amount. Verify using Perfmon to see how much RAM its actually using.
View Answer | October 15, 2010 6:50 PM
CPU, RAM, SQL, SQL Server, SQL Server 2005, SQL Server memory, Windows Server 2003 32-bit
I don’t know what you are trying to do. I suppose it is some kind of test. Also, I don’t see much relation between the question title and the code you posted. <b>You are getting the error because your source blob is null.</b> I would recommend taking a look at this: <a href=”http://soft.buaa.edu.cn/oracle/bookshelf/oreilly/bipack/ch08_03.htm”>DBMS_LOB Interface</a> But [...]
View Answer | October 14, 2010 7:56 PM
Binary Large Object, BLOB, SQL, SQL Database Transfer
id recommend removing ver 1 as it seems to be causing a issue, if i recall PS 2 is required for SQL 2008 to function
View Answer | October 13, 2010 4:47 PM
PowerShell, PowerShell 2, SQL Server 2008, Windows Server 2008, Windows Update