Answer Questions

• Alex Simkin Migrating to Sql25k

  We’ve got hundreds of branch which are working with MSDE. As we are moving sql25k, what the ideal version would be adviceable to install there Sql Express How to handle this I have a fuss on my head because of there are many vesions available. Thanks in advance for any comment or further information, enric, could you please mark an answer. And your welcome. thanks, Derek Thank you Yes, SQLExpress is the succesor to MSDE however "Express" is a much better core database engine as it support more hardware, less restrictions (including the fabled 5 connection limit of MSDE) etc. Here is a link that lists out the differences b ...Show All

• Paul Diston SOLUTION! - VB.NET 2005 Express and SQL Server 2005 - NOT saving updates to DB - SOLUTION!

  VB.NET 2005 Express and SQL Server 2005 Express - NOT saving updates to DB - SOLUTION! ----------------------------------- The following article is bogus and confusing: How to: Manage Local Data Files - Setting 'Copy to Output Directory' to 'Do not copy' http://msdn2.microsoft.com/en-us/library/ms246989.aspx You must manually copy the database file to the output directory AFTER setting 'Copy to Output Directory' to 'Do not copy'. Do not copy The file is never copied or overwritten by the project system. Because your application creates a dynamic connection string that points to the database file in the output directory, this setting only works for local database files when you manually copy the file ...Show All

• raymuirhead Invalid column name 'rowguid'

  I'm trying to set up a merge publication in MSSQL 2005 SP1. I have a database which I have successfully made into a merge publication.  When I run the snapshot agent, several articles are processed successfully, then I encounter an error with the following: Invalid column name 'rowguid' Note that none of the tables contain 'rowguid' columns before this process - I let MSSQL automatically create these as needed. The replication monitor details the following error: Error messages: ·           Message: Invalid column name 'rowguid'. Command Text: sp_MSpublicationview Parameters:    @publication = RelMS Publication Stack:    at Microsoft.SqlServe ...Show All

• Phil Bolduc Job Hang

  Hi, I am running the following TSQL command and it hangs. These commands are running from SQL 2000 server and it is querying information for SQL20005 database. Running simple EXEC command work fine but running using Insert hangs. Set @Cmd = @ServerName + '.' + @dbname + '.dbo.sp_helpntgroup' Print @Cmd Insert into dbo.DBSecurity ( NTGroupName, NTGroupID, SID, HasDbAccess) Exec (@Cmd) Any idea, SQL Server 2005 is configured as Linked Server in SQL 2000. last wait type is OLEDB Component Services saying 1 Active transaction and 1 aborted. Thanks Shafiq Is the SQL Server 2005 server configured as a linked server or remote server If the SQL Server 2005 server is configured as a remote serv ...Show All

• FlyinBrian Integrate more than one SSIS packages into one package

  Hi I'm new to SSIS field. I'm importing data from flat files to sql server 2005 through SSIS packages. I have around 30 packages which transfers data from flat files to corresponding database tables. I want a single package that will run all the 30 packages by running that single package. Like in a single stored procedure we can run multiple stored procedure, I want the same solutions for my packages. Is there any method which can solve the above issue Please kindly guide me . Its urgent. please reply soon. Thanks in advance. Hello; Package configuration not working. In my project I 've one Mother package and 10 child packages.I've added the package ...Show All

• ron nash Fulltext indexes on separate catalogs

  For performance reasons if I have 2 separate fulltext indexes on 2 separate tables, should they also be in two separate catalogs Will putting them in the same catalog slow things down. I assume that catalogs cannot span filegroups. Thanks for your replay. So is it faster to put the two fulltext indexes in two separate catalogs on two separate filegroups or is keeping it all in one catalog and one filegroup prettyy much the same Sure you can create unique catalog for each of your fts index. However, you cannot span a catalog across multiple filegroups. Though, a filegroup can have more than one file. If you seperate your catalogs onto different LUNs you es ...Show All

• Eduardo Coelho Common Generation Watermark error for Merge Replication

  Hello, We have a sqlexpress subscriber that is receiving the error below. SQL Server 2005 We have tried: Generate new snapshot. Reinitialize the subscription. Dropped the subscription. Reboot the web server box. Reboot the sql server box. Yet we still get the errors for these specific subscribers. Any ideas Error in replication monitor.... Error messages: The merge process failed because it detected a mismatch between the replication metadata of the two replicas, such that some changes could be lost leading to non-convergence. This could be due to the subscriber not having synchronized within the retention period, or because of one of the replicas being restored to a backup older than retention per ...Show All

• programmer01 Error in Transacitonal Replication - SQL Server 2005

  Hi, I'm deploying tran repln between 2 SQL Server 2005 databases and when viewing the 'Distributor to Subscription History' see a error message: Incorrect syntax near the keyword 'where'. (Source: MSSQLServer, Error number: 156) On the subscriber, I don't see the snapshot being generated....Please advice. I am having a similar problem. I know that I fall into the 3rd category. Basically, I want to replicate an identity to the subscriber, keeping the same value as what is in the publisher. I also have a situation where only the publisher can make changes to this table, not the subscriber. Is there any way I can alter the system stored procedures that are used to create the insert stored procedure ...Show All

• Gurpreet Singh Sawhney SSIS Deployment Question about Conn Strings? Please Help.

  Hi everyone: I have a package(SSIS) that works fine on a local SQL Server. Once I deploy it to the server A, and change the connection strings, it throws the following error: Error: The AcquireConnection method call to the connection manager "DatabaseName" failed with error code xxxxx. Error: component "OLE DB Destination"(16) failed validation and returned error code xxxx. Error: An OLE DB error has occurred. Error Code: 0x80040E4D. Al OLE DB record is available. Source: "Microsoft SQL Native Client" Description: "Communication Link Failure" Error: Error: An OLE DB error has occurred. Error Code: 0x80040E4D. Al OLE DB record is available. Source: "Microsoft SQL Native Client&quo ...Show All

• createdbyx Sending email to multiple recipient

  I am trying to send emails to multiple recipient using the Send Mail Task, but it is failing with the error: " The specified string is not in the form required for an e-mail address." It works when I have only one emailID in the ToLine, I have a script task that build the emaiID list and saves it in a variable and the in the Send Mail Task, I am using the Expressions for ToLine to use this variable. If there is just one emailID in the list, everything works, but if there are multiple, it throws an error. For building the emailID list, I tried using "," as well as by ";". But none seem to work. Any help will be greatly appreciated. The Send Mail task likely doesn't ...Show All

• 13117 qyering data from two databases on different servers

  Hello- I am trying to write a report that combines data from two different databases on two different servers. Wherther I run the query in SQL Server 2005 management studio or reporting services, I get the same error: Msg 208, Level 16, State 1, Line 1 Invalid object name 'King_County_SWD.dbo.vwDriver_Out_Gate'. There is an error in the query. Invalid object name 'King_County_SWD.dbo.vwDriver_Out_Gate'. I have written queries that access two different databases on the same server and they work just fine, so I am guessing that I am not providing enough of a fully qualified path to the second server. We have not implemented linked server. Any ideas on how to properly identify the second server/database/object would be appr ...Show All

• Uwe82 Application Role And SSRS

  Hi dear reader I made an application that uses a Sql Server 2005 Express DataBase. In the database I made a application role. When the user logs into my application I run this procedure: If Not sqlConnectionCR Is Nothing Then If Not sqlConnectionCR.State = ConnectionState.Open Then sqlConnectionCR.Open() SqlConnection.ClearAllPools() ConsultasSqlCommand = New SqlCommand ConsultasSqlCommand.CommandType = CommandType.Text ConsultasSqlCommand.CommandText = "sp_setapprole 'appRole', 'drowssap" ConsultasSqlCommand.Connection = sqlConnectionCR ConsultasSqlCommand.ExecuteNonQuery() End If Else.... I understand that this procedure connects to my sqlserver database ...Show All

• k_Prasad Calculated Measu Formula limitations

  Hi, I am using AMO to programmaticaly create the SSAS objects like Cubes, MeasureGroups, Measures, Calculated Measure, partitions .etc. I pick the necessary information from an existing Oracle OLAP/datawarehouse. In the Oracle OLAP the calculated measure can contain any formulae which the oracle db can support. This means its a huge list....! for example, Log, Decode functions. Though SQL Db provides these functions, they are not avaliable to use directly in the MDXScript of the Calculated Measure. so now when I am synchronizing the Oracle OLAP to SSAS programmatically at runtime, how do I resolve these inconsistencies in the formulae Regards Vijay R I think you mixing several concepts. You can still re ...Show All

• Antioch Package Configuration with XML file

  Hi, I have about 40 packages in my job. One of the problems that I have encoutered is that I don't know how I could use same XML dtsconfig file for all of my files. Each SSIS calls different file. The XML dtsconfig file is a replacment for my *.ini file in sql 2000. The dtsconfig file will hold paths to all different files. Each SSIS will take different file name at a runtime. How can I have all the files paths in one dtsconfig file - and is it even possible to do that in SSIS Any help greatly appreciated....Thank you, Maria Hi Jamie, for my first ssis package I created new XML dtsconfig file and lets say called it "common.dtsconfig". That all works fine. Then I created my se ...Show All

• comspy execute SSIS package in SQL Express environment

  Dear all, I have an SSIS package and want to execute it on a computer that only has SQL Express installed on it. Since SQL Express didn't brought dtexec or dtui so what should I do Sorry for my bad English... Thanks for advance, Sorry, I am a little bit confused. I am using SQL Server Developer Edition, which I believe is the same as SQL Server Express. Yesterday I was trying to find out how to do DTS in 2005 and found out on msdn that it had been renamed S QL S erver I ntegration S ervices, and whilst I could not seem to start the SQL Server Import and Export Wizard via SQL Express as outlined in the knowledge base article, I could start it from the command line by running DTSWizard.exe manually as outlined in the ...Show All