Answer Questions

• Sportsdude Can I Use Non-empty Behavior for These Calculated Members?

  I still find myself extremely confused about using the non-empty behavior for calculated members. We have a series of calculated members that we refer to as "Velocity", such as "Velocity Sales". The basic definition for these velocity measures is to get the total from the previous 63 business days and then annualize that total (i.e. multiply by 4), with the 63rd business day belonging to the previous month. For example, Velocity Sales for any day in September 2006 would be totaling the sales $ for the business days in the range of 06/05/2006 through 08/31/2006, and then multiplying it by 4. Perhaps not surprisingly, these measures result in extremely poor performance. Since I'm confused on the non-empty behavior, this p ...Show All

• N3vik To create data mart or not

  UDM provides us a chance without creating data mart. How do we know when to create or not to create the data mart which then interact with the cube ( or rather the other way round :) ) Regards Alu Have a look at this previous thread: http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=801915&SiteID=1 HTH Thomas Ivarsson Hi thanks for the thread. Regards Alu Hi do you know what are the most time consuming /complex queries that may easily lead to time- out expired. i would like to simulate the time difference to use UDM and without ( ie normal queries) so that I can vertified the usage.Thanks. Regards Alu ...Show All

• Lee Eden Accuracy of Host column on SS 2000 Enterprise Manager Current Activity Process Info Screen

  Yesterday and today, the Process Info screen in Enterprise Manager indicates that the "Host", a single workstation on our network, is generating around 50 connections to the database. This particular application is well-behaved and typically generates only 2 to 5 connections per instance. Furthermore, we cannot find this particular workstation/host on our network because we retired it off the network some time ago. Anyone know of the accuracy of the Hosts column on this Enterprise Manager screen We're suspecting that the network address column is correct but the Hosts column is incorrect. There are about 10 different network addresses pertaining to this particular Host (1-5 connections per network address). ...Show All

• Marc Jones Using SQLExpress on a network

  Hi, I have a VS2005 application that I run with a SQL server 2003 database. In order to make the application distributable, I'm trying to get it to run with SQLExpress. I've installed SQLExpress on a spare machine and changed the connection string in my application to use SQLExpress c:\databases\mydatabase.mdf (and the database is obviously in that location!). This works fine on the spare machine. However the problem is getting the application to run on another machine but using the same database. I note that SQLExpress won't let me put the database on a networked drive. On another machine I've also installed SQLExpress, I've enabled the tcpip stuff and the browser but to be honest don't really know what I'm doing! How do ...Show All

• rameshkl COPY DATABASE WIZARD

  Hello, I have been trying to use the Copy Database wizard, once I get through all the steps of defining the databases to use and hit finish (using SMO transfer), I get an 'Copy Database : No such interface supported' Error and the action terminates! How can I fix this Regards I am assuming you are copying both from and to SQL 2005 based databases Not sure if Copy DB Wizard will support DMO for the older sql2000 servers. Hi Raaj, Please take a look at the existing CDW Feedback issues and either add your comments to a related one you see, or post a new Feedback Defect with the following information: 1. Source and destination server versions (8.0 or Yukon), including Service ...Show All

• Ather. Default values of columns not transferred in SSIS Transfer Objects Task

  I am working on a project that is creating a new application, my area of the project being the migration of data from the old application database, transforming it, and populating the new database. The transformations to the old data are done in a staging database. At the end of the process, the staging database ends up with a lot of new applications tables, populated with the migrated legacy data. We need to move these tables from the staging database to (initially) our test databases, but ultimately what will be the live database. We have tried using the "Transfer SQL Server Objects Task" in SSIS, but have ran into a problem that a lot of the database tables have default values for columns. These default values a ...Show All

• aaraaayen Error: Subreport could not be shown.

  I have a problem with a report containing a number of subreports not running successfully when deployed to the Report Server. The report runs successfully every time in the VS Development environment, so parameters are all setup correctly and the result is as expected accross the whole report. No errors or warnings are listed when building or deploying. All subreports are in the same project as the main report and deployed to the same folder in Report Manager. All the individual subreports run successfully both in VS Studio (Preview Tab) and in the Report Manager portal. About 50% of the time, the main report runs but shows the error "Subreport could not be shown" for some or all of the subreports. Running S ...Show All

• gokce How to specify datatypes for Excel columns?

  So I have Excel Source in my dataflow - so I do a simple transform and try to save it to db and guess what - a freaking error message: Columns blahblah and BlahBlah cannot convert between unicode and non-unicode datatype. I cant figure this MS stuff out - why the heck is this data from excel unicode to begin with & I just dont feel it is right to always use the derived columns to convert datatypes when dealing with Excel data. Am I missing something again or is it another one of those MS gotchas -- Note - all profanity in this post is replaced with words like freaking, stuff, gotcha and so on by the author I've overlooked "Data Conversion" transformation - still - it adds it as new columns. How can you remove the extr ...Show All

• CantStopGamin Can columns be added to an error output?

  When setting an output's "IsErrorOut" property to true, is it also possible to add additional columns to that error output I'd like to add a message beyond the standard errorCode and errorColumn columns, a column which is the "specific error message", not just a lookup on the errorCode. IDTSOutput90 outError = ComponentMetaData.OutputCollection.New(); outError.Name = "Error Output"; outError.IsErrorOut = true; // Add extra column here, e.g. ErrorMessage Can you give me more details on this. I will wait to see if you reply beofre I elaborate.. It sounds like this is something I am looking to do based on my post: http://forums.microsoft.com/M ...Show All

• Blast Can't uninstall or reinstall SQL Server 2005 Dev

  Long story short: Installed SQL Server 2005 Developers Edition along with Visual Studio 2005. Everything worked as it should. Then there was a problem installing .NET Framework 2.0 Security Update. Fixed that by uninstall and reinstall of .NET Framework 2.0. Now SQL Server does not work. So I figured uninstall/reinstall. Only problem is that it WILL NOT uninstall. I have tried to uninstall manually per KB article (9009967). That doesn't work either. The error info that I'm geting is: LinkID: 20476 Product Name: Microsoft SQL Server Product Version: 9.00.2047.00 Message source: setup.rll Message ID: 50000 EvtType: stateengine\resourcemodule.cpp@ScheduleActionAction@sqls::ResourceModule::LoadStringW@0x716 I ...Show All

• Mafti Generate Report Model from Cube with perspectives

  1. Is there a way to generate SMDL programmatically from a cube besides using the RS Webservice API 2. Is there a way to programmatically modify the SMDL once it has been created without doing crazy xml manipulation 3. How can I create a Report Model from a cube with multiple perspectives I want the model to only contain one perspective of the cube. I do use SetModelDefinition API to modify the SMDL. But after a cube has been processed and the structure changed, I will need to regenerate the model base on the new cube. If I do that, all my reports break because the datasource reference is no longer valid even though the model has been recreated. This makes sense in the situations where the ...Show All

• GavH bye

            This is a SQL Server forum, not a Messenger or MSN forum. You might get contact with a MSN buddy who can be found on the MSN site and are very helpful in these cases. HTH, Jens K. Suessmeyer. --- http://www.sqlserver2005.de --- ...Show All

• OLE72 How to Automate Synchronizing logins after failover

  Since the logins/jobs do not get stay in sync between principal and mirror after a failover (when using sql logins), is there a workaround to schedule a job or something to automate dropping, re-creating and autofixing logins I've read somewhere that an alert can be setup to run (after a failover) and a job can be executed, but cant seem to get this to work. Does anyone have any helpful hints on a solution to this I have been following and using KBA How to transfer logins and passwords between instances of SQL Server http://support.microsoft.com/kb/246133 http://support.microsoft.com/kb/246133 and see this http://groups.google.com/group/microsoft.public.sqlserver.server/browse_frm/thread/ ...Show All

• sdj_dk Is SQL Server CE really the solution?

  Hi,   So far, with other programming platforms, I used to have the facility, embedded within application .exe, to:        1- Interface with already existing "multi-user" database (ex: Oracle, Access, etc.)        2- Create/access "local"/"Single-User" files for processing purposes.  (try to minimize network trafic...)   So far, I've read a lot about SQL Server products (SQL Server, Sql Server Express, SQL Server CE), at least all articles I could find, and would like to have your opinion on what would be the best approach        1- What SQL version to use for "multi-user" databases &n ...Show All

• FreddyHalim question about job names

  When I create a 'simple' transactional push replication 3 jobs are created. As far as I know from studing books online I can either let SQL Server generate the jobs, and SQL Server determine the jobname (which is different with every time I let generate them), or I can create the jobs manually and use that jobs when I create publication and subscription. What I like is that SQL Server generate the jobs with a name I define. Why is this not supported Or do I miss something Regards Wolfgang Kunk OK, as soon as the procs are supported they will solve the example. But it is only an example. In general I don't want to change references to jobs at all. And I cannot see that providing a job name could be a sec ...Show All