SQL Server

Page 4790




  • Topics
    Replies
    Last post
  • Add SQL database - "login failed for user" error
    by Jon 2007
    3 Replies
    Last post by Charlie Calvert MSFT
      • Hi I've installed 'SQL Server Express 2005 SP2'. When I select 'SQL database' from 'Add new item ' (either in Visual C# or Visual Web Developer express) I get the following errror: "Login failed for user'. My OS is Vista. I've tried reinstalling SQL Server express, but I still get the same error. Any ideas on how to fix this Thanks Jon
  • MULTIPLE COLUMNS using and GROUP BY
    by SighD
    8 Replies
    Last post by SighD
      • I hope there's someone that is able to help me. I'm new to SQL Server 2005 and have come across a pretty tough problem. I need to return City Names from the City Table ordered by province and postal code. However, SELECT statement returns multiple occurrences of a City_Name from the Cities table. I only want the City Name to appear once though. Here's the SQL statement: "SELECT City_Name, Pr
  • Service Pack
    by Techquest
    4 Replies
    Last post by Geert Verhoeven
      • How would one determine the SP for Reporting Services. Is it different from the SP of SQL Server itselves. This is for 2005
  • copying a DB from one server to another
    by EugeneB
    3 Replies
    Last post by EugeneB
      • Hi I have a PC with MSDE2000 and need to copy the data to another PC running SQL2005. I have registered the MSDE server on my SQL2005 PC and can see the tables etc. Can this be done automatically, say every day Is there a way of mirroring the DB Cheers Eugene
  • Default message for data unavailability
    by Mahesh Kulkarni
    9 Replies
    Last post by Mahesh Kulkarni
      • While running report if user make some selection which reflects no data I want display some default message instead of blank screen. How it can be achieved
  • Schema use in SQL2005
    by Colm Ryan
    10 Replies
    Last post by Michael Hotek
      • The problem we are having is that we are including components from 3rd parties that are expecting the default behaviour of the EXEC statement within a SP to default the schema correctly according to the invoking user. From what I can see this is not happening in SQL2005. Is this a bug in SQL 2005 or normal behaviour
  • SQL Server 2005 Standard will not install MSSQL default instance
    by fbellay
    2 Replies
    Last post by fbellay
      • I installed SQL Server 2005 flawlessly yesterday. When login as "sa" through SQL Server Management Studio, I get an error message saying it cannot connect to my PC. I checked the MSSQL Server Service. It is not started and cannot be started because it's looking for a path that does not exist!. The folder in question is missing. C:\Program Files\Microsoft SQL Se
  • Limited Remote Login db access
    by Rob690
    9 Replies
    Last post by Arnie Rowland
      • I have connected my desktop and laptop computer at home, on my desktop I have a series of db's under my default named instance <computername>/sqlexpress and I have created access logins using windows auth. When I connect to the desktop from the laptop using tcp:<computername>\sqlexpress\userid I can only see the system db's...I am trying to view adventure works, which I can see on the
  • Dynamically display/hide the parameter input
    by mdipalma78
    7 Replies
    Last post by LieutenantFrost
      • I have a handful of reports that are currently used by sales reps, and I'm trying to make them available to their regional VP's, and coporate users (executives and administrative staff that support Sales nationwide). Currently, the reports take the UserID and resolve it to show the information that is only appropriate for that specific rep. What I would like to do is have the paramet
  • Shredding XML to Relational Data: Query Processor Out of Resources
    by smithicus
    2 Replies
    Last post by smithicus
      • Hi there, I have an irritating problem which I just cant seem to solve. I am trying to retrieve the relational dataset from an xml column using the nodes method provided by SQL Server 2005. This shredding to relational data is done by one stored procedure which is triggered when the xml document is retrieved by a soap service. The stored procedure first inserts the xmldocument into an xml column a
  • How do I stop replicating deletes without a Snaphot?
    by ColSchmoll
    3 Replies
    Last post by ColSchmoll
      • I can switch off replication deletes be running the following: EXEC sp_changearticle @publication = 'PUBNAME' , @article = 'ARTICLE1' , @property = 'del_cmd' , @value = 'NONE' I believe I can the effectively then remove the delete stored procedure from the replicated database. And all this wroks no problem. However, when I come to add a new article, &qu
  • Sql Express Vista trouble #2
    by AlexBB
    9 Replies
    Last post by Mike Wachal - MSFT
      • Actually I should have said #22 but this is beyond the point. It seems the errors pop up and then go away for no reason, then appear again. I had Sql Server Express with Advanced Features set up all right as far as I can see. It is the connection issue that is causing the headache. Currently when I try to make a connection with an Sql database I get an error in Visual Studio:
  • Deploying reports/TargetServerURL - beginner question
    by TinaSC
    1 Replies
    Last post by Hammer2
      • I am trying to figure out Reporting Services and to to deploy results -- and really don't know what I'm doing. I'm going through some books and it looks like our TargetServerURL would either be http://SERVER NAME/reports or http://SERVER NAME/reports erver. Either one will give me a prompt for user & pswd. When I enter my network user & password, I get this message: "You are no
  • LastNonempty return null when filter time hierarchy
    by Tom Chu
    4 Replies
    Last post by Tom Chu
      • Hi there, I am using SSAS 2005 SP2. Now I have a big problem. My scenario is that: I have a measure, inventory and set its aggregateFunction to "LastNonempty". I have a Time dimension and create a hierarchy for it. The hierarchy contains two levels, namely Year and Month. Everything goes fine when I display the report using BIStudio. However, if I filter the T
  • I have been told to run the following SQL script against the database
    by FrustratedAsUSUAL
    5 Replies
    Last post by FrustratedAsUSUAL
      • Please forgive my ignorance, I am trying to learn. First off I have installed SQLserver express successfully, with help from here. I want to thank you all for your input and advice. which brings me to my question: I have been in contact via email with my application support group and they have emailed me the following : Hi Hector, We have tracked down the problem. This issue was caus
  • How do I supress duplicate data
    by Bogey1
    2 Replies
    Last post by suresh babu krishnappa
      • Cannot find this anywhere while creating a report. Is this an option thanks.
  • Project 2007 Server Cube Build Fails Connecting To Another SQL 2005 Analysis Server
    by Allegro
    7 Replies
    Last post by apbdbs
      • Have spent days on this. Followed install guides and troubleshooting thouroughly. Here are the error messages I get when trying to build a cube. THE PROJECT SERVER ERROR WHEN BUILDING THE CUBE: ===== Initiating cube build process ===== [8/21/2007 12:45 PM] Cube build request message has been added to the Project Server queue ===== Verifying and running pre-build serve
  • Passing multi value parameters to CreateSubscription
    by Cato1969
    8 Replies
    Last post by Cato1969
      • Hi folks, I am trying to create a SSRS subscription from an asp.net app. I collect the parameter values from the client and make the arrangements to send them to the CreateSubscription method. When the report has single value parameters, my code works perfectly. But if there is a report param with multiple values, I get the error System.Web.Services.Protocols.SoapException: Default value or
  • Data Flow Task - Conditions to add value for a field.
    by MA2005
    9 Replies
    Last post by Jamie Thomson
      • Hi: I have a data flow task in which i have multiple OLEDB sources going to a one OLEDB destination via UNION component. I also have a derived column component sitting behind the union, because there are some columns, which exist in the destination table, but are not coming from source, but I am responsible of providing values for those fields. The question is that some of those values are cond
  • Search by multiple date range options
    by MichiganMark1956
    2 Replies
    Last post by MichiganMark1956
      • I inherited a system and am moving our SQL2000 input data into a new 2005 database for web searching by clients. The conversion went pretty well, but I'm looking for suggestions on how best to index and query the data. Details: We have almost 500,000 records in a pretty wide history table, and will be adding more records daily. The original table design has numerous sets of dates(first/la
  • MSSQL Select commands to FTP
    by MrHat
    4 Replies
    Last post by MrHat
      • Hello, Im new to Sql Server Integration Services. I need to get the data I get from my SQL Select statement into TXT, XML, CSV or Excel file format and then send it with FTP. What is the easiest method that you recommend that I use Thank you very much!!
  • VS.NET debug website gives connection error to SQL Database
    by JohanNL
    3 Replies
    Last post by JohanNL
      • Hi all, I've got a little problem. I'm working on a ASP.NET project. The applications has 4-layers. When I look in the Data Access Layer and test the typed dataset, then the "Preview Data" works fine. I see the right records from SQL Server 2005. But when I run the app (default.aspx) in debug-mode, then the system gives the following error: "An error has occurred while e
  • Passing Parameters thru a Link
    by Tarana
    5 Replies
    Last post by larry smithmier
      • I have a Summary page on a report and then a detail page. FOr eg on the summary pg, I have a field called 'Name'. eg summary will be on name ie 'A', B, C ETC.. When the user clicks on the summary name ie A, he should be able to directly go to that details for that particular name ie details of 'A'. How can I achieve this, will be probably thr parameters, but not sure how.
  • how to select a specific value from dataset to fill a specific cell ?
    by Btong
    2 Replies
    Last post by Btong
      • Hi there ! Thanks for taking the time to read this thread. I don't know whether anyone has this problem, but I am definitely not using the right keywords to search for a thread. My situation is this... I have a dataset that has values to fill cells to multiple tables in a report. However, I only want to select specific data from the dataset to fill textboxes and others. I cannot change th
  • How to stop PAD_INDEX dein being scripted
    by Stuart Campbell
    3 Replies
    Last post by Stuart Campbell
      • Our team checks SQL scripts into version control. On my machine, however, the generated script always differs slightly. When I generate a create table script, the primary key part always has PAD_INDEX = OFF. Nobody else's server generates this. Does anyone know what option or setting I need to change to prevent PAD_INDEX = OFF from being output WITH ( PAD_INDEX = OFF , IGNORE_DUP_KEY =