Terminate SQL exception, if it is running more than a specified time.
Whether we can forcefully terminate an sql statement during its execution if it is running for a long time or running more than a specified time?

Answer Question   |  November 15, 2010  10:03 AM
Oracle 9i, Oracle performance, Oracle SQL, SQL Exception, SQL statement

Delete all tables in SQL Server database?
How to delete all tables of a database in SQL Server?

Answer Question   |  November 16, 2010  8:28 AM
DELETE statement, SQL Database, SQL Server, SQL Server database, SQL tables

How to add an article in transactional replication in sql server 2005?
How to add an article in transactional replication in sql server 2005? and what are the prerequisites for trnsactional replication?

Answer Question   |  November 15, 2010  6:55 AM
DBA, SQL, SQL Server, SQL Server 2005, Transactional replication software

Error Message ORA-00903 in SQL table
Here is my query:   select guestid, guestfname, guestlname from guest where tourid = 6; It says tourid is an invalid identifier. TourID is a defined attribute in a table called Tour. I’d be grateful for any help.

Answer Question   |  November 15, 2010  11:53 PM
ORA-00903, SQL, SQL Plus, SQL tables

Filename from SQL 2005 Query
I have a batch file that runs a SQL query command overnight once a week and outputs the results of that query to a file as a .csv file. The query produces, amongst other things, a week ending date. Is it possible to to name the output file with result of the week ending column [...]

Answer Question   |  November 12, 2010  12:56 PM
Batch files, SQL 2005, SQL Query, SQL Server, SQL Server 2005

SQL Agent in SQL environment?
what is SQL Agent in SQL Environment?

Answer Question   |  November 12, 2010  11:52 AM
Agents, SQL, SQL Server, SQL Server Agent

How to update data for one column in MS SQL?
Hi, I have a table column named “Question” that stores the question without space.For example “Who are you” is stored as “whoareyou”.Now I have modified the code to store the data with spaces in Question column.Problem is newly added data will be stored with space,but I want to change the already existing thousands of records [...]

Answer Question   |  November 16, 2010  3:50 AM
SQL, SQL Database, SQL Server, SQL tables

I know SQL, should I learn Oracle database?
I know SQL but i am not master in that.I know only basics of SQL. Can I start to study Oracle database directly? if so please suggest me some good way to learn.

Answer Question   |  November 11, 2010  11:23 AM
Oracle Careers, Oracle certifications, Oracle Database, SQL Server

Question about SQL Server managament database upload
how to upload sqlserver management studio database on online

Answer Question   |  November 10, 2010  6:29 AM
.NET, .NET Framework 2.0, C# .NET, SQL Database, SQL Server, SQL Server Management

How to find particular database in SQL stored procedures other than manually?
Hi all, i have a Stored Procedure, i need to find the database in which the particular SP is available, i dont want to go through all the SP’s……….. Is there any way to find the database using server name, i need the query for this.. Please help me

Answer Question   |  November 11, 2010  6:28 AM
SQL Database, SQL Server, SQL Server stored procedures, Stored Procedures

Remove double qoutes from text file using SED in SQL 2003
This goes along with my previous question “How to remove specific lines from a text files using either vbs or bat.” I am having issues removing the double quotes our app uses in its export as a separator for some fields. The command I use in ssed is ========CODE=================== “s/”//g” =========END OF CODE============ But it [...]

Answer Question   |  November 10, 2010  9:20 PM
SQL Server, SQL Server 2003, Text manipulation, Windows XP Professional SP3

SQL SERVER SAN Setup
I do not know much about SAN’s, I want to setup a SQL Server to use a SAN. 1. Should I use a SAN drive to install the OS or is it best practice to install the OS on a local drive on the server? 2. Should I install SQL SERVER on the SAN or on a [...]

Answer Question   |  November 15, 2010  9:15 PM
SAN, SQL, SQL 2005, SQL Server, SQL Server 2005, SQL Server 2005 (32-bit)

How to secure MySql server?
How to secure a MySql server for webhosting?

Answer Question   |  November 17, 2010  5:20 PM
MySQL, MySQL functions, Security management, SQL Server, Web hosting

AS400 RUNSQLSTM – Problem with CAST
I am using a RUNSQLSTM to insert records from file A into file B. One of the fiels in defined as 4S 0 in file A and as 4A in file B. If the value in file A is zero, not matter what I have tried file B gets populated with a 0 followed by [...]

Answer Question   |  November 9, 2010  4:27 PM
AS/400, DB2/400, RUNSQLSTM, SQL Server, V4R5

Free IT Book: Microsoft Windows 7 Administrator’s Reference
This week’s IT book giveaway is for the Microsoft Windows 7 Administrator’s Reference: Upgrading, Deploying, Managing, and Securing Windows 7. Interested? All you need to do is answer one of the questions below and post the link to your answer in the discussion area of this question. JavaScript Error through a VPN connection Packet loss [...]

Answer Question   |  February 24, 2011  5:50 PM
Cisco, Cisco 3750, Cisco Firewall, Exchange 2003, Firewalls, Giveaways, IT Books, JavaScript, Javascript error, SQL 2008, SQL Database, VPN

We’ll trade you an Xbox 360 for your knowledge!
The holidays are approaching and so is your next chance to win an Xbox 360 by simply doing what you do around IT Knowledge Exchange. Between today and December 15th, the three members who accumulate the most knowledge points will win some great prizes:   1st Prize: Xbox 360 with 250GB hard drive & Kinect [...]

Answer Question   |  December 1, 2010  3:12 PM
AS/400, Business Intelligence, Channel, CIO, Contests, CRM, Database, DataCenter, Development, Exchange, Giveaways, IT answers, Knowledge Point Challenge, Knowledge Points, Linux, Lotus Domino, Microsoft Windows, Mobile, Networking, Oracle, SAP, Security, SQL Server, Storage, Virtualization, VoIP, Windows Server, XBOX Contest

Orace v/s SQL Server careers
Hi, I am newly join a job on Sql Server.Is it having good future?  I heard that Orale is more good and having good career. Please give me ur valuable suggestions.

Answer Question   |  November 8, 2010  9:14 AM
Oracle, Oracle Careers, SQL Server, SQL Server career advice

.mdf file backup in Visual Studio
I developed one Visual Studio .Net(C#) Project.After Publishing I couldn’t access Database(.mdf file). can yuo tell how to backup?

Answer Question   |  November 15, 2010  12:53 PM
.MDF files, Backup, C# .NET, MDF, Visual Studio

Copy Table in SQLPLUS
How to copy a table from an access database using sqlplus

Answer Question   |  November 8, 2010  2:18 AM
Access, Access Database, SQL tables, SQLPlus

What is the best way to replicate SQL 2008 DBs to a failover site?
We are looking to replicate our SQL 2008 databases to a hot failover site.  We can’t use DB mirroring due to the number of databases we have.  Has anyone replicated databases to a hot site using a replication solution and what was your experience.

Answer Question   |  November 16, 2010  3:58 PM
Failover, SQL Server, SQL Server 2008, SQL Server database, SQL Server replication