The most-watched IT questions this week: Oct. 6, 2009
Once again, we’ve compiled the 10 most watched questions on ITKE, and found some great discussions on topics ranging from virtualization to disaster recovery to disaster recovery. Go answer a question now and you could win a TV, or check out the rest of the top 10 on the Community Blog: 1. How to remove [...]

Answer Question   |  October 6, 2009  3:48 PM
AS/400, Channel, CIO, CRM, Database, DataCenter, DataManagement, Development, Exchange, ITKE, Linux, Lotus Domino, Microsoft Windows, Mobile, Netwokring, Oracle, SAP, Security, SQL Server, Storage, Virtualization, VoIP

Change SQL Server licensing
Hi, I was wondering if it is possible for a 50 seat (i.e. maximum of 50 connection) SQL Server 2000 or 2005 license to be change to a 10 seat? If it is possible is there any limitation on the number of seat that can be change? Thanks

Answer Question   |  October 6, 2009  3:18 AM
SQL Server 2000, SQL Server 2005, SQL Server licensing

SQL Script with hyphen in the value set
We have a particular piece of malware that will put some binary code in the HKLM/System/ControlSet001/Services/{5083B7D5-47AF-8FF9-657C651C2B10}/ I am using an sql script along with Microsofts logparser to parse some data out of the registry on a windows box and I am having trouble with the last bit of the code. The data is located at [...]

Answer Question   |  January 23, 2010  9:03 PM
SQL Scripting, SQL scripts

vb.net 2008 and sql server 2008
How can i connect to the sql database using the app.config file over a network and also have the ability to edit the app.config during installation or when the application is installed on another machine on the lan

Answer Question   |  January 23, 2010  12:00 PM
ADO.NET, SQL Server 2008, VB.NET, VB.NET 2008

Reordering the Table position in SSRS
Is there any provision to reorder the table position in a rdl? I have two tables, say A and B where A is placed after B at design time. Can I reposition them with B coming first and then A at run time?

Answer Question   |  October 5, 2009  5:10 AM
SQL Server Reporting Services, SSRS, SSRS 2005

Oracle LIKE statement on SQL Server 2005
I’m trying to execute the LIKE statement but it’s not displaying  any values SELECT R_NAME FROM LAWSON.DEPTCODE WHERE (R_NAME LIKE :r_name)

Answer Question   |  October 5, 2009  10:14 PM
LIKE statement, Oracle 10g, Oracle Statements, SQL Server 2005

installing sql server 2000 32-bit on vista 64-bit
how to install sql server 2000 32-bit into vista 64-bit?

Answer Question   |  October 2, 2009  7:43 AM
SQL Server 2000, SQL Server 2000 32-bit, Vista, Windows Vista 64-bit

Best way to copy large amount files
I have 50 GB of files on an iServer that was copied onto an external hardrive.  What is the best way to copy these files onto a Seagate NAS Server.  The external HD is plugged into the USB and appears as a drive.  Should I use xcopy is DOS or can I drag and drop [...]

Answer Question   |  October 5, 2009  8:43 PM
Bulk Copy Program, Copy programs, NAS, NAS devices

SQL 2008 Security: How do I give users access to just views within a DB?
[h1 class="subject"> [/h1] I have inherited a SQL DB and need to give a group of users access to some views within a DB. We do not want them to access the tables, just the views. They will be connecting using MS Excel for reporting purposes. Do I use a role or schema? What is the [...]

Answer Question   |  October 3, 2009  5:19 PM
Microsoft Excel, SQL, SQL 2008

How to Edit SQL 2008 RDLs to run on a SQL 2005 SSRS Server?
Has anyone figured out how to edit a SQL 2008 RDL to run on SQL 2005 SSRS server?  Mr. Denny (see link below) believes it can be done. http://itknowledgeexchange.techtarget.com/sql-server/you-cant-deploy-a-sql-2008-ssrs-report-to-a-sql-2005-ssrs-server/

Answer Question   |  March 23, 2011  4:03 PM
RDL, SQL Server 2005 Reporting Services, SQL Server 2008 Reporting Services

The IT Blog Top 10: Oct. 1, 2009
10. Choosing a block size when creating VMFS datastores Eric Siebert provides a guide detailing how to choose a block size for VMFS datastores. 9. Using VRDP to view VirtualBox virtual machines remotely Rick Vanover walks through Sun’s xVM VirtualBox’s ability to tap into VRDP remote viewing. 8. Does Larry care about Oracle customers? When [...]

Answer Question   |  October 1, 2009  3:54 PM
AS/400, Channel, CIO, CRM, Database, DataCenter, DataManagement, Development, Exchange, IT Blogs, ITKE, Linux, Lotus Domino, Microsoft Windows, Mobile, Networking, Oracle, SAP, Security, SQL Server, Storage, Virtualization, VoIP

Database Views in SQL Server
When I open database expert and open a new DB connection, only tables and stored procedures are shown. How do I get views to show? And yes, I did select views under options/database.

Answer Question   |  January 17, 2012  10:56 PM
Database Expert, SQL Server databases, Windows Server 2003, Windows XP

Working TRIGGER and TRANSACTIONS QUESTION
Hello all, My company purchased an operations software (called [strong]darwin[/strong]) that works with SQL 2005 Server. I need to extract some data and save it in my Own Database, which is located in the same SQL Server. On the darwin software there is a screen that updates a field X in a table, which fires an an AFTER [...]

Answer Question   |  October 1, 2009  6:25 PM
SQL Server 2005, SQL Trigger, Transactions Per Second, TRIGGER

SQL Server 2005 is running slow
SQL server 2005 is running very very slow while it has 32 GB ram 200 GB SAN and 4 Processor of Xneon 566 GHZ. The normal select query takes 30-35 seconds to returning 37 records. Please give me the suggestion how to increase the performance

Answer Question   |  November 9, 2012  12:44 PM
SQL Server 2005, SQL Server performance

Textbox input to a a sql dataset table in Vb.net
How do I input data from textboxes in Vb.net to …a table in a  data set ….and then display generated data back to some more textboxes ???? I am using sqlexpress ….Thx. mace100

Answer Question   |  January 23, 2010  3:24 PM
data input, SQL, SQL Data Set, VB.NET

SQL Server 2000 hang and shrink won’t stop
I’m troubleshooting a SQL 2000 database problem. It’s a db for our datawarehouse system that pull everyday data from host. Current size is 461Gb for db and 67Gb for log. Because of space concern, I want to detach the log file and create new, but today I cannot open the database locally or remotely. When [...]

Answer Question   |  September 29, 2009  2:43 PM
Event Viewer, SQL Database, SQL Server 2000

Getting last entries from two different tables
Hi, I need to get the last entries from two different tables in MSSQL. I can get the last entry for one table by usung the following. SELECT * FROM dbo.Shaft_Scales WHERE dbo.Shaft_Scales.ID = (SELECT max(ID) from dbo.Shaft_Scales ID) The problem is adding another table. Please help

Answer Question   |  September 29, 2009  7:29 AM
MSSQL, SQL tables

SQL error
I’ve a cursor to fetch date from DB2/400…When date is stored as 0001-01-01, I get error – Year portion of the Date not in correct range. This is the default date my update program stores when user doesnt enter anything for date field. How can I bypass this error while fetching SQL cursor in my [...]

Answer Question   |  September 28, 2009  4:57 PM
DB2, DB2/400, SQL error messages, SQLRPGLE

how to use sql server 2005
i have installed sqlserver2005 but i want to know how to open sql server and connect DB

Answer Question   |  February 23, 2012  12:28 PM
SQL Server 2005, SQL Server database

Error when insertin.g data into SQL table
                I’m using SQL Server 2005 Express edition as the Database and Microsoft VB.NET 2005 as the programming language for my project. At the moment I’m having a problem of inserting data into one of the tables in my database through my VB.NET application. I did successfully inserted data through my [...]

Answer Question   |  September 28, 2009  10:31 AM
Microsoft Visual Studio, SQL Server 2005, SQL Server 2005 Express, SQL Server tables, SQL tables, VB.NET, VB.NET 2005, VB.NET 2005 programming, Visual Studio 2005