Answer Questions

• Kris Nye SQLCMD does not work from commandline

  SQLCMD works in the Studio if SQLCMD Mode option is chosen. OSQL and SQLCMD does not work from commandline and produces this constant burnt in message. Sqlcmd:Error:Microsoft SQL Native Client:Login timeout expired. Cleint and Server have the same set of protocols Studio has been added to the list of those permitted by Firewall Tried to connect through tcp, lpc Remote has been enabled. SQLNativeClient does not have a property or method by name 'timeout'. Let me know if something else is needed It sounds like you've done the right things so far - start here and see if this helps: http://msdn2.microsoft.com/en-us/library/ms170207.aspx Hi: It sounds like your sqlcmd might have been ...Show All

• Tryst SQL Server Management Studio problem

  Hi, i got a problem for which a question has already been raised but closed without solution (or working solution). When i launch SQL Server Management Studio i receive 2 times a "Package ' Microsoft SQL Server Management Studio Package' failed to load. i've already resinstalled SQLTools90 but without any impact or event reapply sp2. Someone has an idea Hi, Have emptied your TEMP Directory before installation finished!!! Or their's not proper permission set for Temp Directory under Documents and Settings for your User Profile.... i found this error comes while permission is not properly set for Temp Direcoty for User . Hemantgiri S. Goswami Actually the problem lie ...Show All

• flandersit Why no stored procedures?

  We currently develop a large desktop application that uses Sql 2005 (standard edition). At present we use stored procedures extensively. Soon we will be starting a new project that will require offline functionality and again run on the desktop, so we are thinging of using Sql Everywhere. However, the thought of writing TSQL in code (c#) just seems a little uncomfortable at the moment. Why is there no stored prcedures in Sql Server Everywhere One of the great things about SP's is that you can make slight changes to your business rules without re-deploying your app. Thanks for your help Graham Then why not go for SQL Express Have a look at the discussion on why we did not add stored proced ...Show All

• tvcouch Insert Date values from SQL Server 2005 to ORacle 10g

  I am trying to insert records with a datetime field type from a SQL Server to an Oracle table using SSIS. Any suggestions to get it to work Do you get an error If so, I would use a more generic format like ISO Date to pump the data through SQL Server IS to Oracle. Look for the Convert method in the BOL and the the setting 112. HTH; Jens K. Suessmeyer. --- http://www.sqlserver2005.de --- ...Show All

• William Watts T-SQL Date Format question

  I have a small problem (creating big issues) in T-SQL. I have a sql query that gets some date data from SQL Server 2000 and displays the result in a grid. This grid is a custom sortable grid. The problem is that the result returned from the server is in American format and I want to display the dates in UK format. I tried using Convert but Convert seems to be converting dates into character strings and hence creates problems while sorting the grid. I tried finding other functions but could not find any. Mind you that this is just a sql query and hece cannot do something like SET DateFormat = some value. If you could guide me to the right direction and help me get rid of this problem then it would be really greatful. ...Show All

• helen369331 Web Synchronisation Using RMO

  hi every body please help me out on this issue , since i am at final stage in finishing up the module. Previously i had done web synchronisation using RMO it is working fine at my office where i have an 2003 server which is an domain controller , publisher i have configured on the 2003 server , and i had subscribers on xp Machines where it was well working fine, clients were not on the domain , it is an independent Machine. we had an security error which was resolve by this same forum, ie the client windows login id should exists on the server too. only then synchronisation is happening at our office, Now the problem is i have an same setup , but the server 2003 is hosted at a remote place , which is not an domain controller, n ...Show All

• monchhib Unhandled Exception

  After I installed Sql Sever 2005 and open SQL Server Management Studio, I get this error just after connecting to any server (DB / AS / IS).. Also, during the installationm, I had ignored an error that was raised while SSIS was being configured. The error said, that thr is already a 32 bit registry on the target Com + Application. You must remove the registry from that app. I have done the installation of SS2005 X64 edition. Attaching the exception :- See the end of this message for details on invoking just-in-time (JIT) debugging instead of this dialog box. ************** Exception Text ************** System.TypeLoadException: Method 'GetMenuItems' in type 'Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.Default ...Show All

• RANGERAZIZ Integrated Security doesn't work - "Not associated with a trusted SQL Server connection." Error

    Hi, I have a piece of Java code that needs to connect to SQL 2000 (SP4) using Windows Authentication. It's running on Windows Server 2003 SP1. I tried JDBC v1.1 and followed the code from the following blog: http://blogs.msdn.com/angelsb/default.aspx p=1 But still get this error as shown below. Any help appreciated. I am using JDK1.4.2, "sqljdbc_auth.dll" is located under "E:\SQL2005JDBCDrv\sqljdbc_1.1\enu\auth\x86", also made a copy under "E:\JavaTest" and "C:\Windows\System32" but still won't work. Cheers Allan   =========================================================== E:\JavaTest>javac -classpath ".;E:\JavaTest\sqljdbc.jar" TestW2.java E:\JavaTest>java -classpath ".;E:\JavaTest\sq ...Show All

• UncleZen negative values when calculating percentages

  I get negative values for percentage calculation in a MDX query. The MDX query has a crossjoin between two sets containing calculated members from the same dimension, one of the calculated members being a percentage value. I'm not sure why some of the percentage values are negative. Another problem I'm facing is that the percentage value is not being displayed as per the FORMAT_STRING property, in my Reports in Reporting Services 2005 that use the data generated by the MDX query. Any help or suggestion is appreciated. Hi. Can we see the MDX query you're using and a small data sample which provides the negative percentage PGoldy Hi. Thanks for the detailed query and example. I don't see ...Show All

• Jeff Levinson Replicate and Sync between Server 2k and 2k5

  Hi all. I want to do the following: I have a (quite big) sql server 2000 database. I'd like to replicate the whole DB onto a 2k5 server. Then disconnect that connection, to have an independent copy on the 2k5 machine. After I made some modifications on the data on that machine, I'd like to sync those databases to have the data on the sql server 2000 as well. Is this possible in any way (tool or API available) or must I hand code it At the moment I do this thing by exporting to *.sql files, and then importing, but the replication/sync method would be quite nice. Yours, Dave For this particular scenario, your best option is to use transactional replication with queued updatable subscriptions: SQL Server 20 ...Show All

• MrJP dataMining

  i create a model mining to know percent of product, which is like more by customer is have percent biger than other products that is don't like by customer. i use DTS to get result to sql server. select flattened predict([modelName].[tablePredict],Include_statistic) from [modelName] prediction join ..... i have result with a table A in sql server: productid $support ... $adjustedprobability 1 0.0 ... 1 0.0 ... 1 63.3 ..... how can i write in Dts so that table A not have record with value $support=0.0 - second: percent people like that product is knowned by $adjustedprobability or $support and value small or big ...Show All

• ŁukaszS How to know if SQL Server 2005 trial version is installed?

  When I ran @@version I get this: Microsoft SQL Server 2005 - 9.00.2047.00 (Intel X86) Apr 14 2006 01:12:25 Copyright (c) 1988-2005 Microsoft Corporation Standard Edition on Windows NT 5.2 (Build 3790: Service Pack 1) I assume this is a licensed version because the std edition does not have a trial license Can someone confirm this If this were a trial version, what could I expect to see Hi, here you are: http://support.microsoft.com/kb/914158/en-us HTH, Jens K. Suessmeyer. --- http://www.sqlserver2005.de --- Prior to expiration of the trial version, you can upgrade to the full version by using the SKUUPGRADE command-line parameter as documented at http://msdn2.microso ...Show All

• nordboh New partition using XMLA

  Hi, I have an existing cube containing a single partition. I am running the following xmla script to create a new partition : < Create xmlns = " http://schemas.microsoft.com/analysisservices/2003/engine " > < ParentObject > < DatabaseID > myDB_id </ DatabaseID > < CubeID > mycube_id </ CubeID > < MeasureGroupID > mymg_id </ MeasureGroupID > </ ParentObject > < ObjectDefinition > < Partition xmlns:xsd = " http://www.w3.org/2001/XMLSchema " xmlns:xsi = " http://www.w3.org/2001/XMLSchema-instance " > < ID > mypartition_M1 </ ID > < Name > mypartition_M1 </ Name > < Annotation ...Show All

• QWERTYtech SQL Server 2005 trial - which file to download?

  Hi all, I am extracting SQL server 2005 trial edition to my flash memory hard drive. Hence suppose I should download one of the following three files: " Self-extracting executables: X86 Executable X64 Executable IA64 Executable " But which one should I choose based on what criteria (This point seems clear to everyone but myself, even after I went through all the docs on the download site) Thanks, Jack (an absolute beginner) Follow the link I provided above, the one are directly linked to the download page and should start up a download right away. HTH, Jens Suessmeyer. --- http://www.sqlserver2005.de --- How d ...Show All

• Ben Vanik sql 2005 cluster setup fails

  am trying to install sql 2005 with cluster option in win 2003 R2 servers and keep getting sql database setup failed error.Summary log show that it failed with error number 67. It doesn't even create a SQLSetup0004_M2MTPONE_SQL.log file. core log shows Complete: DetectLocalBootstrapAction at: 2006/5/1 18:15:31, returned true Running: LaunchLocalBootstrapAction at: 2006/5/1 18:15:31 Error: Action "LaunchLocalBootstrapAction" threw an exception during execution. Error information reported during run: "C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\setup.exe" finished and returned: 67 Aborting queue processing as nested installer has completed Message pump returning: 67 We have two machines in running enterp ...Show All