Answer Questions

• MW200675 Complex Join

  Hello, I am blocked with a Join Request I have 3 tables : TaUtilisateurs store the users TaClients store the customers TaJoinClients_Utilisateurs store right of user on customers : for example : TaUtilisateurs Id_Utilisateur Login 1 Nico 2 Philo TaClients Id_Client Entreprise 0 Company 1 4036 Company 2 TaJoinClients_Utilisateurs Id_JoinClient_Utilisateur Id_Utilisateur Id_Client Editeu ...Show All

• daviasch SQL Mail

  Dear Professional, I'm writing a vb program which try to use SQL mail to send an email to Outlook client. It is including document path (e.g. http://server01/document/Management And Design.doc) in the email content. When received email on the client side, it is found that the document path is broken and cannot be opened directly by double click the link. Is there any way to sove this problem Thank you, Cindy ...Show All

• Patrick_F cannot connect to sql 2005 with management studio

  Hi , I install sql 2005 CTP but cannot connect to the server with management studio installation was successful and was named instance and under local system account in event viewer mssql service is running ok, I see even it connects to master db I can start and stop server with my old sql agent 2000 and I see only 1 error saying in event log: The SQL Network Interface library was unable to register SPN. Error: 0x54b. I  have for OS 2003 ...Show All

• pgiuseppe Management Studio all databases . . .

  I see that Management Studio lists all databases, even ones that the user doesn't have access to.  I thought this was going to be fixed so I've been watching it from CTP to CTP throughout the year.  But I can see view a list of all databases on a server even if I'm simply a db_owner on one database.  I've tested this on the September CTP build. Microsoft posted a KB article to resolve this for Enterprise Manager (SQL 2000) just l ...Show All

• codepro2 regarding xml export

    If we need to generate an XML file for a specified  database table, we will go for " for xml " clause in a query for sqlserver. If we have to generate the XML file which requires the data from different database tables. we may use joins but it leads performance issues. Is there any process to generate the XML file with good performance. any points regarding this is very much helpful ...Show All

• AmyKutty DATEDIFF in Report Builder

  I'm having a bit of trouble with the DATEDIFF function in my Report Model project and in Report Builder. I am trying to create a new Expression field that will work out a persons age from the current date and their Date of Birth, here is the formula that I have entered, DATEDIFF("y", NOW(), DOB) where DOB is the field that holds the persons date of birth in the database. When I enter this into the formula box and click OK i get the following e ...Show All

• ASGMikeG Can't connect from SQL Server 2000 Enterprise Manager

  I have two servers, one have SQL Server 2000 and another has CTP2005.  I am trying to register the newly installed CTP 2005 in Enterprise Manager of SQL Server 2000, but failed. I have make sure that SQL Browser is started and TCP/IP protocol is enabled in the configuration manager.  I stopped also all firewalls between the two servers.  But I still cannot find the CTP.  The error message seem to be some Japane ...Show All

• bilescu2 Can you please tell me where I'm going wrong in my asynchronous script component?

  Hi, Im new to this list and after many days of trying to figure this out-here we go Can you please tell me where I’m going wrong in my asynchronous script component I’m almost there but by using to variable iReadingCount to add the row is not quite correct. There has to be a better way !!! Thanks in advance Dave I have to process a data from a staging table this which has imported a data in a structure like ...Show All

• ChristosX Release unused spaced on tables in SQL2005

  Environment: Windows 2003 ent - 64bit /SP1 SQL2005 ent - 64bit Problem: SQL Server doent seems to release allocated space on tables when you empty the tables! When i run sp_spaceused 'tablename', true #Records = 0 Reserved = 794688KB Data = 8KB Indexes = 40KB Unused = 794640KB The tables in question doesn't contain any LOB data. I have also tried running dbcc cleantable with no success. DBCC shrinkfile shows no space to release. I d ...Show All

• yaarit 0x80040e21 error running SQLCE 2.0 on Windows Mobile 5.0 device

  I have an SDF using SQLCE 2.0. When I run the app on a Pocket PC device running Windows Mobile 5.0 I get 0x80004005 and 0x80040e21 errors. The same app executes fine on PPC 2003. The app is written in VC++ using and uses the SQLCE OLEDB Provider to access the SDF. It is complied with eVC 4.0 Any idea as to the problem Where are these errors being generated Can you pinpoint the exa ...Show All

• Swadow Copying Dimensions in BIDS

  Is it possible to copy a dimension from one solution/project to another.  I have a generic time dimension and a few other common dimensions that I would rather just copy from one project to another rather than setting it up entirely from one project to another. I tried copying the XML file from one project to another, but that did not work because they had different DSV's, and thus different design-time unique names. any suggestions -Clayt ...Show All

• Mule How to skip snapshot in Transaction Replication (from SQL Server 2005 to 2000)

  We have two SQL Server 2005 production DB at remote sites. Due to network bandwidth issue, we need to replicate these DBs (publishers and distributers) to central corporate SQL 2000 DB (subscriber for backup and possible reporting (and in rare case as a failover server). We would start out with backup from SQL 2000 db restored on remote SQL 2005 DBs. When we have DB issue on remote 2005 DB, we want to restore it from central corp. 2000 DB bac ...Show All

• Nate52 package variable question

  Hi Guys, I'm trying to evaluate a user variable to ToLine expression property from SendMailTask. My Question is, Is it possible to evaluate a user variable in expression(..) Hi Jamie, I've tried setting the EvaluateAsExpression=TRUE of my variable but I still got error on my send mail task. The error is: "Error at Send Mail Task:No Recepient Specified". Here's the situation. I'm retreiving an email address f ...Show All

• GC99 Configuration failing: The path is not of a legal form.

  When I push Add in the configuration dialog, I cannot even get to the first page of the configuration wizard, due to the following error, in several solutions (but not in several others). All have at least one existing configuration (necessarily, to get passwords for connections). ** An error occurred while a new configuration was being added. Additional Information: The path is not of a legal form. (mscorlib) ** PS: How have the rest of y ...Show All

• John Evdemon Measure expressions and currency conversion

  OK - here is my scenario... I have a fact table containing one measure: Sales. The values of the measure are stored in the same currency (DKK) for all records. In another fact table I have exchange rates for four different currencies per day for a 15 year period (approx. 22000 records). I have built a cube around these fact tables containing two measure groups. Measure Group 1 Measure: Sales Dimensions: Time, Product, Company Measure Grou ...Show All