Answer Questions

• oremo Package configuration not used after deployment?

  I've been searching for an answer to my question quite some time now and I've not been able to figure it out yet. Situation: - I've created a SSIS package containing a bulk insert task. - I've added a package configuration containing the appropriate connection manager (i.e. dev, beta or live) - CreateDeploymentUtility = true - I've copied the deployment folder to our beta server and I started the manifest file to install the package to the ...Show All

• johnedgar MySQL to SQL Server migration

  Hi, I would liked to know the SQL Server equivalent for the below MySQL query : SELECT a.col1, a.col2, max(a.col1) FROM test a, test1 b WHERE a.col2 = b.col2 GROUP BY a.col1 Thanks, Smitha SELECT distinct MAX(id), name FROM  test3 GROUP BY  id, name Above query is not helping me ! It gives all the rows Adding all the select columns to the group by can't be the solution as the result will differ when compared to the ...Show All

• Philsky repeatwith property

  I have tried for days to get certain textboxes and tables in page body to repeat on multiple page reports Any help is appreciated. How to transfer parameter to Header and display it on next page. I reference one report textbox to header textbox "= ReportItems!textbox1.Value " But it didn't display on second page.... What can I do How to use static query in my header textbox = "SELECT [Contracto ...Show All

• Galin Iliev SP_WHO2 on SQL 2005

  The behavior seems to have changed on SP_WHO2 in SQL 2005. In SQL 2000 I could be logged in as a regular user in my system and run SP_WHO2 and get all the users currently logged in. This is no longer working in SQL 2005. It now only returns "me". What kind of rights do you need to have to see who is logged in VIEW SERVER STATE allows its grantees access to a lot of information in the server. R ...Show All

• drewex Solutions and Projects: What are they and how do they help the DBA

  I guess the Subject line sums it all up, but I need some experienced explanation of what do a solution and a project represent, and how do I use them to my advantage. Is a solution an entire database If so, how can I create a solution from my existing databases Are either of them a way to collect together scripts etc which will be run against a production database when the solution is rolled out What is a project Is it a single set of ...Show All

• flaviocunha AMO DataSource ConnectionString Password and ConnectionStringSecurity

  I am creating a datasource using AMO with the password embedded in the connectionstring to the database. After the datasource has been updated to the server, if I load it again, the password is removed from the connectionstring. I tried setting the ConnectionStringSecurity to "Unchanged" but it's reset back to "RemovePassword" when I load the datasource object again. Any ideas on how to avoid entering the password everytime ...Show All

• Hepper Displying rtf database field properly formatted

  I am a simple user- I have a SQL Server database that stores a particular field as rtf, including all of the formatting characters in addition to the actual user-entered text. I use the report wizard to easily build reports, but this particular field outputs all of the gobbldygook but I just want the user-entered text. Crystal Reports easily translates rtf- why can't Microsoft easily translate their own format Any help would be appreciat ...Show All

• Kjell Arne Insllation of Reports failing on SSL installation of RS

  I am using the scripts to install my reports on to a server, it works fine on my development server, but on the Live machine which is also running SSL, it throws up errors when trying to install the reports. I am running the process using the administrator and point to https:// version of RS The underlying connection was closed: Could not establish trust relationship with remote server. Anyone know why this is happening ...Show All

• sgrussell How to use SQL Express to Cache the data.

  Hi, We are using VSTO 2005 and developing an Ms-Office Excel application which has to work both in Online and Offline. When the user connects to office LAN network then the data that the user will use data comming from our centralised database. This is for online scenario but when the user is in offline i.e. when the user is out of office user has to use the data which comes from the SQL Express. Once user connects to office LAN all the data fro ...Show All

• Teo97917 SQL 2005 Mobile Merge Replication size limits?

  I am in the process of testing a SQL 2005 Std x64 server with merge replication using Windows Mobile 5.0 clients and SQL 2005 Mobile. The test DB is a copy of the currently active DB, but has been expanded to include some new tables to support planned application functionality extensions. Once the publication exceeds 97 Articles, the error is thrown that "The buffer pool is too small or there are too many open cursors". If I drop on ...Show All

• Elver HowTo Union a given query across n duplicate databases

  I can't seem to accomplish my task of having T-SQL return a recordset that is Union of any given select query against n databases. I am working in an environment that has several databases with duplicate structures within the same SQL instance. The passed in SQL will be a select statement and I need the SP to return a Read-Only recordset. The code I think shows what I am trying to do. I can use any other approach as long as I can ...Show All

• andrew M "order by" in xquery

  Given the following XML data in SQL Server (where each Employee is a separate rowset), is there a way to order by ID using XQuery Row 1<Employee><ID>3</ID></Employee> Rpw 2<Employee><ID>1</ID></Employee> Row 3<Employee><ID>2</ID></Employee> Ex: SELECT Employee.query(' for $emp in /Employee order by $emp/ID ') Adrian, you are the ...Show All

• mikelaw Help on Script Component assignment of output variable

  Hi all, Actually I’m working with the beta 2 of the Sql Server 2005 with SSIS. And it’s great fun! But I’m now experience a problem: I’m working with a script component. In that script component I would like to assign a value to a specific column ("Row.Formula"). The type of "Row.Formula" is Unicode text stream [DT_NTEXT]. Whenever I try to assign a byte array or a string to that field I am getting a compliation error. I have to assign a v ...Show All

• mbothmer Problem with multi-valued parameters since SP1

  Hi, after the installation of SP1 I have a problem with multi-valued report parameters. The option to select all values are gone. Is there a bug within SP1 Before the installtion of SP1 multi-valued report parameters works fine, the option to select all values was added automatically within the preview in Visual Studio 2005 and in published reports on the server. The server was migrated from SQL2000 SP4 to SQL2005. So long Lemmi ...Show All

• Lucho_1981 Problem with sample databases

  I have installed SQL Express 2005 together with VS 2005. After a while I found out that the sample databases (Northwind and Pubs) were missing, so I installed them. According to the 'Readme', which comes with the installation I could choose between attaching the db to the Server or running a SQL script. Neither works. I've read this link about remote connections ( http://blogs.msdn.com/sqlexpress/archive/2005/05/05/415084.aspx ). My developme ...Show All