Answer Questions

• laboremus connecting to SQL Server 2000 database using SQL server 2005 JDBC driver and Tomcat 5.5.17

  Hi there: I am trying to connect to SQL Server 2000 database using SQL Server 2005 JDBC driver. I have set the classpath for the driver as C:\Program Files\SQL Server 2005 JDBC Driver\sqljdbc_1.0\enu\sqljdbc.jar and I copied sqljdbc.jar file in the lib directory of WEB-INF. I have a login.jsp page that asks for user name and password to log on... when you click submit... it doesn't go anywhere... and I checked the tomcat server console... doesn't give me any error. The url and driver I used inside login.jsp page looks like this... url = "jdbc:microsoft:sqlserver://localhost:1433"; driver = "com.microsoft.sqlserver.jdbc.SQLServerDriver" dbUsername = "xxx"; dbPassword = "YYY"; ...Show All

• Helen Cool Granny Installing 2005 or not . . .

  Hi, What is the installer checking for when it determines that components have been found on the machine If it is the Registry, what keys does it use Cheers The easiest would be to do an install and see what happens. Go to www.sysinternals.com and look around, there's lots of utilities there that could help you figure what's happening on your machine when software is being installed, files read, registry modified etc. /Kenneth ...Show All

• pugs manual way to rename instance of analysis server?

  is there a way to manually rename my instance of analysis server 2005 i have a 32bit machine, and the 32bit version of sql server 2005 and analysis server 2005 installed, yet i continually get an error. this happens on my servers too, which are all 32 bit. does anyone know of a manual work around ( via regestry maby) to rename an instance Yes, there is a way to rename the instance. Search for ASInstanceRename.exe program under %Program Files%\Microsoft SQL Server. But, as Darren has suggested, you might want to not do it right away because it might not fix your problem and make things even worse since it is unknown what is causing your current problem. The utility operates on registry, service control ma ...Show All

• Mitch Wardrop insert only time in sql server

  hello, i have prob in inserting the time values in sql server. i want to insert only time in sql server database. plz help me how to do it reply me.it's argent. Regards, Shruti. hi, you can not... SQL Server does not provide just the "time" data type, but the "whole package", datetime (or smalldatetime)... if you not set the date protion, "19000101" will be set, where 00:00:00 (midnight) will be set if you omit the time part.. regards ...Show All

• Jessie Zhao Attaching a db - missing log (ldf)

  Hello, I'm trying to re-attach sqlserver 2005 db. I have the mdf file but I don't have the log file. When I try to attach, I get the appended error. Is there anyway, around this Thanks Houman TITLE: Microsoft SQL Server Management Studio ------------------------------ Attach database failed for Server 'SERVER'. (Microsoft.SqlServer.Smo) For help, click: http://go.microsoft.com/fwlink ProdName=Microsoft+SQL+Server&ProdVer=9.00.1399.00&EvtSrc=Microsoft.SqlServer.Management.Smo.ExceptionTemplates.FailedOperationExceptionText&EvtID=Attach+database+Server&LinkId=20476 ------------------------------ ADDITIONAL INFORMATION: An exception occurred while executing a Transact-SQL statement or batch. (Mic ...Show All

• Krenshau VB on SQL Server 2005

  hi everyone. i am asking for help. i am a programmer using vb 6 and used to SQL server 2000. i have this new job now and they are using SQL server 2005 and my normal ActiveX connection on SQL 2000 dont work on the SQL 2005. what can i do to check this. thanks a lot in advance to anybody who will give me help. good day. gstServerName = txtServerName.Text gstDatabaseName = txtDatabaseName.Text stDriver = GetIniSetting("DSN", "Driver", "SQL SERVER") gstConnStr = "driver={" & stDriver & "};server=" & gstServerName & ";database=" & gstDatabaseName & "; UID=bmpci; PWD=bmpci" If gcnBMPCI.State = adStateOpen Then gcnBMPCI.C ...Show All

• Kamen SSIS Scripttasks, Vista and SP2

  Hi, does anyone know, if with SQL 2005 SP2 Scripttasks will run under Vista thanks, Thomas yes it works with SP2 installed on vista. Regards, Navaneethan Hi Thomas, Script tasks will run in SP2 with Vista, but it requires an additional hotfix to be installed. You can see the details in this KB article: FIX: Custom applications that use the Visual Studio for Applications Visual Basic Runtime may be unable to compile macros or to run macros Thanks, ~Matt Yes it seems to run - but debugging is not possible with BIDS. If I set a breakpoint, the task turns red with the message: Error 0x5 by "Taskname" Error loading scriptdata Sorry, the message may be not exact because my BIDS ...Show All

• eduar_hte microsoft decision tree algorithm

  I have read some sources about microsoft decision tree algorithm like in claude seidman book, paper about scalable classification over sql databases and paper about learning bayesian network. But i still don't understand and i still didn't get the point on how microsoft decision tree algorithm works exactly when splitting an atribut. Because i have read that microsoft decision tree using Bayesian score to split criteria is it true Well, anyone could help me to understand about microsoft decision tree algorithm, please give me details explanation with some example(cases). thanks for anyone help Hi, there, the first link fails, i am also interested to know how Microsoft Decision Trees splits a continous attribute for deri ...Show All

• Ofir Epstein Importing Data from Oracle 8i/9i to SQL Server 2005 using SQL Server Import and Export Wizard (AKA DTS Wizard)

  Hi All, I have become frustrated and I am not finding the answers I expect. Here's the gist, we support both Oracle and SQL for our product and we would like to migrate our Clients who are willing/requesting to go from Oracle to SQL. Seems easy enough. So, I create a Database in SQL 2005, right click and select "Import Data", Source is Microsoft OLE DB Provider for Oracle and I setup my connection. so far so good. I create my Destination for SQL Native Client to the Database that I plan on importing into. Still good Next, I select "Copy data from one or more tables or views". I move on to the next screen and select all of the Objects from a Schema. These are Tables that only relate to our application or ...Show All

• WynApse help with inserting WMI query into SQL

  Hi, I'm a compleate noob and trying to learn c# and wmi. I have used WMI queries in vbscripts but I want to take things a bit further now and read a server name from a SQL db and query WMI (eg. disk space available) then record it back into SQL. I'm really struggling on how to do this. I written the code to query WMI (SELECT * FROM Win32_LogicalDisk) but referencing it to DB's is something I can't do! Can anyone help with this Hi, a simple program using SMO would be: Server s = new Server ( "." ); Database d = s.Databases[ "SomeDatabase" ]; Console .WriteLine(d.SpaceAvailable); Console .WriteLine(d.Size); Console .WriteLine(d.DataSpaceUsage); HTH, Jens ...Show All

• papercodes Importing Null Date Fields

  I'm using SQL Server Express and am trying to import a CVS file. The CVS file contains a string field (named DAS) that represents a Date. This field can be null. I've tried using the DTS Wizard to import this CVS file and convert the DAS field to a Date, which works great until it hits a record with a NULL DAS field. It then throws a convertion error. Still using the DTS Wizard, I've changed the DataType of the DAS field in the Source file to [DT_DATE], it works fine but all the null dates are converted to 12/30/1899. Is there a way (DTS Wizard or something else) that will allow me to import these CVS files with null Date fields and keep them as null in SQL Server table. Thanks for any help, Jon ...Show All

• amazingsunday ETL Package Problem

  I'm going through the Integration tutorial, Lesson 1: Creating a Simple ETL Package. Everything goes fine until I run the package. I get an error about inserting Null in the CurrencyKey field which is set to not null. The flat file looks okay. Any help would be appreciated. --------------------------------------------------------------------- SSIS package "Lesson 1.dtsx" starting. Information: 0x4004300A at Extract Sample Currency Data, DTS.Pipeline: Validation phase is beginning. Information: 0x4004300A at Extract Sample Currency Data, DTS.Pipeline: Validation phase is beginning. Information: 0x40043006 at Extract Sample Currency Data, DTS.Pipeline: Prepare for Execute phase is beginning. Information: 0x40043007 at Extract S ...Show All

• LuckyL Copy cube from a DB to another one

  Hi, I would like to copy a cube and its content from a database to another one. The first database is the one used for production and the second will be used to archive the old cubes. Is there a specific way to deal with this kind of issue Thanks in advance for your support. Rgds, Juan Hello! You have not told about what version you are using, AS2000 or SSAS2005 With SSAS2005 you simply change this is the properties of the project and deployment. This is in the solution explorer of BI-Developer Studio. In AS2000 you can use archive and restore from one machine to another as long as the data source name is the same. Regards Thomas Ivarsson ...Show All

• iliketoeaticecream After deploying a Business Intelligence project how to recreate the OLAP security

  During development the project is focus on schema and schema changes and test security. When I I deploy the database to production, I end getting the development security in the production database. How does one create a script that recreates the security in the production environment so that I can be reused it after the deployment. The synchronziation wizard is not appropriate since it moves data as well. You actually did what i meant. Performance is another story. In SQL Server Management Studio you can access Script related menu commands from the context menu. All management dialogs in that program also have Script button on the toolbar ...Show All

• eric02 Need help after creating SSIS project

  Hi, I have created SSIS project that imports .csv file into sql server 2005. SSIS package is saved successfully but now i want the table created in sql server 2005. So, how to get the imported data in sql server 2005. Can any1 help me out Thanx n Regards, Ruja :) Are your destination table field settings large enough to handle the data you are attempting to load Not seen the error message you refer to yet, however it sounds like you have a data mapping where data is going to be truncated due to insufficient field size in the destination table and that you have no data flow item to handle such an event. Take a look at the source data once it's been read from csv by attaching a data viewer to the gree ...Show All