Answer Questions

• Kartit Couldn't connect to reports

  Hi, I'm not able to browse through http://localhost/reports . When I'm trying to connect it gives me "Server Error in '/Reports' Application."At the same time I'm able to view Reportserver.At the same time I'm able to view Reportserver.(i.e)http://localhost/reportserver please can anyone suggest me some solution to this problem.. Server Error in '/Reports' Application. Hi, we had given full control to the administrators as well as system users. And read and execute permission to reportserveruser as well as webservice user. Thanks Anandhi Permissions for both reports and reportserver are one and the same.Read permission is there.And it is mapped to th ...Show All

• kinny_k import a CSV delimited text file into a table

  Hi, Could you help me to write a script to import a CSV delimited text file into a sql server table. Thanks, carlos Hi, you can use either a linked server or OPENQUERY for ahhoc querying the data, or the Import wizard of Management Studio. A sample of this would be: http://p2p.wrox.com/topic.asp TOPIC_ID=20163 HTH, Jens K. Suessmeyer. --- http://www.sqlserver2005.de --- Thanks Jens, but it is too complex. I am using BULK INSERT, but now I have a problem when a try to load a DATE value, I get error Msg 4864, Level 16, State 1, Line 2 Bulk load data conversion error (type mismatch or invalid character for the specified codepage) for row 1, colu ...Show All

• amer sohail sp_executesql From App's Dynamic SQL Causing Performance Problems vs. Query From SSMS

  Okay, so I came across an odd performance issue that I'm wondering if some guru can help me out with. I have a query that uses a paging algorithm that uses a paging algorithm and a table variable, then gets a page of data based on a join to that table variable. Here's a simplified query using the algoritm: --declare table variable... not shown for brevity --make sure we only store the least amount of records possible SET ROWCOUNT ( @pageNumber + 1 ) * @pageSize --insert into table variable INSERT INTO @TableVariable( Key ) SELECT key FROM table WHERE whatever = @p1 --we only want one page of data SET ROWCOUNT @pageSize --now get the page of data from the table SELECT key FROM table WHERE whatever = @p1 AND [Table ...Show All

• Alex Mujar Errors after installing Server 2000 DTS Designer Components

  Hello, After Having installed the SQL Server 2000 DTS Designer Components necessary to edit legacy DTS packages on 2005 server, I keep getting the following message when trying to open SQL Server 200 Enterprise Manager: "The procedure entry point ProcessExecute@@YAXPAUHWND_@@PBG1@Z could not be located in teh dynamic link library SEMSFC.dll." Is there a way to fix so that I can open Enterprise manager Thanks! Thanks for the info. I really appreciate it. Good info. Fixed what I thought was a very cryptic error message. Thanks for the details! I uninstalled the DTS Designer Components and I'm still getting the error. Is there anything else I might try I Wo ...Show All

• CoderD datetime and timezone

  Hi All, I just wanted to confirm what I've found: A datetime field is not stored independent of timezone In otherwords, I have a java app that accesses MSSQL via JDBC. In java, the 'Timestamp' object is internally represented as GMT, but when printed, it looks at the timezone of the OS to determine how to display it. I thought that MSSQL would be the same in this respect but it seems not to be... I set a datetime field to, for example, 10:30 am. I then changed my OS's (win xp) timezone from eastern to central, then opened up sql server management studio. The datetime field still showed as 10:30 am. Does this sound right or am I doing something wrong Thanks, Martin Well, it depends ...Show All

• Alberto Ramacciotti Delete syntax to delete a record from one table if a matching value isn't found in another

  I'm trying to clean up a database design and I'm in a situation to where two tables need a FK but since it didn't exist before there are orphaned records. Tables are: Brokers and it's PK is BID The 2nd table is Broker_Rates which also has a BID table. I'm trying to figure out a t-sql statement that will parse through all the recrods in the Broker_Rates table and delete the record if there isn't a match for the BID record in the brokers table. I know this isn't correct syntax but should hopefully clear up what I'm asking DELETE FROM Broker_Rates WHERE (Broker_Rates.BID <> Broker.BID) Thanks I use the zero because the select list is not relevant. Your syntax will work fine. I need to do something lik ...Show All

• Samuel I Need help from someone who is an expert w/t-sql

  I am trying to create a query that will determine if a field has a specific value first. If that field contains the specified value then use that value, else determine if it contains a secondary value. A row the contains the first value takes precedence if one exists so it is not a straight 'OR' situation. I have no control over the data in the way the tables in the db are designed or I would have done it a lot differently, I just have to work with the data as is. Any advice would be most welcome. If I come up with a solution on my own and anyone is interested, let me know and I will send you the solution. SELECT @SBCUID=c.xcrt_xonr_sbcuid, @OwnerName = o.xonr_gps_ownername FROM exception_criteria c LEFT JOIN exception_owner o ON ...Show All

• MMBVN Import and Export Wizard: Did they try it out before they shipped it!!!???

  I have an excel file that, at least to me, is pretty simple. It's got 8 tables with about 25 records each. I'm trying to import 2 of those tables. Everytime I try to import I get this message: Column "Name" cannot convert between unicode and non-unicode string data types. So I've tried every combination of import/export that I can think of here and stil I get this message. Now I really don't think that I have any oddball characters in my data. As a matter of fact there isn't even any punctuation in there. And yet, SQL thinks there's some unicode in there. My dest column type for Name is a varchar(max). No issues there. So this is really about the simplest sort of data transfer that I can think of. And yet it doesn't ...Show All

• jforward5 Toolbar available with Web Service?

  Hello - I am trying to find out whether the Toolbar is available when using the Reporting Services Web Service interface. Right now, I am using the Web Service to render a report, but the Toolbar does not appear. I have set the <Toolbar> element in the DeviceInfo string to true. thanks - will I am using RS 2005...but I am trying to integrate RS with a ASP.Net 1.1 site...and using VS.Net 2003 for dev. Too bad there isn't a control like the ReportViewer for VS.net 2003. Oh well...thanks for the info. And..thanks for the great book. I purchased your RS book in electronic format a year or so ago. Thank you. If you ask me, the effort to upgrade your app to .NET 2.0 (granted without knowing too much ...Show All

• comspy help with an expression

  I need to create an expression to handle a simple calculation. Here is what I have: =Sum(Fields!MH_POS.Value, "lexis_sales_dbdata_prd")/ Sum(Fields!MH_POS_Goal.Value, "lexis_sales_dbdata_prd") What do I need to add to handle the when the MH_POS_Goal = 0 I tried isnull and nullif and kept getting errors. Something like this = IF(Sum(Fields!MH_POS_Goal.Value, "lexis_sales_dbdata_prd")>1,Sum(Fields!MH_POS.Value, "lexis_sales_dbdata_prd")/ Sum(Fields!MH_POS_Goal.Value, "lexis_sales_dbdata_prd") ,'') Anyone I tried this: =IIF(Sum(Fields!MH_POS_Goal.Value, " ...Show All

• Armela Custom time period - 26th of month to 25 of next month

  How do I create a server time dimension which has custom defined month periods. For example we use month that starts on 26 and ends on 25 next month. So our January is actualy starting from 26.Dec.2006 until 25.Jan.2007, and so on for Feb, Mar... Any idea how I can do it Thank you, Mitja Thank you Thomas! I have tried the proposed solution, but I get syntax error at "where" critieria. I was looking for some pre-made solution in business intelligence wizards, strangely enough to find there isn't one. Any ideas This is an example that works with the AdventureWorksDW sample database: Alter Table ...Show All

• JonnyAJAX incremental update

  hi guys, I'm a newbie in sql. anybody know how, if I want to update incrementally using integration service. say I have 2 server. we want to took the data from server A and put the data to server B. but we want just the changes in server A that send to server B. regards, -dedys if you only want the data that has changed since your last load then you need to keep a record of when your last load with. You can then compare that value with timestamps on the source data (assuming that there are timestamps). Once you have done that you will have all of the new and updated records. You can then use one of the techniques here: http://www.sqlis.com/default.aspx 311 to pass ...Show All

• Buddhist ERROR IN SQL SERVER ENGINE

  I have a problem starting my SQL Server engine. Its service has been stopped. It was working properly till evening “ December 8, 2006 ”. But when I came to office at 10:00 AM, it did not start. When I checked the service in “Services.msc”, it was stopped. So, I tried to start the service “ SQL Server (MSSQLSERVER) ”, but it failed with message “ Error 1069: The service did not start due to a logon failure ”. I opened “Event viewer” and looked the list in “Application” log to find out what had happened. There was an entry for “SQL Server” source with type “Failure Audit”. There was a message “ Login failed for user sa ”. What went wrong….Can someone help me Plz its urgent…. My company deals with many IT solutions ...Show All

• Byonksd SQL Server 2K client do not connect to DB server with IP addresses added to same NIC

  I am setting up a lab on a Windows server 2003 Standard Edition that works as a Database Server. Some clients connct to this database server; clients are on different subnet. Routing is ruled with Windows server 2003 RRAS. The differents subnets are created adding IP addresses to the network interface (I mean: TCP/IP Properties - General - Advanced - IP Settings - IP Addresses - Add) Clients ping without problem with server, I access to folders. Then I connected the first client SQL using SQL Server Client, I run registration, Everything works. I can see SQLServer, I managed everything as usual. In this case IP client is 192.168.1.50 and IP for server is 192.168.1.1 (his IP is in the "general" page of TCP/IP Proper ...Show All

• Jahid Report Subscriptions <-> Scheduled Reports

  This question is in regards to using the ReportingServices2005 WebService classes with C# .net 2.0. What I am having trouble with is how to relate a schedule to a subscription. The piece of functionality that I am trying to duplicate is adding a report's subscription to a schedule (on the Subscription:{report_name} page's subscription processing options under the asp.net "Reports" app). How can I programmatically set a report's subscription's "subscription processing options" to use one of my existing Schedules Some things I have tried: - use ListSchedules to get a list of reports, use ListScheduledReport(scheduleId) to get a list of reports related to a schedule (this is great, it gets me the reports, but I ...Show All