• Read Excel from Sql Server 2005/2008 SQLEXPRESS

    How to read the excel data's from Sql Server 2005/2008 SQLEXPRESS

    Sridhar12350 pointsBadges:
  • shredding xml in sql server 2005

    In SQL Server 2005 one shreds XML via the nodes() method. When inserting into a table using this it preforms extremely slowly. If the "into #x" is removed the shredding is very fast. declare @x xml -- there are 1000 rows in the xml document set @xml = ' <rows> <row>...

    Skidancer5 pointsBadges:
  • SQL Server restore job fails

    I've created a Restore Job under SQL Server Agent. Job owner is sa, Run as User dbo. There are no users connected to the database or processes running. The job fails with: Msg 3101, Sev 16: Exclusive access could not be obtained because the database is in use. [SQLSTATE 42000] Msg 3013, Sev...

    TuftsDBA0 pointsBadges:
  • Upgrading from SQL Server 2000 SP3 to SQL Server 2000 SP4

    We have SQL Server 2000 SP3 running on Windows 2003 Server. Every week, after running our optimization and integrity checks on Sunday, we get this error: Time out occurred while waiting for buffer latch type 2... This happens several hours into the day every Monday. Would upgrading to SQL Server...

    SQL Server Ask the Experts2,585 pointsBadges:
  • Mainframe access to SQL server data

    How can I access SQL server data from a mainframe COBOL program?

    Artisan5 pointsBadges:
  • What is the biggest way data centers can help with PCI?

    What is the biggest way data centers can help with PCI?

    Artsypal5 pointsBadges:
  • Changing the background color of a page in Microsoft Word 2010

    In Microsoft Word 2010, I can change the color of "all" my pages because of the Page Layout Tab. However, I'm looking to change the color of just a "single" page. Is there a way to do this?

    ITKE62,175 pointsBadges:
  • Invoice error

    I accidentally posted an invoice without entering the figures in sage line 50. Is there a resolution to this problem?

    jackie4610 pointsBadges:
  • How to build a career in IT if the person is from commerce field

    Hello, I'm from commerce but now I'm joining a course on software testing. Please suggest to me how I can build my knowledge in Software Testing and I'm also joined one software company as a trainee but I'm not fully knowledgeable yet. Please suggest to me on how to star my work. Thanks!

    seeds15 pointsBadges:
  • HTTP vs. http

    What is the difference between HTTP & http...or is there one? If there is no difference, why is it that one acronym is in lower case and the other in upper case? A very basic query, I realize.

    JanuaryGirl5 pointsBadges:
  • Update Data SQL Server From AS400

    Hi, some help me. I want to write data to SQL Server from AS400 in RPGLE. Some have code for make this. Thanks for advance.

    JLH5 pointsBadges:
  • 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,445 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...

    ITKE62,175 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:

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