• Backing up virtual SQL servers

    The following question was recently submitted by a user via e-mail: I’m using ArcServe to back up our virtual machines, and I’m wondering what other tools people are using to back up their virtual SQL servers?

    ITKE350,945 pointsBadges:
  • IBM System x3400 connectivity

    We have brought IBM server x3400(7975PAT) which is running on windows server 2003 with SQL sewrver 2005 which is connected to 15 kiosks. I want to connect it to the one more server 2003 installed system to transfer data from the ibm server. How to connect ?

    Ppaul5 pointsBadges:
  • SQL Server vs Oracle comparison

    what is the difference from sql and oracle in detailed?

    Geta5 pointsBadges:
  • Error while referencing external assembly in SQL Server 2005.

    Sir, I created a dll (SqlWcfServiceLibrary1.dll) using .net frammework 2008. My code has a reference of another assemble (WcfServiceLibrary1.dll) also. I want to create assemble in sql and use that assemble in a procedure. I am getting error that "Error while referencing external assembly". I am...

    Batsa15 pointsBadges:
  • Database Migration

    Hi Friends, Any one can explain how to do the Sql Server database migration from version to version with screen shots i am new to Sql Server Thanks in Advance Thanks grace

    MSQL5 pointsBadges:
  • Large DB, low capacity line, resync log-shipping options.

    Hello, We've a large SQL2000 DB which is 335GBs in size and a majority of tables are geographically replicated to a subscriber using transactional replication across a 10Mbit line. We're going through the process of converting the DBs' environment to SQL 2005. Unforetunately I think this means...

    SuperCoolMoss140 pointsBadges:
  • Running Microsoft SQL Server on AS/400

    Anyone out there running Microsoft SQL Server on an AS/400?

    TopKat135 pointsBadges:
  • SQL Server with domain accounts

    When we install SQL 2005 servers, we usually have a collection of domain accounts for the services that will be running on that server. We usually log on to the server using a local account without logging into the domain. However, it seems to not recognize the domain user accounts and we end up...

    Andrewn20005 pointsBadges:
  • “Login Failed.”

    Using STANDARD REPORT CREATION WIZARD, I connected to UNIVERSES Data Sources and RUN a querry in BUSINESS OBJECTS QUERY PANEL, When I pull in fields from the universe into the query panel. But, the minute they hit "OK" they get and error that says "Login Failed." i am getting ERROR Message "Failed...

    Sandeepk6660 pointsBadges:
  • what is the max length for an sql cursor name?

    what is the max length for an embeded sql cursor name in RPG?

    TheMarkWTaylor5 pointsBadges:
  • New Contest: Win 1 of 3 Xbox 360′s

    New Contest: A trio of Xboxes for our top three users Now through the end of April, you can not only show off your IT skills by asking and answering questions on ITKnowledgeExchange.com, but you can earn the chance to spend some quality time honing your bad-guy-vaporizing skills on your very own...

    ITKE350,945 pointsBadges:
  • Using the return value of a SQL Restore script

    I am trying to use the return value of a SQL Restore script executed with SQLCMD, so that my batch script can report on the succes or failure of the restore. I am having difficulty getting the script to return the result of the backup or restore process. Do you have any suggestions? The follwoing...

    SQL Server Ask the Experts2,585 pointsBadges:
  • split column into column

    I need to Split the single datetime column into separate date and time column in SSIS package and exprot the data into Excel Sheet. Can any one guide how to do it ? Thanks in advance.

    Shamilh10 pointsBadges:
  • table row values for column headers

    Hi. I have two tables in a simple database: Prices ID (int, identity, PK) Year (smallint - year of value) Quarter (smallint - year quarter 1-4) Area (smallint - FK to Areas.ID) Index (float) Areas ID (int, identity, PK) Name (varchar) So, as you can see, the Prices table contains price information...

    Snowbunny5 pointsBadges:
  • Searching for a T-SQL query to find data from multiple SQL 2005 servers

    I need a T-SQL query to find a list of all database names and sizes from multiple SQL 2005 servers that are connected in a local network. Does one exist?

    SQL Server Ask the Experts2,585 pointsBadges:
  • pass variable from Foreach loop to stored Procedure parameters

    in control flow I run "Execute SQL Task" to retrive array variables like State Code ('AR', 'WI', .. et). Then I run ForeEach Loop Container and pass global variable gv_StateCode into Data Flow, where I run stored proc with one parameter in "OLE DB Source" (like exec sp_StProcname ?) and i assign...

    IG194410 pointsBadges:
  • Configuring SQL Server to not lock tables when using the SELECT statement

    Is there a way to configure SQL Server to not lock tables where I am using the SELECT statement, so as to not have to writte "with NOLOCK" every time I use SELECT?

    SQL Server Ask the Experts2,585 pointsBadges:
  • SQL Server 2005 log shipping network pass thru security

    I have a need to ship logs to a remote secondary server that is in a different domain and without domain trusts. I have configured the SQL Agent on each machine to use a local account (.\SQLAgent) with the passwords the same on both machine. The secondary machine can read the network share that...

    Jando9995 pointsBadges:
  • SQL Server 2005 Select Multiple views or Tables

    in SQL 2000 it was easy to cntl-right-click and select multiple views, stored procedures or tables and generate one script which could be changed (using SQL Analyzer) to create new objects (search and replace text) with different names. This was a big time saver but I don't know how to do that in...

    SapwizSAP5 pointsBadges:
  • SQL Server 2005 SP3 installation on Vista – error message

    A user recently submitted this question via e-mail: This Program has known compatibility issues. Check Online to see if solutions are available from the Microsoft website. If solutions are found, Windows will automatically display a website that lists steps you can take. Program: Visual Studio 2005...

    JennyMack4,280 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