• Virtualizing a SQL Server cluster in a production environment

    What is Microsoft's official position in using virtualization (Virtual servers such as VMWare, etc.) for a SQL Server cluster (two node Active Passive) in a production environment? What are the best practices?

    SQL Server Ask the Experts2,585 pointsBadges:
  • What is the difference between RAM and Cache Memory in SQL Server 2005?

    What is the difference between RAM and Cache Memory?

    SQL Server Ask the Experts2,585 pointsBadges:
  • SQL SERVER 2005-MAX FUNCTION

    I have a stored proc1 which returns a list of dates for one particular job number.I execute this proc in an other proc2 ,to get the list of all dates. Then in my proc2 we can get the MAX of this list of dates. In the WHERE clause of my SELECT statement, i need to filter the result set by dates less...

    Beginner in IT5 pointsBadges:
  • Access rights in SQL Server 2005 users

    Hello, I'm using Ms SQL Server 2005. I'm connecting server via ADO. I have a question about access rights. Let me tell this with an example. Let's say I have a database named as DB. In DB there are 3 tables. TBL_1, TBL_2, TBL_3. I want to create a SQL user which will have all righst on TBL_1 and...

    DetayMan5 pointsBadges:
  • Issues rebuilding system database on SQL Server Express 2005

    I am having some trouble rebuilding the system databases on my SQL Server Express 2005 instance. While I have had a total system failure, the backups have been good. I have restored the operating system but obviously there are no SQL system databases present (they were open at the time of the...

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

    ITKE56,495 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:

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