Answer Questions

• victor2007 save unicode data into MSDE SQL

  Dear Expert: I am facing a problem which is after the Asia characters saving to SQL server (MSDE version), value in the field will be showed in all question marks, the develop enviroment which I used is Visual Studio .Net 2003 C# and in Windows XP Sp2, the system is already configured to Unicode, I have also set the field type in database is nVarChart, when I manually key in these Asia characters into the database, it shows the correct word, w ...Show All

• Cyndi 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

• Adam Scott Newbie question - how do I specify a variable for the file location when using the Execute Package Task

  There are two options to specify the subpackage location (SQL Server or file location). I'd like to know how I can specify a variable name that points to the file location so I avoid hard coding the file location which could change during production installation. thanks This is a start. http://sqljunkies.com/WebLog/knight_reign/archive/2005/11/12/17375.aspx Thanks, K Hi Ovidu, Thanks for the reply. Yes, I am working in ...Show All

• Rob Loach An existing connection was forcibly closed by the remote host

  Hi, I am using ASP.NET 2.0 application to fetch data from a SQL server 2005 using stroed proc. Stored proc is also using one table from Linked Server (SQL 2000). Linked Server is configured to use login's current security context. I am getting the following error message Event code: 3005 Event message: An unhandled exception has occurred. Event time: 6/15/2006 4:26:30 PM Event time (UTC): 6/15/2006 8:26:30 PM Event ID: 988964e6fa5249 ...Show All

• NeuroWinterMute Is there something like a referer report to use for navigation

  Is there something like in HTTP - a REFERER - which names the report called the current report or do I need to implement this on my owne by hidden report parameters Thanks HANNES No, the referer report is not available. You would need to pass through the information with hidden report parameters. -- Robert ...Show All

• Rod Colledge Import CSV file data from URL/HTTP

  Hi, I'm truly a newbie to this, so please ignore any stupidity :-) I am trying to (in SQL2005 - integration services) 1) Import a CSV file over http (using an URL) 2) schedule the job (so it is done regularly) 3) *bonus* edit the URL dynamically I have a web link, e.g. http://dummy.com/cgi-bin/run.cgi from=050101&to=050102 when accessing this "page" the result is sort of a CSV file. It looks something like this: Date;cus ...Show All

• Keith Murray Strange Deadlock issue

  Hi,    Before posting this thread, I have searched for answer in this forum.    But this case is a little bit different from the others.        In our application, we encounter deadlock on a single table.    Env: SQLServer 2000, SP4, ReadCommitted    One thread is trying to do this update sql:    "update resources_allocate set FromDate= , RepFromDate= , Res ...Show All

• Alicia Rose Insert /Update data in destination

  I am new to integration services. I am trying to a build a data warehouse and need to be able to insert new data as well as update data that has changed. I am getting the data in a flat file and need to import it into SQL 2005. I saw some post on www.sqlis.com/default.aspx 311 but I did the example is for OLE DB component. I am not sure how to achieve this using a text file as source. Any help would be greatly appreicated. ...Show All

• Fatcat2315 Running query in SQL 2005 stored procedure against table on SQL 2000

  I'm trying to set up Service Broker Services on SQL 2005 x86.  I've got two services set up, and a stored procedure associated with one of them. The stored procedure is going to execute a query against a database on another server running SQL Server 2000 SP3. I can get the stored procedure to activate by using ALTER QUEUE WITH ACTIVATION...EXECUTE AS USER My problem is that the execution of the query within the stored procedure ( selec ...Show All

• Stylus Studio Help with ##table

  Hi, I am trying to drop a global temp table (##table) with sa rights and I get no joy. Does anyone have an idea what this could be caused by. The table is used by a sp which checks if the table is there and it drops it if its there. Tnx for help. Quite possible that another user might be accessing the ##table since it is a global temporary table. Hi Kudah Just tested ...Show All

• Sonia Pignorel XMLBulkLoad

  Hi,     I have been working on SQL Server 2005 nearly for an year now. In Beta2, there is class XMLBulkLoad which can be used to bulk copy data from an XML file into SQL Server using a mapping schema. Now I have installed the Yukon April CTP and OMG the XMLBulkLoad class is missing. Does anybody have any idea whether it has been removed or changed to something else It was earlier "unofficially" in the " System.Data.SqlXm ...Show All

• Jaewon Package Configurations not so portable?

  I'm still struggling with finding a sound approach to creating configurations that are truly portable.  For instance if you use XML files to store configuration information, the path to the XML file that stores the configuration is baked into the package.  This would require the same file system structure on all machines that could host the package. Store in SQL server - one key thing that is valuable to configure is Data Sources - bu ...Show All

• n.ar Can i create reports using VB Express and SQL Server Express??

  Hi, i ve installed visual basic express and sql server express. my question is can i create reports in my database application An update for SQL Server Express that includes a limited edition of Report Server is expected to become available in 2006. Its features are described here: http://www.microsoft.com/sql/technologies/reporting/rsfeatures.mspx -- Robert ...Show All

• lgcardona How can you enable remote connections using TSQL?

  I know how to enable remote connections using the Surface Area Configuration tool. Seems there would also be a way to configure it using a TSQL command/procedure call. thanks,   - Paul - You can use sp_configure to enable the features exposed by Surface Area Configuration tool. To see the options, run following first: exec sp_configure 'show advanced options', 1; reconfigure with override; Plea ...Show All

• tod Common Password

  Hi, I would like to setup a common password for all the MS SQL Server Users. Is there any generalized script for the same Thanks In Advance. Thanks Again. Yes you are right but i tried using the Statement and it does not work. I did not find anything related in BOL. Note: I am using MS SQL Server 2000. Thanks No, there is no such script that ships with SQL Server because we do not recommend setting a common password for al ...Show All