Answer Questions

• Sweeps78 SQL Server Express and AMD 64 bit dual cores

  Hello All, I've installed SQL Server Express and its Management Studio Express on two different machines with the same hardware. http://msdn.microsoft.com/vstudio/express/sql/download/ Both machines are suffering the same problem. At least once a day, when the user starts a process, it will peg the cpu at 50% (so presumably one core is at 100%) and explorer.exe will hang. If you start another process, it will hang in the same way. Killing explorer and restarting it does not seem to solve the problem. Rebooting seems like the only course of action. I think this is related to SQL Server Express because this did not happen on either machine until it was installed on the machines, and it started happening immediately after installi ...Show All

• Vikas Pradhan Creating databases on WinXP SP2 with SQL Server 2005 CE RC

  Hi, For various reasons a new desktop application I am developing is using the SQL Server 2005 Compact Edition Release Candidate to store local data. On my development machine (XP SP2, VS2005, SQL Server 2005 Developer Edition) the software is able to create the database file, and read and write to it fine. However on our test machine, which does not have any of the development tools the software is unable to create the database. A System.Data.SqlServerCe.SqlCeException is thrown. The message is: "SQL Mobile usage is restricted on this platform. To use SQL Mobile, you must install SQL Server 2005, Visual Studio 2005, or the Tablet PC SKU." Obviously this goes somewhat against the blurb for SQL Server CE. Is this somethi ...Show All

• XNA Rockstar Case conversion with SQL or Stored Proc

  Hi experts, I m new in SQL stuff. I have to work out a fucntion with ASP.net for CSV import to the DB in MSSQL. I would like to know for Stored Proc, is there any way that I can do the case conversion e.g the Full_Name read from CSV file: Lennon, John Then for the family name I need to convert into uppercase so the converted one: LENNON, John Is there any way I can check those words before the comma The CSV file is delimited with | instead of , Can I use substring for that And also do you have any online tutorial for Stored Procedure recommended Thanks a lot!!! Cheers, KNVB Merci beaucoup, Geert! By the way, have you heard of a company called i4net from Namur ...Show All

• JennaSoft ON DELETE CASCADE

  hello guys! Well im using MS SQL 2000 and i have over 250 Tables in one of my Database the problem is all the Foreign Key in the Table is not turn ON in ON DELETE CASCADE. The question is, is there anyway to write a script to turn the ON DELETE CASCADE on all the Tables Thanks for the reply! Novelle Nope, not really. You will just have to script your keys out, then change to ON DELETE CASCADE manually. Unless there is some tool to do it, but I don't know of it. A trick I would use is to take your database scripts (or if you don't have any, use a comparison tool, compare my full database to an empty one) and just replace all ON DELETE NO ACTION values with ON DELETE CASCADE. Then use your s ...Show All

• vitich connect dbase II in ssis

  I am having trouble connecting dbf of version dbase II. I can connect dbase III and dbase IV in ssis package,but can't connect dbase II.hope your help! who can help me liguancong wrote: I am having trouble connecting dbf of version dbase II. I can connect dbase III and dbase IV in ssis package,but can't connect dbase II.hope your help! have you tried saving the dbf as a version III or IV file MS does not support DBBase II with their solution (JET). See the supported versions listed here- How to use dBASE data with Access and Jet ( http://support.microsoft.com/kb/230125/en-us ) You will need to find a third-party driver, for ODBD, OLE-DB or ADO. ...Show All

• Student_I expression syntax for variable

  What would be the correct syntax if I wanted to add the following lines into a variable using an expression The lines should be the first two rows before my XML. < xml version="1.0" encoding="UTF-8" > <dataroot xmlns:od="urn:schemas-microsoft-com:officedata"> +@[User::xml_output ] Thanks, Phil Sigh... I hope there's an easier way and I'm just missing it myself... "< xml version=" + "\x0x22" + "1.0" + "\x0x22" + "encoding=" + "\x0x22" + "UTF-8" + "\x0x22" + " > <dataroot xmlns:od=" + "\x0x22" + "urn:schemas-microsoft-com:officedata" + "\x0x22" + ">" + @[User::xml_output] notalreadytaken wrote: You can just escape th ...Show All

• DARSHAN GERA SQL 2005 Analysis Service blocked by Zone alarm

  SQL 2005 Analysis Service blocked by Zone alarm when trying to load new data mining structures I have given every program related to SQL rights that I can think of. If Zone Alarm is up, BI Studio will freeze up loading data mining structures. If Zone alarm shut down no issues. No logs anywhere about program being blocked. Any ideas I wimped out on the resolution. Removed ZoneAlarm and installed free Comodo firewall. Nice firewall more detailed control and most important no issues with SQL.. gotta love it. thanks for the help Great article thanks.  I looked at everything firewall related and in fact turned off all filtering or controls.  It appears if Zone Alar ...Show All

• Allan Huang RunningValue ?

  I am having problems with the following - this represents the dataset Date Customer Voucher Number Document Amount Check Amount 7/15/2006 Company G 101 15.00 45.00 7/15/2006 Compnay G 101 25.00 45.00 7/15/2006 Compnay G 101 5.00 45.00 7/18/2006 Company A 102 35.00 35.00 7/25/2006 Company M 103 45.00 50.00 7/25/2006 Company M 103 15.00 50.00 This represents the final report this is what I am getting Date Customer Voucher Number Document Amount Check Amount Check A ...Show All

• Gwiz Running out of Identity Ranges

  Hello I have the following problem: - I have a transactional replication between a publisher and a few suscribers, - The servers are SQL 2003. - I have Identities columns in some of the tables - I'm using the Automatic Identity Range Handling The problems happens when the publisher or one of the suscriber goes down, (it happens relativly often and we can't do anything against it), so when the connection is restablished, the merge agent assign a new identity range to the publisher or the suscriber(the one that went down). Everytime a server goes down, it "eats" a idetity range, doesnt matter how many idenities have been used, and i am running out of identity ranges. I want to keep using the Automatic Identity Range Handling to man ...Show All

• WinstonPennypacker SQL 2005 Enterprise to 2005 Standard

  We have a situation where we installed the Enterprise version of SQL Server 2005 on a server that is now in production and we had intended to install the standard edition (what we are licensed for). We have enterprise licenses for other servers so we have both types of media and it was a mistake that was made. I was wondering if there is a way to downgrade the version without uninstalling and reinstalling and having to backup and restore all the databases, jobs, SSIS packages, etc. Any suggestions or help would be much appreciated. Thanks, John What do you mean "with the exception of license rights" Microsoft has historically been pretty generous when ...Show All

• raghu_grdr Microsoft Access Database Synchronizer (ADS) RTW

  Hi, Today we are very pleased to announce the RTW release of Microsoft SQL Server 2005 Compact Edition Access Database Synchronizer (ADS) for which many of you been waiting eagerly. Access Database Synchronizer provides a way to synchronize data between Microsoft Access database on a desktop and Microsoft SQL Server 2005 Compact Edition database on a device. The salient features of this solution are summarized below O Provides a synchronization solution between SQL Mobile/SSCE and MS Access. Data conversion is done while synchronizing the data. O Synchronization happens when there is an active ActiveSync connection between the device and the desktop. O There is no update to SQL Mobile/SSCE ...Show All

• Dan F. Jansson How get table size?

  I am trying to create a report showing the allocated size of each table. How can I obtain the size of each user table and place in my report Thanks! I would start with stored proc "sp_spaceused". ...Show All

• b182f117 unable to create maintenance plan

  I get an Ole db error while trying to create maintenance plans: An ole db error ox80004005( unable to create client connection)occurred while enumerating packeges. If I make the the sql startup account a local admin, everything works fine. I have checked to see according to the kb article to see that the account has all the necessary windows permissions and the account does have all the necessary rights. Thanks in advance for the help KRSE Have you tried creating that MP using another client's machine, I guess it could be a client tools problem/ Have you installed SP2 If not also note the post above " Maintenance Plan Changes in SQL Server 2005 SP2 " Make sure that you change the start ...Show All

• gf Error: unable to retrieve column information from the data source

  Hi, I am trying to set up a data flow task. The source is "SQL Command" which is a stored procedure. The proc has a few temp tables that it outputs the final resultset from. When I hit preview in the ole db source editor, I see the right output. When I select the "Columns" tab on the right, the "Available External Column List" is empty. Why don't the column names appear What is the work around to get the column mappings to work b/w source and destination in this scenario. In DTS previously, you could "fool" the package by first compiling the stored procedure with hardcoded column names and dummy values, creating and saving the package and finally changing the procedure back to the actual o ...Show All

• prtonemy Account lockout problem with sp_send_dbmail

  I am running this code in a job: EXEC msdb.[dbo].sp_send_dbmail @profile_name = 'Blah Blah', @recipients = 'blah@blah.com' , @subject = 'Server Report 1', @body = '', @execute_query_database = 'DBInfo', @query = 'EXEC dbo.usp_SvrRpt1;', @query_result_header = 0, @query_result_width = 300, --@attach_query_result_as_file = 1, @query_result_separator = ''; GO Because I am creating a total of 6 server reports, I alter the subject and query like so: @subject = 'Server Report X' --where X is replaced with values 1 to 6 @query = 'EXEC dbo.usp_SvrRptX' --where X is replaced with values 1 to 6 I can run 4 reports without any problems. If I run more than 4 reports in the same batch, my network account under Windows 2000 Activity Direc ...Show All