Looping in SQL
Should be able to do something like this: UPDATE table_name SET new_column = (calculated value) WHERE new_column is NULL

View Answer   |  February 23, 2011  7:17 PM
.NET Framework 3.5, Looping, SQL Server, SQL Server 2005

International SQL Server Replication
Yes this can be done, using SQL Server replication. You’ll probably want to initialize the subscription using a process called init from backup, which allows you to take a backup of the main database and then restore that database to the remote system. Will you need to allow people to write to both servers? If [...]

View Answer   |  February 22, 2011  8:51 PM
Secure Data Transfer, SQL replication, SQL Server, SQL Server 2008, SQL Server 2008 R2, SQL Server database, SQL Server replication

SQL concatenate results
You could do something like this: <pre>… AND FDDWHD20.DCOUT1 LIKE <b>{?your_parameter} & “*”</b></pre> Or you could use a Record Selection formula, using the <i><b>startswith operator</b></i>

View Answer   |  February 21, 2011  3:26 PM
Concatenate, SQL, SQL Server

Restore SQL Server after OS loss
+++++++++++++++++++++++++++++++++++++++++++++++++++++++++ DISCUSSION: What sql server are you using, and what type of backup did you make +++++++++++++++++++++++++++++++++++++++++++++++++++++++++ I am using SQL Server 2008r2 x64 on WINDOWS 2008r2 x64. I made a full backup of all files. However the drive the data is located on is in tact. When using oracle I just need to create [...]

View Answer   |  February 20, 2011  7:46 PM
Backup, SQL Server, SQL Server backup, SQL Server backup and restore

SQL Server and AntiVirus
Every progam I’ve ever seen that uses SQL recommends that you exclude their program directories. But you should definitely install antivirus software on it. You’re SQL server is for sure one system you wouldn’t want to have infected with a network virus, so make sure you keep it protected.

View Answer   |  February 19, 2011  5:54 AM
Antivirus, SQL Server, SQL Server 2008, SQL Server security, Windows Server 2003

Open IT Forum: What’s high on your priority list for 2011?
Our software was developed over the last 15 years. Durring that time there has been a constant turnover in staff and seldom was there anyone with much prior experience. As a result, we have a lot of spaghetti code and it is overflowing with hard coding. Our goal this year is to rewrite our main [...]

View Answer   |  February 16, 2011  9:24 PM
AS/400, Channel, CIO, Cloud Security, CRM, Database, DataCenter, Development, Exchange, Linux, Lotus Domino, Microsoft Windows, Mobile, Networking, Open IT Forum, Oracle, SAP, Security, SQL Server, Storage, Virtualization, VoIP, Windows Server

Free IT Book: AAA Identity Management Security
Hi, Just posted my answer to <b>Bandwidth & prerequisites for VMware View</b> <a href=”http://itknowledgeexchange.techtarget.com/itanswers/vmware-view/”>here</a>. An answer to <b>Upgrade Exchange 2007 from 2003 (downgrade license of 2007)</b> posted <a href=”http://itknowledgeexchange.techtarget.com/itanswers/upgrade-exchange-2007-from-2003-downgrade-license-of-2007/”>here</a>.

View Answer   |  February 15, 2011  4:47 PM
AS/400, Channel, CIO, CRM, Database, DataCenter, Development, Exchange, IT Books, Linux, Lotus Domino, Microsoft Windows, Mobile, Networking, Oracle, SAP, Security, SQL Server, Storage, Virtualization, VoIP, Windows Server

Oracle 10g terminated_with_error
Thanks for your share. Your site is really good, and it is very worthy to visit again. Welcome to our bridal gowns online store <a href=”http://www.bridalgownsstore.com/”>http://www.bridalgownsstore.com/</a>

View Answer   |  February 14, 2011  6:47 AM
Oracle 10g, Oracle 10g error messages, SQL Server Report Builder

Thousands and thousands of simultaneous users hitting a sproc — what do you do?
OK, you are over thinking it. Having multiple copies of the same stored proc, or multiple copies of the same database on the same server won’t do anything but make the think harder to manage. SQL Server can handle thousands of users all calling the same procedure at the same time. Everything in SQL Server [...]

View Answer   |  February 14, 2011  2:46 AM
SQL Server, SQL Server 2008, SQL Server stored procedures, Stored Procedures

Would like to learn SQL. Which vendor should I go for and what certification should I get?
According to ur background, I think, Oracle for Financial Services delivers a powerful combination of technology and comprehensive, preintegrated business applications, including key functionality built specifically for banking and capital markets organizations. U may go for the certification of Oracle Certified Financial Applications Consultant Rel 11 which is a part of Oracle E-Business Suite. For [...]

View Answer   |  February 12, 2011  6:04 AM
SQL, SQL certifications, SQL Server, SQL Server certifications

Contest Bounties: Last chance to win an iPad!
tweeted about IT Knowledge Exchange via twitter..

View Answer   |  February 12, 2011  1:03 AM
AS/400, Channel, CIO, CRM, Database, DataCenter, Development, Exchange, ITKE Contests, Linux, Lotus Domino, Microsoft Windows, Mobile, Networking, Oracle, SAP, Security, SQL Server, Storage, Virtualization, VoIP, Windows Server

SQL Server 2005 Reporting Services Move
You have to install a new SQL Report server, and configure it. You then need to upload the reports to the SSRS server. You can’t just restore the database as the guids for the web servers won’t match.

View Answer   |  February 11, 2011  7:13 PM
Report Server, Reporting Services 2005, SQL Server 2005, SQL Server migration, SQL Server Report Server

Open IT Forum: Security Worst-Cases
We had an IT exec who also wanted to write code, especially SQL. He would take nice compact stored procedures and turn them into a nightmare. Not only did he rewrite 75 % of the stored procedures, he bypassed our content control system doing it so none of it was documented. He had procedures that [...]

View Answer   |  February 11, 2011  6:18 PM
AS/400, Channel, CIO, Cloud Security, CRM, Database, DataCenter, Development, Exchange, Linux, Lotus Domino, Microsoft Windows, Mobile, Networking, Open IT Forum, Oracle, SAP, Security, SQL Server, Storage, Virtualization, VoIP, Windows Server

un-format object viewer sql tab
Try going to: Tools->Preferences->Database->SQL Formatter Look for a check box “Autoformat PLSQL in procedures, packages, views and triggers”, and uncheck it. This is the path to the option in version 1.5.3 (it could change from version to version). ——————

View Answer   |  February 11, 2011  2:29 PM
Oracle SQL, Oracle SQL Developer, SQL, SQL Server

Search: Error with SQL : Login failed for ‘SA’.
Sounds like you either have the wrong sa password, someone has changed the sa password, someone has renamed the sa account, or someone has disabled the sa account. No software should ever use the sa account to log into the SQL Server. The sa account should be used for administrative purposes to manage the database [...]

View Answer   |  February 8, 2011  6:34 PM
SQL Server 2000, SQL Server 2005, VB.NET, Visual Basic, Windows Server 2003

SQL Server 2005 database installation
Assuming you have installed a full server product, you should have also installed the client tools, in particular SQL Server Management Studio (SSMS). If you didn’t, go through the installation again and add them. Once you have SSMS installed, you will find most of the basic functions available with a click or two in the [...]

View Answer   |  February 7, 2011  8:55 PM
SQL 2005, SQL Server 2005, SQL Server 2005 Database, SQL Server database

Storage Area Network Certification
SNIA offers several different standards base SAN certifications. http://www.snia.org/education/certification/ In addition, most vendors offer their own certifications as typically the administrative software used is very vendor specific. You would generally get certified by the storage vendor that makes the storage array that your company uses.

View Answer   |  February 7, 2011  8:29 PM
SAN, SAN certificate, SQL Server, Storage Area Networks

Log on error Oracle enterprise manager
From the command line (assuming you are logged in as linux oracle userid) the password field is ignored. I tried it on my 11g system logged onto Linux as my oracle user. sqlplus sys/fred as sysdba << I connected. sqlplus sys/wilma as sysdba << I connected. Try to connect as sys without the /password so [...]

View Answer   |  February 6, 2011  7:45 PM
Oracle 10g, Oracle 10g administration, Oracle error messages, SQL Plus

SQL Server 2005 login error
Sounds like you’ve got an SSL certificate installed on the SQL Server that isn’t trusted by the client. You need to get the certificate from the CA that created the certificate for the SQL Server and install that CA certificate on the client computer.

View Answer   |  February 6, 2011  7:20 PM
SQL Server 2005 error messages, SQL Server error messages, SQL Server errors

Can I install SQL Server 2005 32 bit on 64 bit OS?
It requires ASP.NET 2.0 32-bit and IIS 6.0 configured to run this. With Windows Server 2003, IIS 6.0 can run 32-bit applications on a 64-bit Windows using a compatibility layer which is called WOW64. NOTE: Once it is configured IIS 6.0 to run on 32-bit, it is not possible to run other 64-bit web applications. [...]

View Answer   |  February 4, 2011  5:50 PM
SQL 2005 installation, SQL Server 2005, SQL Server 2005 (32-bit), SQL Server installation, SQL Server Installation Options, Windows Operating System, Windows Server 2003