Tree View Control
i am trying 2 make and explorer using the tree view control in my project using VB 6, SQL Server 2000 and crystal reports. in the looping statements i had inculed the details and all. i need 2 display the results in the Grid Box when click the nodes in the Tree control. please provide [...]

Answer Question   |  October 15, 2009  8:55 AM
Crystal Reports, SQL Server 2000, Tree View control, VB 6, Visual Basic

Writing a stored procedure across two databases
I currently backup our live databases and restore them into a QA environment. This doesn’t cause a problem with our stored procedures as they have all been written without hard-coded database names.

Answer Question   |  January 12, 2010  6:46 PM
Backup & recovery, Stored Procedures

Restore a View Sql Server 2005
I over-wrote a VIEW by mistake. How do I recover the original version of the view? Is there a way to ROLLBACK a “CREATE VIEW…” command?

Answer Question   |  October 15, 2009  3:10 PM
SQL Server 2005, SQL Server View

The most-watched IT questions this week: Oct. 13, 2009
Here are the 10 most watched questions on ITKE: There’s some great discussions going on ranging from going green to how to create a new network. Go answer a question now and take your shot at winning a TV, or check out the rest of the top 10 on the Community Blog: 1. Going green: [...]

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

Different database & server collation
Hi, We have a database that is sitting on a SQL Server 2005 with different collation setting, the application connect to the database is running with out any issue. Have anyone had this same issue, if so how long has your application run with different database and server collation without running into collation issue? Thanks

Answer Question   |  October 19, 2009  5:26 AM
Collation, SQL Server 2005

Resource usage of SQL Server 2005 Generate Script
Hi, I am wondering how resource hungry the Generate Script for SQL Server 2005 is. We are planing to script out one of our production database on a production server that has over 1000 object to script, and wether this will have more affect on SQL performance during the scripting? Thanks.

Answer Question   |  October 13, 2009  12:28 PM
SQL Scripting, SQL Server 2005, SQL Server performance, SQL Server performance tuning, SQL Server Scripts

SQL 2000 & Outlook 2000
We have a couple of SQL 2K Servers which have a mailbox associated with them, have always used Outlook 2000 because anything newer does not work and today it has gone wrong!!! We are now getting a “Cannot open the mailbox, information store not available” we cannot get the server to work with email and [...]

Answer Question   |  October 13, 2009  2:12 PM
Exchange 2007, Outlook 2000, Server 2000, SQL Server 2000

Trying to setup a Merge publication between two database Need Help!
HI I am trying to setup a Merge publication between two database and I am having troubles.  I have to server one is HKDD01 and LDDD01 and the HKDD01 is set as the distribution and the LDDD01 is set as the subscriptions. I am trying to create a Merge publication with pull subscription and I [...]

Answer Question   |  October 13, 2009  9:39 AM
SQL Server 2005, SQL Server databases, Windows Server 2003

ms sql query problem with a case statement
[strong]This code works: SELECT     passengers.*, passship.passship_name AS name, passship.passship_speed AS speed, passship.passship_size AS cargo, hyperjump.hops AS hops, ROUND((passengers.pass_engers * passengers.pass_price) / (hyperjump.hops * passship.passship_speed), 0) AS ptprofit                        FROM         passengers INNER JOIN                       hyperjump ON passengers.pass_terms = hyperjump.startsystem AND passengers.pass_system = hyperjump.endsystem CROSS JOIN                       passship WHERE     (passship.passship_name = ‘Rinkratt’) ORDER BY ptprofit DESC, [...]

Answer Question   |  October 18, 2009  3:02 AM
CASE statement, MSSQL, SQL

Can I Use Tomcate as a “Witness” Server in SQL 2005 Mirroring
Hello i am using SQL 2005 and i have Tomcat as an Application Server i want to use Mirroring on my DB and i am looking for the way that let me make Tomcat as my Witness server [Br class="height5" />[small] [/small]

Answer Question   |  October 10, 2009  2:54 PM
Application Server, SQL 2005, SQL Mirroring, Tomcat

Replication Causes Client Application to Hang
I’ve got 25 Sites that are running an application that connects to MS SQL 2005, All the sites have their own copy of a database and have one similar database that holds information gathered from the different sites, now what is happening is that if a client registers at one institution and then later visits [...]

Answer Question   |  October 9, 2009  8:56 AM
SQL 2005, VB.NET

Pulling data from tables on different servers
I have a join between a table on my local database and a table on a different database on the same server. I reference the non-local database with DatabaseName.TableName. Now I find that the non-local database might be on a different server. I tried ServerName.DatabaseName.TableName, but I got this error: Login failed for user ‘(null)’. [...]

Answer Question   |  October 12, 2009  5:53 PM
Linked SQL Servers, SQL Database, SQL error messages

Full vs Transaction Log Backups
Is it nessisary to perform a log backup on a database that is set to Full recovery if I am uninterested in doing a point in time restore? I could opt for Simple, but, really my question is, why? My question also goes on to the size of the ldf file, and will it reuse [...]

Answer Question   |  October 8, 2009  3:11 PM
SQL Backup, SQL Log Files, SQL Server

Soon you can redeem knowledge points for Amazon.com gift cards
Yes we are coming up knowledge points and will be announcing the ability to redeem all the points you have earned thru december this year for amazon.com gift cards. Next week we will be sending out an email with all the details but it should be fun to see who ends up asking and answering [...]

Answer Question   |  June 16, 2012  4:53 PM
AS/400, Channel, CIO, CRM, Data Center, Database, Development, Exchange, Linux, Lotus Notes, Mobile, Networking, Oracle, SAP, Security, SQL Server, Storage, Virtualization, VoIP, Windows

Why are naturl JOIN keywords not an option for producing a self-join?
Why are naturl JOIN keywords not an option for producing a self-join?

Answer Question   |  October 7, 2009  2:16 PM
JOIN statement, SQL procedure

How does SQL Server 2000 CAL licensing work
Hi, Just wondering how SQL Server CAL licensing work. For example in one of our client SQL Server 2000, we notice in the SQL Server 2000 licensing icon in Control Panel, it is set to CAL of 50. Does this mean if the 51st client tries to access the SQL Server, an error will occur? [...]

Answer Question   |  October 8, 2009  5:52 AM
SQL Server 2000, SQL Server CAL licensing, SQL Server licensing

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