Questions & Answers

  • How to match CSV field values in SQL Server 2005

    i have an table in sql-server 2005, in which my one field is storing csv values.Suppose i have two tables; one is roles and another is users; and multiple role can be assign to one user. so that i have make a fields i.e roles in user table which is keeping the values in csv format. now my problem...

    Sanjeevgoyal5 pointsBadges:
  • Java Code to Copy AS400 file to SQL Server database/table

    I need Java code to access and copy an AS400 file to SQL Server database/table. It must also copy a specific amount of records from the SQL Server side. 

    IRob5 pointsBadges:
  • Which feature are you most looking forward to in SQL Server 2014?

    In the most recent edition of SQL in Five, Mark Kromer, national platform architect at Microsoft, discussed his top three features for the upcoming SQL Server 2014. These included: Hekaton Big data Data Explorer Which feature are you most looking forward to in SQL Server 2014?

    Michael Tidmarsh29,685 pointsBadges:
  • How do I convert SQL Server 2012 files to SQL Azure?

    Currently, I’m running SQL Server 2012 with Visual Studio Beta 11 as well as SQL Server 2008 R2 version of the .mdf file because the staging server uses R2. I’ll be moving up to SQL Azure for a project I’m working on. What is the best way to port files over? Do I actually need to make changes...

    ITKE344,995 pointsBadges:
  • How can I write a stored procedure to copy data from one database to another database on the same SQL Server, every weekend?

    How can I write a stored procedure to copy data from one database to another database on the same SQL Server, every weekend?

    SQL Server Ask the Experts2,585 pointsBadges:
  • SQL Server 2005 Query Very Slow in the first run

    Hi, I have an sql query which takes 8 seconds in the first run. The next run there after takes 0.5 seconds and all consecutive runs take 0.5 seconds. Is the plan getting cached? How do i make this query run in 0.5 second in the first run itself? Please find the query below. select...

    Jsql155 pointsBadges:
  • WebLogic Server Admin Online Training

    Hi Folks,I got the valuable information about WebLogic Server Admin online training. It is nice, brief and interesting. for more info regarding WebLogic Server Admin check out http://weblogic-onlinetraining.com/

    SVRTechnologies15 pointsBadges:
  • Exchange 2010 Active Sync Whitelisting

    I was under the impression you could do this but now I am having trouble finding it. I want to ONLY allowed whitelisted (manually by IT) devices. I don't mean type of devices. I mean my specific phone and nothing else. if you get a new phone you bring it to IT and we enroll it. I don't want any...

    DraconianBillly25 pointsBadges:
  • SC delete OracleServiceXE is not working for me

    I have removed Oracle from system, but when I try to install it again, I'm getting the error as an instance of Oracle already there please remove the files and re install again. I have delete all files, but I'm still getting same error. As suggested above, I have try to run sc delete...

    Reddy0075 pointsBadges:
  • SQL Server date format

    Hello, I have a problem when i am inserting a string date ie 19/9/2010, which is stored in table as 9/19/2010.  i want to insert dd-mon-yyyy format. can i insert dd-mon-yy format,please replay. 

    Shamu75 pointsBadges:
  • Sorting hierachy data alphabetically in SQL Server 2005

    I have a follow-up question to the article Navigate hierarchies using recursive common table expressions. I have an employee hierarchy that follows a similar pattern to the article, but I need to be able to sort my data alphabetically within each level. Do you have any advice on how to accomplish...

    SQL Server Ask the Experts2,585 pointsBadges:
  • Accessing the Northwind database in SQL Server 2005

    In SQL Server 2005, I am not able to access the Northwind database. Some people have said that it is built into the SQL Server, but I can't access it. How would I do so?

    SQL Server Ask the Experts2,585 pointsBadges:
  • Backup Programmability in SQL Server 2005

    How can I backup the Programmability (functions, triggers stored procedures etc.) as part of a schedule job? Do I need to write code or can I use the wizard?

    IT Systems Analyst15 pointsBadges:
  • Connectiveity JAVA to Sql server 2000

    Dear all, I have problam to connect SQL 2000 server with jdbc driver.\ i m using windows 2003 server SQL server 200000 and jbuilder. anyone have jdbc driver for the same environment thnaks

    M.Asif5 pointsBadges:
  • Error installing the client tools for SQL Server 2000 onto an XP desktop

    When attempting to install the client tools for SQL Server 2000 onto an XP desktop, I get an error stating that “A previous program installation created pending file operations on the installation machine. You must restart the computer before running setup.” Rebooting only leads to the same...

    SQL Server Ask the Experts2,585 pointsBadges:
  • Migrating from MS Access to SQL Server Express

    I've just installed SQL Server Express and I want to create a local instance. I would like to use SQL Server to do my analysis in running queries instead of Microsoft Access. I want to import my tables from Access to SQL Server Express. How can I migrate from MS Access to SQL Server?

    SQL Server Ask the Experts2,585 pointsBadges:
  • BlackBerry getting non Lotus Notes inbox emails now.

    I have email rules setup in Lotus Notes that keeps me from getting 100's of our system emails by sending them to other folders and has been working that way for years. Last week even though Notes is still sending the emails to the correct folders, those emails have started going to my BlackBerry...

    mjonesjr815 pointsBadges:
  • Problem sending notice accepting calendar invite

    Whenever a user accepts a calendar invite from outside the organization, the following happens: - the meeting posts to the calendar correctly - the acceptance message is sent as coming from username@servername.mydomain.com Regular mail is sent as coming from username@mydomain.com Why is the...

    Stiletto3,830 pointsBadges:
  • Unable to take export

    When agent schedule then export not coming to directory.

    PravinPatekar5 pointsBadges:
  • SQL Syntax issue via Free-Form RPGLE

    I'm having difficulty with a select statement.  As below, it works .  If I remove the '//' comment-out tags, it doesn't, so obviously there's an issue with those statements.  I'm trying to populate an output 3-char field with either Yes, No, or N/A.  The Y/N comes from the contents of a field...

    Eric Witham690 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