• Looking to enter IT field

    I am a college grad but I have no IT experience and I am looking at pursuing at Networking career. What is the best way for me to break into the industry? Should I get a Network Admin. certificate or should I go for an Online Masters Degree in IT? Or should I get another bachelor's degree in IT?...

    Jackcarr205 pointsBadges:
  • SQL Server does not exist or Access Denied Error

    I have a VB.Net app which connect to a SQL Server database, just recently the technical guys removed the DNS server from the network for maintenance. and now my application cannot see the SQL server. I can ping it using its IP address and it responds but even if I configure my application to use...

    Sanisto45 pointsBadges:
  • convert a query from access to sql server 2005

    Ive recently been given the task of converting an application from an Access database to sql server 2005. One of the queries has this on the ORDER BY Clause ORDER BY not isdate(Obsolete), not isdate(not_relevant), isdate(assessed), isdate(published), isdate(implemented), not locally_adapted,...

    Mark...w10 pointsBadges:
  • Failed ODBC USER DSN connection to SQL Server 2005

    I developed a project in VB.net with SQL Server as the backend using ODBC Data source. I converted the DB to SQL Server 2005 and tried to change the ODBC Data source connection with a SQL Server native client. The ODBC USER DSN connection is not obtaining the SQL Server 2005 database I created. How...

    SQL Server Ask the Experts2,585 pointsBadges:
  • 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 Tidmarsh25,225 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...

    ITKE54,720 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:

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