How to concat SQL Server 2005 data with line feed
I am attempting to update a column in SQL Server 2005 by concatenating data from two other columns and include a line feed between the two and have the second line begin with a /. The data will be viewed through an MS Access 2003 database with a linked table using an ODBC connection. The [...]

Answer Question   |  February 2, 2011  10:46 PM
Access 2003, Concatenate, Line Feed, SQL 2005, SQL Server 2005, T-SQL

How to populate datagrid using store procedure
m trying to populate a datagridview using a store procedure called from  a module but it is givign me some problem as in my module i use the Function as a bindingsource can someone help me here im totally lost

Answer Question   |  February 1, 2011  10:20 PM
DataGridView, Stored Procedures, Visual Basic, Visual Basic developers

Connect Powerbuilder in SQL Server 2005
how to connect the sqlserver 2005 database in power builder

Answer Question   |  February 1, 2011  12:36 PM
PowerBuilder, SQL 2005, SQL Server 2005, SQL Server connectivity

Crystal report asks for parameter at runtime
Hello All, I have a problem with crystal reports at runtime…… I have a desktop application in which I have used crystal report… When I run the application, crystal report asks for parameter even though I have supplied it through code in C#. Not able to figure out why this happens….. My Report also contains [...]

Answer Question   |  August 12, 2011  10:22 AM
.NET, C#, Crystal Report, Crystal Reports, Crystal Reports Conditional Parameters, SQL Server 2005

SQL Server 2008 Upgrade
I have 7 SQL Servers I need to upgrade from SQL Server 2005 to SQL Server 2008. Can I install the SQL Server 2008 prerequisites using Microsoft System Center? If yes how?

Answer Question   |  February 1, 2011  8:10 PM
SQL 2008, SQL Server 2005 upgrades, SQL Server 2008, SQL Server 2008 administration, SQL Server upgrades

Free IT Book: Computer Incident Response and Product Security
This week’s free IT book is a practical guide to building and running incident response and product security teams. To win Cisco’s Computer Incident Response and Product Security answer one of these five questions and post the link to your answer in the discussion area below. Good luck! Mitigating cloud server risks during DDoS attacks [...]

Answer Question   |  February 1, 2011  5:18 PM
AS/400, Channel, CIO, CRM, Database, DataCenter, Development, Exchange, Giveaways, ITKE Contests, Linux, Lotus Domino, Microsoft Windows, Mobile, Networking, Oracle, SAP, Security, SQL Server, Storage, Virtualization, VoIP, Windows Server

Cross-database name change in SQL Server 2008 stored procedures
Hi: The easy part is the databases will be on the same server.  However at the moment I am writing code in database SOMEDATABASE_TEST which is accessing objects in SOMEOTHERDATABASE_TEST.  When its time to go to production the names are going to change to SOMEDATABASE and SOMEOTHERDATABASE.  However the queries in SOMEDATABASE_TEST stored procedures read: [...]

Answer Question   |  February 2, 2011  5:03 PM
SQL 2008, SQL Server 2008 R2, SQL Server stored procedures, Stored Procedures

SQL Server 2008 tables
I  have 2 tables, tanle1 and table2 Can someone help for  SQL query  for table3 with 2 colums colum 1  is select number from table1 for colum2 in table3  I need to get the total number of times  each number in colum1 of table1 apears in in colums n1,n2,n3,n4 of all events in table2 as [...]

Answer Question   |  January 31, 2011  1:51 PM
SQL 2008, SQL Query, SQL Server, SQL Server 2008, SQL tables

SQL 2000 view debug help
I have the following (admittedly convoluted) view that I cannot get right for some reason that I cannot see. Consider the following: SELECT     s.s_SAMPLEID AS LimsSampleId, s.U_CLIENT_SAM_NO AS ADASampleId, MAX(s.SAMPLEDESC) AS SampleDescription,                       MAX(CASE d.paramlistid WHEN i.paramid THEN d.paramlistid WHEN ’1.Purity I’ THEN pm.paramdesc WHEN ’2.Purity Analysis’ THEN ‘Purity Analysis’ WHEN                        ’5.Germination’ THEN pm.paramdesc [...]

Answer Question   |  February 1, 2011  6:23 PM
SQL 2000, SQL Server 2000, SQL Server 2000 administration, SQL Server 2000 queries

Recursion in Visual Studio 2010
I’m running Microsoft Visual Studio 2010 Professional on a Windows 7 laptop and trying to learn C#. I’m working on recursion and want to prompt the user to enter a specific word into a console application and then use a recusive method to print each character of the user-supplied word on a separate line by [...]

Answer Question   |  January 31, 2011  5:07 PM
C#, Recursion, Visual Studio, Visual Studio 2010

Experience applying SP4 to SQL 2005?
Hi, I have a Microsoft SQL 2005 SP3 database server with 2 instances (both patched to SP3.) The one instance (1a) includes 52 small production databases. The other instance (1b) includes 2 large production databases. Now I would like to upgrade the (1b) instance to the new Service Pack 4. The way I would to [...]

Answer Question   |  February 7, 2011  5:49 AM
Database Instances, SQL 2005, SQL Server 2005, SQL Server database, SQL Server multiple instances

iSeries SQL ISNULL Equivalent
What is the equivalent of the function ISNULL in t-sql in AS/400 iSeries Navigator SQL? or the equivalent of the NZ function in Access?

Answer Question   |  January 27, 2011  10:28 PM
AS/400, iSeries Access, iSeries Navigator, iSeries SQL, T-SQL

Can I transfer a SQL license/install to a new server
We are in the process of upgrading on of our db applications to a new version. This version will require a replication server, meaning we will need a SQL server. Ether 2003 or 2008.  We will need to have a full working test environment before rolling out live with it. Can we transfer our “test” [...]

Answer Question   |  January 26, 2011  7:27 PM
License management, Licensing restrictions, SQL Server, SQL Server 2003, SQL Server 2008, SQL Server licensing, Windows Licenses, Windows Server 2003

VIEW_TABLE_USAGE SQL 2005
In MS SQL 2005, when I select * from VIEW_TABLE_USAGE, I get incomplete results. At least one object that is used in at least one of the views is not listed. View “PTP__MARA_MARC” uses two tables and one view, but VIEW_TABLE_USAGE only lists one table and one view.  Can you please help?

Answer Question   |  January 26, 2011  2:53 PM
SQL, SQL 2005, VIEW_TABLE_USAGE

Where does the WPHOST file get stored in our Novell server?
Where does the WPHOST.db file gets stored .Does it get stored in our local disc.If yes then where.And where is the novell address book gets stored it gets stored in our local disc or is present at the server side

Answer Question   |  January 25, 2011  9:23 AM
C#, Database Files, Novell, Novell GroupWise

Upgrading for database structure
hello everyone  Maybe my previous question was not the correct question to ask. I am in the middle of making an application upgrade which includes DB structure upgrade with keeping Data “data loss is not accepted here”. I have a complex DB structure in my application which depends “in some cases heavily depending” on database specific features. [...]

Answer Question   |  January 25, 2011  7:42 AM
Java/J2EE, JBoss application server, MySQL Database, Oracle, SQL Server, SQL Server 2005, WebLogic Server, WebSphere Application Server

Crystal Reports 8.5 iMIS 10.6 database
I am using Crystal 8.5 with iMIS 10.6. In the database we collect Annual Fund gift information. Each Annual Fund year is a discrete value (AF_2011, AF_2010, AF_2009 etc. I am having difficulty writing a formula that will give me new (AF_2011 only) gifts. I want to show those who only gave to AF_2011 after [...]

Answer Question   |  January 24, 2011  3:11 PM
Crystal Reports 8, Crystal Reports 8.5, iMIS, SQL Server

Application Upgrade and Data migration
Hello Sir/Mam We have a web application that has an intensive usage of Database operations. This application of course has some sort of sophisticated Database (tables, indexes, …)  structure according to Database engine used.  My question now is , what is the best practice to migrate old database structure to new one “including data of [...]

Answer Question   |  January 24, 2011  11:29 AM
Database, Development, Oracle, SQL Server, Web application development

DBCCShrinkDatabase as Security Cleanup Measure?
Recently a private document wasposted to a publicly accessible SharePoint site. The file was deleted and removed from the search index by running an intermediate crawl of the content database. Now the client wants to shrink the database, which is just under a 1Tb in size and sits on a SAN, claiming that this will [...]

Answer Question   |  January 24, 2011  9:38 PM
Database file security, SQL Server 2005, SQL Server security, SQL Server Shrink Database

SQL command question
I have three tables as below: Table 1: attributes fields: attID, att_CategoryID, name Table 2: att_Category fields: att_CategoryID, name Table 3: prodcutAttributes fields: ID, productID, attID, I desigining this tables to be able to add multiple prodcut attributes for ecommerce site. I don’t know how good this design is. Anyways I need to find out [...]

Answer Question   |  January 27, 2011  4:20 PM
SQL commands, SQL Server, SQL Server tables, SQL tables