Answer Questions

• Rajat Talwar Database Collation: Chinese, Japanese, Korean

  My application supports multiple languages/locales in a single database. Some of our new customers want to support Chinese, Japanese, Korean, Italian, Spanish, and German in addition to English. Supporting the Latin based languages is not a problem. But I am having trouble finding a collation sequence that allows me to store the other double byte languages in the same database correctly. I have found changing the data types from text, char, varchar to ntext, nchar, nvarchar and adding an N in front of the various strings that getting inserted seems to work: insert into CONTENTDATA (recordid, xml) values (newid(), N'<CHANNEL1><FILE1/><TEXT1><![CDATA[和 魔拉拉 的 感精神 ]]></TEXT1><TEXT3><![CDATA[和 魔拉拉 的 感精神]] ...Show All

• Sandyee Installing Microsoft SQL server management studio express broke my asp.net databases

  Morning, I installed the managerment stuid on my machine and now none of my database connections seem to work any more. I keep getting the attached error. Before I installed the studio the system worked fine, I could connect to the database and everything was fine. Does the studio change any permission stuff I cannot seem to get it to work again at all now, I added in aspnet as a login inside the studio and it still won't let me connect to the database. I cannot find *any* logs anywhere that might be helpful in what it is doing or see any way to debug the connection to find out what the problem is. When I look at the permissions inside of the studio it shows me that the connections should all be fine. I checked and remote and local connec ...Show All

• Peter Kahn SQL Server Agent Jobs

  Hi, I'm new to this area so hope someone can help: 1) Does SQL Server agent jobs support executing windows script files (.wsf) I tried running using an Operating System Command (CmdExec) but nothing happened: wscript c:\file.wsf 2) The windows script file is located on the Web Server. I want to run the job from an SQL server calling the windows script file which is located on a different server. The target server is not an SQL Server. Is this possible Thanks, Martin Hi, did you try running under a domain account rather than a network account. It could be that the service doesn’t have permissions using the internet connection (perhaps if you use a proxy server and you get a input b ...Show All

• Pwint Currency Variables?

  Starting in my control flow, I execute a data flow that populates a recordset via SQL 2005 Stored Proc. One of the columns in source table is a currency type. Back to the control flow, I have a for each container that includes an execute sql task that updates or inserts records into another table. I get precision or data type issues since I can not assign the package variable to a currency data type. The only way I can get this to work is if I convert the currency column in my data flow to a string and then cast the variable in my update/insert sql task. Any suggestions Thanks....Gary One suggestion would be to map the currency type in the recordset to a variable of type Object in the ForEach cont ...Show All

• CJira Reading EMail in SQL Server 2005

  Clients send our database user emails with attachments which we automatically import and process on a schedule. I'm currently using SQL Mail to do this in 2005, but it's marked as deprecated and to be removed in future versions. Currently, Database Mail is supposed to replace it, but so far as I know, it cannot read email. Is there a preferred way to do this that will work in the future SQL Mail works fairly well, my only complaint is that an email with multiple attachments may not generate unique file names. It only takes the first 8 characters. If an email has two attachments, TestFile22.csv and TestFile37.csv, SQL Mail tells me I have two files both named TestFile.csv. The file exists, but is only one of the two attachements, and I hav ...Show All

• Phillip S. Windows Authentication connection problem

  I belive this issue maybe to do with the domain or the network, but since I don't know how to diagnose the problem exactly I've posted here as the starting point. When connecting to Sql Server 2005 using Windows Authentication, the first attempt will fail, but subsiquent attempts suceed. It fails with a message of the connection attempt timeing out. This happens when directly using SMO or using the Management Studio (which I belive also uses SMO but at a more raw internal level). If I use Sql Authentication then I can log on fine. Also when in Management Studio frequently opening a diagram or modifying a table and other general tasks will take an unsually long time. Other things like outlook (working with exchange) are al ...Show All

• aboeing Help me remind me why I never run a package from a package

  Hi, For some reason, I stay away from executing a package from a package. I guess that this is because I have experienced issues with this in the past and because I have read some articles in that forum that pin point specific issues when you do this. So far I try very hard to either combine all I need in one package or I break it down in multiple packages and use SQL Agent to drive the package chaining. Does anyone has a better experience with SP2 as far as running child package from parent package is concerned Any bugs remaining out there Thanks, Philippe I'm not running SP2 yet, but I've seen quite a few people start to lean on SP2 as causing most of their recent issues. Please, ...Show All

• Raptorix A critical SQL Server problem

  Hi, Once, I wanted to attach a database to SQL Server by means of "CREATE DATABASE ... FOR ATTACH" command, in Query Analizer. I encountered an error and attaching database failed. (The error was something like this : "the phisical file 'FILENAME' maybe is incorrect") But after going to Enterprice Manager, I realised that a database whitout a name was created. Since then, I wasn't able to do any process in SQL Server whitout either not recieving an error or failing the process. I decided to uninstall and reinstall SQL Server again. But after uninstalling, whenever I want to reinstall SQL Server I get this error : " A previous program installation created pending file operations on the installation ...Show All

• Raja Nadar Merge replication using files.

  Is it possible to use merge replication without direct connection from suscriber/publisher I'm trying to find a solution to use files for send/receive merge-replication info from/to server. ^_^, Thank You. I needed for all syncs :(. Do you feel there's a way to bypass merge-web-synchronization and use files to do sync. I don't know the communication process, but simplifying, maybe we can merge request/s in an ouput file, and response/s in an input file ... Than you. There is currently no support for Merge replication with files. Are you concerned about the snapshot fules or you want all of the syncs to be using files If the former, you should look ...Show All

• BobH storing a list in a database table (messaging queue?)

  hey all you database guru's hopefully someone can lend some insight as to a little table design problem I have. Basically I've got a system in place to authorize users to access a website typical username password stuff. The table contains a list of users and there passwords plus the auth level and a few other tid bits that aren't really important enough to into detail about them here. What I want to do is add a messaging system to this, I think I could probably figure out a way to do this half decent if I setup a seperate table for each user to add a row to the table for every message entry than in my asp.net code have it delete everything but the last 10 entries every time a user logs on. However I would much prefer a way that I didn't h ...Show All

• hellomcv Loop container to process all excel files

  What I'm trying to achieve is a SSIS package that will pick up 1 or more excel files, process the data in them via the conditional splitter, pushing the good data into a table, and all other rows into an error table. I'm having some issues using the ForEach container to process multiple excel spreadsheets into tables. The excel import into the tables is more or less working (imports data for good cases, but uses a null if the Excel Source when it gets an unexpected value - but that's a seperate problem). I found something related to this when searching, but it related to CTPs (June and September) and trying to reuse the connection strings they built up there (using my own variable names, naturally) causes a 'Property Va ...Show All

• Chiisana 'sa' User Map error

  Hello all, I'm having a problem with my sa account, we just migrated from sql server 2000 to sql server 2005 and 1 of our production applications is failing on the sa login. I checked the 'User Map' setup to the 'sa' account and the databases that need accessing aren't mapped. When I try to add the map, I get error "Cannot use the special principal 'sa'. (Microsoft SQL Server, Error: 15405)". I get the same error when trying to remove a user map for sa (there are a couple db's already mapped), and I don't remember how I mapped them in the first place, but it certainly isn't working now! Thanks in advance, 102020 What is ther error that you get back and for waht operation do you get it back Pl ...Show All

• jayakhanna package configuration are ignored

  hi everyone I am putting my connection string in package configuration file, which i create through package configuration option. But connection is not picking up value where as other varibles are picking up values from same file. Is there is any other setting that we have to set for connection string. Thanks and regards Rahul Kumar hi I got it right now. Actually i was not giving connection string in design time and wanted package to pick it from config file.So package was not running. Mistake i was making was i wasn't setting delay validation as true. Chek the execution log of the package and see if there is any warning about configurations not ...Show All

• Peterlih Date Range Issue

  I've been trying to find a good way to do this and it seems every idea I come up with or find only accomplishes the desired result in one scenario. Here is my issue. I'm designing reports with SQL Reporting Services 2000 and many of these reports need to show values for a dynamic date range such as the last full month, last full week, etc. similar to the built-in functions in Crystal Reports. To accomplish this, my first effort was to filter my results by looking only at results where a specific date parameter matched the current week or month -1 or -2 or whatever was needed. The following example would look at records for the previous month only: SELECT * FROM tbExample WHERE MONTH([Entry Date]) = MONTH(GETDATE())-1 AND YEAR([Entry ...Show All

• bennymacca Error Handling problem

  I have a strange behavior when executing a CLR SP: The SP contains the following test code: try { int.Parse(""); } catch (Exception ex) { try { command.CommandText = "raiserror (100003, 16, 1, 'parse error') with seterror"; pipe.ExecuteAndSend(command); } catch { return; } } Here the SQL I use to test it decare @e int begin try exec MySP set @e = @@error print @e print 'phew!' end try begin catch print error_message() end catch print 'done' What I expect is that, since MySP throws an error, the catch block is executed and the error message is printed out. What happens is that @@error contains the correct error code 100003 the catch block does not executes Here the output of SSMS ...Show All