SQL Server

Page 2372




  • Topics
    Replies
    Last post
  • Microsoft project server 2007
    by laura22
    0 Replies
    Last post by laura22
      • Is it possible to run Microsoft project server 2007 on LAN without using Active Directory Is it possible to keep Active Directory on a separate machine and install project server 2007 on a different machine.
  • Invalid Schema or Catalog with Linked Servers
    by Amstel
    4 Replies
    Last post by Amstel
      • Hi I am current having an issue with using a catalog in my linked server on SQL Server 2005. I create my Linked server as follows: exec sp_addlinkedserver @server = N 'LINKED_SERVER' , @srvproduct = N '' , @provider = N 'SQLNCLI' , @datasrc = N 'MYSERVER' , @catalog = N 'MYDATABASE' (and I add the user security accordingly)
  • How to split three-value column into the same target?
    by enric vives
    1 Replies
    Last post by Phil Brammer
      • Hi everyone, We've got a source file which owns three different values: 'A','B','M'. Where 'A' stands for "New Rows" and 'B' for "Delete rows" and 'M' for 'Update rows' Using Conditional Split task we can redirect each subset into a OLEDB Destination but we are wondering how can we do the same using only one OLEDB We've got only one table. Thanks for your input and
  • Variables
    by BrianJohnson
    4 Replies
    Last post by JayH
      • Hi everyone, Is the only way to get a SSIS variable to change values via a configuration file or table I thought that at one point in developing some SSIS packages that if I changed the value of a variable in a script that value was then retained. Thanks
  • Calculated members are unbelievably slow
    by Ashok Ojha
    3 Replies
    Last post by Mosha Pasumansky
      • In general. Need help what are the top items I must check My client is Excel Pivot table I have one cal. member [NAV] from one fact table  I am getting POSN TOTL CURR NAV BAL PTFC and OWNSHP PRCNTG cal. mem [NAV] formula is below Iif (([Investment]. CurrentMember . Level . Name = "Investment Cd" or [Investment]. CurrentMember . Level . Name = "Investment Type Cd" ) and
  • Exists and Filter don't play together?
    by furmangg
    3 Replies
    Last post by Mosha Pasumansky
      • Can anybody explain why the first two queries work, but the last query returns no rows --works fine with member [Measures].[TestTrue] as True select {[Measures].[Internet Sales Amount]} on 0, Exists ( [Product].[Product].[Product]. members , ,"Internet Sales" ) on 1 from [Adventure Works] --works fine with member [Measure
  • ODBC support
    by achalk
    8 Replies
    Last post by William Vaughn
      • Can CE be called from an app. that makes ODBC calls Thanks.
  • LEFT JOINING two INNER JOINS
    by Diango
    8 Replies
    Last post by Arnie Rowland
      • Just double checking with you guys, but is this an acceptable way of joining two inner joins: Select column1, column2, column3 FROM table 1 INNER JOIN table 2 ON table1.column = table2.column LEFT JOIN table 3 INNER JOIN Table 4 ON table3.column = table4.column ON table3.column = table1.column
  • EXTRACTING DATA FROM FOXPRO/ACCESS 2000 INT SQL SERVER 2005
    by Wilfi
    3 Replies
    Last post by Wilfi
      • Dear Sir/Madam, I have some data which is stores in Foxpro dbf files & Access 200 MDB file. Can i extract import these files into SQL Server 2005
  • Binding WebService as Datasource
    by TravisBickle
    1 Replies
    Last post by Ian Roof - MSFT
      • I've painstakingly managed to get a XmlDocument from a webservice and run this to retrieve data. However, i cannot bind any of the returned elements to anything. Any help appreciated.
  • Parent Package Variable issue?
    by Hubajube
    3 Replies
    Last post by Phil Brammer
      • I have noticed an issue with parent package variables. I have a package with multiple parent package variables defined, call them X, Y, and Z. I also have a parent package that calls this other package. The parent package has variable definitions for X and Z. It seems that the value for X will be passed along, and Y will give a warning since there is no variable of that name in the parent. The iss
  • relationships problem
    by curiousEngine
    2 Replies
    Last post by Manivannan.D.Sekaran
      • VB.NET 05 (ADO.NET) / SQL SERVER 05. i have a many-to-many relationship. therefore, according to the normalisation theory, i introduced a new table which acts as a link between them. 1) tblOrders PK: orderID 2) tblOrdersItems FK: orderID FK: itemID 3) tblItems PK: itemID the user wishes to view the details of a particular order which should include all the items contained withing that particular o
  • Does Fuzzy Lookup work with Oracle ?
    by Jan Vandepitte
    2 Replies
    Last post by Matt Masson - MSFT
      • Sorry, this might be an obvious question, but I can not find anything in the documentation/forum. I want to use a Fuzzy Lookup between 2 Oracle tables. I select the Reference Table. I then switch to the Columns tab, but the "Available Input Columns" and "Available Lookup Columns" lists are always empty. I have experimented quite a bit, but to no avail. I not
  • Report Navigation and jump url
    by Degremont
    2 Replies
    Last post by Degremont
      • Hi all, I have got a report with external hyperlink. When I put this link in TextBox properties >> Navigation >> Jump URL of my gridView : http://www.micheldegremont.com it works. However, if I put " http://www.micheldegremont.com id=" + Fields!ID.Value it doesn't work. I haven't not link in my report. And if I put http://www.micheldegremont.com id=Fields!ID.Value
  • Using devenv to deploy a Reporting Service project
    by Martin Mason
    1 Replies
    Last post by Martin Mason
      • This issue has been raised in a tangentially related thread ( http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=301467&SiteID=1 ) but no thread has been started specific to this issue. When trying to deploy a reporting services project using devenv on the command line, the following error is raised for each report. Code Snippet Error : Invoke or BeginInvoke cannot be called
  • 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
  • Linked Server loses login-mapping
    by cherrii
    1 Replies
    Last post by Raul Garcia - MS
      • I use linked serve with (Security :be made with specific security conterxt) to connect to my production server from a Data Archive server. Stored Procedures loop throught the prodcution data to insert records into Archive tables...Howerver after few hundreds of iteration I get the following error... "Access to the remote server is denied because no login-mapping exists." I am confused w
  • ASP 3.0 Record is getting saved twice.
    by Sunil Dutt
    6 Replies
    Last post by Sunil Dutt
      • Hello All, I am facing this unusual error. In My ASP Page I am submitting the Page and after submitting the form I am calling another ASP page, which contains sql command to insert the record. My Problem is when I am submitting the Form. Record is getting inserted twice with same values. What is the cause of this problem as I am facing this problem in every form. With Regards Sunil
  • Performance issue
    by Dagz
    13 Replies
    Last post by Dagz
      • Hi, I trying to figuer out why the following update takes to long. To run the following code as an update takes about 20 minuets with 125,000 records if I remove teh Update and run it as a Select it take 4 seconds. so seems to be taking a very long time to write the Data to disk (I looking for reason other than Hardware, while it might be hardware it running an a dual chip xeon system with loads
  • Sql Server Cube/Database updates
    by jonkazama
    1 Replies
    Last post by Darren Gosbell
      • Hi there, Do Sql Server sample databases or cubes (for example, the Adventure Works database/cube) ever get updated or hotfixed If so, where would I go to find the latest version/hotfix Thanks, Jon
  • Date format UK/US
    by chris585865
    4 Replies
    Last post by chris
      • Hi I have installed SQL server 2005 developer edition.When trying to insert a date in the UK format '16/04/2007' I get the following error... The conversion of a char data type to a datetime data type resulted in an out-of-range datetime value if I change the date to be inserted to an American format then I am able to insert it. I don't want to change the sql as this is something that has always
  • can transaction log file (.ldf) creation be disabled?? and HOW??
    by Ibrahim85
    6 Replies
    Last post by Joe Webb
      • I am using SQL SERVER 2005. I have a huge database(.mdf) file. The main reason for the big (.mdf) file is having one huge table that is around 4gb. So every time i try creating an index or working on the table, the transaction log file grows rapidly and fills my whole disc space, even though my RECOVERY MODE is set to SIMPLE. As the log file is not very important, i would like to know if there is
  • How to Create Rank column
    by Ragz
    7 Replies
    Last post by CoolBhatt
      • If I have a column like this value --------- 34 45 54 How can I write an expression to create corresponding Rank column. value   Rank -------------- 34        3 45        2 54        1 Thanks
  • SQL Profiler launching error
    by Mike Sailer
    4 Replies
    Last post by Satya SKJ
      • Not an expert on this but have multiple XP system running SQL Express and am trying to get Profiler90 to run. Regardless of system, every time it is executed, it generates an "application failed to initialize properly (0xc0000005)" error. When running dependency walker against it, it appears the instapi.dll file is not found although it exists on the system. Trying to register the dll pr
  • CustomData on SQL Server connection string?
    by furmangg
    3 Replies
    Last post by Jivko Dobrev - MSFT
      • Analysis Services has a CustomData connection string property. You can put anything on it, then inside an MDX query you can use the CustomData() function to retrieve whatever was on the connection string. This is helpful for passing in a security token. Is there anything equivalent for SQL Server I also posted this here , but got no response so thought I'd check in the security forum