Answer Questions

• Tigers21 De-install and re-install problems SQL server 2005

  I never installed previous beta versions on my computer before. But now I have some serious problem after an incomplete de-install and a re-install of SQL server 2005 express advanced. I hope anybody can help me to solve this. Because the first installation eas not succesfull I had to do an de-install. I have tried to unstall through start/control panel/ add-remove programms and even there not all programs were removed. And that caused the problem. After that I wanted to re-install again but an msi file was missing. So I did a de-install agian. Tried to re-install again but with a lot of errors. After looking at the library I found a program: Windows Install CleanUp. I installed it and that even gives an error for all programs installed ...Show All

• Philipp Lamp How to order measures in SSAS?

  Hello, I'm wondering if any of you was able to sort all measures (including calculated) alphabetically so it is displayed nicely in pivot table I'm able to sort them by partitions, but do not know how to sort all measures across partitions. Your help is appreciated. -Lawrence The DisplayFolder is a property of measure or calculated measure in SSAS. But since you use Excel 2003 - it won't help, because Excel 2003 doesn't respect DisplayFolder. I am puzzled now by your comment about grouping measures by "partitions", AFAIK, Excel 2003 doesn't group measures at all. Can you provide screenshot Yes. I am not quite sure how to create folder to bucket the measure groups, and the link ...Show All

• ComputerWhiz New SQL-NS 2005 Book

  Folks, I want to let everyone know that the 2005 update to my Notification Services book is now available for order. You can get it from http://www.amazon.com/gp/product/0672327791/ . This book has been completely updated for the 2005 release: - All source code examples are now designed to work with the 2005 programming model and tools - New chapters have been added to cover the new 2005 features (such as the NMO API, Hostable Execution Engine, and User-Defined Matching Logic) I hope you find this useful. As always, I appreciate receiving any feedback you may have. Thanks -shyam   For those who consider buying this book to prepare for their new project on SQL Server Notifica ...Show All

• learnerplates sqlexpress sa connection

  I am having the same problem described in the previous posts. Everything was working fine, then I got up one morning and everything was haywire. I am working on a web site and when I try to login in I get the error message Login failed for user 'SA' because the account is currently locked out . I went to my SQL Server and was able to log in using my windows authentication. 1. My Server was set up for Sql Server and Windows Authentication mode 2. Most of the database permissions for sa were gone. When I tried to adder use SA to any database role I got the error message Cannot use the special Principal SA (Sql Server Error message 15405) 3. I logged on to the server as SA and got the same results listed above. 4. I ...Show All

• winstonSmith SQL Server Installation

  Hi, I had been using Windows 2000 Server along with MS SQL Server 2000. But now I have formatted my computer and installed Microsoft Windows Server 2003 for Small Business Server Service Pack 1 . Since then, I am not able to install SQL Server 2000 in it. Please suggest which version of SQL Server should I install, and where to download it from. Is it possible to install SQL Server 2000 server module in Windows 2003, since it says only the client module of SQL Server 2000 can be loaded here. I dont want to install any express edition, i.e., MSDE. Please help. Thanx, Suman. Here is the OS/edition matrix for SQL 2000. I believe that SQL 2000 can be installed on Windows 2003 for SBS Premium (but not standard). Basically, client tools ...Show All

• project2n5e0o1 Bulk import data to SQL Mobile

  Hi!. Is there something like BCP utility in SQL CE I need to import (pereodicaly) large ammount of data to my CE database. When tested import on network this take a lot of time. That's why decided to send raw data in ASCII files (because of small size) and to import files to CE database. Certainly, it's not a problem to write those cli by myself, but it's interesting if someone already did this... Thanks, Sandr does SqlBulkCopy work with SQLEv There isn't a bulk import utility as you might think about BCP, but you do have a couple of options. 1. if the goal is to load a "starter" SQL CE database with schema and initial data, you can setup a si ...Show All

• cak89502 Error Output for SQL Server Destination

  I'm in the process of running some tests to determine which method is faster... I created a data flow task OleDB Source -> Data Conversion -> OleDb Destination. Error outputs from the OleDB destination is sent to a flat file destination. This works great. I'm importing millons of rows and found that using SQL Server Destination (local) is much faster than the OleDB Destination. However, I have not figured out how to output errors to a flat file destination like I did when using the OleDB destination. Is there any way to trap errors in a flat file when using a SQL Server Destination Thanks! NLC OK..I found the answer to my problem. Books online indicates that SQL Server destination do ...Show All

• Hussain Saffar Flat File to SQL Destination - Unused Columns Warning

  I have a flat file data source and SQL Server destination data flow. Only a subset of columns from the source are mapped to the destination. During execution SSIS returns DTS pipline warnings for every unmapped source column. Is some kind of transformation the only way to get rid of these warnings Also this data flow subsequently returns an error: [SQL Server Destination [1293]] Error: An OLE DB error has occurred. Error code: 0x80040E14. An OLE DB record is available. Source: "Microsoft SQL Native Client" Hresult: 0x80040E14 Description: "Could not bulk load because SSIS file mapping object 'Global\DTSQLIMPORT ' could not be opened. Operating system error code 2(The system cannot find the file specified.). Make sur ...Show All

• rmccullough Can't connect to sql server 2005 database using vb 2005 express

  I've used Sql Server 2000 and Visual Studio 2003 for a few years. I've started a new position and they have access to Sql Server 2005 Standard and Visual Basic 2005 Express which I'd like to use for a new project. So I installed Sql Server 2005 and then VB 2005 Express on my workstation. I didn't choose the Sql Server option for VB Express because I already had Sql Server 2005 Standard installed with a simple database created. I created a simple vb project that justs connects to the database but I get the following error. Request for the permission of type 'System.Data.SqlClient.SqlClientPermission, System.Data, Version=2.0000, Culture=neutral, PublicKeyToken=b77a5c561934e089' failed. I looked at permissions in the database and it ...Show All

• DrDeath Import MSSQL Tables

  Is there a way in SQL 2005 Express Edition to import/export data from another MSSQL Server Something similar to the right click/ import table functionality of MSSQL2000. I've read similar threads which all recommend using MS Access but there has to be a better way, right regards, dj Hi DJ, SQL Express, and Management Studio Express, don't include the Import/Export wizard because that wizard is dependent on SSIS, a component that is not part of SQL Express. There are a number of different ways to accomplish this depending upon your need including Access. Since you are going from SQL to SQL, I would recomend the following: Script out the table from your source database and then use the script to create the same tab ...Show All

• rtaiss Microsoft SQL Sever management Studio: Failed to open connection dialog

  Does anyone encount the following problem before When I tried to connect to Microsoft SQL server 2005 with MS SQL Server Management Studio, I received: "Failed to open connection dialog" message with additional information is "Package 'Mircrosoft SQL Server Object Explorer' failed to load. This's just happened recently. Although I am receiving that message, I still able access into database with different types of connection. Can someone shred some light Thanks Tommy. This looks like some of your .NET components have corrupted. Reinstalling the same should help. Thanks, Kuntal Good morning ( or afternoon for me ) Goo and helpful ...Show All

• Seapoppy Is there any reportviewer control available between VS2003 and RS2005

  I was using reportviewer control before when i had RS2000, Now i removed RS 2000 and installed RS 2005 and trying to use the same Reportviewer control via VS 2003 and RS 2005. I am getting error saying unable to load assembly tried multiple times still get the same error. Please does anyone know of any reportviewer control which can be used between VS 2003 and RS 2005. Please please help, any information is greatly appreciated that will save me lot of headache i have been trying almost since 15 days on this. with no success. Thank you very much for your help. ...Show All

• nikki01 Generate Scripts option in SQL 2005 Management Studio

  Did anyone even bother to test the Generate Scripts option for a database I changed the following options from their default setting: "Include Descriptive Headers" = True "Include if NOT EXISTS" = True "Script for Server Version" = SQL Server 2000 "Script Indexes" = True and scripted all Stored Procedures, Tables, User-defined functions, and Views Problems: 1.  Generates IF NOT EXISTS (SELECT * FROM sys.objects ... should be ...SELECT * FROM dbo.sysobjects ... 2. Generates WITH (IGNORE_DUP_KEY = OFF) ... on the indexes. That portion is incompatible with SQL 2000 3.Generates EXEC sys.sp_addextendedproperty ... should be EXEC dbo.sp_addextendedproperty ... Is there a hotfix or patch to deal with these issues ...Show All

• Pablo Jord Subscription To Address

  Is there a way to have when a user creates a subscription, using NT Authentication, to allow the user to edit the To field or have it default to a certain @<domain> We have a test environment, but it is not the same as production, so when they subscribe they only see their NT account and when the report is attempted to be delivered it fails. I can go in as an Admin and change the subscription, but would rather not to have to do that. Seems like a simple configuration change somewhere, I just have not been able to find it. This did make it available for the user to enter their email address in. Thanks. The only danger in allowing a user to enter their own ...Show All

• rcook349 How and where should I create a mdf file if I installed a sql server 2005(Developer EditioN)

  hi: I am a newbie to sql server 2005 ( developer edition ). Now I installed both sql server and VS 2005 professional edition on my machine. I just what to know how and where should I create a mdf file on my server or .net window project because I try to combine to it from a window application. Should I use the sql server management studio or the Visual Studio 2005 What is the generate steps to create one I am completely confused. Please help me, I cannot find related on line source. Thank you, thank you bigheadjj Even if VS 2005 can connect to the server and create database files, I recommend that you use the SQL Server client tools (SSMS, sqlcmd, etc.) This gives you a good u ...Show All