Answer Questions

• ARehman Web Synchronisation Using RMO

  hi every body please help me out on this issue , since i am at final stage in finishing up the module. Previously i had done web synchronisation using RMO it is working fine at my office where i have an 2003 server which is an domain controller , publisher i have configured on the 2003 server , and i had subscribers on xp Machines where it was well working fine, clients were not on the domain , it is an independent Machine. we had an security error which was resolve by this same forum, ie the client windows login id should exists on the server too. only then synchronisation is happening at our office, Now the problem is i have an same setup , but the server 2003 is hosted at a remote place , which is not an domain controller, n ...Show All

• ChristianBG alternate colors

  Hello all, I am using sql reproting 2000. I have areport which spans a number of pages...say for every radio station, the report starts with a new page. On every page, I must have alternate row colors(white and gainsboro). It was easy to do that. The issue is, for every new page the report renders for every new radio station, the first row must be white. Say...Radio Station 1, the alternate row colors will continue...i.e white and ganisboro. But for radio Staion 2, the first row should be white again. I hope I have explained it clearly enough. For alternate row colors, I use either an expression - IIF(RowNumber("ds_LineUpByFeedDetail") Mod 2, "White", "#dddddd") OR a VB Function in CODE window. ...Show All

• rr_rej Location of default instance SQL server 2005 files

  I have just installed SQL Server 2005.  I was not given a choice during installation (that I remember seeing anyway) about which drive I wanted to place the default SQL instance on. It ended up on C: and I needed it on D:.   So my questions are: Is there a way to move it to D: that is easier than the way you had to go about it in SQL 2000 Is there a way to do it during setup so I can avoid this in the future If you're installing SQL Server Express edition you are running an executable called SQLEXPR.EXE. This is a compressed package that when run expands the contents to a temporary folder, runs the installation and then deletes the temporary folder. You can persist the uncomp ...Show All

• Sondre - MSFT Regional Director Simple AS 2005 migration question (Time Dimensions)

  I am updating work done on cubes under AS 2000. In AS 2000 a Datetime field could be linked directly to a Time Dimension from which the levels inside that dimension could be selected. This included being able to break a date into fiscal quarters. It was not necessary to divide up the field containing the full date and time into Day, Week, Months, year columns. In AS 2005 it seems I must break the date up into Day, month, and Year then link these fields to time dimension and specifying whether they are fiscal or calendar. Is there is a way to have the same intelligence as AS 2000 where the date partitioning is done for you without breaking the field up Can someone point me in the right direction Any help appreciated ...Show All

• knvb Calculating Age in a Stored Procedure

  Currently, I'm having an issue with patients under the age of 1 year. I had a patient 9 months old and it calculated 8 weeks. Can anyone see where there may be an error in this This is the section pertaining to the "Patients Age" -- Full SP below this. '308.PatientAge' = CASE WHEN datediff(day, pp.birthdate, @ApptDate) <= 6 THEN cast(datediff(day, pp.birthdate, @ApptDate) as varchar(10)) + ' dys' WHEN datediff(day, pp.birthdate, @ApptDate) <= 112 THEN cast(floor(cast(datediff(day, pp.birthdate, @ApptDate) as decimal) / 7) as varchar(10)) + ' wks' WHEN floor(cast(datediff(day, pp.birthdate, @ApptDate) as decimal) / 365.25) < 2 and day(pp.birthdate) <= day(@ApptDate) THEN cast(datediff(month,pp.birthdate, @ApptDate) ...Show All

• NetPochi New Data Source showing only default instance

  I have two instances in SQL on my machine. When creating a New Data Source in BIDS, I can only see the default instance. I have checked the SAC manager to make sure the second instance allows remote connections and the setting are exactly the same as the default. Any ideas Thanks. I checked the Config Mgr and the port number was blank for the second instance. When I changed the port number to the same as the first instance, I was unable to restart the second instance until I removed the port number. Should I use a different # After changing the ports and changing them back to get the second instance to start again, the test connection in BIDS was successful this time. G ...Show All

• Yash Purohit Distributed transaction does not work with SQL Server 2005 on Windows Server 2003

  Hi, I'm having problems trying to put triggers working between SQL Server 2005 connected by linked servers. I'm using two SqlServer 2005 both running on Windows Server 2003 Standard Edition SP1. Both doesn't belongs to a Domain. They are configured in they own workgroup. Microsoft SQL Server Management Studio 9.00.2047.00 Microsoft Analysis Services Client Tools 2005.090.2047.00 Microsoft Data Access Components (MDAC) 2000.086.1830.00 (srv03_sp1_rtm.050324-1447) Microsoft MSXML 2.6 3.0 5.0 6.0 Microsoft Internet Explorer 6.0.3790.1830 Microsoft .NET Framework 2.0.50727.42 Operating System 5.2.3790 MSDTC version 5.2.3790.1830 What I checked on both servers: ...Show All

• Flagstaff bulk insert causes out of memory error in asp.net

  Hi, I am running a bulk insert from withn an ASP.NET application that periodicaly throws an out of memory exception (always at the worst possible moment). I am running SBS 2003 and SQL 2003 and I cannot find any messages in the application log to tell me what has happened. I saw this KB and wonder if it is related to my problem or if there is something else I should try http://support.microsoft.com/kb/892985/ thanks in advance, Michael I did resolve this issue. I was getting error “Exception of type System.OutOfMemoryException was thrown.” while performing bulk inserts in SQL Server 2000 from C# 1.1 Web Application. However. it was not related to SQL server at all, but instead with the ado.net memory allocation of a ...Show All

• Jeff3464 SQL Server Management Studio Express: How can I install AdventureWorks "dbo" files? Is AdventureWorksBI.msi right for them?

  Hi all, I downloaded the AdventureWorksDB.msi and install AdventureWorksDB in my C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data with the following stuff: AdventureWorks_Data AdventureWorks_Log masterlog mastlog model modellog ......... But, in my computer\SQLEXPRESS (SQL Server 9.0...), I did not see the following: |-| Databases |-| AdventureWorks |+| Database Diagrams |-| Tables |+| System Tables |+| dbo.Production.ProductCategory |+| dbo.Production.Product |+| .................... Should I download the AdventureWorksBI.msi from Microsoft and install it to get the 'dbo' and other files Please help and advise. Thanks in advance, Scott Chang The schema ...Show All

• Mr_White SDF database - Create table error

  Hi, I have connected sdf database through SQL server management studio. I want to execute a simple query as, CREATE TABLE [dbo].[user]( [user_id] [int] NOT NULL) While executing the same through Query pane, it gives error as, <> Major Error 0x80040E14, Minor Error 26100 > CREATE TABLE [dbo].[user]( [user_id] [int] NOT NULL) The table name is not valid. [ Token line number (if known) = 1,Token line offset (if known) = 22,Table name = user ] <> Any pointers   Thanks, Shailesh. Hi Joao, Your statement is valid. However, I am trying to execute a script generated by SQL server 2005 and i need to create a schema from ...Show All

• paddyO Dates not sorting properly

  I am trying to sort by a date and then use a secondary sort on another column date field. The first date sorts properly, but the second is not in sorted order. I have also tried ORDER BY first date, second date and that queries the information in sorted by the first date, but then not sorted by the second date. Any ideas BJ Hello BJ, Can you post a sample of the raw data, and also, how it shows on the report Jarret ...Show All

• Tom2U Automatically print multiple copies of the same report with different label on letter size paper

  Hi, I am new to reporting services and I'm really stuck on a design problem. Can someone please help me I would like to design my own print function. When a user clicks on the print icon (preferably the one that came with reporting services), the report is automatically printed twice, once with "For Person A" and the second time with "For Person B" on it. It doesn't matter where these two labels are placed on the page. These two reports need to be printed on letter-size paper regardless of user's selection. How do I do this with minimum amount of code Any help would be greatly appreciated! In that case your only other option is write your own rendering extension. That's ...Show All

• someone030 Constraing Question

  Converting a program from VS03/MSDE to VS05 Pro/SQL Express... In VS05, in Datasouse tab, "edit with Dataset with designer", click on relation between two tables, choose "edit relation" from context menu, under "Choose what to create" there are 3 radio buttons: - Both relation of foreign key constraint - Foregin Key constraint only - Relation only I have discovered that the choice made dramatically affects the Fill order of tables. In general I use the first one. I would like more information on these options than I have been able to find in help. Here is the specific issue (simplified)...two tables UserID -> Recordings. In a specific senerio, I must fill recordings table first ...Show All

• steveareno system grants without admin rsp.

  What kind of permissions I need, when I want to see the system views, perfstat, ect...but I don't need admin responsibility. See the permission sections for the Books Online articles describing the catalogs you want to access. You can access Books Online at: http://msdn2.microsoft.com/en-us/library//ms130214.aspx If you find errors in an article, or missing information, please open a report at: http://connect.microsoft.com/Main/content/content.aspx ContentID=2220 Thanks Laurentiu ...Show All

• RaimondB E

  Hi I am using SQL Server 2005 Enterprise Edition. On this friday i was doing performance tunning for one if queries where i found that Estimated Execution Plan Costs Greater Than 100%. On http://support.microsoft.com/kb/274643/en-us#appliesto MS says that it applies to ? Microsoft SQL Server 7.0 Standard Edition ? Microsoft SQL Server 2000 Standard Edition Does any one knows if it's issue with SQl Server 2005 as well Regards; Rakesh It is a bug. Please file one with repro scripts at http://connect.microsoft.com/sqlserver . Execution plans are never exact and will probably always have rounding errors which make it add up to greater than 100%. They are only usefu ...Show All