• null v/s ” “(empty string) in Java

    what is the difference between null string and emty string(" " ) in java? String name; if(name == null || name == "") { } wat is the meaning of the abouve if statement?

    Prcvjr220 pointsBadges:
  • SQL Server 2005 License

    This question is not about doing something illegal toward the SQL Server Licensing; on the other hand it is about knowing relationship between Licensing and hardware. Question: I have SQL Server 2005 licensed for 2 physical CPUs. Recently, I bought a system with 4 CPUs to replace the old machine. I...

    Vahemelikian10 pointsBadges:
  • Application not responding in Windows XP Professional

    How do I determine what is causing a "Not Responding" status in Windows Task Manager when running my application? It changes back and forth from "Running" to "Not Responding". It is very slow but eventually finishes. Using Windows XP Professional and SQL Server 2000.

    Smythprog30 pointsBadges:
  • Copy BLOB to BLOB using TSQL

    Is there a way I can copy a BLOB from one column to another using TSQL ?

    Prototyper5 pointsBadges:
  • How to write text into word doc using SQL 2000 query analyzer

    how to write text into word doc using sql 2000 query analyzer. Thanks in advance.

    Pkaur65 pointsBadges:
  • Is it safe to delete SQL Server Transaction Log?

    In one point, I create two Transaction Log for a database, and now I want to delete the second Transaction Log in order to free more space. I just want to get ride of the second file. Is it safe to delete it? SQL Server allow me to do it from DATABASE PROPERTIES WINDOW, but I want to make sure that...

    Vahemelikian10 pointsBadges:
  • Can I direct query the Oracle database with SQL Plus?

    I am about to start work on a SAP system which has an underlying Oracle(version 10) database. I would like to know if it straightforward to query the Oracle database directly iusing SQL*Plus for example ?

    Mikecold10 pointsBadges:
  • How to secure MySql server?

    How to secure a MySql server for webhosting?

    Ashishagw5 pointsBadges:
  • Help running a CmdEXEC from the SQL Server

    I am trying to run a CmdEXEC from the SQL Server- script c:userspublicdocuments The process could not be created for step 1 of job 0xAA781DCB64C4D84392B6730923A77C3D (reason: The system cannot find the file specified). The step failed any help?

    Tocken10 pointsBadges:
  • 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...

    Santhoshnk735 pointsBadges:
  • How to write text into textfile using SQL 2000

    can I use exec sp_OAMethod 'c:osqloutput.txt', 'WriteLine', Null, 'hello' to write something on file using sql2000

    Pkaur65 pointsBadges:
  • 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.

    DaveMPA55 pointsBadges:
  • 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.

    Kmuller5 pointsBadges:
  • 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?

    Suneelsqldba5 pointsBadges:
  • 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?

    Liveena5 pointsBadges:
  • Can I backup the entire SQL drive?

    I have an application that uses SQL Express 2005. I will be upgrading the application and am planning for rollback should it be required. I have nightly database backups which also go to tape but I am wanting the entire hard drives of the server backed up to tape prior to the upgrade. As a rule, we...

    Carlyvehof5 pointsBadges:
  • .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?

    Zamak5 pointsBadges:
  • 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 local drive on the server?

    Rick Martinez585 pointsBadges:
  • 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 in the query. All...

    Apbarker5 pointsBadges:
  • SQL Agent in SQL environment?

    what is SQL Agent in SQL Environment?

    Prcvjr220 pointsBadges:

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following