Answer Questions

• Amelia Concatenate field based on unique id.

  I have a table like this Id comment -- ------- 1 abcd  1 efgh 1 cc 2 aa1223 3 myComment 3 myComm123444444 I want to a SQL statement that returns unique Ids with their comments concatenated with comma. 1 abcd,efgh,cc 2 aa1223 3 myComment,myComm123444444 Can anyone help me with this. thanks. Thanks a lot. It worked the way i wanted. While this works it uses a nasty side- ...Show All

• Chakshu DB Mirroring VS. Clustered Failover Questions

  We are planning to update our two node, active/passive clustered system to SQL 2005 from SQL2K. Would we be better off to use database mirroring rather than clustering with failover I believe mirroring takes 3 systems rather than two (one for each mirror and one for monitoring), but can the monitor be a rather low powered PC Our current cluster uses two 4-processor Dells and an external PowerVault RAID array with fiber channel connections. E ...Show All

• Hannah82 Catch Error message in Variable?

  Greetings all, When an error occurs it is written to a log file (Assuming you have loggin on). Anyone know of a way to catch the error in a variable When an error occurs I send an email explaining where there error happened and to view the logfile. I would like to include the last error in the email. Saves having to go view the log... Thanks Thiru_ wrote: Hi Jamie, Thanks for your info. Actually I am also looking for this v ...Show All

• The Edge also develops software Option for accessing external DLL's from the CLR

  What are my options for calling external DLL's from SQL CLR, I used to use the sp_OA method but these have been converted to .Net assemblies and I do not want to use interop for several reasons. Any suggestion would be greatly appreciated. J- Well, you'll have to load System.Web first.  But I'd be VERY cautious about doing that -- make sure you -really- want to use an asse ...Show All

• Precipitous Report model GetUserID() function

  Guys, What is "GetUserID()" function returns when the report server, report builder and everything is using windows authentication http://msdn2.microsoft.com/en-us/library/ms156292.aspx Enkh. I don't really understand it. Can you please just describe it for me or someone Is it windows authentication username or some kind of ID Just use USERID Mo ...Show All

• Manuel_Sukerman Referencing field by name in code

  I have a field (Fields!myfield) that I would like to pass in the name as two parts(Code.GetField("my","field") and dynamically return either a reference to myfield or the value itself. I'm getting Reference to a shared field requires a shared reference error when I try to return Fields!Myfield.Value from the function. I would like the ability to pass in the name of a field to a function and return the actual field name ...Show All

• Jason Bolstad Maximum Memory Settings for Analysis 2005

  Dear Anyone, We have a live machine with an Analysis Services 2005 (32 bit) installed. The machine has been running for a couple of months. They recently upgraded to 8GB (formerly 4GB). It seems that the 32 bit version of MSAS 2005 does not support 8GB or memory. Can anyone please suggest memory settings to maximize the use of the 8GB of memory in the server Or does anyone know of the maximum memory setup that we can give Analysis Services 20 ...Show All

• Jennifer LaMacchia Microsoft.SqlServer.Dts.Pipeline.DoesNotFitBufferException

  Hi I have a SSIS project that has one parent package and three child packages. When I run the project on my development machine in debug mode it works fine. Also if i run the packages using dtexec on my development machine it still works fine. However the problem comes in when I try and run the project using dtexec on the staging server i get the following error: Microsoft.SqlServer.Dts.Pipeline.DoesNotFitBufferException: The value is too ...Show All

• Eva Pierce Monsen sub-reports don't start in the first page

  Hi all, we are using SQL Server 2000 with RS SP1. We've built a report that use sub-reports, each sub-report is quite long (more than 1 page). It happens that the first sub-report begins in the 2nd page but the first page contains only the title. So we have the 1st page with only the title and all the data in the 2nd page (not very nice). Is it a problem that someone have solved Am I doing something wrong with building sub-reports ...Show All

• Justin Butcher Web Synchronization wizard

  Thanks Mahesh, the above su ggestion did work. However, I have a new problem with SQL Server mobile subscription. I use SQL server 2000 and SQL server management studio from SQL 2005. After the Synchronization start, I have following error “The constraint cannot be removed because it is referenced by another constraint. [ Constraint name = specCategories ] HRESULT 0x80040E90 (25077) The SQL statement failed to ex ...Show All

• Henrik Andre Tellevik SCD Insert and Identity Columns

  It looks like you can't use an identity column to generate your surrogates. (Leave out the value during the insert operation) What gives So is the only alternative to do a lookup when I start my data flow to get the Max surrogate, then after my SCD and before the OLE insert destination , use a script task to increment   Wenyang wrote: Using identity columns should be a best practice for ...Show All

• cobramatt Object Explorer/Server Explorer Error

  I have just installed the released VS2005 as well as the released SQL2005.  When ever I try to browse my SQL Server with either the Object Explorer in MS SQL Server Management Studio or the Server Explorer in VS2005 I get the following error: Unable to cast COM object of type 'System.__ComObject' to interface type 'Microsoft.VisualStudio.OLE.Interop.IServiceProvider'. This operation failed because the QueryInterface call on the COM componen ...Show All

• xpatriot How to convert a timestamp into dateTime in SQLServer 2000

  Hi Everyone,   We have a table in SqlServer 2000 with a column type TimeStamp and contain value such as 0x00000000656AC51F. Are there any way for me to convert that value back to DateTime I tried to use cast function like: Select cast (MyTimeStampCol as DateTime) myDate from MyTableand I encountered error below.   Msg 8115, Level 16, State 2, Line 1 Arithmetic overflow error converting expression to data type dateti ...Show All

• Halsafar error message says WkUFind cannot open because MSVCR70.dll is not found

  how do I load this file Is this a SQL Server Setup question Please repost with more detail if so. Thanks, Paul This seems to be a more universal problem, I've tried to run other programs which work on previous versions of windows, only to get this error also. Two confirmed programs are DrJava (a standalone java compiler) and UnrealIRCd (an irc server). With DrJava, the problem was solved just by s ...Show All

• Bill van Melle try to setup membership with ASP.NET configuration

    When I whant the use the new ASP.NET configuration tool (2005) and I want to define a provider I get the following error. You should know that on installation of VS 2005 SQL-Server Express did not install and I installed SQL-Server 2005 (shiped with VS 2005). So now it seems that VS waits for the Express edition. I changed under Tools/Options/Database Tools/Data Connections the SQL Server Instance Name to "MSSQLSERVER" but this does ...Show All