• 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,415 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:
  • inserting null record in SQLServer2005 SSMEI through ASP.Net

    I'm developing my 1st website but when I'm trying to insert data into the SQLServer 2005 it inserting null record. I tried as it is on access. again their is a same problem. Here is my code: Imports System.IO Imports System.Data Imports System.Data.Sql Imports System.Data.SqlClient Public Class...

    Joshi4u5 pointsBadges:
  • SQL Server 2008: SSIS pakage with parameters

    I need to create SSIS package with user entered date parameter. I have two questions: 1. How I can promt the parameter when I test the package in debyg mode. 2. How can I put on the begining of the package design condition: Global Variable gvar_Date datetime; If @p_Date is null Then gvar_Date =...

    IG194410 pointsBadges:
  • Attaching a SQL Server 2005 database to SQL Server 2000

    How can i attach a database created in SQL Server 2005 to SQL Server 2000?

    SQL Server Ask the Experts2,585 pointsBadges:
  • Unable to correctly view overlapping SQL Server tables

    I want to overlap two SQL Server tables, and when I do, it is visible in Report Preview. When I run the report in a browser, however, the second table starts only when the first ends. Also, when I view them as a PDF, they show properly. Any ideas?

    SQL Server Ask the Experts2,585 pointsBadges:
  • Possible to deploy 2005 report to sql 2000 RS?

    I've never needed to do this before, but I need to know if I can deploy a report built with VS 2005 to a SQL 2000 Reporting Services box. I don't have an environment at the moment to test it on. Does anyone know if this is possible? Thank you in advance, tley

    Tley15 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