Answer Questions

• Daniel Reib SOS, please help

  hi all I'am working on a smart device application that is supposed to be capable of communicating with a sql server DB on another PC on the same network. using VS 2003 i tried to specify the IP address in the connection string but it didn't work out i tried to put a web service on the DB server but the problem i hit is i wanted to send and receive objects between the service and the device, so i added a DLL containing the classe ...Show All

• Morgan Cheng Express Manager

  When will the express manager be available for the msdn version that is scheduled to ship later this month. If express manager isn't going to ship then what tool will allow me to create users in my express 2005 database. After reading a number of posts and trying out SSMSE, I would have to say that you have done an excellent job on 2005. Dave Retired SQL Sever DBA with 35+ years experience ...Show All

• Jiadong Export Wizard generates errors

  I am trying to export data from my local server to the hosting server. However I get errors when executing it:   Validating (Error) Messages Error 0xc0202049: Data Flow Task: Failure inserting into the read-only column "ID". (SQL Server Import and Export Wizard) Error 0xc0202045: Data Flow Task: Column metadata validation failed. (SQL Server Import and Export Wizard) Error 0xc004706b: Data Flow Task: "component " ...Show All

• Trevor_M Significant performance reduction after migration from SQL 2000 to SQL 2005

  Hi all,   I am wondering if anyone has similar experience.   I did the migration by detaching the database from SQL 2000 running on W2K Pro and attaching it to SQL 2005 running on XP Pro.   Some queries with simple aggregate functions such as AVG() have been slowed by at least an order of magnitude.   I understand that SQL server can intelligently adapt to improve the performance.   I am not s ...Show All

• leowang Sql Server 2005 Mobile/RDA connection problem

  I have a working Pocket PC 2003 app that uses RDA to exchange data with SQL Server 2000.  I'm attempting to port it to a Windows CE 5.0 device.   (I'll be porting to Mobile 5 in the near future, but the gadget I have at the moment is CE).  I installed SQL Server 2005 Mobile Edition on the computer running IIS according to package directions, and used the wizard to set up a virtual directory with sscesa30.dll. The direct ...Show All

• daz1 Linked Server problem when querying

  I have a linked SQL Server on another machine which is created using a stored procedure that executes the following: EXEC sp_addlinkedserver @server = 'Achilles\Mixed' , @srvproduct = ' ' , @provider = 'SQLNCLI' , @datasrc = 'Archilles\Mixed', @catalog = 'DB_INTRANET' The stored procedure executes successfully and I can also succesfully DROP the linked server. H owever when I try to query tables in linked database ...Show All

• gbetz Assistance on implementing Data Mining

  Hi, I'm new to SQL Server and data mining, so please forgive my ignorance... I'm working on a project which requires me to use the datamining provided by SQL Server 2005. I've a table for which i want to predict the values in a table (Encyclopedia) The table contains the following fields: Component Major Attribute Minor Attributes(which is basically a list of CSV for attributes in no particular order) I want to predict the c ...Show All

• Martin Bonner accessing report server programmatically

  Hi friends I have .net app ,where i display reports from my report server in a screen .,which works fine. I added a web reference to my report server ,to my solution to get it work. since i know my report server name on machine i added webreference to my project. but when i deploy at site ,as you can guess, the server name can be different. is it possible add web reference programmaically so that i dont need to hard code report server name a ...Show All

• rdrenker Disable user configurable Subscription

  Hi, Does anyone know if you can disable a users ability to set their own schedules and only choose from shared schedules for their reports. The reason I ask is because we have a window from about 3-7 in the morning where we do DTS and maintenance etc and dont want the databases queried as the results could be wrong. Therefore we want to setup a range of shared schedules for users to pick which wont coincide with that time. Thanks in advanc ...Show All

• P-ter internal parameters

  When attempting to use an internal parameter, it still shows up as a parameter at the top. According to http://msdn2.microsoft.com/en-us/library/ms178770(SQL.90).aspx, internal means that it should not be visible anywhere. Does anyone else have any luck with internal parameters -Lori Please check parameter's properties in Report Manager or Management Studio ...Show All

• PraveenPatel SQL Server authentication mode in 'Transfer SQL Server Objects Task' gives error

  I was trying to transfer a SQL Server 2000 database  to SQL Server 2005 using SQL Server Objects Task. However, The following error message was encountered:   "[Transfer SQL Server Objects Task] Error: Execution failed with the following error: "Cannot apply value null to property Login: Value cannot be null..".“   Once I changed the authentication mode from SQL Server authentication to Windows Authentication&nb ...Show All

• F.Costa SSIS - XML config file

  Hi All, I am looking for help trying to configure an XML dtsconfig file, I am using different connection managers for my Source and Destination Databases, I am also using an XML dtsconfig file to set these parameters dynamically, however I dont want to use userid/password to connect to my source/destination databases and instead use trusted connection or windows authentication, I remember we had an option in earlier DTS where we could set ...Show All

• Mark Attenborough SQL 2005 Enterprise June CTP Installation Error

  Tried to install several times (on Win2003 Ent. SP1) but I always get the following error: Failure adding user NT AUTHORITY\NETWORK SERVICE to local group SQLServer2005MSSQLServerADHelperUser (1388) The user varies (sometimes NT AUTHORITY\SYSTEM) and so does the local group (sometimes SQLServer2005SQLBrowserUser). Any tips Regards Roger In my case, yes, it's a DC. I have trie ...Show All

• Vantskruv The Report Services Instance could not be found

  I Try to connect to Report Services I Recieved This Message The Report Services Instance could not be found (Microsoft.SqlServer.Management.UI.RSClient) I don't have an ASPNET user Hi There, had the same problem. When I looked in the Reporting Services Configuration I had a lot of "red icons". I simply fixed those things. I guess the error have to do with the webservice and I fix ...Show All

• minamur Joining Table Operation

  I have two tables Customer and Customer Details. Both are joinde with cust_id. How can I insert data both the tables at the same time using ado.net. Should I insert individually or can I use JOIN operation for insertion. Please correct me with an example would be really appreciable. Thanks in advance Note that the best way to achieve this is by performing both inserts in a transaction. And this is the simplest method to solve this problem ...Show All