Answer Questions

• MircoS Alternative to Merge Replication?

  Is there a simpler alternative to merge replication I am concerned about the splash of GUID across the DB, performance issues, and the complexity of the deployment. Sorry, meant to post this earlier... Info about the different types of replication, http://msdn2.microsoft.com/en-us/library/ms152531.aspx Correct, but it does require every table to have a primary key. You will need to read more on both technologies to determine what works best in your environment. I am using SQL 2005. Your solution does NOT require a GUID Peer 2 Peer does not currently handle conflicts (it will in the next version of sq ...Show All

• Orest Bolohan Simple query chooses clustered index scan instead of clustered index seek

  the query: SELECT a . AssetGuid , a . Name , a . LocationGuid FROM Asset a WHERE a . AssociationGuid IN ( SELECT ada . DataAssociationGuid FROM AssociationDataAssociation ada WHERE ada . AssociationGuid = '568B40AD-5133-4237-9F3C-F8EA9D472662' ) takes 30-60 seconds to run on my machine, due to a clustered index scan on our an index on asset [about half a million rows].  For this particular association less than 50 rows are returned.  expanding the inner select into a list of guids the query runs instantly: SELECT a . AssetGuid , a . Name , a . LocationGuid FROM Asset a WHERE a . AssociationGuid IN ( '0F9C1654-9FAC-45FC-9997-5EBDAD21A4B4' , '52C616C0-C4C5-45F4-B691-7FA83462CA3 ...Show All

• Sweed my script not working when the name of a DB has - (the dash character)

  Hi, this script uses MSforEachDB to check all the SPs in all the databases and look for a keyword LockCookie . The script runs well except when there is a database with a dash - in ots name. ie: When in the script is replaced by a database whose name contains a dash - the dash and the rest of the database name after the dash is ignored. And I get the message for example: Could not locate entry in sysdatabases for database 'SharePoint_AdminContent_f5c0f71f'. No entry found with that name. Make sure that the name is entered correctly. Here is the script: exec sp_MSforeachDB ' use select ''LockCookie'' as searchedTxt, o.name AS ProcName ,Len(SubString(object_definition(o.object_id),1, PatIndex(''%LockCookie%'', object_definitio ...Show All

• Zero_ Can I add user and passw to my OLAP ConnectionString??

  Hi all, I have written a custom assembly that works fine in preview mode, but when I deploy the report I get the '#Error' message instead of the output. I have copied the assembly to the bin folder of Reportserver, placed it in the GAC and even edited the policyfiles. Any help would be very appriciated, Thanks in advance public static class SimCardBuyer { public static string ReturnBuyer( string Seller, string PeriodeCode, string ComDevice) { string connstring = "PROVIDER=MSOLAP;DATA SOURCE=srv03-gc-10;INITIAL CATALOG=Invoicing" ; AdomdConnection conn = new Microsoft.AnalysisServices.AdomdClient. AdomdConnection (connstring); //Create a new string builder to store the results System.Text. StringBu ...Show All

• dillysdad Deploying database with application

  i written an application in vs2005 using vb; it connects to a database on the server. how do i publish/distribute this application with the database so that when the client installs the application it will also create the whole database on its machine... or have it create the database on a server asking the client to specify the server path, name... etc i am sure there is a simple way ot do this but i am new ot this and have never done this before.. appreciate all the help... thanks You can take help of unattended installation, refer http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=636755&SiteID=1 too. Here is an excellent resource detailing unattended installations of SQL Server ...Show All

• mickyjtwin Very Urgent ASP.NET 2.0 with SQL Server 2005 - ADO.NET 2.0 DataAccess using Functions (CTE)

  Dear All, We developed a web based application using asp.net 2.0 with C# and back end SQL Server 2005. In Database we wrote a CTE for get record from SQL Server 2005. In ASP.NET, we wrote Dataset (xsd file) for DAL using TableAdapter we retrive the data using Table adapter in Dataset. In Local development Web server working well. When I hosted to live web server I encounter the new type of error. The query has been canceled because the estimated cost of this query (706) exceeds the configured threshold of 300. Contact the system administrator. Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where ...Show All

• progames25 bulk load change in 2005?

  I have a dts package that does some bulk load operations without a problem in 2000. When trying to convert them to SISS or trying to run the same dts package against the a copy of the database (in 2000 mode) running on a 2005 server I get Bulk load data conversion errors (truncation) for row xxxx.... Has the bulk load process changed in 2005 My Sproc is using a bulk insert command with a fmt file.. Daveko wrote: Has the bulk load process changed in 2005 Yes, there have been certain changes in the bulk load that may cause seemingly fine SQL Server 2000 scenarios to fail when they run against SQL Server 2005: the engine now enforces stricter data purity checks and additional physic ...Show All

• PSHK Unlock account from Management Studio does not work!

  Hi, I recognized that I cannot unlock an locked account with Managament Studio for SQL Server 2005 SP1 (Login properties). I need to use 'ALTER LOGIN'-command from a query window. I found old forum entries mentioned the same problem. Is there a time frame to fix this problem Maybe in SP2 or SP3 Wolfgang Kunk Wolfgang, Could you please mark the question as answered if you don't need any further assistance. Greetz, Geert Geert Verhoeven Consultant @ Ausy Belgium My Personal Blog Can you please explain again the problem you are hitting Was the login disabled to begin with If not, then enabling it should not have changed anything. Enabling a login does not change its p ...Show All

• crossraleigh ReportViewer use in .Net 3.0/WPF?

  Hello, We are working on a WPF/.Net 3.0 based application and have some reporting needs. Is it possible to host the WinForms ReportViewer control in WPF context I have learned that WinForms controls can be hosted using WinFormsHost, but I wasn't sure about ReportViewer control sicne it's not really part of the .Net framework (I could be wrong about this). I appreciate any help/advice. Murthy The Report Viewer Control is part of the .Net 2.0 framework. I was actually hoping for a time frame. This year, next year... thanks Do you know when ReportViewer will be available via the SQL 2005 patch for Vista Thanks The report viewer for Vist ...Show All

• muthuraja MIN and MAX strange results

  I want to get the MIN and MAX value of a table column from a specified period of time. I execute a query and it return the result. The problem is that the values returned by MIN and MAX are not always correct!! This is the result table Date Statement From To 1 2007-01-03 00:00:00 Invoice 1 2 Correct 2 2007-01-04 00:00:00 Receipt 1 1 Correct 3 2007-01-04 00:00:00 Invoice 10 9 Wrong 4 2007-01-05 00:00:00 Receipt 2 5 Correct 5 2007-01-05 00:00:00 Invoice 100 99 Wrong 6 2007-01-08 00:00:00 Invoice 124 175 Correct 7 2007-01-09 00:00:00 Invoice 176 224 Correct 8 2007-01-10 00:00:00 Invoice 225 265 Correct From =From Statement Number To= To statement Numb ...Show All

• gagis updating automatically an SSAS 2005 cube

  hello to every one. i have a small problem. well in order to create the data source for my cubes i created a relational database (static) by merging 2 databases . i order to do that, i used integration services. my question is how can i update/add data to my cubes automatically do i need to add data to the ralational database by running the application over and over (when the 2 databases are updated), can i do that automatically and update the dimensions and the partitions can i program integration services to look periodically at the two databases and do the update thank you in advance for your answers As part of your SSIS package udating relational databases you can have Analysis Services processing ...Show All

• Friendly01 DTS Code works only with VS 2003 but not with VS 2005 ?

  Hi; I wanted to use the following code to run a DTS package from a 2005 Web Page code behind partial class. This code works fine in a VB 2003 module going against  SQl Srvr 2000. Here is the code: (It initiates from a button click handler) Dim conn As New SqlConnection( "initial catalog=MY_Data;server= XYZ081552X7X441\TRSQL;integrated security=SSPI" ) Dim hold1 As Integer Dim hold_source As String = "" Dim hold_desc As String = "" Try conn.Open() Catch ex1 As Exception MsgBox( "The Test connection failed to open" & vbCrLf & ex1.Message) End Try MsgBox( "About to create a DTS object" ) Dim oPackage As New DTS.Package2Class (Compiler doesn't l ...Show All

• ceebee Simple mode and huge log files

  All, We have a database set to simple mode due to batch processing, and the log file is still huge compared to the data file (40 gig data / 10 gig log). I thought SQL server truncated the log file when the database is backed up Can anyone clear up this seemingly simple topic Thanks, Jim The active log is truncated when the database is backed up, not the log file. In Simple recovery mode, the active log is truncated after data changes have been written to the database ("truncate log on checkpoint" is another name for this mode). Truncating the active log means that the section of the log file that contains active records is marked as inactive when the changes have been committed in the database, so that thos ...Show All

• Biceps Please help with partitions!!

  Hi everyone, Primary platform is sql25k 32-bit. I'm trying to move data from one partition to a table I am not able at all. Find attached the full script for that: CREATE PARTITION FUNCTION rangoAnualFP ( datetime ) AS RANGE LEFT FOR VALUES ( '200301' , '200401' , '200501' , '200601' ); CREATE PARTITION SCHEME rangoAnualFE AS PARTITION rangoAnualFP TO ( PRIMERO , SEGUNDO , TERCERO , CUARTO , QUINTO ) --Where PRIMERO, SEGUNDO and so on are FILEGROUPS, of course.. -- SOURCE TABLE CREATE TABLE [dbo] . [DatosMensuales] ( [Id] [int] NOT NULL, [Concepto] [varchar] ( 50 ) NULL, [FechaAlta] [datetime] NOT NULL ) ON [rangoAnu ...Show All

• sarasotamac Hours/minutes in the Calendar date time prompt

  Is there any way to get teh date time prompt to display hours & minutes For example, if I default the field to '=Today', I would like to see '8/10/2006 9:04 AM' instead of '8/10/2006' Similarly, when I pick a date using the date picker control that is displayed by default, I would like it to also display the time, which I guess would default to 12:00 AM. Thanks in advance! Thanks...your replies got me off on the right path. I ended up using the following: =DateAdd("h",12,Today) and =now I had been using =Today which just returns a date. Duh. Hi, I encountered the same situation once and this is what I did: in the report paramet ...Show All