Answer Questions

• RUSSO Yet another SQLEXpress remote connection problem

  I can not connect from a remote computer on my LAN to the SQLExpress database using Visual Studio 2005 Beta 2, SQL Express 2005 June CTP. I have: 1. Enabled TCP/IP on the SQLExpress Surface and started the SQLBrowser. 2. Changed the connection method using Vikram's step by step procedure in the registry setting the LoginMode = dword:00000002 3. I have added a user to the ProfitPlus database with these steps:    USE ProfitPlus &nbs ...Show All

• ladymuck Error Installing SQL Server 2005 Express Editios

  Hi all, First of all I apologize for my very poor English. I tried to install SQL Server 2005 Express Edition (I also Installed Visual Studio Express Edition) and the intallation program don' t finish correctly: I opened the archive C:\Archivos de programa\Microsoft SQL Server\90\Setup Bootstrap\LOG\Summary.txt: SQL Server 2005 installation program has detected incompatible Visual Studio Beta, .Net Framework or SQL Server components. ...Show All

• Toma? Pajonk Failed SQL 2005 SP1 installations (Hotifx.exe crashes)

  I am seeing repeated failures installing SP1 database services with crashes in hotfix.exe being reported and the following appearing in log files: Property(S): SqlUpgradeMessage = SQL Server Setup has encountered the following problem: [Microsoft][SQL Native Client][SQL Server]Cannot find the object 'dm_exec_query_resource_semaphores', because it does not exist or you do not have permission.. To continue, correct the problem, and then run SQL ...Show All

• dhaval vyas Performance with simple calc on FirstNonEmpty

  Asume a simple query with a view measures on columns and 100 of 2000 members of a parent child dimension on rows. ==> Profiler Query duration 950 ms Added a calculation member - code see below and include the member in the query the response time ==> Profiler Query duration 5500 ms increaes about 500%! The special point "Effective area in m2" uses the "FirstNonEmpty" Aggregate function - while we switch for testing to ...Show All

• circusfire Replication Advice

  Hello, I need to set up a replication between 2 servers. The first is a dedicated server hosted in a datacenter. The second is our office server, hosted at office. Is it a good idea to set up the dedicated server with sql express and suscribe to the SQL server at Office The objective is double : backup and performance. Is it possible to have an immediate replication (without delay) Thanks a lot ...Show All

• Tony63 error execute sp_addlinkedserver in stored procedure

  Error Message : Msg 7202, Level 11, State 2, Procedure LoadConvertsDB, Line 24 Could not find server 'CONVERTSDB' in sysservers. Execute sp_addlinkedserver to add the server to sysservers. T-SQL: EXEC master . dbo . sp_addlinkedserver @server = N 'CONVERTSDB' , @srvproduct = N 'Access' , @provider = N 'Microsoft.Jet.OLEDB.4.0' , @datasrc = N 'F:\Converts.mdb' ; Environement: SQL 2005 Std, Win2000 Pro SP4, same comp ...Show All

• Golm What should the maintenance plans be on your mirror server?

  If your principal fails and your mirror assumes the main role and it is in Full recovery mode (which it has to be in Standard edition), then the log files will grow and grow until a transaction backup and shrink is executed. I have maintenance plans running daily (and hourly for transaction log backup/shrink) on my principal, but nothing on my mirror. Do I need to set up the same maintenance plans on my mirror server Thanks Ed ...Show All

• Bronko Modify SSIS package saved on server

  I have saved an SSIS pacakage on my sql server. I am able to see and run the package through Integrations services. My question is, is there a way to edit the package through Management studio Thanks Jim I really miss good ole DTS packages. The old days when you could write a process and edit it without running through a ton of unnecessary hoops. Microsoft is a tools provider. It is NOT Microsoft's place to say HOW we use the ...Show All

• Dave Cowell Introductory articles on SSIS / DTS

  Hi, I am looking for one or two online articles/documentations that introduces SSIS / DTS to novice, for VS 2005 / SQL 2005.   What can be accomplished with SSIS, and how to get started... David Try this: http://www.sqlservercentral.com/columnists/jthomson/thenewetlparadigm.asp -Jamie ...Show All

• qpeHukc new fact records

  Hi there Is there functionality in SQL 2005 to update only new records, e.g. only records from yesterday. I've seen functionality for dimension tables to only get new records but nothing for fact tables. Thanks Hi Jamie Thanks for the reply, I want to do an iterative update of my datawarehouse add new records only rather than deleting the table and reimporting the entire table. I have read ...Show All

• Rick Murtagh Properties affected by Expressions

  Hi, is there any way to see which property is changed/affected by expressions If not that would make things really complicated because you look at a property and it seams to be OK but the task doesn't do what it's supposed to because "behind the scenes" the setting is changed by an expression... Thanks,   Thomas Pagel wrote: Darren, OK, you can see the expressions at the place where they are defined... My idea would be that pr ...Show All

• Andris Ažēns creating a conflict viewer/resolver

  Hello, I see that MS has a conflict viewer that can be accessed by managment studio, however I would like to create one with some customized options. Is there a sample of code somewhere to start this I could really find anything in BOL. Thanks in advance. John what version of sql server are you using Books online should have examples for two types of conflict resolvers - COM and stored procedure. Sear ...Show All

• neostylo How to ignore timepart when using LookUp with date.

  Hi I want to lookup the datekeys from my datedimension. However it does not work because matching for same dates does not work because of different timeparts. The dates in my lookup-table have a 00:00:00 timepart, but the dates in my input table have a non-zero timepart. How can I ignore the timeparts or make the timeparts zero Regards, Henk Can you not use T-SQL to change the data at source -Jamie ...Show All

• Rusi Hilloowala Changing Column size/type with Derived Column

  I have a number of date columns that are parsed as DT_WSTR (6) and I have written a Derived Column converting them into DT_DATE via this (found on the forums) type expression: (DT_DATE)(SUBSTRING(Date,6,2) + "-" + SUBSTRING(Date,8,2) + "-" + SUBSTRING(Date,1,5)) But I really want to replace the current column, not create a new one. If I use "replace" the data is forced to be a DT_WSTR (6), and I get a truncation error at run-time. Simeon ...Show All

• Ken Adeniji SSIS Send Mail task problem

  Hi, I have got the problem connected with Send Mail Task in SSIS. The general idea was: sending email alert to different email users. I tried to use Foreach Loop task which loops through dataset (where the emails are stored) and assign different email addresses to SSIS package variable. When I try to use this task inside Foreach Loop task I receive this error message: "Error: 0xC002F304 at Send Mail Task, Send Mail Task: An error occu ...Show All