SQL Server

Page 2999




  • Topics
    Replies
    Last post
  • oracle oledb provider not registered in local machine
    by r214acc
    9 Replies
    Last post by r214acc
      • Hi, I am trying to establish a connection to an Oracle database using the following code in a script task: Dim oOleDbConnection As OleDbConnection Dim sConnString As String = _ "Provider=OraOLEDB.Oracle;" & _ "Data Source=DBxxx;" & _ "User ID=Userxxx;" & _ "Password=Passxxx" oOleDbConnection = New OleDb.OleDbConnectio
  • Comparing two SSIS Packages?
    by MatthewRoche
    9 Replies
    Last post by pjtaylor
      • I'd like to know how people out there are comparing ("diffing") their DTSX files. Using XML file compare doesn't seem to work, because the package XML appears to be arbitrarily ordered and reordered by the designer in Visual Studio. ApexSQL is supposedly planning to have a tool available in Q3, but even their product page does not seem too hopeful: " Compare and Docume
  • Replication
    by vamsikg
    6 Replies
    Last post by vamsikg
      • Hi all: I am new to Mobile Data Bases. I am using mobile data base 2005. I want to transfer the data from the mobile DB to to the sql 2000 server DB. Presently i am using RDA where i am having a problem when the new records got inserted when the mobile and sql 2000 server. I saw this as a limitation for the RDA. Will any one suggest me the better option for transfering the data from my m
  • Query Notification stops working after 10 minutes
    by EdenZa
    5 Replies
    Last post by PMass
      • Hi All We built a Cache component that take advantage of the SQL Server 2005 query notification mechanism, all went well , we tested the component in a console application , and notifications kept coming for as long time as the console application ran. When we initiate our Cache Component in our web service global.asx application start event , the query notification works for a few minutes ,
  • Replication on table with image column.
    by obsid
    5 Replies
    Last post by obsid
      • I got a problem when replicating a table with an image field. First I started replication and it seemed to work. Then after a day or so I noticed that the replication had stopped and it had a few errors like this: Command attempted: if @@trancount > 0 rollback tran (Transaction sequence number: 0x000182EB0000025E001100000000, Command ID: 1) Error messages:
  • Previous Month To Date Calculation
    by AdamAtAirNWater
    14 Replies
    Last post by Deepak Puri
      • I am currenty attempting to add a calculation to get previous month to date calculation. I currently have the following calculation in to calculate previous Year to Date and am having trouble adapting it. Any help is appreciated. Please note I am fairly new at this. Previous Year To Date: ([Time Calculations].[YTD Pr Yr]= Aggregate( Crossjoin({[Calendar Year].[Current Period]}, PeriodsToDa
  • The owner () of job <Job Name> does not have server access.
    by RoviWil
    7 Replies
    Last post by Robert W.
      • Up till now the jobs have been running without fail for months after the upgrade to SQL 2005. For some reason the jobs started to fail with the error: The owner () of job <Job Name> does not have server access. The user is a domain admin with the ability to control every sing aspect of SQL. I then changed the owner and now the jobs are running again. I am however afraid it will happen
  • Question on how to display data in this unique situation.....
    by Btong
    13 Replies
    Last post by Btong
      • Hi guys, Man I do come up with strange scenarios, but that is the joy of working in software field right ;-) First off, thanks to anyone taking their time to read this, and Ihope this post paints a clearer picture better than my previous posts. I have an old stored procedure (which I didn't create) that produces a dataset of the following:- ((All names and values had been changed t
  • Problems using SSIS w/ non-SQL Server data sources
    by Christopher Hart
    2 Replies
    Last post by Rafael Salas
      • I've encountered a few problems using SSIS against non-SQL Server data sources and was hoping that others might have some experience. Google searches and browsing MSDN hasn't led me to a solution, so any advice on the following is appreciated: 1) When using the "Data Source Views" wizard to add a data source view from an ODBC data source, only tables appear in the object listing. V
  • Best Practices Analyzer Installation Problem
    by Sharon F. Dooley
    1 Replies
    Last post by happy we tod
      • For my classes, I build a machine with all the necessary tools, including the current version of the Best Practices Analyzer. We then create a Norton Ghost image of this machine. The ghost image is restored to each classroom machine. I run a program to change the machine name, its IP address and randomize the machine's SID. Then I join the machine to the domain. All the installed software is avail
  • Help with SQL Query
    by MdGo
    12 Replies
    Last post by [rh4m1ll3] Rhamille Golimlim
      • Given the following two tables below, I need help in writing a query that would retreive only 3 or less distinct values of BDesc from tbB table for every row found in tbA. for example: I expect result to be: Aid Bdesc 100 1st Desc for 100 100 2nd Desc for 100 100 3rd Desc for 100 200 1st Desc for 200 200 2nd Desc for 200 200 3rd Desc for 200 300 1st Desc for 300 300 2nd Desc for 3
  • foreach loop xmla analysis services execute ddl task
    by avneet sd
    1 Replies
    Last post by Yimin Wu
      • Hi: I am a R data miner who is new to SQL and SSIS and would appreciate any help. I wanted to automate the process of creating and processing decision tree models for every county in the Country. I wanted to use the foreach loop for iterate through all the counties. I wanted the foreach enumerator to be used by the XMLA code that creates the model so it would append it to the name of the model an
  • MSDB database grows too much even though its empty.
    by Marcos Bertoldi
    12 Replies
    Last post by Marcos Bertoldi
      • In my SQL Server 2000 msdb database I have several DTS and a few jobs. I also do backups daily. All this should make the msdb grow but I've removed most of the logs and histories and, still, the database is almost 1Gb big. The log file is almost at 0. It is the data file that ocupies the whole size. I'm thinking it must be some kind of corruption of a table so I ran dbcc checkdb, checktable, cl
  • Help with finding last record!
    by Hollispj
    10 Replies
    Last post by Hollispj
      • I have two columns - code (nvchar) and date (datetime) within an sql 2005 table. The code contains a list where the items are duplicated and I need to search for each item for the newest date and if the date is older than 180 days to display that record. Was relatively easy using the Last function but this does not exist now. Any help would be appreciated. TIA
  • CrossDB Model
    by tviel
    5 Replies
    Last post by Eyso Zanstra
      • Hi, I'm used to AS while designing and using OLAP-Cubes. Now I have to build and publish several models directly on relational base. So far, no problem with the wizards, every DB got a model with attribs and roles. But the information i wanna analyze, is splitted across multiple databases, where there is no foreign key relationship designed in DB. I have to link the tables of differe
  • Performance issue on BLOB
    by KristianT
    4 Replies
    Last post by John Gordon - MSFT
      • Hi there, I have a table with 3 fields: CREATE TABLE images (id INT PRIMARY KEY, blobSize INT NOT NULL, image MEDIUMBLOB); which is filled with ~4000 rows with images about 70-80kB in size. What I can't understand is why it should take so much time to get a single image from the database. It actually takes about the same amount of time to get one image as it do
  • Limiting Content of Progress Tab
    by Dolllar Dude
    24 Replies
    Last post by Dolllar Dude
      • Is there any way to limit the content that is placed into the Progress Tab during execution of a package in debug mode My problem is that I have a complex package that puts lots of info in there. This package is called in a loop from another package. Each time the package is called, the new info is added to the existing info in the Progress Tab. Eventually the instance of Dev Studio hangs
  • SQL Server 2005 Reports not displying properly in Mozilla
    by Deepthi Jeffin
    1 Replies
    Last post by Amilas
      • Sql server 2005 Reports are not displaying properly in mozilla.What should I do to work It is working fine in IE.
  • Multiple Reports
    by facemann
    9 Replies
    Last post by facemann
      • Hi all, I have created a report that everyone is happy with. My dataset (simplified) looks like this: SELECT * FROM FamilyMember WHERE QuestionnaireID = @QuestionnaireID Now, instead of running individual reports the users want to run several reports on a list of QuestionnaireID's. I thought something like this would work: SELECT * FROM FamilyMember WHERE QuestionnaireID IN (@QuestionnaireID) but
  • What is the best Backup strategy
    by Julius.S
    14 Replies
    Last post by S.Julius
      • We are currently doing daily full backup of system & custom databases since database size is small. Is that good idea or better option would be weekly full & daily incrementatl Do we need to do any special backup on system databases or transactional logs Please advice
  • SQL Server 2005 Express Edition with Advanced Services SP1
    by api.ionescu
    2 Replies
    Last post by Mike Wachal - MSFT
      • i have an installation of SQL Server 2005 Express Edition and now i want to upgrade to SQL Server 2005 Express Edition with Advanced Services SP1 but without uninstall the old version...could someone help me...
  • Can not create a Full Text Catalog or Index
    by RushMehta
    1 Replies
    Last post by zuomin
      • When I try to create a full-text catalog on my local database I get an error that I can not find support information for. Here is the command I run : CREATE FULLTEXT CATALOG asset_search_values_catalog on FILEGROUP ftFileGroup IN PATH 'C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data\' as default Here is the error message I get: Msg 7689, Level 16, State 1, Line 1 Execu
  • Error: A deadlock was detected while trying to lock variable "x" for read access. A lock could not be acquired after 16 atte
    by TheViewMaster
    9 Replies
    Last post by GrahamTu
      • I simply made my script task (or any other task) fail In my package error handler i have a Exec SQL task - for Stored Proc SP statement is set in following expression (works fine in design time): "EXEC [dbo].[us_sp_Insert_STG_FEED_EVENT_LOG] @FEED_ID= " + (DT_WSTR,10) @[User::FEED_ID] + ", @FEED_EVENT_LOG_TYPE_ID = 3, @STARTED_ON = '"+(DT_WSTR,30)@[System::StartTime] +"',
  • how to pass strange looking Passwords to SQLCMD ?
    by KonRi
    3 Replies
    Last post by KonRi
      • I have problems with passing strange looking passwords from my win.form application to sqlcmd. I tried to do this: sqlcmd -S myServer -U myUser -P 2pQ-""xELfG~fze<= -d "McSpalDB" -i "C:\myProcedure.sql" -o "C:\temp\myOutput.out" but it fails, so I tried to encapsolate the passwoard in "": sqlcmd -S myServer -U myUser -P "2pQ-""xE
  • Load a XML file to a variable
    by MShetty
    12 Replies
    Last post by jaegd
      • When I look into the XML Source component, there is an option of XMldata from varialbe, can anybody help me in knowing how exactly do I go about in loading an XML file onto a variable