Answer Questions

• JIM.H. Is it possible to generate alter Table statements using SMO

    Hi I'm trying to modify existing tables in a database. How can I create alter Table scripts using SMO/DMO Thank you Thanks Jens Got it. while comparing a table in one database to other table (identical) in other database, if the Source table has some modified(altered) columns and need to be modified in the target table. How to solve this problem.Any Idea. I generated the alter scripts manually for each column. Like ALTER TABLE [dbo] . [wo] ADD [requested-time] varchar ( 8 ) NULL Thank you Thanks alot Jens. I'll try for this You will have to do this manually. Load the two schemas and compare the columns (if you just want to check the colum ...Show All

• bryanedds Error with SP1 upgrade for reporting services

  Hi, I just tried to install SP1 for SQL 2005. All of the steps succeeded except for the upgrade for Reporting Services, which failed with the error "Unable to install Windows Installer MSP file". When I checked the log there were a whole host of errors such as "12/19/2006 09:06:41.031 Failed to read associated hotfix build information for the following file: C:\Program Files\Microsoft SQL Server\MSSQL.3\Reporting Services\ReportManager\Bin\ja\reportingserviceswebuserinterface.resources.dll" and "12/19/2006 09:06:41.203 Failed to read version information for the following file: C:\Program Files\Microsoft SQL Server\MSSQL.3\Reporting Services\ReportManager\es\help\f1_rsc_webui_standalone_5yr5.htm" ...Show All

• TDays Programatically create and configure a FlatFileConnectionManager

  I am writing some C# code that builds a package programatically. the package contains a flat file connection manager. I have referenced Microsoft.SqlServer.Dts.Runtime.Wrapper in order that I can use the ConnectionManagerFlatFileClass class. Here is some of my code: Package p = New package(); ConnectionManager sourceCM = p.Connections.Add("FLATFILE"); sourceCM.Name = "some-name"; ConnectionManagerFlatFileClass cmffc = sourceCM.InnerObject()   I get a compilation error on the last line saying I cannot implicitly cast as ConnectionManagerFlatFileClass . Fair enough, so I change the last line of code to: ConnectionManagerFlatFileClass cmffc = ( ConnectionManagerFlatFileClass )sourceCM.InnerObject() ...Show All

• stephanielauym Calling SSIS packages from ASP.NET - Packages with file system tasks end abruptly

  I've run into a problem with SSIS packages wherein tasks that write or copy files, or create or delete directories, quit execution without any hint of an error nor a failure message, when called from an ASP.NET 2.0 application running on any other machine than the one where the package was created from. By all indications it appeared to be an identity/permissions problem. Our application involves a separate web server and database server. Both have SQL Server 2005 installed, but the application server originally only had Integration services. The packages are file system-deployed on the application server, and are called using Microsoft.SqlServer.Dts.Runtime methods. For all packages that involve file system tasks, the above problem occurs ...Show All

• April m SQL Express connection problems

  Hello, I have installed Sql server express version and I am trying to connect to it using the following connection string "Data Source=localhost;Initial Catalog=PersistenceStore;Integrated Security=SSPI" I get the following error InnerException = {"An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: Named Pipes Provider,... I have changed the Sql Server settings to accept remote connections(use TCP/IP and named pipes) and I have also tried connecting using <machinename\SQLEXPRESS> and <.\SQLEXPRESS> as the datasource. ...Show All

• SnakeSV Is it possible to enable TCP/IP connection to SQL Server programmatically? Is there any function in SMO?

  Anyone know I'm making an installation package and I want my installation program (which is a custom action class inherited from Installer Class) to adjust the network configuration of SQL Server, for example enable TCP/IP. What can I do Is that any function in SMO package that can do this for me Hi, that is a registry setting, you have to switch the appropiate network protocol values in this section to get it working: HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\MSSQL.1\MSSQLServer\SuperSocketNetLib HTH, Jens Suessmeyer. --- http://www.sqlserver2005.de --- ...Show All

• Ather. Generating Reports From LoadTest Database

  Dear All, I have configured reproting services in Sql Server 2005. I have also created the LoadTest Database. I have seen Sean Lumley's Blog sample report also visited the link provided by him 'http://blogs.msdn.com/slumley/archive/2006/02/16/533356.aspx ' however i am not able to figure out what to do next with this link ,how togenerate report in the format as he has suggested from my load test store. Regards, Follow the link to gotdotnet, the report are downloadable from there and can be easily customized to your needs. HTH, Jens Suessmeyer. --- http://www.sqlserver2005.de --- ...Show All

• Orellang Package variables

  Couldn't quite find the answer I was looking for via a forum search. I have 9 packages that are currently called by a master package - all child packages take a datetim e variable from the master package which is subsequently used in the child processes. The question I have is that if I run the master package manually from Visual Studio I can set the master package variable manually to a date of my choosing and run it, which works fine. However we will be wishing to automate the package execution at some point and want to know the best way to run the package(s) on an automated basis and have the data variable supplied to the master package. What would be the best way to do this Presently we have a variable called MasterPackage ...Show All

• RenegadeMind SQL Server time zone?

  I don't know what is going on, here's the error message, could someone please answer thanks Server Error in '/' Application. might it be possible that it was corrupted when the db was corrupted I didn't change anything so don't know how it would be changed unless it became corrupted in someway. Is there a way to check on this In the comments of this blog page, there is a similar discussion: http://weblogs.asp.net/scottgu/archive/2006/01/09/434925.aspx Is it possible that you are using a different version of the db schema than the ASP.NET application code I don't have any experience with the ASP.NET 2.0 Membership and Role Management tool, but the explanation given by ScottGu sounds ...Show All

• Peter McEvoy SYNONYM Question

  Is it possible to create a SYNONYM that does not require you to use the owner prefix Similar to an Oracle PUBLIC synonym. for example: CREATE SYNONM MySynonym FOR dbo.myfunction. SELECT MySynonym FROM dbo.mytable; No. All objects are stored in schemas, even the synonyms. HTH; Jens K. Suessmeyer. --- http://www.sqlserver2005.de --- Schema name is optional for object names but it is best practice to always use schema-qualified names. Note that owner is different from schema. The user to schema separation is now possible in SQL Server 2005 and we are more closely aligned with the ANSI SQL standards than older versions of SQL Server. Using schema qualified object n ...Show All

• Christoph M&amp;#252;ller 'microsoft.sqlserver.batchparser' is malformed or not a pure .NET assembly.

  Hi all, I have a small dll that use the SQL Server 2005 SMO library. SQL Server 2005 has SP 1 installed. When I tried to register the assembly with the followin command, I get the error shown. If I remove all references to SMO, the assembly registered fine. I really need help on this. Thanks in advance. CREATE ASSEMBLY ACDataBridge FROM ' H:\User\Development\Projects\Applications\ACDataBridge\bin\Debug\Projects.Applications.ACDataBridge.dll' WITH PERMISSION_SET = UNSAFE Msg 6544, Level 16, State 1, Line 1 CREATE ASSEMBLY for assembly 'Projects.Applications.ACDataBridge' failed because assembly 'microsoft.sqlserver.batchparser' is malformed or not a pure .NET assembly. Unverifiable PE Header/native stub. ...Show All

• sreevidya Advanced Lookup in a Data Flow

  Here is the deal - I have a flat file with 2 fields: ProdNum FeatureCodes 1 A01, B22, F09 2 C13,C24,E05,G02,G09,J07,J09,M03,M17 3 J07,M01,M17,N02,N11,N13,X15 The I have Excel file like: Code Description A01 Handicap features B22 Smoke-Free F09 Tinted Windows C13 Picnic Area C24 Extra Storage J07 Tile Flooring M01 Central Airconditioning The result in a database needs to be like: ProdNum Features 1 Handicap features, Smoke-Free, Tinted Windows 2 Picnic Area, Extra Storage, ..... 3 Tile Flooring, Central Airconditioning, ..... How can I do this in a data flow - any ideas Thnx for the idea - however, there are 665 features codes - so pivoting / unpivoting ...Show All

• bob yoplait what's wrong with setup.exe for MS SQL 2005 (trial version)

  Hi, I just downloaded the trial version of MS SQL 2005 from Micriosoft website. However, when I run the setup.exe. it is to install Microsoft Office 2003. Can anyone help me Thanks. Where did you try to download that One part of the installation (depending on which option you chose is to installl the office Web Components OWC) which isnot Office, its needed for the Reporting Services part of SQL Server. HTH, jens Suessmeyer. --- http://www.sqlserver2005.de --- Thanks! the installation has been succeeded. ...Show All

• Ralf_from_Europe Stuck between "Failed to generate user instance" and "An attempt to attach...failed"

  I wrote an application using Visual Studio 2005 beta 2 which uses a SQL Express .mdf file, included in the project, for the database.  After installing Visual Studio 2005 RC and the SQL Express that comes with it (I followed all of the uninstall instructions first) I can no longer add a SQL Express database to any of my projects, nor can I open the SQL Express database in my original project.  When I try either of these tasks, I get the "Failed to generate user instance of SQL Server due to a failure in starting the process for the user instance.  The connection will be closed."  I read the thread which dealt with this error, and changed the connection string for the database file that had worked before to User Instance ...Show All

• SouLDragooN Dumb question about compatibility level

  Hi everyone, This is my first psot so I am hoping for success.. I had been asked to web enable a sql 2000 database. We upgraded to sql 2005 and I imported the data. All went well until a tried to run a CTE ( common table ) routine and it kept on coming back with an error. On searching the web it turns out that the compatibility level must be set to 2005. When I tried to set the compatibility level the only two options are sql 7 and sql 2000. I thought it might be due to the fact I had restored from a 2000 database so I tried to create a new database in SSMS but again only sql 7 and 2000 options were available from the drop down box.. What am I doing wrong Am I not running in sql 2005 at all Any help would be appreciated Peter ...Show All