Answer Questions

• Rajnesh Failover Cluster Option Grayed Out

  I have a mystery that I need a little help with.  I am trying to install SQL Server 2005 Std Ed. into a two node failover cluster running on top of Windows Server 2003 Enterprise Ed..   I have the cluster up and running.  It consists of an IP address, cluster name, a shared drive (E:), and an MSDTC resource.   When I run the SQL Server 2005 setup, the failover cluster option is always grayed out.  I have tried installing from the active node and from the cluster virtual server.  The result is always the same, no option to install a failover cluster.   Some suggestions would be appreciated.  I have read all the online docs I could find related to SQL 2005 failover clusters and found no ...Show All

• cmazur How to find filegroups for a given Table and Table's indexes

  Hi I am using SQL Server 2005 Developer Edition. I want a list of the following things from the database: - Table Name , FileGroup Table resides on Table Name, Index Name, FileGroup index resides on To put it simply, consider the following example:- Lets say I have a table XYZ in my database created on Filegroup F1. It has a PK PK1 nonclustered index on Filegroup F2. List1 ------- XYZ        F1   List2 --------- XYZ          PK1         F2   Please do not tell me of sp_help <table> option Regards Imtiaz   For the ...Show All

• Emy_P Enterprise Manager in version 2000

  Typically when I bring up Enterprise Mgr, I get the options to look at the databases, tables, etc. Now, when I choose EM, it brings up the Microsoft Management Console without anything in it except 'Console', 'Window', and 'Help'. When I open a new window, I can see the databases etc. but the top of the window says 'SQL Server Enterprise Manager [2:Console Root\Microsoft SQL Servers]' and a few of the icons are grayed out like 'New Database', 'New Login', and 'New Job'. I haven't changed anything that I know of. Please Help! thx Kat A reinstallation of SQL Server solved the problem. I think it came up because I'm working on an old laptop while my newer one is getting fixed. Not much space, memory, and it is slow. Oh, the joy ...Show All

• axl Which Visual Studio .NET Version?

  Hello, we want to introduce Reporting Services 2000 in the next few months. Basically, 2 - 4 interns will work with it at the same time. Which version of Visual Studio .NET is recommended for such an environment I do not have ANY experience with Visual Studio .NET, so excuse if this is a dumb question ;) Thanks, Michael If you just want to design some reports in SQL 2k, you will just need a one language VS edition, which you will get for about 100$ per client. For viewing reports you just need an IE and a SQL Server CAL or a processor license. HTH, Jens Suessmeyer. --- http://www.sqlserver2005.de --- For Reporting Services 2000, you will need to use Visual ...Show All

• Toni Greco Configuration files do not work in CmdExec mode

  I have created an Integration Services package on my development machine. The package contains a configuration file witch let's say is stored in c:\projects\MyIntegrationServicesProject\myConfigfile.dtsConfig (on my dev machine). Then I have another "Production" machine where I import the SSIS package into an SQL database. I then create an sql-job with only one step, to run my SSIS package. This works fine if I configure the step to be an "SQL Integration services package" and configure it to use my configurationfile. However I would like to configure this package as a CmdExec step. In the commandline, I specify /CONFIGFILE "d:\....\myConfigfile.dtsConfig" (the correct path on the prod machine). But it s ...Show All

• renyx Email Report in Outlook 2007 not the same as Outlook 2003

  I have a Reporting Services 2005 report that is emailed to users.  I created/formatted  the report based on how it looked in Outlook 2003 which all of our users had at that time.  The report is wide, but just fit in the email window when it was full size.   Now I have a user who has been converted to Outlook 2007 and he emailed me a copy of the report he received in Outlook 2007 and it looks like it reduced the column sizes; it does not fill the entire email window and wraps the wording on most lines because the column sizes have been reduced.  The report is: Delivered by: Report Server E-mail Include Report is checked Render Format is Web archive Any ideas on how I can fix this ...Show All

• PhilthyPhil processing cube not pumping data

  I am trying to process a cube on a fact query that should return about 600M rows. When I run the processing, all Dimensions are processed successfully, and it starts processing the Facts, but no row count is shown indicating that it does not actually start streaming the data to Analysis Services. It has been running for 30 minutes and no count of processed rows has appeared. When I double-click the query and open the query in SQL Server Management studio it runs fine. Also I tried it with set rowcount 100000 and it starts streaming data to query output right away and gets to 100000 rows within a minute or so. So the query seems optimized and returns the data quickly. Also tempdb seems to be growing slowly. Does Analysis ...Show All

• Raulsassaa .Net 2003 access Crystal Report XI: Error:Failed to open the connection: [Database Vendor Code: 17 ]

  I am receving this error: Failed to open the connection: [Database Vendor Code: 17 ], from .Net 2003/C# to Crystal Report XI with SQL Server 2000 has backend database. Is there a security permission that has been overlooked Here is the code I use to access CR XI ConnectionInfo connectionInfo = new ConnectionInfo(); TableLogOnInfo tableLogOnInfo; Database DB; 'CrystalDecisions.CrystalReports.Engine.Table' table; Tables tables; //Log in connectionInfo.ServerName = "ServerName"; connectionInfo.DatabaseName = "Database Namet"; connectionInfo.UserID = "userid"; connectionInfo.Password = "password"; //Get Table inf from report D ...Show All

• r3n Bulk load from Access to SQL 2003

  I am trying to configure a bulk table upload from a 2003 Access table to a matching table in SQL with SSIS. I can configure the source file but am unable to configure the destination. When I configure the SQL source and use SQL Native Client I get an error message of: The selected connection manager uses an earlier version of a SQL server provider. Bulk insert requires a connection that uses a SQL server 2005 provider. When I go through the new connection setup I don't see any available provider named like that. I believe the SQL server I am loading to is a 2003 version. try using the ole db destination. it uses bulk loading by design. Thanks, that seemed to work to pull the table up. Pushing ...Show All

• WineNCheese Error by converting string to decimal

  Hi, I'm trying to import a text-file into SQL2005 by using SSIS. Unfortunately it doesn't seem to work in the way I thought. Because I'm using the german version of SQL2005 I need to translate the items of my toolbox, so dont wonder if their names are not exactly the same as in the english versions. Try number1: a) My datasource is a flatfile, in the connection manager I changed the DataType for the input column to DT_DECIMAL. In my destination table the data type of ths column is decimal(20,4). Name of the column is "NXT_PUT_PX". b) Running this package results in this error: "Fehler bei der Datenkonvertierung. Die Datenkonvertierung fur die NXT_PUT_PX-Spalte gab den Statuswert '2' und den Statustext 'Der Wer ...Show All

• Banacek Dynamic Logging Properties in MS SQL DTS packages

  Since I can't seem tofind the Microsoft SQL 2000 forum, I will post this here: I currently have logging enable on several of my packages. However, we are still in development of our packages and are reaching upwards of 100 and logging will eventually need to be active on all of them. In production, there will still be a development server and a production server, both with different server names and user id/pwd. I am looking for a way to dynamically change the logon information for the logging so that we do not have to have someone go through and manually change the options. I have tried using Dynamic Properties Task, but this only works on the 2nd run of the package. ----- As a second question: can anyone explai ...Show All

• Sinno How do I do an Unattended install of "MSDE 1.0 sp4"?

  I am trying to upgrade an MSDE 1.0 db with the Service Pack 4 patch but I need to do either a Silent or Unattended install. Does anyone know how to do this Does anyone know the command-line command to do this I tried using... sql70sp4.exe -a -f1 "unattend.iss" ....but that didn't work. It popped up a window asking where I should extract the contents of the .exe (that shouldn't be appearing either) and then after it extracted it didn't do anything else. Any help is greatly appreciated. see if this helps http://support.microsoft.com/default.aspx scid=KB;EN-US;q233312 ...Show All

• Joe Albahari Restarting OLAP Service fails / ultraslow

  Hi, since about 2 weeks I have a problem with the MSSQLServerOLAPService Service. When I try to restart it, the following happens: till about 50% of restarting, it goes smooth... but after that, it goes very very slow... finally generating the following error: "Could not start the MSSQLServerOLAPService service on Local Computer. Error 1053: The service did not respond to the start or control request in a timely fashion." I have to click OK then. The service list shows me that MSSQLServerOLAPService service is "Starting". After about 3 to 5 minutes, it says "Started" and then I can use the Analysis Manager again. During restart I can see the following processes eat memory and they keep the memory allocated ever after. msm ...Show All

• Gerry2007 Enlarge the database size??

  I have a database that seem run out of space I click my database properties and show this info Size:139,19 MB Space Available: 0,00MB maybe thats why I cant input new data on my table, but when I do this EXEC sp_spaceused 'MyTable', I got this info rows: 74 reserved: 112 KB data 32 KB index_size: 24 KB unused: 56 KB And this is why i confuse, if I run out of space why my database have 0,00 MB but MyTable have unused 56 KB how to enlarge the database size thx Table don’t shrink themselves. Data pages will be rserved in advanced for additional data in the meaning that the data will grow for a specific value to hold the new data. if you delete data, the data page will ...Show All

• Roman Benko. IMPORTANT: "Unexpected Error occured" When trying to view calculations tab

  Hi. When trying to view the calculations tab (of any cube, including the samples that comes with SQL Server 2005) in Visual Studio (BI Development Studio) I get the following error text in the rigth pane: Unexpected error occured: 'Error in application.' I'm using SQL Server 2005 SP1 and Visual Studio Team Edition (and Office 2007 Beta 2 refresh). I tried also installing the hotfix pckage (dated to September 2006) but the error is still here. Tried to create a few new projects, cubes, etc... nothing helps. No error is logged in the event viewer. Thanks, this works for me too. I've just copied the most recent version (from Ole DB folder) to other locations. Office 2007 compatibility p ...Show All