SQL Server

Page 2374




  • Topics
    Replies
    Last post
  • Service Broker "TO service could not be found" Message origin: "Transport"
    by Anonymous558364
    8 Replies
    Last post by Anonymous
      • I am trying to send a message between to SQL Server 2005 instances on two different machines. I have checked all my routes and all my objects appear to be setup correctly. However, when running Profiler on the target machine, I receive the "This message has been dropped because the TO service could not be found. Service name: "[tcp://mydomain.com/TARGET/MyService]". Message origin:
  • Where clause in a SET
    by JohnSLG
    6 Replies
    Last post by JohnSLG
      • Can you use a WHERE clause in a set statement I want to limit the set I am building to a certain subset of data. SET [Customers] as ORDER ( NONEMPTY ([Dim Customer].[Name].[Name]. members ,[Measures].[Coil Weight]), [Measures].[Coil Weight], BDESC ) MEMBER measures.[Ton Rank] AS RANK ([Dim Customer].[Name]. CurrentMember ,[Customers]) Somewhere I'd like to add
  • Can i set somehow the package to have the components automaticaly updated?
    by dancatalin
    1 Replies
    Last post by DarrenSQLIS
      • Help ... i'm lost I have one custom dataflow component in assembly A with version 1.1.0.0 used in many packages. The component is now in assembly A with version 1.2.0.0 but not changed. There is aniway to have those packaged configured in order to automaticaly be upgrated to use the new version of the component I tried (in this order): - set the property "UpdateObjects
  • Table transfer errors
    by DaveDB
    14 Replies
    Last post by Jamie Thomson
      • Hello, I am trying to transfer a database from one server to another using the Import Export wizard in SSIS and I am consistantly getting this error on 2 different tables so far. - Execute the transfer with the TransferProvider. (Error) Messages * ERROR : errorCode=-1073451000 description=The package contains two objects with the duplicate name of "output column "ErrorCode" (
  • Query takes more time from user interface or in a network
    by aashirwad
    1 Replies
    Last post by mrdenny
      • I execute a pretty big sql query which joins multiple tables and I reviewed indexes on all these tables. I am happy with the result when I run the query using SSMS in the server locally i.e., where my SQL Server database is installed. It takes 4 seconds to get around 17000 records. If I run the same query in a network or from my desktop using SSMS i.e., i connect to the above mentioned SQL Server
  • Packege success, despite task failure
    by killerless
    3 Replies
    Last post by jwelch
      • Hello, When I run my package, a task will fail, however, the package will claim that it was successful. Why is this, and how can I trigger a failed package when one task fails Thanks in advance.
  • Can i host a SQL2005 EE DB on SQL2000 engine ?
    by lamarty
    6 Replies
    Last post by Mike Wachal - MSFT
      • Hi, I'd like to host a small website created using VS2005 EE with a company that offers just SQL2000 DB support. My question, can i use the DB created by VS site manager as a DB to the site, if not, is there any alternatives. Thanks.
  • Incorrect processing order for views
    by aero1
    6 Replies
    Last post by aero1
      • I am using SQL 2005 merge replication with SP1 hotfix build 9.00.2227.00. This build is in use rather than SP2 because a fix I need is not yet available for SP2 Essentially the problem is as follows: 1) Initial state is that merge replication of table and views is working fine 2) I then alter one view which reference s a new view in the same publication 3) Synchroniz
  • Unable to read local eventlog (the parameter is incorrect)
    by Michael Luttmer
    14 Replies
    Last post by SteffenRuland
      • In trying to setup alerts and activating them, an error occurs in the sql agent log of Unable to read local eventlog (the parameter is incorrect) The full messages from the Windows NT Logs shows: Event Type: Error Event Source: SQLSERVERAGENT Event Category: Alert Engine Event ID: 318 Date:  03.11.2005 Time:  17:14:47 User:  N/A Computer: 
  • Database Blobs & Performance
    by Basel Al-Khateeb
    3 Replies
    Last post by Arnie Rowland
      • Hi geniuses, I have a core database question in MS Access and SQL Server. Assume the following table in MS Access or SQL Server: Employees table: EmpID, Name, Hiredate, Photo; and the following query: "SELECT EmpID, Name, Hiredate FROM Employees;" The question is, "does the blob object ( Photo) affect the performance of the query even when not in
  • How to extract domain name from an email address??
    by Sam_dia
    6 Replies
    Last post by Arnie Rowland
      • Hi do you know incase a script which extracts domain names from an email address like foreg. we have xyz@dmc.com or abce@dmc-int.com should give dmc and dmc-int
  • problem connecting Remote Analysis service 2005 from vb.net 2005
    by manand123
    7 Replies
    Last post by Darren Gosbell
      • hi mates, following code works fine in the server machine where sql server exists. but this doen't run at client machine. it throws error as " A connection cannot be made. Ensure that the server is running. " help to solve this problem thanks Code Snippet Dim msSvr As New Server Dim db As New Database Try I
  • select inside update query?
    by abcdefgqwerty2
    1 Replies
    Last post by Jens K. Suessmeyer
      • Is it possible for me to do something like update table1 SET var1=something,var2=something2 from table1 (SELECT * from table2) as newtable where newtable.field1=acondition
  • SSAS processing
    by jjsr
    5 Replies
    Last post by jjsr
      • Hi, I created IS package for cube processing and if I execute this task , then execute result is successful. But I don't see any update information through BIDS when I browse the cubes. Why it happens and how can I check it Connection string is fine and i've also checked the processing configuration and I don't see any problem. Any kinds of advice would be appreciated.
  • Schema (owner) Names Not Visible In Shapes On Diagram
    by ScoMo
    2 Replies
    Last post by Roger Best - MSFT
      • When reverse engineering a SQL Server 2005 database (using VS 2007 Professional), I can't figure out a way to display the schema name in front of the table name in the database diagram. For instance, If I have a table named Person.Type, it just comes over as Type. It knows what the schema is because it's in the properties box for that object. It just doesn't appear in the name on the shape itself.
  • Select Statement Problem?
    by pinoyz
    5 Replies
    Last post by Matt Tolhurst
      • Hi every1, Recently i have this exam about sql statements, it shows that it has 1 table like this one. name telephone1 telephone2 ian 1234567 7654321 test 1111111 2222222 How can we make a select query where the output is this name telephone_numbers ian 1234567 7654321 test 1111111 2222222
  • MS SQL2005 express ed + SSIS installation problem
    by IgorTrono
    3 Replies
    Last post by jwelch
      • Hi, I have tried to install SSIS going steps msdn2 using "mssql setup" but my "ssis" option is not available for installation. Pls, help!
  • Problem in MDX query for calculating total sales.
    by jaee83
    2 Replies
    Last post by jaee83
      • hi, can someone help in finding the error in this mdx query for the given problem statement. Query : Sales performance by gender of the customers. - The expected output is 2 values of sales ,one for all male customers and other for all female customers. - The level CustomerID of dimension Customer has attribute GENDER. - I have calculated two sets [Male] and [Female] . - At present
  • help enabling FTS in multiple database
    by smitha.s
    5 Replies
    Last post by Amit Banerjee - MSFT
      • Hi all, We have a remote server which runs SQL server 2000 DEV edition. We have 4 databases running in it. Our application needs the feature of Full Text Search in all the four databases. We have installed the necessary services. The problem is that we are able to create FTS on one database but when we try to run FTS on other databases the MSSearch service stops. on restarting it mssql stops. w
  • Dervied Column - Expression?
    by MA2005
    4 Replies
    Last post by Rafael Salas
      • Hi: I have a Dervied Column Component, in which there is a column called RecStatusCode. The criteria to give a value to that column is below in SQL: (SELECT CASE CertParticipant WHEN 'Y' THEN 'C' WHEN NULL THEN 'A' END FROM [dbo].[SchoolCertRequest] WHERE SchoolID = (SELECT SchoolCode FROM [WebStrategy].[LAF].[LoanApplication] WHERE LoanApplicationID = @LoanApplicationID) and Schoo
  • How Do I Hide Internet Explorer Menu and Tool Bar
    by TRA Tech
    7 Replies
    Last post by ?®€?§Q?
      • How can I hide the Internet Explorer Menu and Tool Bar in SQL Reporting.
  • The INSERT statement conflicted with the FOREIGN KEY constraint FK_source_destination.
    by pbd22
    4 Replies
    Last post by pbd22
      • Hi. Please excuse the rookie question, but I am not sure how to get around this error. "The INSERT statement conflicted with the FOREIGN KEY constraint "FK_users_editprofile". The conflict occurred in database "MyDB", table "dbo.editprofile", column 'userid'. The statement has been terminated." I encountered the error when running a series of test INSERT
  • Missing Properties???
    by paulbihs
    2 Replies
    Last post by Darren Gosbell
      • Has anyone tried to open a cube into Business Intelligence Studio and the properties for the database vanished (project menu, properties) How do you get them back
  • SQL Restore Rights
    by Brad Roland
    4 Replies
    Last post by Brad Roland
      • Hi All, I've got an SQL 2005 server setup with some databases. I'm trying to set it up so that a user can upload his database backup and then restore the DB using Studio Express but am having some issues with it. The user can upload his database fine, but when we try and go in to restore it, he can't view the directory or file of the backup. I've added the service account that SQL runs as, as we
  • Multiple masks in a For Each File Loop container
    by Paris Hilton
    10 Replies
    Last post by Paris Hilton
      • Hi, Is it possible to use multiple masks in a For Each File Loop container I need to process "*.txt" and "*.csv" and tried to separate them with all the usual characters("," ";" etc.) but it does not seem to work. I don't want to create 2 or more containers for each mask. Thanks