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
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
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
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?
Answer Question | April 8, 2009 5:33 PM
Database mirroring, SQL Server 2005, SQL Server Database Mirroring
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
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
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
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
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
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
ANY ONE KNOW WHAT -727 SQL RETURN CODEIS?
Answer Question | April 8, 2009 7:54 PM
SQL 727, SQL error messages, SQL Return 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
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
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?
Answer Question | April 6, 2009 10:16 PM
SELECT statement, SQL, SQL queries, SQL statements
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
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
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
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