Answer Questions

• thukralz Synonym

  I have to deal with a naming convention for database objects, e.g. table and column names, which can be very hard to read. I am thinking of using Synonym for the name of each object e.g. table and columns. This can be seen as the logical layer of my physical database. However, there is no such feature as synonyms for columns ( correct me if I am wrong). If you want to create a logical layer, or to resolve the hard-to-read naming issue, how would you go about it Thanks. You can create views to expose the tables and columns as needed instead of synonyms. Yeah...but....Okay and thanks! ...Show All

• FrankSp Inserting chars into nvarchar turns into '?'

  hey.. im using a simple insert command (sqldataadapter) to insert a string in hebrew into a nvarchar field in my db...   the problem is that i always done that perfectly..but lately i started a new project and instead of the hebrew chars the command insert " " char instead of any hebrew char... any idea   thanks From your comment, it seems like you had things working correctly in the past. Other than starting a new project, was there any other changes, in terms of language setting Starting the new project on a different computer If you know for sure that the column is nvarchar, then it is likely an issue with the client side application. If the client application was in the Hebrew locale and was ...Show All

• jeka804 Updating Database User SID in SQL 2005

  Hi all We're currently undertaking the development of our first SQL Server 2005 database and we've stumbled across a problem with our method of deployment from Development through System Test, UAT and, finally, to Production. Under SQL Server 2000 we would build a new database in Development and assign permissions to a specific database user which was linked to an appropriate Windows Login - the whole build process was scripted. We would then hand the mdf and ldf files over to the Operations team who would attach the database to the System Test server, create a new Windows Login (appropriate for the environment), then run a script which would update the SID stored against the database user to the SID of the appropriate login. e.g ...Show All

• Itzik Paz Import Analysis Services 2005 cube into Siebel Analytics

  Hi, I'm trying to import a cube I've created with Analysis Services 2005 into Siebel Analytics Physical Layer. I've installed XML For Analysis SDK on the SQL Server and created a virtual directory which contains the file msxisapi.dll. When I try to import I get the following error message fro the server :"Error proccesing request". I think the problem occurs because the xmla service doesn't "know" I want to import the cube from it. I'm very new to the issue and we don't have knowledge in our company to solve the problem. I'll very appreciate it if someone could help me. Thanks in Advance, Moving to the SQL Server Analysis Services forum. ...Show All

• dba72 SQLCEReplication: Error 28037 - HResult -2147012892

  Hi! Since a few days we get sometimes the following error message: A request to send data to the computer running IIS has failed. For more information, see HRESULT. HResult: -2147012892 NativeError: 28037 I havent't found anything about the HResult -2147012892. What does this error mean Before this everything works fine for about 4 Months. We use SQL Server 2005 Juni CTP and Visual Studio 2005 Beta 2. The replication works over a GPRS connection at the PocketPC, through a ISA Server 2004. Sometimes it works and sometimes not. best regards, Markus Hi Tommyitvn, We solved this problem by using SQL server replication, Please check ur SQl server settings..... Hi Kabul, Do you solve this proble ...Show All

• Hassan Ayoub Add connction Fails in VS.NET with SQL Server Everywhere

  When I try to use the "Data Source Configuration Wizard" (Menu: Data\Add New Data Source...) and I try to add a new Connection to the "Northwind.sdf" database using Microsoft SQL Server Mobile Edition it fails with "Unable to find the requested .Net Framework Data Provider. It may not be installed." What's really strange about this is that if I click the Test Connection" button it states "Test Connection Succeeded." I've looked everywhere and I see that other have had the same problem but no one seem to know the solution. jc3 Adding the entry in Machine.config works fine for me, thanks! okay here is the exact error message: The upgr ...Show All

• Luminita Converting Crystal Reports 8.5 XML output to RDL....

  All-- We have several dozen Crystal (8.5) Reports that we would like to port to SSRS 2005. I believe that I can save these reports as XML data files with an accompanying schema. We are not interested in the data, but would like to be able to preserve the reports' layout from one reporting platform to another. I believe I might be able to write an XSLT transformation to convert the Crystal XML output into RDL, but this is not a trivial task. (We would like to avoid, at all costs, manually redesigning the reports in SSRS, but, if it comes to that, we will have to bite the bullet.) Has such an XSLT transformation already been created, and, if so, would anyone care to share their work TIA, mattyseltz in NY ...Show All

• project2n5e0o1 Getting events upon DB changes (NOT SCHEDULED)

  Hi. i'm trying to set an Event Provider that will provide me with events when a specific data changes in a specific table in the DB. I've noticed that the built-in SQL Provider polls the DB using a schedule and that doesn't help me. I'm thinking of implementing a customed event provider but I'm looking for a way to get events upon DB changes without using an interval (a continues event provider). is there any way to do it OTHER THAN using a QueryNotification if the best way is indeed using QueryNotification - is there a way of using it with the notification services and if anyone had done it - any documentation / code examples / links would be highly appreciated ! Thanks ! HostedProvid ...Show All

• John Cargill RS Data Driven Subscription is out of control...

  Hi - I'm hoping someone can help me with a subscription problem (SQL 2000, Reporting SErvice SP2). Created a data driven subscription and made a mistake in the parameter list. It was really long, and now I can't get the subscription to stop. I've bounced the server, but as soon as we restart RS the job starts back up again. I tried to delete the subscription, but it gives me a timeout error. I've already changed the subscription (because I didn't realize the trouble) and I'm wondering if there is a way to get rid of it. Right now, I've left RS service stopped. Thanks, Mary Brad - I did try that but RS would not allow me to delete the subscription. I found another post though, that explained if I deleted ...Show All

• comspy publishing a report with parameters

  say if i have a report that takes 2 parameters, StartDate & EndDate. and i want to publish/deploy this report for other users to run. Will the user be prompted to enter the 2 dates when they attempt to run the report sorry for the "what if" type question. ive been asked to do a bit of research on SQL Reporting Services Cheers, Craig This depends on the report setup and on the method of access. By report setup I mean the parameter. You can configure these with defaults and hence the users won't need to select the values but will still have the option to change the defaults. By method of access I mean whether you are using the report manager (or some equivalent method of URL access) or ...Show All

• Karl Seguin - MVP How can I find out if a string exists in a list?

  There are 5 sales person in our company that use a sales report. I have a SalesPerson parameter that allows them to choose thier own name and see their own sales information. I want them to see their own sales information by default. In other words, whoever uses that report, the report should grab his UserID and default the SalesPerson Parameter to UserID. I am populating the list of these 5 SalesPersons from a seperate dataset. So How can I code: If the UserID exists in SalesPerson Data set then default to UserID I need to put this expression in the default value for parameter. Please help. Thanks, Using a stored procedure would be a good idea for this one. Here's what I would do in it's ent ...Show All

• opticyclic An error occurred while performing this operation.

  Hullo Team, I kindly request for your help so that I could be able to start reporting services. The main services are running but reporting services is not running. It actually gives me the following error TITLE: Microsoft SQL Server Management Studio ------------------------------ Failed to retrieve data for this request. (Microsoft.SqlServer.SmoEnum) For help, click: http://go.microsoft.com/fwlink ProdName=Microsoft+SQL+Server&LinkId=20476 ------------------------------ ADDITIONAL INFORMATION: The Report Server Windows service 'ReportServer' is not running. The service must be running to use Report Server. (rsReportServerServiceUnavailable) (Report Services SOAP Proxy Source) For help, click: http://go. ...Show All

• Agostino Marottoli Package scheduling and error trace-

  I am scheduling the package to run on the nightly basis everyday using windows scheduled task. How do i check whether the package ran successfully or it has given any error. Can anyone please suggest me if I can log the error in some table of SQL server. PLease suggest the steps. When building a package in BIDS, have a look at the logging options. See the SSIS menu item, Logging. You can log to several locations including a table. I would expect DTEXEC to send the appropriate return code when it failed, so the scheduled job should fail. Unfortunately the windows scheduler is not very advanced, so you cannot capture output or configure the return code. The lack of output and monitoring mea ...Show All

• oipreS Using FreeTextTable Conditionally

  Hello all! I have a stored procedure that accepts a parameter @SearchTerm that may be null. In my WHERE clause, I check for all records where @SearchTerm is null, or are LIKE '%' + @SearchTerm + '%' when not null: SELECT (some records) FROM (some tables) WHERE @SearchTerm IS NULL OR (some fields are LIKE '%' + @SearchTerm + '%'); I am trying to use FTS with a FreeTextTable to make our search ability more robust: SELECT (some records) FROM (some tables) JOIN FreeTextTable(tableName, columns, @SearchTerm) ft ON ft.[KEY] = tableName.[KEY] However, because @SearchTerm can be null, meaning the user is not filtering our records by a search, doing a JOIN to a FreeTextTable throws an error (cannot have null as search string). Ple ...Show All

• Zadoras Report Builder: Date filter, Relative Date

  I have a date filter, and I default it to first day this month and last day this month under relative date, when I run it it givis me error: The Value expression for the report parameter ‘FromDate’ contains an error: [BC30456] 'Date' is not a member of 'Integer'. (rsCompilerErrorInExpression) Can anyone fix this problem But it works for Today or (n)months ago. Thanks. So are you saying this gives the error =parameters!FromDate.Value I doubt that is causing the problem unless you maybe have a number format string for the textbox Post your expressions and indicate what the data types are for the referenced field(s). OK, ...Show All