Answer Questions

• Dungeonhawk Ignore Grouping

  I'm trying to place 2 matrices on a list. The first matrix I want to listen to the grouping of the list, and the second I want not to listen to the grouping of the list. In other words, I want the scope of the second matrix to be at the same level as the list. Is this possible Basically I want the second matrix to always show the same results regardless of the list's group.  - List groups on PersonID     - Matrix1  &nbs ...Show All

• LeoNicolas bcp utility stringing

  ok.  so, i've gotten the bcp utility to work and now i'd like to string all the prompts together and place them in a job to be scheduled to autorun. i don't have much experience in this arena and appreciate any help or suggestions.  I'd love to be able to run (from the command prompt) a file takes care of synchronizing all my tables. I have an additional concern.  I'd like to retain the integrity of my primary keys but I n ...Show All

• David Swain Copy tables on remote servers

  Hi all, I'm trying to create a script / stored proc that copies one table from a remote server to another table on a different remote server. The approach I wanted to take was... create a stored proc that can be called remotely the stored proc tests to see if the table exists, if it does it is dropped, if not it is created new table structure and data copied from remote server A to remote server B ...I feel that this should be ...Show All

• Ning Unable to restore SQL Server 2005 Beta 2 databases in SS 2005 Final

  I'm in trouble. We moved to MS SQL Server 2005 Final release after using Beta 2 release. I switched the installations. When I tried to restore the database backups, I got following message. System.Data.SqlClient.SqlError: The database was backed up on a server running version 9.00.0852. That version is incompatible with this server, which is running version 9.00.1399. Either restore the database on a server that supports the backup, or use a b ...Show All

• Cliff Buckley PROBLEM W/ OLE DB COMMAND

  In a data I'm trying to implement an Ole DB Command to do a database table update.  When I enter my sql command I get an error saying [OLE DB COMMAND [5926]] - unable to retrieve destination columns...  It appears it doesn't recognize the table I'm trying to update, however I do have a sql task in the control flow that is successfully selecting a row from the same table that I'm trying to update (just to prove that I can access that ta ...Show All

• IrishAnto Executing .sql file using SMO

  Hi all, Is it possible to execute a .sql file using SMO. like in old days we used to use osql.exe to execute the sql files Thanks in advance Rujith Hi, you don’t need SMO for that,executing scripts can be done via a *normal* sqlconnection (untested script, just wroite down in notepad) static void Main(string[] args) { if (args[0] == null) { Console.WriteLine("No fil ...Show All

• davidwj OLE DB Error in SSIS

  Hi All, We are using IBM iseries OLE DB provider and once we make a source connection using the same we get an error saying that the "Default Code Page" property is not defined and a default code page will be used. Any ideas Thanks Manish That's probably a different error. i.e. Related to something else. -Jamie Thanks Jamie. Tried it out but it also does not seem to work, tho ...Show All

• Harendra_1976 Restricting data in Report Builder

  Hi guys, I have a question on restricting a data using some kind of dynamic parameter when users are using Microsoft Reporting Services Report Builder. I saw that I can set permissions and restrictions for report model items like columns, but I want the users be able to see all the columns, but the actual data that gets pulled needs to be restricted using a database table (bridge table) that assigns the users to what they are able to see. ...Show All

• Coldwine Query producing Dups

  I swear I had this fixed but when I looked again this morning, I noticed that this query is producing dup records in the results. Something is not right with my query here: SELECT DISTINCT m.customer, c.name, c.customer, (SELECT Top 1 fd.Fee1 FROM FeeScheduleDetails fd where c.feeSchedule = fd.code) AS FeeSchedule, m.Branch, CASE WHEN ph.batchtype = 'PUR' OR ph.batchtype = 'PAR' OR ph.batchtype = 'PCR' OR ph.batcht ...Show All

• TweezerMan How to return varchar(MAX) from a CLR function?

  Hi, I am trying to return [ string/SqlString ] from a CLR function, but it was truncated at 8000 characters. How can I solve this problem and return varchar(MAX) Thanks Thanks Adam, it works. Visual Studio deployment unfortunately has a lot of quirks.  In case you're interested, I discuss another one in the following blog post:   http://www.amazon.com/gp/plog/post.html/ref=cm_blog ...Show All

• Fuzzier SP1 Installation Failure for Reporting Services Instances

  The upgrade was alright for my first/default instance of reporting services but failed for the other 3 non-default instances. I was running SP1 using remote desktop connection. I got the following error at the report manager and the reporting services configuration's initialization. Is there any way to get around this The version of the report server database is either in a format that is not valid, or ...Show All

• Frank0824 Problem with a Replication with two publications

  Hi. I have a database with two publications. One publication is used to replicate data among 4 SQL Servers, while the other is used for the replication with SQL Server CE clients. The problem here is that the SQLCE receive a number of changes that it is not correct. Before establishing the publication for SQL Servers the SQL CE clients were working great, but now i have this problem. Is there any patch or fix I should install on the server , or ...Show All

• saydhu Failed to generate a user instance SQL Server Express 2005

  Hello, I get the following message after updating to sql server express 2005 advanced. Failed to generate a user instance of SQL Server due to a failure in starting the process for the user instance. The connection will be closed. I noticed that in my C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Template Data I have not databases How do I get them back I also had to add back the aspnet to the permissions and the network ...Show All

• PainlessProd Scale issue with oracle Numeric types and OLEDB or datareaders

  Hi, I saw some threads here about related issues however I am still trying to find a workaround. I use the Sept CTP. When pulling data with a query from oracle 8 or 9 against numeric [DT_NUMERIC] columns set with a scale 0f 2 on the Oracle side, I allways get a scale of 0 on the SSIS side. I tried datareader and oledb, it is the same. When I use datareader, I can change the input column to a scale of 2 however i get an error when I try to change ...Show All

• Aatif latif Problem about authentication of OLAP on web

  server : MS SQL Server 2000 olap : Analysis Service client : Excel save to .html connection client/server : workgroup I use Excel to retrive data from AS and publish to website by save file to HTML file The problem about authentication of OLAP is it's depend on Windows account . Example. If I would like to create new account to viewable data on client , I must 1.Create user (Windows account) in server and set to group that ...Show All