Answer Questions

• Tony Steele SQL Server Mobile tutorial and getting proper mobile DB installation

  Hi folks, I'm new to Windows Mobile progamming, and new to this forum. Apologies in advance if I'm asking a boneheaded question, but I've done searches and can't find anything directly applicable to my problem. I'm currently walking through the published MS tutorial in setting up an SQL Server 2005 Mobile application that subscribes to a publication on SQL Server 2005 to exchange information. I've gotten almost all the way through... successful ...Show All

• Ferchus How to run package with variables using dtexec?

  Hi, I am running my package in this way: exec xp_cmdshell 'dtexec /SQL "\SBLoadExcelDBLog" /SERVER test /USER **** /PASSWORD ***** /MAXCONCURRENT " -1 " /CHECKPOINTING OFF /REPORTING EW /LOGGER "{6AA833A1-E4B2-4431-831B-DE695049DC61}";"Test.SuperBowl" /Set \Package.Variables[User::varExcelFileName].Properties[Value];"aaab" /Set \Package.Variables[User::varExcelWorkbo ...Show All

• franz String truncate error

  Yesterday my program was inserting and loading data in the database just fine, now when i try to do a myriad of things(make a paramatizsed search ad a favorites option) when ever i add data to the database i get a string trucate exception, basically its telling me the data im uploading is too large, problem is the feilds in the databse can take it.Its telling me the column im updating to has a string limit of 255 , but in reality the column its ...Show All

• irf Error Handling with Execute Package Task

  I have a main package that calls several other packages using Execute Package Tasks. I also have OnPreExecute, OnPostExecute, and OnError event handlers at the package level to audit the beginning and completion of each package. I want to prevent each task from bubbling up to the package event handlers as well as prevent each task from bubbling up to the main package event handlers. I've tried setting the Propagate variable for each of the event ...Show All

• Dan Crowell sp name in trigger

  There are two different Stored Procedures insert data into a table, is it possible to catch what stored procedure name was that trigged the trigger in the trigger You could use the SET CONTEXT_INFO command to store the SP name in a connection wide context and then retrieve it from the trigger using a query on sysprocesses or CONTEXT_INFO() built-in in SQL Server 2005. See BOL on SET CONTEXT_INFO for more details. This will allow you to ...Show All

• Keeron Modi Error Message when accessing Report Manager

  Whenever I try to access Report Manager, I get this message. I don't know what caused it. I recently installed Crystal Reports v11 & Oracle 10gEX evaluation apps. Could they have caused this How do I fix this Product: SQL Server Reporting Services Event ID: rsReportServerDisabled Source: Microsoft.ReportingServices.Diagnostics.Utilities.ErrorStrings.resources.Strings Version: 8.00 Message: Unable to encrypt or ...Show All

• Ahmedweb Default OLAP store directory

  When I connect to the OLAP service in SQL Server 2005, select the main node and right click on properties; I get a property page with options to change things. I would like to change the DataDir property, but the directory picker is limiting me to some predifined options that I would rather not use (we need the cubes on a non 'C' drive)   Thoughts I got this from a list that I'm on. ----- When it doubt, hit the registry. Is thi ...Show All

• Texas Sooner is it possible to create a Master Details Report?

  is it possible to create a sort iof Master Details Report mean one dataset returning the master data while the other dataiset returns the details and then relate this two datasets on a common key and show the report . hi thanks for your reply, i understand that we can do this using drill down reports, what i want to know is is it possible that in a same report i.e. RDL file can i have master and detail d ...Show All

• radhesh Bug cannot export/import any dts package on sql 2000 from 2005 manag. studio

  I am connectd to a 2000 database and select import and try to generate a dts to pull in a flat file... the destination is also a 2000 database.. I used to do this using enterprise manager.. Nothing works you get the error: The operation could not be completed. The existsonsqlserver mthod has encountered an ole db error code 0x80004005 (client unable to esablish connection) the sql statement issued has failed. I can ...Show All

• Jejomar Ronquillo Select Permission Denied on object

  Hello all, I have just begun to develop a simple web application to maintain phone book / contact details of people. I have been facing problems wrt the connection to the database, while trying to execute the reader it throws this error - Server Error in '/phonebook' Application. OK, two things. Either you use integrated authentication whereas the user that uses the browser is authenticated against the database, then you have t ...Show All

• Sabbas Difference Between Physical IOs and Read-Ahead

  Hello ... I was running a table scan query on a 650MB table w/ 1 million rows.  With statistics IO and time I noticed that I was able to get the following numbers on SQL Server 2005 (note this was the Sept CTP): Logical IOs: 76,931 Physical IOs: 0 Read-Ahead: 58,321 CPU Time: 1212 ms Clock Time: 42946 ms So, in looking at the above I'm not seeing any physical IOs, but a lot of "read-ahead" IOs.  If I understand it ...Show All

• Erwin De Leon Unable to display image of unconventional url in Subreport

  Hi All, I have a situation here where by an image in my report is tied to a parameter name call ImagePath. The image is an external image. The strange thing here is that when I assign the ImagePath to "http://server/images/xxx.png" the image properly displays on the report. However, when I assign a value of "http://server/imagebinarystream.aspx" into the ImagePath (note: the url will stream a png image) it doesn't display anything, even ...Show All

• Fabio82 Exporting Tables from SQLExpress 2005 to SQLExpress 2005

  Hi, I just installed the latest version of VWD 2005 Express Edition and the latest version of SQL Express Edition 2005 and noticed that some stored procedure in the ASPNETDB.MDF file have been implemented. When I use my ASPNETDB.MDF file from the Beta 2 release, in the latest version, I cannot connect using my login info to the database... I receive an error message that the stored procedure is "to long.....". As I already created more than 35 T ...Show All

• Praisy Noel Cannot Install SQL Server 2005 along side SQL Server Express

  Hi, I have SQL Express edition installed. Now when i am trying to install SQL server 2005 June CTP i get an error saying "SQL Server setup cannot run. Another instance SQL Server Setup is already running. The running instance must complete before you can run the SQL Server setup again". I have restarted my machine twce but still i get this error message. Any ideas Regards Deepak ...Show All

• srem Where are the SQL Management tools???

  I just finished installing SQL Server 2005 Developer Beta 2. There are no menu items for the manager or any thing else. Where are these things installed.  How do I access them I was able to resolve this by uninstalling SQL Server 2005 Express and reinstalling The developer edition.  However, now all attempts to reinstall The Express edition have failed.  It seems to me they don't like each other. I just spent over 8 ...Show All