SQL Server

Page 2125




  • Topics
    Replies
    Last post
  • Adding new column to Flat File Source Connection
    by holly kilpatrick 22222
    7 Replies
    Last post by DearDearDear
      • What is the best way to deal with a flat file source when you need to add a new column This happens constantly in our Data Warehouse, another field gets added to one of the files to be imported, as users want more data items. When I originally set the file up in Connection Managers, I used Suggest File Types, and then many adjustments made to data types and lengths on the Advanced Tab because Sug
  • I get "Line 1: Incorrect syntax near ')'." when using SqlClient ExecuteScalar
    by Anni
    2 Replies
    Last post by Matt Neerincx
      • Hi Marc, I have a similar problem as mentioned in the first mail of this chain. I am getting Line 202:Incorrect syntax near 'end'" while I try to execute the procedure from my VC++ code using ExecuteNonQuery method. can you guide me about solving this issue Regards, Anni
  • Millisecond values missing when inserting datetime into datetime column of sql Server
    by plmanikandan
    2 Replies
    Last post by Caddre
      • Hi, I'm inserting a datetime values into sql server 2000 from c# SQL server table details Table name ate_test columnname datatype No int date_t DateTime C# coding SqlConnection connectionToDatabase = new SqlConnection("Data Source=.\\SQLEXPRESS;Initial Catalog=testdb;Integrated Security=SSPI"); connectionToDatabase.Open(); DataTable dt1 = new DataTable(); d
  • Access database with php access
    by TrojanH
    8 Replies
    Last post by TrojanH
      • Hello all, forgive me if this isn't the right forum for this isue I'm using the following php code: $db = realpath("database/userdatabase.mdb") or die('<b>Connectie met database mislukt</b>'); $conn = new COM("ADODB.Connection"); $conn->Open("DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=$db"); $conn->Execute("INSERT INTO TblNews(Tit
  • Using Private Public Keys in SQL2005
    by jdyoumans
    3 Replies
    Last post by Raul Garcia - MS
      • Here is what I am trying to do. I want to create a private / public key pair (either a certificate or asymmetric key) and be able to give the public key to my business contacts. They would then use the public key to encrypt data to be sent to me and then I could import that data into my SQL 2005 database and use the private key to decrypt it. It seems to me that this should be a pretty simp
  • Problem: Formatting The Sql Report
    by Rgoal
    9 Replies
    Last post by Adam Tappis - IMGroup
      • I created a report using SQL Report Server project. I was able to retrieve my data without any problem. I am having a hard time to format the data correctly: when somebody access the report he will have the option to export it to PDF file Here is how I would like to format the PDF File: Test (title) Department : A
  • Automatically enable broker after restore or attach
    by Gh0sT.
    1 Replies
    Last post by Remus Rusanu
      • Is there a way to automatically enable Service Broker on SQL Server 2005 Express Edition after a database has been attached or restored My initial idea was to check if broker is disabled whenever the client application starts and enable it from there but the problem with this is that the current user might not have the required permissions. So now I'm looking for another way to enable it right aft
  • Problem with sync O2 mini with Windows Mobile Device Center
    by O2mini
    1 Replies
    Last post by Ilya Tumanov
      • I use my Pocket PC XDA O2 mini for 2 years already and I don't have any problems when I sync it with my previous laptop which has Window XP operation system. A few months ago, I bought a new laptop with Window Vista operation system, I could not sync my O2 mini with my PC. Then, I download Windows Mobile Device Center but my computer still could not recognize my O2 mini. My O2 mini has wind
  • Windows Authentication - Cannot generate SSPI context - Login failed for user ''. The user is not associated with a trusted SQL
    by Jon1982
    8 Replies
    Last post by Caddre
      • We are looking at developing an SQL Server 2005 Database and I would like to use Windows Authentication rather than SQL Server Authentication to connect our client app. In our development environment, we have two Servers, one being used as a file server and the other as an SQL Server. We have now set up a domain using the file server as the domain controller. (We had previously been set
  • MetaData Data Mining
    by Parkerjbp
    2 Replies
    Last post by Parkerjbp
      • I am looking for anyone who can help me find an existing tool that will allow my programming team to build reports and data extracts simply and easily from a form of query builder. Unfortunatley, my database is structured as a metadata store using name data pairs. The actual structure is something like: DateTime; Customer (integer); fieldname(string); fieldvalue (string) In addition, I have anoth
  • Affinity mask and affinity I/O mask configuration
    by un Laurent
    0 Replies
    Last post by un Laurent
      • I'm experiencing some problem with the affinity mask and affinity I/O mask configuration. We are running SQL Server Enterprise Edition 2005 64bit on Windows 2003 Server 64bit with 4 dual core CPU. The actuelly configuration is: Affinity Mask Affinity I/O Mask CPU0 0 0 CPU1 0 0 CPU2 1 1 CPU3
  • Finding the top 4 values in a given row and clubbing others
    by aquinn_21
    8 Replies
    Last post by aquinn_21
      • Hi Everyone, This is the table I have: Sections Class1 Class2 Class3 Class4 -------------------------------------------------------------------- A 30 20 30 40 B 40 15 10 10 C 20 5 10 5 Total 90 40 50 55 There are around 6 more classes which I haven't mentioned. The resultant table
  • Unpivot with multiple DestinationColumns
    by edazevedo
    2 Replies
    Last post by jwelch
      • Hi, I need to unpivot an excel worksheet with the following format Artcode Model Qtd1 Price1 Qtd2 Price2 Qtd3 Price3 Article1 Model1 1 10 2 11 1 12 Article2 Model2 3 15 3 12 2 14 Article3 Model3 2 12 2 20 1 15 If I had only one destination column, for ex: Qty, I had no problem,
  • Sending Message Using xp_sendmail
    by Madhuranath
    9 Replies
    Last post by Phil Brammer
      • Hi I have difficulty in sending message to different reciepients. I am using SSIS package to send in the parameter. If anybody could help to resolve will be great. Thanks declare @MailMsg varchar(1000) select @MailMsg = 'Hi there, Here are the Documents Nos. and details Status. Thank you.' exec master.dbo.xp_sendmail @recipients = , @subject = 'Documents Status', @message = @Mai
  • How do you call RMD on a component that has no editor?
    by Jamie Thomson
    8 Replies
    Last post by Jamie Thomson
      • I have a custom component that has no editor (i.e. NoEditor=TRUE in DtsPipelineComponent attribute). This component derives all of its metadata based on the input (hence no editor is needed). What this means is that if the input changes in any way (e.g. the datatype of a column changes) my component will fail validation. That's not a problem, the problem is my Validate() method returns DTS
  • New to MDX - Querying Dimensions
    by Robert F Bouillon
    8 Replies
    Last post by Darren Gosbell
      • This seems like a basic need that I don't understand. I would like to populate cells with "aggregated" attributes. For example, I have a Store with measures such as Sales and Expenses . I'd like to include in the report the Location and Size , both of which are dimensions. I want one record per store. The size of the store may change, so if I add Size to the axis, then I ma
  • User Defined Date Range in Stored Procedure
    by Donna Lee
    14 Replies
    Last post by Arnie Rowland
      • Using SQL SERVER 2005 for our work orders database which contains opendate and clsddate fields. My user would like to enter a start date and an end date and see a count of cases that were opened, closed and are still pending as of each date in the range. For example: OPEN CLOSED PENDING 04/16/07 65 43 131 04/17/07 53 59 125 04/18/0
  • Auto Filter in 2005 Reporting Services
    by ray_newbie_SSIS
    5 Replies
    Last post by ray_newbie_SSIS
      • Hello Experts, I have been playing around with RS 2005 and like it so far. I am in the process of replcating some excel reports in RS. I was wondering if there is any way to replicate the Auto Filter Functionality of Excels sheets where column is a dropdown with disticnt values of that specific column and also has Top 10 and Custom filters attached to it. So when selected from dropdown the report
  • SSIS - Fuzzy Lookup fails with the following error on SQL 2005 SP2
    by dwBIconsultant
    7 Replies
    Last post by dwBIconsultant
      • Hi All, I have created a SSIS package with a Fuzzy lookup transformation. It matches on 18 columns, looks for a 95 % match and has 50 variables that are passed through the transformation. When I run the transformation it fails with the following error :- Warning: 0x8007000E at Data Flow Task, Fuzzy Lookup [228]: Not enough storage is available to complete this operation.
  • Server Error in '/XCopyDeploy' Application
    by emmy_23
    1 Replies
    Last post by Jens K. Suessmeyer
      • hi there, i'm using visual web developer express edition 2005 to make internal web site using asp.net and sql server 2005 express,sql server management studio for attaching the db(company.mdf),windows xp professional and IIS for deploying the project.the project is working fine when i run it using localhost with explorer only the default page is running but when i access the other pages which h
  • Restore Sql Express (2005) to Sql Server 2000
    by RDuke
    5 Replies
    Last post by MikeBee
      • Well, my understanding is this should be possible and easy -- use a backup created by Sql Express (via Management Studio Express), copy the backup to the Sql 2000 server, select Database Restore through EM, specify Restore from Device, point to the Sql Express generated backup file as the *only* device, and launch. Doesn't work. When I launch the restore, I get the following error dialog: Too many
  • SQL Server CE tools problem
    by BLytt
    6 Replies
    Last post by _John Reynolds_
      • Hi I had VS 2005 Pro and SQL Server Dev. Ed. 2005 installed. These were patched to SQL Server 2005 SP1 and then VS2005 SP1. Yesterday I installed SQL 2005 SP2. Today I successfully installed the main bits from http://www.microsoft.com/sql/editions/compact/downloads.mspx but the VS tools will not install. It's telling me that the upgrade cannot continue. I think that VS2005 SP1 may already include
  • Passing Report Parameter Through URL
    by SQL Servant
    14 Replies
    Last post by Lisa Nicholls
      • I am experiencing a problem that has been posted a number of times but cannot find a solution. Passed linked report parameter value through URL: Jump to URL: Code Block ="javascript:void(window.open('http://myservert/Reports/Pages/Report.aspx ItemPath=/Sales/Enquiries/Order+Enquiry&rs:Command=Render&Cust="+Fields!Cust.Value+"'))"
  • Remote Source and Destination Performance
    by RickGaribay.NET
    8 Replies
    Last post by Rafael Salas
      • Given the following scenario, what kind of performance should be expected in transferring about half a million rows We are seeing about a 9 minute execution time. Is this reasonable for about 460,000 records moving from source to target, with 3 inner joins from the source Source: Server A.OLTPDB Target: ServerA.DataMartDB Server A is running SQL Server 2000. SSIS is running on a different
  • Problem installing SP2 on active-passive x64 cluster
    by RL Coppedge
    5 Replies
    Last post by Forrestsjs
      • I just tried to apply SQL 2005 Std SP2 on a cluster, and all succeeded except for the Database Services. I've looked about and can't see any specific information for this. The Summary.Txt is below. I thought I was following the appropriate steps, according to the SP2 Readme. Thanks for any help. (I'm at the client today) Bob Coppedge me at RLCoppedge dot com Time: 04/04