MS SQL installation error

SQL Server Setup & Upgrade

Index ‹ SQL Server

- Previous
  - 1
    - Possible to render direct to PDF instead of viewing the report on a webpage? Will check that out in the beginning of the next week. Thanks!!! Tag: MS SQL installation error
  - 2
    - how can i get such a result set? sorry this may not help because as i said before, i don't know how many phone columns would appear, so if one customer has 6000 phone no., then does that mean i hv to select Customer_name, [1] as Customer_phone1, [2] as Customer_phone2, [3] as Customer_phone3, . . . . . [6000] as Customer_phone 6000 that ain't work i think, but thanks a lot buddy Tag: MS SQL installation error
  - 3
    - Custom Object in SSIS I also need the same. My code is in C# and that could not be converted in VB.NET. Did you find any way to invoke C# class Please let me know also If you find any solution. Thanks, Pooja Tag: MS SQL installation error
  - 4
    - Index Fragmenation Yes it is a clustered index. I thought the problem with GUIDs in general is that they are pseudo-random. That is why I went to the newsequentialid() function that generates sequential guids across a machine. Tag: MS SQL installation error
  - 5
    - Error When Open Analysis Services From Management Studio Dear Edward, Thanks for your reply. I have installed SP1 + Hotfix so the version of SSAS is 2153. Is it recommended to installed SP2 on Production server yet Thanks. Tag: MS SQL installation error
  - 6
    - mobile phone and databases Can you please tell me what are the risks of customers using a mobile phone to send a request of information which will be automatically responded to as an entry is made into the database. How do I ensure that the data intergrity is maintained, as this 'Table' in the database will take in many request a day and repond based on what the customer has type in on the text message. Tag: MS SQL installation error
  - 7
    - Howto get the result from two columns? Clearly, the stored procedure is not giving you all the columns to fill into @TIME, check that first. My guess is you are missing the ID Column, since it is generated automatically. You need to do 2 things to fix this: Change your table definition to include ID as Identity, so that it is generated automatically DECLARE @TIME table ( ID int Identity(1,1) , REP_TIME int , GO datetime , MYVALUES datetime , START_TIME int , MYTESTVALUE tinyint ) Tag: MS SQL installation error
  - 8
    - Change Flat File Source Dynamically Matthew, Thank you! I knew that should be possible, but, I couldn't figure out how. Based on your hint (expression) I was able to find the expressions section on my Connection's properties pane. I added an expression the ConnectionString (path) to a variable. It works! One small oddity... I wanted to set the variable in a Script Component for testing (rather than command line). However, I couldn't set the Script Component as the first object on my Data Flow since the Flat File Source object will not take a predecessor. Instead I created another Data Flow, made my main one dependent on that, and then added a "Source" Script Component to the new Data Flow... then I populated the new variable in that Script Component. Thanks, Chris Tag: MS SQL installation error
  - 9
    - How to check multiple records with one query Which version of SS are you using 2000 - openxml 2005 - openxml or value() method OPENXML (Transact-SQL) http://msdn2.microsoft.com/en-us/library/ms186918.aspx value() Method (xml Data Type) http://msdn2.microsoft.com/en-us/library/ms178030.aspx Example: Code Snippet use tempdb go create table dbo . sizeCombination ( sizeCombId int , sizeId int , [size] varchar ( 10 ), pieces int ) go declare @x xml set @x = N ' <e size="S" pieces="1" sizeId="1" sizeCombId="1"/> <e size="M" pieces="3" sizeId="2" sizeCombId="1"/> <e size="L" pieces="3" sizeId="3" sizeCombId="1"/> <e size="XL" pieces="1" sizeId="4" sizeCombId="1"/> ' insert into dbo . sizeCombination ( sizeCombId , sizeId , [size] , pieces ) select t . c . value ( '@sizeCombId' , 'int' ), t . c . value ( '@sizeId' , 'int' ), t . c . value ( '@size' , 'varchar(10)' ), t . c . value ( '@pieces' , 'int' ) from @x . nodes ( '/e' ) t ( c ) where not exists ( select * from dbo . sizeCombination as sc where sc . sizeCombId = t . c . value ( '@sizeCombId' , 'int' ) and sc . sizeId = t . c . value ( '@sizeId' , 'int' ) ) select top 1 t . c . value ( '@sizeCombId' , 'int' ) from @x . nodes ( '/e' ) t ( c ) go select * from dbo . sizeCombination go drop table dbo . sizeCombination go AMB Tag: MS SQL installation error
  - 10
    - Cannot Deploy Report - Please Help What is the value for "Server Mode" in the RS Config. tool's "Database Setup" tab thanx, Prash Tag: MS SQL installation error
  - 11
    - Query Performance - SQL Server 2005 post back the table script and the query ... You might want to create covering index. Madhu Tag: MS SQL installation error
  - 12
    - Analysis Services Performance We have an Analysis Services server that freezes from time to time (processor is sometimes very high, memory is high, and then we can not even stop the service - as if it went in an infinite loop). I would like to know whether the following configuration overloads the service or not: 4Gb of RAM SQL Server and Analysis Services installed on the machine SQL Server limited to 1Gb of RAM Analysis Services stay below 1.5Gb Analysis services takes the rest We have 102 cubes, some of them up to 100Mb Apriori, is that configuration overloading the processor, or the problem is somewhere else Tag: MS SQL installation error
  - 13
    - 70-431 (MCTS - SQL 2005) What is the passing mark/percentage for MCTS Tag: MS SQL installation error
  - 14
    - How do I not show a field if the field contains nothing? what does the IS NOTHING code translate to does it mean if the field is blank if i just use the IS NOTHING code alone without the OR...="", then it works perfect, but should I be concened about not have the OR or second condition in there will the IS NOTHING be enough thanks for helping! it's working so far, i'm just wondering about future confrontations with this. thanks! Tag: MS SQL installation error
  - 15
    - Remote Connections using SQL Server 2005 Developers Enterprise Edition Hi Hemantgiri, Thank you for your reply. I have reviewed the links that you recommended. I have completed most of the steps recommended. I am using a different firewall than Windows, and I will have to contact ZoneAlarm to receive more information about adding exceptions for SQL Server and SQL Server Browser. Usually, ZoneAlarm notify me to allow certain transactions to occur on my machine. I will ask the technical service people at ZoneAlarm why ZoneAlarm firewall was not informing me that it was blocking a remote connection to SQL Server from this machine. When I receive my requested information from ZoneAlarm and apply it to my firewall, I will let you know what happen next. Tag: MS SQL installation error
  - 16
    - Non-queried Parameters Thanks for the response. I have verified that the data is a string and when I put in the value as you suggested or many other variations I have tried, it will run but will return a "0" match but I know that there should be a match. If you only enter one value it will return results. Here is my parameter: WHERE location_type IN (@Type) Then in the report parameter dialog box I select "Non-Queried" Label Value Mail Order 001 Pharmacy 001, 002, 003 (will work if I only place one value) This will return results for "Mail Order" but returns "0" for Pharmacy. I figure it's just as simple as a syntax issue but so far I cannot find any examples of this. Tag: MS SQL installation error
- Next
  - 1
    - Display DB Table in ASP hello forum friends, i need to display the database table in ASP page.how it is possible,can anyone explain me with code. Regards Prathap Tag: MS SQL installation error
  - 2
    - SSIS Capacity Hi, Thanks for your response. It is very useful. We cannot use Bulk insert because it involves data cleaning and this need to be done every month. So, We are planning to develope SSIS package to do this. My concern is whether SSIS can handle 100 GB data. or Will it fail due to the file size Once again Thanks, Regards Pandi Tag: MS SQL installation error
  - 3
    - Transaction log file disappearing without reason yeah, my thoughts exactly, but it's a standard SBS2003R2 running a SQL express... No other software is running on this machine, even not backup since ntbackup is being used... The drive is not shared (lol)... the database is around 1GB, free disk space is +- 65G, I'm not seeing error 9002 (full disk)... to be honest, I don't have a clue anymore.... Thanks Didier Tag: MS SQL installation error
  - 4
    - Stored Proc NOT using Index? Hello, I agree with richbrownesq. I had a similar issue. If the query is a critical/important one, try using an index hint . This would help in executing within desired time. Regards.... Tag: MS SQL installation error
  - 5
    - Sample code to importing data from ODBC Yes, I am. The number of tables in ODBC source will change at any time. So I'd like to build SSIS package programatically using SSIS API. So what I want to do is to check to see if a table in ODBC source existing in SQL2005 first, if not, create a table first with same table name, schema... and then pump data. Thank you. Tag: MS SQL installation error
  - 6
    - Add column with fixed number of values (text) to the select statement What is the version you are using... (2000/2005) Give some sample data & required output.. Tag: MS SQL installation error
  - 7
    - SQL 2005 - Migration from SQL2000 / LEFT OUTER JOIN Hi, Yes, I did. I run Code Snippet sp_updatestats and also Code Snippet USE xxx GO update statistics dbo . Firma_adresse_FAD with fullscan , all; update statistics dbo . Katalog_einfach_KTE with fullscan , all; update statistics dbo . Interessent_INT with fullscan , all; GO The query takes about 2 seconds on the sql2000 and 6 minutes on the sql2005! Firma_adress_partner is a (complicated) view, which depends on other views over a few levels; within this views some "subviews" are used more than one time. I assume it depends on the optimizer of sql2005. Since the company, which has developed this application, does not exists anymore, I have inherited this ingrate project.... Does anybody know if there is perhaps any possibility to tell the optimizer to exeute it in the same way sql2000 does I would be glad to solve this without rewriting the query... Thanks to all! Sascha Tag: MS SQL installation error
  - 8
    - Editing Input Data in Script Component And why are you inserting an empty string rather than NULL -Jamie Tag: MS SQL installation error
  - 9
    - SQL Server Management Studio Express won't open but appears in task-bar When I first installed SQL Server Management Studio Express everything worked great The next day, when I try to open SQL Server Management Studio Express I get the Startup Screen then all that happens is SQL Server Management Studio Express appears in the taskbar but no window appears I think my problem has something to do with a SQL related product crashing one time when I shut down my computer Does anyone know a solution to this problem Tag: MS SQL installation error
  - 10
    - Pass parameter to SSIS Thank you. This makes conceptual sense, but I am unfamiliar with dtexec. Does the app have to shell to the OS to run this Do you have an example Tag: MS SQL installation error
  - 11
    - SQL Server 2005 Express Edition Is SQL Server 2005 Express Edition, compatable with Visual Basic 2008 Express Edition Tag: MS SQL installation error
  - 12
    - Upgrading SQL Express: is it possible to restrict to which version upgrade is possible? I don't believe this is possible either. You may want to ask this question on the setup forum for a last opinion, but I'm like 97.89% sure of this answer. Mike Tag: MS SQL installation error
  - 13
    - Partitioned Tables and Parameters Hi Jag, thanks for the reply, though I don��t see how or why a clustered index is going to solve this issue, seeing its an issue with the optimizer not performing the correct partition selection, and also because the clustered index is actually several clustered indexes, one per partition. Granted the clustered index will order the pages by the key, which I assume the partition function has are ready taken care of that. Thanks Eric Tag: MS SQL installation error
  - 14
    - Granting Permissions using SQL 2005 Schema... CONTROL should cover ALTER and DELETE. My guess is that the users from that group have been denied some permission that is affecting their DELET statements. You can make use of fn_my_permissions and has_perm_by_name to find out the actual permissions on the object, for example: -- Connected as/impersonating a member of Sandbox users -- SELECT * FROM fn_my_permissions ( 'Sandbox' , 'schema' ) go SELECT has_perms_by_name ( 'Sandbox.SampleTable' , 'object' , 'DELETE' ) go I hope this information helps, -Raul Garcia SDE/T SQL Server Engine Tag: MS SQL installation error
  - 15
    - replication folder's didn't locate local publications,need help! Hi Narasimha, Thank you for your reply. By the way, i have installed MS SQL Server 2005. I have uninstalled and re-installed it many times and this time,i got another problem beside the problem as above.When I opened MS SQL Server 2005 with Database Engine Server Type and I was facing a problem where is the connection failed to connect to my server. However, when I opened MS SQL Server 2005 with SQL Server Mobile Server Type,it connected and under Object Explorer, it showed the subscription folder under the replication folder and it didn't show the publication folder under the replication folder. What should i need to do Do you have any suggestion Tag: MS SQL installation error
  - 16
    - Returning a value that has the smallest number of instances in a table Above should not sort DESC but just normally. Else you get the one with the highest workload. Tag: MS SQL installation error

Variar

We are trying to install the SQL Server 2005 Enterprise 32Bit Edition in a clustered environment and keep receiveing the following error during the install:

The installer has encountered an unexpected error. The error code is 2878. On the dialog ClusterGroupDlg the control DataPath has a possible value : y:\Microsoft SQL Server\. This is an invalid or duplicate value.

Top

Re: MS SQL installation error

LateNightDBA

Was there a work-a-round for this I have found only two references to this error, both without resolution :-(

Currently getting same error on Windows 2003 64Bit - SQL2005 install also on cluster...

Regards

Rod

Top