Migrating DTS packages to SSIS
What is the tool that migrates DTS packages to SSIS, and how effective is it?

Answer Question   |  April 8, 2009  8:25 PM
DTS packages, SQL Server, SSIS, SSIS Package

Connecting a SQL Server database with Visual Basic 6.0
What code would I need to connect a SQL Server database with Visual Basic 6?

Answer Question   |  October 25, 2009  8:23 PM
SQL Server database, Visual Basic, Visual Basic 6

Null Expressions
I am sure this is simple, I just need to know what the expressions is if you have fields in lets say a report that are : some empty and some with information…such as Telephone Field. I want to show only those “telephone” that are actually in the field. Example John Doe 555-555-5555 430 Cow [...]

Answer Question   |  April 12, 2009  6:17 PM
NULL, Null Expressions

sql with windows vista home premium 32bit
can i install sql programs in windows vista home premium 32bit

Answer Question   |  April 10, 2009  6:04 PM
SQL, SQL Installation, Vista, Vista Home, Windows Vista Home Premium, Windows Vista Home Premium 32-bit

Do all versions of Microsoft SQL Server 2005 support database mirroring?
Do all versions of Microsoft SQL Server 2005 support database mirroring?

Answer Question   |  April 8, 2009  5:33 PM
Database mirroring, SQL Server 2005, SQL Server Database Mirroring

Using SQL Server databases on data with numerous checks
I am interesting in cleaning census data, and I have a number of edit checks, consistency checks, validation checks and range checks to perform. What is the best practice you would recommend, using SQL Server as the database?

Answer Question   |  April 8, 2009  5:17 PM
SQL Server, SQL Server database

Refresh a SQL View in ILE
I have created a view and am using in an ILE module. I have updated one of the files that the view is built with. How do I refresh the View to see this record the next time I run the SQL view? Is there a CREATE OR REPLACE VIEW in RPGILE? Thank you.

Answer Question   |  April 7, 2009  5:05 PM
AS/400 SQL View, RPGILE, SQL View

SQL Stored Procedure
Is there a way to call a child stored procedure form a parent sp but then immediately stop the parent?

Answer Question   |  April 8, 2009  3:29 PM
SQL stored procedures

Shell script within Stored Procedure
How do I execute a UNIX shell (.sh) script from within an MS SQL Stored Procedure?

Answer Question   |  April 20, 2009  2:11 PM
Shell scripts, SQL stored procedures, Unix, Unix shells

Tool for migrating DTS to SSIS
What is the tool for migrating dts to ssis.And how effective it works.And I want migtate 500DTS packages to ssis how much time it will take?

Answer Question   |  April 7, 2009  5:48 AM
Data Transformation Services, DTS, SQL Server Integration Services, SQL Server migration, SSIS

Running queries causing system to hang
A few weeks ago we had a major crash that was caused by a bad install. I wiped the machine and reinstalled the OS (Windows Server 2003). At first everything appeared to be fine. We are using: 2 x 4 core 2.33 GHz Xeon E5345 Intel s5000XVN motherboard 12GB Ram ATI Radeon x300 Video The [...]

Answer Question   |  April 6, 2009  8:02 PM
SQL Server 2005, System performance, Windows Server 2003, Windows Server Performance

sqlcode -727
ANY ONE KNOW WHAT -727 SQL RETURN CODEIS?

Answer Question   |  April 8, 2009  7:54 PM
SQL 727, SQL error messages, SQL Return Codes

how to capture cases in store procedure codes
I wish to creat a query in store procedure (with variables such as Start Datetime, End Datetime, Parameter varchar(3) as you can see on my store procedure for other reports). But for this report, I wish to capture a case might fall into one of the columns (only one column such as DECLEAREDDATE OR SOMATICMCCLEAREDDATE [...]

Answer Question   |  April 18, 2009  6:48 PM
SQL, SQL stored procedures

SQL 6.5 Upgrade
We recently upgraded an application from MS SQL 6.5 to MS SQL 2008. We took quite a performance hit. Is this to be expected?

Answer Question   |  April 9, 2009  6:38 PM
SQL, SQL 6, SQL 6.5, SQL Upgrades

Adding SQL perfrmon counters
Recently a site administrator installed a SQL2000 server on Windows 2003. For some reason the perfmon counters for SQL do not show up when trying to check performance. How should these counters be added and/or activated post-installation? In the IT trenches? So am I – read my IT-Trenches blog

Answer Question   |  April 8, 2009  2:26 PM
SQL Server 2000, SQL Server performance, SQL Server performance tuning, Windows Server 2003

How do I write a SQL statement to get all data from a table called subscrib?
How do I write a SQL statement to get all data from a table called subscrib?

Answer Question   |  April 6, 2009  10:16 PM
SELECT statement, SQL, SQL queries, SQL statements

Store Procedure Codes Please help
I have a problem in SQL, and please expert helps me out and give me an advice of how to solve this issue. I have a main table where to store the data, I have mutliple columns and those are SSN, DECLEAREDDATE, SOMATICMCCLEAREDDATE, PSYCMCCLEAREDDATE, DESECONDCLEAREDDATE, SOMATICMCCLEAREDDATE, PSYCMCSECONDCLEAREDDATE, DDS. SSN INT, DDS VARCHAR, and the rests [...]

Answer Question   |  April 4, 2009  6:36 PM
SQL, SQL stored procedures

Renaming a SQL 2005 server
What considerations and procedures should be followed when renaming a Windows server that is hosting SQL 2005? Previous testing has shown considerable applicaiton problems after a system rename. Thanks for the guidance.

Answer Question   |  September 21, 2011  5:54 PM
SQL 2005, SQL Server 2005

Viewing distinct records in a SQL query result
I have a set of records in a SQL query result. I only want to see one record, per the data field “ID”. I am getting 2 records for some ID’s, as there is one field that is different in the 2 records. This happens even if I start the query out with SELECT, DISTINCT, [...]

Answer Question   |  April 7, 2009  5:48 PM
SELECT statement, SQL Query, SQL Server Query

Error running an ASP.NET application in SQL Server 2005
I have SQL Server 2005, version 9.0, installed on my system with VB.NET 2005 and IIS server running. When i tried to run an application created in ASP.NET, it showed me the following error: The XML page cannot be displayed. Cannot view XML input using XSL style sheet. Please correct the error and then click [...]

Answer Question   |  April 4, 2009  5:44 PM
ASP.NET, IIS, IIS Server, SQL Server 2005, VB.NET 2005