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

Diff. between PF and a sql table
can anybody say what is the most basic diff. between making pf by writing DDS and sql table by create table command because both can having index…..

Answer Question   |  October 9, 2009  8:35 PM
DB2/400, DDS, Physical Files, SQL tables

synonym in SQL server 2005
How can one get the information about the object type of synonym that is whether the synonym belongs to function, stored procedure, table or view using a query. Sys.synonyms table contains information about synonyms present in a particular database but it does not tell for which object the synonym is created?

Answer Question   |  September 25, 2009  11:13 AM
SQL Server 2005, SQL Server Synonyms, SQL Server System Tables

Upgrade to IDES CRM 7.0 (ABAP)
Hi All, My client using sap IDES CRM 5.0 (ABAP) and he wanted me to upgrade to IDES CRM 7.0 (ABAP) . I am new to BASIS, can any one help , which CD’s( with the CD numbers and related notes numbers ) to be downloaded from service market place and how to start the [...]

Answer Question   |  September 25, 2009  3:48 AM
SAP ABAP, SAP Basis Administrator, SAP CRM, SAP IDES, SQL Server 2005, Windows Server 2003

Windows Server and SQL database upgrade
 We are goging to upgrade server, SQL server databases and domain name, now currently using as following setting 1. Server OS - Windows server 2003 Enterprise Edtion. 2. SQL server 2000 3. domaname xxx1 we are looking and upgrade to new os version, server SQL server and change domain name. 1.  Server OS - Windows [...]

Answer Question   |  September 24, 2009  3:25 PM
SQL Server 2005, SQL Server Upgrade, Windows Server 2003 to Windows Server 2008 Upgrade, Windows Server 2008, Windows Server 2008 R2, Windows Server Upgrades