Answer Questions

• foleyp SQL 2005 Add New Login Fails Error msg 15025.

  I have read alot of threads her about 15025 and not one of them have addressed my problem or solved it. I wanted to add a user to a new database, when I go to security and logins her login is not in the system, yet she was able to log into the production db and do her job without any problems using Windows Domain account. I went to the New Login and tried to add the record but it gave me an error that the Domain\UserName already existed error 15025. I have gone into every database on the server to see if the login was in any of them and it was not. Then I tried to find orphan users and did find one in about 1/2 the databases that was from our Software provider. My guess is there is a sid issue, but I am at a loose how to find ...Show All

• Josibe Remove SP1 or install SP2 Dec. CTP

  This sounds trivial but it has become an issue here. We had the original RTM of SQL2005 with Reporting Services installed and running fine. We were explicity NOT installing SP1 because of a feature that was removed from reporting services (the select-all checkbox in the multi-value parameter). This feature is supposed to be back in SP2. So wouldn't you know it, somehow someone inadvertently installed SP1 in the course of doing windows updates and now users are complaining about the missing select-all checkbox. I figure my options are to either install the SP2 Dec CTP or try uninstalling SP1 (if that's even possible). Any recommendations When will SP2 be released Couple days, weeks, months ...Show All

• Parwej Ahamad How is it possible that inserted and deleted are both empty in trigger?

  I created manage update trigger to react on one column changes. There is an application which is working with DB, so I don't have access to SQL query which changes this column. In most cases trigger works fine, but in one case when this column changes, trigger is fired and IsUpdatedColumn is true for this column, but both inserted and deleted table are empty, so I can't get new value for this column. Any idea why is it happened Is any way around This column type is uniqueidentifier. Inserted and deleted tables are empty when application is changing value from NULL to not null value, but if I change it myself from Management Studio inserted table contains right values. Most like problem is in query which is changing that value. I'm ...Show All

• Tyrael117 reportitems collection in a custom function

  Helo, I tried to use de global coleciton reportitems in a custom function, but it raise the following error: 'reportitems' is not a member of 'Microsoft.ReportingServices.ReportProcessing.ExprHostObjectModel.IReportObjectModelProxyForCustomCode' I can use the parameters collection without any problem in the same function. I saw in documentation that parameters, fields and reportitems can't be used in inatialization (onInit()), but I think that this is not the same situation since parameters works fine. Any idea Tanks J.Aldrin But, just for information, ReportITems are ReadOnly. HTH, Jens Suessmeyer. --- http://www.sqlserver2005.de --- ReportItems are not ...Show All

• tlcosner sql help please

  I am trying to split a field into segments and write each segment to a different field, the field in question has the character '|' between each segment I want written, the problem is this field may have 2,3 or 4 instances of the '|' character in it, and is never consistent on the number of characters between each '|'. so my question is do I have to search through each character of the field until I find the '|' and then write each character prior to the '|' to a variable and finally write all the characters between each '|' to new fields. Could someone please give me guidance on how to achieve this OK. So, I assume you've got maximum 5 strings in the original string separated by pipes (|). I've got ...Show All

• magicalclick select inside update query?

  Is it possible for me to do something like update table1 SET var1=something,var2=something2 from table1 (SELECT * from table2) as newtable where newtable.field1=acondition OK, the query (although not correct) also makes no sense to me. What are you trying to achive, try to explain the query you want to write in words. HTH, Jens K. Suessmeyer. --- http://www.sqlserver2005.de --- ...Show All

• Lejing sqlexpress sa connection

  Hi guys. I have Windows XP pro with IIS + sqlexpress My problem is, I am writing a code with classic asp, to connect to sqlexpres database and somehow something blocking me. My first try was unsuccessfull , it was keep getting timeout. then I did something and now I am getting this error message shown below; Error Type: Microsoft OLE DB Service Components (0x80040E21) Multiple-step OLE DB operation generated errors. Check each OLE DB status value, if available. No work was done. /myfolder/opendb.asp, line 5 I am using SA user to connecto the server. When I checked the server with managment tool I found out sa doesn't have permission to use this new database of mine. So I tried to add that by going into Security>login ...Show All

• lutalex Errors using multiple parameters in a SQL Statement

  In an OLE DB Source in an SSIS package, we are having difficulties using multiple parameters in a SQL statement. Using a single ' ' works fine, but I've read that when you want to map more than 1 parameter you should use 'Parameter0, Parameter1, etc'. The problem is that when we use Parameter0 and Parameter1 and then try to map it, it says that the query contains no parameters. Can anyone help with the correct way to use multiple parameters in a SQL query that's part of an OLE DB Source task Thanks, Mike Anything that changes the structure of the dataflow pipeline will not work; this is in the select part of the query: adding/removing columns; changing data types; changing column na ...Show All

• Mariano_60 looking for a free distribution of mysql server

  Hello, i'm curently looking for a ms mysql server, which is free for personal use. May you give me some links to download this type of mysql server I'm neeby in servers - i don't know which version 2000, 2003 and so on is allowed to use free. Thanks in advance :) Did this help SQLExpress is the best match for your requirements... http://msdn.microsoft.com/vstudio/express/sql/download/ Express is an edition of SQL Server 2005, a successor to a product previously known as MicroSoft Database Engine (MSDE) which had two incarnations each based on a version of SQL Server 7.0/MSDE 1.0 and SQL Server 2000/MSDE 2000. All of these products are free to use and dis ...Show All

• Runningwolf SQL Update with id

  Hi I have a Excel sheet in this i have to take out a id and then search in the SQL DB if there is a Id like this and update some fields. I have it allready in Access but i need to have it in SSIS i have everthing exept the Update itself. I take the Id from the XLS and then i go to the DB and look if there are some of this ids in there. i "Merge Join" then then there are some left (5-10) now i wanna say take this IDs and update it on the DB but i search for so long now. I'm sure it have to be easy. TiborKovats wrote: Yes this i did but what i do after if i want the marged data to be Updated in the Database. How can i use a SQL Update with joining 2 Tables in a WorkFlow ...Show All

• morphius1 Database 'model' corrupted

  Hi, my 'model' database corrupted and my SQL Server 2005 Express can't be started. I believe I have the SAME problem as his: http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=455524&SiteID=1 but when I try the command start sqlservr.exe -c -T3608, an error message appeared: "Your SQL Server installation is either corrupt of has been tampered with (Error getting instance ID from name). Please uninstal then re-run setup to correct this problem" Well, the problem is that I have an ActiveBPEL database inside, and I really need a way without reinstalling it. Any solution Thanks, Edwin PLEASE help, i am getting the same error "error getting instance ...Show All

• lewek Varchar colum can be uniqe without beiny PK?

  Question is simple. How to make a varchar(250) column uniqe without being Primary Key. And another little advice i need. Think about a commersial website. Which one will be more efficient while connecting other tables with tblUser. Using UserID(uniqueidentifier) or UserName(varchar(250)). And is there any problem with the uniqueidentifiers performance Waiting for your advices and thanks for them... Happy Coding... ALTER TABLE mytable ADD varchar_col varchar(250) NULL ALTER TABLE mytable add CONSTRAINT uq_unique UNIQUE ( varchar_col ) a column can be unique without being a primary key.... primary key = unique +not null. as for using uniqueidentifiers or varchar(250), the ...Show All

• walkingboy Dynamic capabilities with Parameters

  Hello all, I have a winform application, where in we get the parameters from the reporting service and we display them in a panel for user's to input their criteria. So far everything worked good, but now we have a requirement wherein dynamic functionality is needed. For Example: Based on a selection of a combobox value, we want the other control to be enabled or disabled. Also we want default value of a control to be calculated based on another control's value like .. if user enters value "1" in textbox1 then texbox 2 should have default value of "6". (Textbox1 + 5).........and mix and match of such capabilities. The Question is........IS IT POSSIBLE and if yes...HOW!!! VDeepak, You can n ...Show All

• Bill Calkins Data Conversion Numeric to date

  I have some data which I am trying to put into a DM where I can use it as part of a cube (my first!!) I have hit a small problem with dates, I get it from the ERP system as a numeric field, and I need to convert it to a date format. The intension is to use this converted data with Named Calculations to derive Year, month Day ect. However I cannot seem to be able to convert and store (in SQL) this column can anyone advise Thanks Blackuke wrote: Hi Jamie It worked great until I put in the historical data for data that was like 61103 (YMMDD) the expression worked great I got 2006/11/03 however when I got data from 2000 it was like this, 110 (M/DD) (eg 2006/01/10) this br ...Show All

• dbro101 CLR User-defined aggregate support Java/J#?

  I want to write a Java User-defined aggregate (UDA). Shall I use J# I converted the C# example given in books online to J#. I am getting this error (as well as whole bunch of warning when I create the assembly.) Msg 6558, Level 16, State 1, Line 1 CREATE AGGREGATE failed because type 'Concatenate' does not conform to UDAGG specification due to method 'Init'. Msg 6597, Level 16, State 2, Line 1 CREATE AGGREGATE failed. btw, I have the use unsafe assembly options when creating the assembly otherwise I get this error: Msg 6265, Level 16, State 1, Line 1 CREATE ASSEMBLY failed because type "com.ms.vjsharp.cor.COMUtils" in safe assembly "vjscor" has a pinvokeimpl method. P/Invoke is not allowed in s ...Show All