Answer Questions

• John Sobernheim Adding member on a Role

  Hi all, I'm wondering if I can add a member on my role inside an SP. something like this. -------- EXEC sp_addrolemember 'RoleName', 'UserName' but i can't use the above statemnt inside a stored proc. I'm getting this error msg Msg 15002, Level 16, State 1, Procedure sp_addrolemember, Line 19 The procedure 'sp_addrolemember' cannot be executed within a transaction. Is there any other alternative way to add a member to a role inside an SP Thank you so much and have a nice day to all You can commit the transaction inside the trigger before you execute sp_addrolemember, just put a COMMIT statement before the call to sp_addrolemember. This could have undesirable effec ...Show All

• John P G Visibility expression

  Hi I need to hide a textbox based on three attribute values. I referred one of the posts and was able to hide the textbox based on one attribute value: ie. =IIF(Sum(Fields!G_PUR_RATIO.Value, "WSAttribs" )=0, True, False) I tried to check the second attribute value using logical AND , but doesn't work. I need to do the same for three attribute values. =IIF(Sum(Fields!G_PUR_RATIO.Value, "WSAttribs" )=0 And Sum(Fields!S_PUR_RATIO.Value, "WSAttribs" )=0, True , False ) I would greatly appreciate if you could direct me towards implementing the same. Thanks! Pradeep. I tried something similar and didn't have any problems, I found some fairly unpredictable behaviour out ...Show All

• russ_mac SSMA Migration Tools

  hi all I am Facing problem for using this tools (Migrate from Sybase to SQL Server 2005) when i trying to connect to Sybase on Tools EM, this error apper Error Collecting Data . See the Inner Exception for Details please anyone can help in this issue or advice me what can i do thank's Thanks, I actually got a reply from the syb2sql@microsoft.com email address about this issue: "SSMA 1.1.618 has a known bug, which can appear when the Sybase server is 12.5.0.x. Seems it is exactly your problem. I suggest using a newer SSMA build (1.1.679), where we have fixed this bug." There was also a link to the ftp site in the email but I'm not going to publish that here. The new versio ...Show All

• sticksnap RAISERROR in CLR Routines

  When I use the following code to execute a RAISERROR from within a CLR Routine (Stored Procedure), and I call this CLR stored procedure from T-SQL within a TRY/CATCH block, the error is not caught in the CATCH block. Why is this happening try { SqlContext .Pipe.ExecuteAndSend(cmd); } catch { } I have noticed that if I throw the exception out of the CLR routine, then the T-SQL stored procedure begin catch .. end catch does catch it. But of course, there is a lot of .NET information sent back with it, so the error message is quite messy. Thank you all. Those were two very helpful posts with a complete explanation of the issue! Sam. ...Show All

• Chidu Composite Key

  Hello, just wondered if anybody could either tell me the answer or point me in the right direction to the following question. I have a table that maps Users to Requirements The following is Valid Where User = Jon, Bob and Requirements = 1, 2.... User Requirements Jon 1 Jon 2 Bob 1 Jon 3 Bob 2 The following is not Valid Jon - 1 Jon - 2 Bob - 1 Jon - 1 So I basically need to know how I can enable the above constraint. Any help is much appreciated Jon Not to worry. Solved it.. ...Show All

• Di Wu Sql Server 2000 connection problem

  Hi all... I'm getting some problem while am connecting to my Sql Server 2000. I have design an application in vb.net and using remoting (Tcp Channel). But while connecting to the server am getting "your server is not confiured to allow remote access" can anyone help, thanks.... I must have been asleep when I answered this question. I just realized you said Server 2000 (not 2005). Which version of 2000 are you using I believe the default for 2000 was to allow remote connections but that it is possible to disallow remote connections. Seeing that I don't have a SQL 2000 instance here, I can't give precise directions on how to re-enable remote connections. But that's where I would check first. ...Show All

• newbieneedshelp Multiple joins in a filter

  I'm using Sql 2005 and merge replication. I want to create a dynamic merge filter on a table but the data I filter on is only reachable by a few extra joins. For example: I want to filter Table3. Table3 is joined to Table2 which in joined to Table1. Table1 contains the host_name column that I use to filter i.e. host_name = HOSTNAME(). In order to get filtered data in Table3 do I have to also filter Table 2 and Table1, or in my filter clause for Table3 can I say something like: Table3.FKid = Table2.Id and Table2.FKId = Table1.Id and Table1.host_name = HOSTNAME() I'm pretty sure I can't use AND in my dynamic filter clause but I just wanted to make sure. Thanks for your help Graham The rec ...Show All

• joslat COnfiguring Number of records per page?

  Is there a way I can specify how many records per page should be displayed > This is a very basic functionality that needs to go in the deployment at any cost for us ...any ideas. thanks Here's a working example. The attached report has a self contained dataset and the same table twice, once using a list control with groupping applied. Hope this helps. < xml version="1.0" encoding="utf-8" > <Report xmlns=" http://schemas.microsoft.com/sqlserver/reporting/2005/01/reportdefinition " xmlns:rd=" http://schemas.microsoft.com/SQLServer/reporting/reportdesigner "> <DataSources> <DataSource Name="master"> <ConnectionProperties> <Integr ...Show All

• profesacutz Add/Remove DataViewers makes VS to crash

  Hi all, I'm sick of VS crashing when I add/remove DataViewers any idea why this could happen Sebastien. In my case it happens when a dataviewer is assiocated with a deleted item. When you delete an control flow item on the control flow the dataviewers are not deleted. When you try to delete one VS will crash Workaround: Create a new control flow item with the same name as is used for the dataviewer. Delete the dataviewers in the breakpoint window Delete the control flow item. At least it did the trick for me (after a few dozens of crashes before I discovered this workaround) Sander No idea why, but I get it quite a bit also. BobP Created ...Show All

• manders help in sql server 2000

  i have sql server 2000 database in my office. i want to access that sql server in LAN how to access that database plz help me mail me on abhijitwakde@gmail.com What do you mean LAN Do you want to access your Database outside your office network [1] you have to put the SQL Server 2000 CD in your PC and install the client tools [2] then run the program "query analyzer" to connect to your sql server (you must type in it's name and your credentials) Post here for more details, questions Mr. Abhijit, plz tell us about you complete requirements, On LAN, what your server is , do you have client at the other end what is the version of SQL Server you are using & many more... ...Show All

• ak2in table field datatype

  What datatype should I use for a field in my sql server table that should be able to hold values such as: -1.092 0 2.9875645 25436.432567 etc. Thanks If you want save numbers with floating point, you should use real. If you want to save numbers with fixed point, you shoul use decimal(12,7) (total <=12 digits and after dot <=7 digits) Okay, I thought this answered my question as well, but when I use the decimal(18, 4) data type, and try to use 7.99 as a value, I get an invalid value error. What am I doing wrong I should mention that at this point I am inputing the value directly into the table data from C#.Net. Is it simply a matter of format ...Show All

• No Progress SQL Reporting Services WS - check user input

  Hi, What is the best way of ensuring that users of a report entere data in all the provided input boxes I have written a vb function that checks the above requirement – but when I deploy my report and use a Reporting Services WS to retrieve the data the function no longer works. Any ideas any body Thanks I have done that , but i need a popup window to apear as my end users are very non-IT What about setting the "Allow NULL Values" and "Allow Blank Values" to disable Then the user have to put something in the parameter value box. HTH, Jens Suessmeyer. --- http://www.sqlserver2005.de --- ...Show All

• eriawan migration from sql 2000 to sql 2005

  Hi I am trying to migrate Databases from MS SQL 2000 (server A) to MS sql 2005 (server B). The problem i have when i use database copy wizard is that it gives an error and the login will not be migrated . I tried backup and restore of the databases as well as detach and attach.All cases the logins will have a problem. For example say for database intranet all the tables stored procedures etc gets migrated but under security >>users (say intrauser) i double click user and the the login name wont appear .and when i try to close the window it says login name must be specified(SQLmanagerUI) Please help. Anu_ooo - Your best best, what I've already done, is to do backups and resto ...Show All

• Bennie9425 Checkpoints: FTP task download FTP files fails in between then what will happen?

  Hi, I have a FTP task in my control flow that download files from a FTP server. This ftp task is inside a foreach container that loops over a ADO recordset for the file name. The files that the ftp task pulls are huge. If the FTP task fails then I want the FTP task to restart and only download those files that have not been downloaded. Is this possible What possible configurations do I have to make to the foreach container and the filetask Thanks a lot in advance for your help and time. Regards, $wapnil anyone.....help! Thanks, $wapnil Experts!!!! any inputs on this. Thanks in advance for your time. Regards, $wapnil ...Show All

• John Rayner Hidden Attributes in Report Builder?

  I created a report model off of an Analysis Service Cube. And was checking out the report model with the report builder. Does anyone know if there is a way you can call hidden attributes into the report using Report builder ...Show All