SQL Server

Page 4973




  • Topics
    Replies
    Last post
  • Will diagram chagnes the relationship between tables?
    by hommer
    2 Replies
    Last post by hommer
      • Hi, all, I am using sql server 2000, and I want to use diagram to map a group of tables and relationships among them. However, my question is, when I save the diagram, will the underlying tables change as well ( i.e. with new PK-FK constraint because I linked them on the diagram) Do I have an option to control what I see on the diagram and what are created on the database objects l
  • Can I use business objects as a data source?
    by SSIS Evaluator
    9 Replies
    Last post by jwelch
      • We have decided to use business objects in our new application, which seems to be working well, since they can be used as a binding source for grids, etc. I am trying to evaluate whether SSIS is a practical solution for our ETL requirements. The problem is, I can't find any examples or references, or even the slightest hint that anyone is using them with business objects. Any attempts to se
  • Effect of Joins on the Speed
    by RanaM
    3 Replies
    Last post by kbromer
      • Hi.. I want to know that when I do something like.. Select Query Left Join Select Query 2 Left Join Select Query 3 How does it work actually As in, whether Query 2 & Query 3 will work only on the records retrieved by Query 1 only. Or, all the select statements retrieves all the records and then the condition is applied to filter out the results.
  • Flatfile output truncating after 255 characters
    by swan_sgp
    6 Replies
    Last post by Phil Brammer
      • Hi, iam bringing an output in flatfile which is truncating after 255 characters,some of the data is vanishing because of this.can anyone pls help. pls advice. Regards, sg
  • Problem appending to a raw file
    by millerfjtp
    14 Replies
    Last post by Jamie Thomson
      • I have subscription records for five different magazine titles that i process by looping each one though a dataflow using a for-each loop. I am using the following instructions to append to the raw file: http://blogs.conchango.com/jamiethomson/archive/2005/12/01/2443.aspx This works fine when I pass four different magazine titles. when i try to run all of the titles(five), i get the following e
  • Incorrect Scripts using database generate scripts wizard
    by clayhien
    2 Replies
    Last post by jezemine
      • I am getting incorrect scripts, not an error, on the indexes when I use the database ¡®generate scripts¡¯ wizard. This only happens when I have 8 or more tables and on indexes with include columns. It¡¯s getting the index columns mix up the include columns. Here are the scripts I got: -- From database ¡®generate scripts¡¯ wizard with 8 or more tables (Incorrect) -- CREATE UNIQUE NONCLU
  • Connect to SQL Server from a PDA
    by janols
    14 Replies
    Last post by Hernexto
      • Hi, I'm developing Pocket Pc application, my application establishes connection with a SQL Server Express 2005 Database. When I try to connect to the database I get an error "SQLexception", when i deploy and run my application both on my physical PDA (HP iPAQ) and the Pocket PC 2003 emulator in Visual Studio 2005. I am working in .Net Compact Framework 2.0 and my PDA runs Windows Mob
  • How to write this function
    by JIM.H.
    5 Replies
    Last post by Waldrop
      • How can I write a function that accepts a data as a parameter and if the date is Last Monday in May or First Monday in September or 4 th Tuesday in November returns true otherwise returns false.
  • How specify the variable as parameter for a function
    by Jemini Joseph
    6 Replies
    Last post by Karunakaran
      • I could successfully modify the package level variable using a script component (Control Flow Level) and execute the data flow task after this script component. The OLE DB Command has one parameter for which I'm using one of the user variable. Here's the SQL statement. SELECT Year_Key, Year_Name, Year_Short_Name, Year_Number, Year_Start_Date, Year_End_Date FROM d_Time_School_Year WHERE
  • Interactive Sort on multiple columns?
    by Levi Wallach
    0 Replies
    Last post by Levi Wallach
      • I have one column in my database which is a double value, but based on a second field, it is either considered to be a flat value or a percentage. IE there's a IsPercentage boolean field which if true, makes the RateValue field display as a percentage (in the report), and if false it is formatted as a set $ amount. I want to be able to have an intereactive sort on the Rate column in my report tab
  • Outer join blues-sql 2005
    by logtorahul
    2 Replies
    Last post by Nitin Khurana
      • Hi there!! I want to have right outer join on two or more column between two tables.how can we do that in SQL 2005 as it does not allow us to use =* operator. basically i need below query in sql 2005 Select * from T1,T2 where T1.c1=* T2.c1 and T1.c2=* T2.c2 I tried this one Select * from T1 right outer join T2 on T1.c1=T2.c1 and T1.c2=T2.c2 --But thi
  • Getting the Date From Week Number
    by Rgoal
    7 Replies
    Last post by Lisa Nicholls
      • I have a column in my dataset that contains the week number. I would like to use 'Expression' Or code function to do that how can i get the date from week number for example the week number is 38 so i wil get this output: 09/17/07 - 09/23/07 (the week starts on Monday and ends on Sunday) Thanks
  • String Manipulation
    by EJLindsay
    8 Replies
    Last post by Arnie Rowland
      • I compute a string that represents the management upline for an employee. Example: 11345.22178.237543. 983452 I want to compute the reverse of this string for each employee such as: 983452.237543.22178.11345 How is the best way to do this in T-SQL Jay
  • Can not delet a publication in SQL server 2005: The publication does not exist [SQL server error: 20026]
    by Vincent Zhu
    2 Replies
    Last post by Emanuel Peixoto
      • Hi, everyone, I am new in SQL server 2005. I had setup SQL server 2005 P2P replication. Somehow it did not work one of two way replication. I tried to delete the publication. However I could not do it. have the same problem. When I tried to delete the publication, I got the publication " " does not exist.[SQL server error: 20026]. I tried to use sp_droppublication, it gave me error &q
  • Openrowset to Oracle doesnt work after upgrading to SQL Server 2005
    by Araki66
    10 Replies
    Last post by Araki66
      • Hi, I just upgraded to SQL server 2005 and some of my Openrowset to Oracle doesnt work. I found out that the issue occur with field with structure Numeric. The issue is not solve even when I try to cast the field to varchar. sometimes it succeeded and sometimes I get error 7320 & 7321. I'm using Oracle connector from SQL to Oracle. I've 64 bit SQL Server. Attach the code, th
  • DatabaseMail90 Question
    by Howard H
    1 Replies
    Last post by Mike Wachal - MSFT
      • Hi All- Sorry for the newbie question - but does SQL Server 2005 Express support the new form for databasemail In reading up on examples of how to implement the automated emails, I cannot get the server to send any emails. The event log complains of can't start databasemail90.exe and I can't find that file anywhere on the server. Is it only in one of the purchase versions
  • MDX filter question
    by ajarnolds
    4 Replies
    Last post by Vladimir Chtepa
      • I have a cube with two dimensions, Department and Customer, and a measure, Sales. I want to show Sales per Customer filtered by Department without showing the department. How do I manage this using a MDX query Regards Ajarnolds
  • NotificationText
    by renealejandrov
    2 Replies
    Last post by Joe Webb
      • Hi I wish to know why my notifications don't send the resulting text to my email. I get the email but with an empty body. I searched the NSDistributionLog table and the field NotificationText is NULL. Does anyone knows if I am missing some configuration or something Thanks a lot in advance..
  • Identity column value increments by 2 rather than 1 on insert
    by SIS
    3 Replies
    Last post by Remus Rusanu
      • I have an issue with a stored procedure activation on a service broker queue. The activation stored procedure simply RECEIVES the top message and then INSERTs a row into a table with an identity INT column. Each row inserted has the identity column value incremented by 2 rather than 1. Only one row is inserted in the table. If the activation is set to OFF and then manually calling the orig
  • access to data in the cube
    by cherriesh
    2 Replies
    Last post by dan english
      • Hi, i'm currently building a cube which data has a level of access depending who the logged in user is in the windows authentication. My cube's fact table is actually a VIEW with this line of code: SELECT a.serviceid AS [service code], a.agentid AS [agent code], a.timeid AS date, a.talktime AS [talk time], a.wraptime AS [wrap time] FROM dbo.factAgentActivity AS a INNER JOIN
  • error
    by guddu567568
    14 Replies
    Last post by guddu
      • hi i have one varchar field i m convarting that field to datetime in format of dd/mm/yyyy but i m getting eror select top 30000 CMS_Upload_Details_ID,Scheme_Code,DrCr, convert(varchar(10),cast(AdditionalField5 as datetime),103) 'ValDate' ,AdditionalField13 'dept_slip',AdditionalField14 'dept_dt',Cheque_No 'Instrm_No',Amount,CONVERT (varchar(11),Instrm_Date,103)Instrm_Date ,AdditionalFiel
  • "Creating a Mobile Application with SQL Server" Tutorial Problem
    by jonfroehlich
    13 Replies
    Last post by Ariston Darmayuda
      • I am attempting to go through the "Creating a Mobile Application with SQL Server" walkthrough found in the SQL Mobile Books Online help file. Towards the end of this document (under SQL Server Mobile Tasks), they show how to create a new subscription. Unfortunately, after step 10--when you are asked to click finish--I get the following error: TITLE: Microsoft SQL Server Management Studio ------
  • Design Pages on Report Server
    by Redefine
    3 Replies
    Last post by GregSQL
      • Hi every body I have developed an reporting solution for a customer with reporting services and using report builder. When he connect to http://localhost/reports , he see the page like http://img215.imageshack.us/img215/583/folderhl1.jpg But i would to custom design of my default page, and other maybe. Where i can do it Thanks all Regards Erwan Sarcelet, Franc
  • Login without Connect Permission somehow managed to become db_owner!?
    by howyue
    13 Replies
    Last post by Raul Garcia - MS
      • I tried asking the same question in other forum but couldn't get an answer. I used exactly the following SQL to create a login with sa account in SQL2k5 Management Studio: Create Login yy With Password='yy123Z' Without granting any permission, straight away, i log out sa and login as yy in management studio, yy somehow can access one of my ApplicationDatabase! So i check with the following SQL in
  • Trying to modify a db maintenance plan in SQL 2005
    by REDNARC
    14 Replies
    Last post by Dim0305
      • I am trying to modify a maintenance plan in Mgmt Studio - SQL 2005. All the maint plans were set up & are working correctly. I just want to make minor mods - also creating a new plan is not a problem - it's only when I right click and select modify - the message appears: Value cannot be null Parameter name: Component (system design) Any ideas