Answer Questions

• Ton vd Pol LDAP vs ADSI parameter problem Part IV

  Dear Friends , I have this query that works 100 % OK . CREATE PROCEDURE [dbo] . [GD_SP_LDAP_CGD_GET_APLIC] AS DECLARE @SQLString NVARCHAR ( 500 ) DECLARE @test nvarchar ( 20 ) SET @Test = 'SSI' SET @SQLString = N 'SELECT name,SamAccountname FROM OPENQUERY(ADSI,'' SELECT name, SamAccountname FROM ''''LDAP://OU=GruposDistribuicaoSoftware,OU=Servicos-Transversais,OU=cgd,DC=GrupoCGD,DC=com'''' WHERE objectCategory = ''''group'''' '') ' ; EXECUTE sp_executesql @SQLString ; If I add a new column DESCRIPTION to the query , returns a error : CREATE PROCEDURE [dbo] . [GD_SP_LDAP_CGD_GET_APLIC] AS DECLARE @SQLString NVARCHAR ( 500 ) DECLARE @test nv ...Show All

• suranga_d trim trailing white spaces

  Hi All, I have a column which has some white spaces that I suspect is tab delimeted one. So when I use a rtrim(col1) it would not trim those. So i used a scrip component and wrote this line, Row.trimDetail = RTrim(Row.detail) here trimdetail is an o/p column and detail is the input col with the trailing spaces. but still I don know why the column has that spaces. Can someone help me to figure out what is the problem Thanks in advance, Try this in a derived column transformation: rtrim(replace([field],char(9),'')) Hi All, Thanks for the valuable inputs so far.. I tried using this script but what I see is even after this some of the records get errored out and when I see the error ...Show All

• Sanjukta Printing in MSRS - Riddle

  Is it possible to schedule a report to print to a specific printer, that would work on a schedule the way an email subscription does Thanks!! any other thoughts I did not install it so I dont' think it was done.....what would I do at this point If you instaleld that within your setup, then there is a printer delivery example which shows you the way to enable your reports for printing delivery. HTH, Jens Suessmeyer. --- http://www.sqlserver2005.de --- Go back to setup and install the samples. The sample printer delivery extension is installed by default in C:\Program Files\Microsoft SQL Server\9 ...Show All

• OnCallBI-DBA DTS Package problem?

  I have set up a couple of DTS local packages to run ActiveX scripts creating XML files and copying them to our webserver (on the same domain). I can run them OK manually via the 'Execute' package command in the drop down list when I right click on them and also get the 'Package successfully run' message back on running them, but when I schedule them to run overnight I find the SQL Server Agent reports them as 'failed' . What am I doing wrong This looks like a permissions issue...do you have a proxy account setup for the SQL Agent Look here for info...http://www.support.microsoft.com/kb/890775 Brad Feaker Ex nihilo, nihil fit As referred if you are scheduling ...Show All

• Steven Wilmot DROP USER

  Hi, I’m having problems dropping a user this is my code: Public Function DropUser() As Boolean Dim conn As New ServerConnection( "STATION01\SQLEXPRESS" , wContainer.Username, wContainer.Password) Dim myServer As New Server(conn) Dim myDatabase As Database = myServer.Databases( "VideoDB" ) If myServer.Logins.Contains(“username”) Then Dim db_user As New User(myDatabase, “username”) db_user.Login = “username” db_user.Drop() Dim db_login As New Login(myServer, “username”) db_login.Drop() Return True Else Return False End If End Function ...Show All

• Navin C MSDE Performance verses SQL 2005 Express

  I have been testing one of our Apps under SQL 2005 Express and I am seeing a big downgrade in performance compared to MSDE on the same hardware. Has anyone else experienced this Cheers Aussie Coder Any new info on this Our app does very similar caching for list controls. The tests involved loading a list control with a page of records and then using the down arrow key to scroll through a dataset of 2000 records. There is only enough records stored on the client side to fill the list control. I believe the data access engine I am using implements a server side cursor to access each record on an as needed basis. It also provides some buffering of the records, so it could be buffering 2 or ...Show All

• ElliotHC full, differential, transaction hwo to rotate the differential?

  Being of the "point and click"-generation I managed to create some sort of a fairly simple backup plan for our databases. There are hourly transactional backups and daily full backups, which were set up with a database maintenance plan. As the databases store event records they are ever increasing around the hour. The daily backups are now of a size that holding them is not feasable anymore and I want to move to a differential backup scheme: Weekly full backups Daily differential backups Hourly transactional log backups The problem I have is that the database maintenance plans allow me to rotate backup files automatically as they included the date and time of the backup. For differential backups there is no option ...Show All

• Shirvo How do i display a checkbox on a report?

  Hi, I've been trying to display a checkbox on a report using unicode text eg. (U+2616) (Arial Unicode MS). I get the error: BC30037: Character is not valid. I have read somewhere about using html formatting to display it, how could this be done Is there any thing else i could do Thanks, Sam. please post the code for this issue. thanks. textbox set properties Borderstyle Default = Solid Font FontFamily = Wingdings2 Expression Value =iif( Fields!....Value = "True", "P", "" ) I've been trying to show a boolean value in the database on the report with either a checkbox, Yes/No, or something easyfor a non-technical user to rea ...Show All

• pravej How to pass multiple values to a parameter while cascading

  Hi, I am using RS2005. i have a requirement in which i need to pass more than 1 value to a parameter. this parameter is used in a dataset for filtering. Eg: if i have a parameter as @years, i want to assign values 2005, 2006 to it and use it in the dataset to filter like select.... where year in (@years). How can i achieve this Thanks Vivek S Hi Uzzi / Ron, Thanks for your information, now I have a better idea how the multi-list format has. Do you have in your library this function that convert the format Thanks, Pepe Hi Uzzi How do you dump the multi-list into a temp table and it will not be better to put them into an array Than ...Show All

• sahil1286 Subreport NoRows property

  Hello, How could I render textbox,for example, instead only string When my report datasource is null it is returned as blank, how could I return some content. I don't want to use NoRows, it makes available only string Thanks Actually NoRows can be an expression as long as it evaluates to a string. http://msdn.microsoft.com/library/default.asp url=/library/en-us/RSRDL/htm/rsp_ref_rdl_elements_fp_58qc.asp ...Show All

• mobigital SharePoint Integration

  I originally installed SQL Server 2005 and configured Reporting Services to run on a different port and website and all worked fine. I can access it via localhost:15540/reportserver and also use BI Development Studio to creat and publish reports. I updated to SQL Server 2005 SP2, selected SQL Server integration on Reporting Services Configurator, created a new Report servcies database. Now when I go to localhost:15540/reportserver, the reports I had previously had available do not show... that may be ok However, I go to Sharepoint 3.0 Central Admin, no entry for Reporting Services show under App Management. Should it I also notice that link localhost:15540/reports no longer work... Where should I be able to go to get access to the ...Show All

• Moldau Need Help on this SQL Statement

  Hi All, sqlLstProds="Select * From PRODUCT_DEF "&_ "WHERE productID IN(Select productID From PRODUCT_DEF WHERE (IDProductCriteria = 5) AND ([Value] = '"&getSession("ModelID")&"')) "&_ " Order By IDProduct, IDProductCriteria" I have the above SQL Code in an ASP page. This queries the Product_Def table, however there is also a table called Product_sType, the primary key in that table is productID which corresponds to productID ub the Product_Def table. I need to add to the query a where clause, where active = 1 active 0 is obviously discontinued products, how would I do this So basically, it's somewhat of a join of some sort, like select * from Produc ...Show All

• rhd75 Is it possible to create a measure of data type string?

  I'm attempting to build a cube that will dynamically pivot normalized data in a table. table contains the following columns: column, client, name, columnvalue I want to put client and name in the rows, column in columns, and columnvalue in detail fields. columnvalue is datatype string - which would be non-aggregatable. I am unable to create a non-aggregateable measure of type string for the columnvalue. Even though both string and non-aggregatable are options for building a measure. Any ideas how I might work around this Calculated Measure Custom datatype --Neil ...Show All

• prrao Service Broker Erro but everything working

  Hi I have been running service broker between 3 initaitors and a single target witha forwarder for some time. Everything works 100%, i use persistent conversation and all queues and transmission_queues are clear. Everything works 100%. However while running profiler on the forwarder i see the following errors every now and again. Actually every time a message succesfully gets to central i see this error: On the forwarder: Broker Connection: EventSubClass 4 - Closing : An error occurred while receiving data: '64(The specified network name is no longer available.)'. Database ID 1 : master: ObjectName : tcp:11.45.101.100 - this is the target i sometimes see the exact same error with a initiator IP. I am very confuse ...Show All

• StuartGM SQL Reporting Services

  I have an excel report, with 10 columns on it. And each column has auto filters on it in Excel. When I develop this report, in SQL Reporting services 2000, how do i get the auto filters on the report. Basically, my question is, is there a way to GET AUTO FILTERS on a report in SQL RS 2000. Pl advise. Thanks. Hi Chirs, Thanks very much for the reply. But the dilemma is that the users dont want the report rendered in Excel anymore. I am still going to render the report as a web link. Are there any options to add auto-filters to the report in SQL RS. Because xporting in Excel will not be in an option for me. Any input will be appreciated. Thanks. Adding auto-filters ...Show All