Answer Questions

• HabibRazak BLOB Merge Replication

  Hi, I have setup a Merge Replication between a SQL Server 2005 and a SQL Server Mobile using native C++ code in Windows CE 5. Replication of normal data types (nvarchar, ints etc) works great, but when I try to replicate a blob about 1.5 MB the performance is awful. The download phase seems to be quick while the applytime (printed in debugger) when the database on my CE device is updated is about 3 minutes for 1.5MB binary data which is unacceptable since the database gets locked up during the applytime. The BLOB column is defined as image data type which shall hold up to 1GB data. I have tried to disable compression during replication, but it doesnt matter. Does anyone have some experience of using merge replication with blobs in SQL S ...Show All

• tawm Convert Date

  Hi ! I think I need your help... to convert the date (2006-09-09) to weekday, weeknumber, month number, month, year in OLE DB source editor ... created following sql, which is not working. How about using derived Column transformation editor SELECT DATENAME (WEEKDAY, YYYYMMDD) AS weekday, DATEPART(WEEK,YYYYMMDD) AS weeknumber, MONTH(YYYYMMDD) AS month_number, DATENAME(MM,YYYYMMDD)AS Month, YEAR(YYYYMMDD) AS year, DAY(YYYYMMDD) AS date FROM Purchase thank you so much... Thank you so much! solved! How about dates... This command "convert(char(8),date,112)" converts to YYYYMMDD. Still wondering how to convert date to format YYYYMM(200612) and YYYYwk (year+week as "20073") Phil is absolutely right. ...Show All

• Muralidhar M S Visual Studio C++ and SQL Express

  I currently have Visual Studio .NET 2003 installed on my computer and I am trying to develop an application that would require the use of SQL data base on a network using C++. Would I just need to install the SQL Express and Express Manager to get Visual Studio working with the database Or do I need to also install Visual Studio C++ 2005 express to get the data base features working correctly. Thanks Installing Express is technically all you need, I do recomend Management Studio Express as well to make life easier. The features for data in VS2005 are much richer than in VS2003 however VS2003 should work just fine. ...Show All

• xyzt How to disable windows authentication?

  How can I disable the windows authentication dialog box when opening the RS website http://server/Reports Thanks in advance What's the directory security setting on Reports virtual directory Also under Internet Options->Security (in IE), did you set the "automatch logon" options Thanks for your interest in helping me out James. The virtual directory security setting in IIS is Integrated Windows authentication. I have many users going to this site, and they are complaining that they have to type their username and password all over again, which is true, it should get the username logged in the pc trying to open the site and compare that agains ...Show All

• Aneel Alternative to Merge Replication?

  Is there a simpler alternative to merge replication I am concerned about the splash of GUID across the DB, performance issues, and the complexity of the deployment. My scenerio is: Networked offices with 5-30 internal users, modifying a central DB in SQL Server 2005 1-6 Field workers who need to modify a subset of the tables in the field (disconnected) and then connect to the network and upload their changes. Low (though possible) change of conflicting changes between syncs, as field people tend to work in different areas. Field device might be away from the central DB for 1-10 days. Last-one-wins would be OK for conflicting changes. I've been considering a home-grown system that inserts new r ...Show All

• DrDeath Temp Tables

  Okay i am not sure if i am doing this right but if i am i need help making each table unique so that the same report can be ran by more than one perosn at a time... i am working on some reports and using stored procedures to do this... in my final SP that populates the report it pulls from two other SPs: SP1, SP2. I made these first two SP make global temp tables so that i can use the temp tables they make in my final SP. I was wondering if they is a way to make it so either i don't have to use temp tables or if i can make each table have a unique name. Isn't that the purpose of the #temp tables So each session is unique within that instance of the named temp table   (Note the single "#") WoFe: This doesn't sound r ...Show All

• jason duncan SQL 2005 Reporting Features comparison to SQL server 2000

  Dear all, I am developing a proposal to my company, which is a microsoft select client, for introducing SQL 2005 to a new BI project. The company already has SQL 2000. I would like to have a full tabular format of SQL 2005 Reporting Service Features comparison to SQL server 2000. Most of feature enhancement paper has only tell what is new but not tell about what is already existed and how much it is improved (in quality and quantity). Yes, tabular format is more useful. I tried to search through microsoft.com, technet but still cannot find the relavent one. Would you please give me a web link Please suggest. I am not impersonated myself like a competitor. You can verify my id by sending e-mail to ...Show All

• nishanttheone Transact-SQL Common Features?????

  Hi The white paper which compares SQL Express and SQL Compact says that they both share Common Features Can someone please indicate if SQL Compact will support functions like Average, STDEv etc Thanks Touraj Hi Brian Thanks for the reply Cant this be included in the database It seems ridiculous that its been left out Anyone from Microsoft that can give us a clue about why its been left out thanks TV SQL CE was developed from SQL Mobile which did not have STDev as part of the implementation. If I remember correctly STDev was a function added in SQL Server 7. It is not a SQL92 or SQL99 function. So I would guess the answer would b ...Show All

• darknessangel creating and scheduling job for SSIS

  Hi All I want to create and schedule job for my SSIS packages. But I have no idea how to do that. Hi All SSIS packages works fine in BIDS but when we started testing on our Dev server, we are unable to run the SSIS. Error:System.Data.OleDb.OleDbExecption:ORA:01017:invalid username/password logn denied............... we are unable to connect to Oracle source. Do we again need to specify the connection managers. Paarul wrote: Hi All SSIS packages works fine in BIDS but when we started testing on our Dev server, we are unable to run the SSIS. Error:System.Data.OleDb.OleDbExecption:ORA:01017:invalid username/password logn denied........ ...Show All

• Brian Kramer Sum on conditional Values

  Hi I have a table with Records for employees and evry record has a record type now i need to have a sum in the table footer or in a group for all employees of Amount Column when Record type is "E" and the conditions is if this employee by RecordType "D" the amount column is not 0 else then shuld be 0 is it posible with SSRS Thanks Jhknys jhknys, You can use condition in your SUM statements: Try =SUM(IIF(Fields!RecordType = "E", Fields!Amount.value,0) Ham Hi, In the table, add a group in the group expression set to Fields!RecordType.Value and in the group footer Write this expression:Sum(Fields!Amount.Value), This will sum based on the recor ...Show All

• hye_heena Matrix - How to calculate % of row?

  Hi, I wish to create a matrix with multiple rows in the main data cell and a subtotal at the end of the row. The first row in my matrix main cell is just a count of records, whereas the 2nd row is a % of the value in the 1st row compared to the total of that row. I have 5 columns in the matrix as below (ignore rounding issues): Status A B C D E Total 01/01/2007 Number 9 32 3 13 0 57 % of Total 15% 56% 5% 24% 0.00% 100.00% Can someone advise the best way to calculate the % cells in this example Thanks Thanks for the response Mr.rajz I had to change the query at source as I was not using SSAS. ...Show All

• &#169&#59; Ţĩмό Şąļσмāĸ Confusing layout in SSIS with regard to "Execute SQL Task".

  I hope someone can help. I'm trying to read rows from a SQL Server Table and for each row use a few columns as parameters into a query to be run against oracle which will delete oracle rows. I add OLDEB connections for Oracle and SQL and then I try to add a "Execute SQL Task". I've also tried a "OLE Command" but I can't get the mapping of the columns to the parameters to work. There is lots of articles on the web that talk in general around parameterized queries but no clear examples. I also find the difference between the Control Flow and Data Flow tabs confusing as its not intuitive where to place things. It also appears to force me to re-define things that it should already know (this is no doubt because ...Show All

• Xythe MSSQL 2005 client application running slow on local PCs but not terminal server

  Hi, I am the IT support officer for an office who have recently installed MSSQL 2005 and the application that uses it. However, they have found that when there are more than around 6 users (intotal there are 21) accessing the client system the queries run slowly, 30secs as opposed to 2secs. They have also notified me that when this is occuring and they run the client application from a terminal server, the application on the terminal server run the action at normal speed (2 secs) . The people who installed the client application say that it is a networking issue, but i tested this as the terminal server and some of the PCs share the same switch and the PCs still run slowly. The actual network access appears to be fine, file browsing etc ...Show All

• ACHawk INSERT INTO with SELECT and Static text

  I'm having an issue inserting rows of data into a table with a column of static text using a selection as criteria: Insert into TableA ( CatID , ContID ) Values ( '27' , ( Select TableB . id from TableB where ColumnA < 0 ) ) Any help would be appreciated. SQL 2005, SP1. That worked great! Thank you so much! Insert into TableA ( CatID , ContID ) Select '27' , TableB . id from TableB where ColumnA < 0 ...Show All

• chico305 IE7 script error when opening Infopath forms

  Hi, I installed IE7 recently and it is giving me problems when I open Infopath forms to edit documents. I have a sharepoint website which contain links to these forms, when I click on the link it opens the infopath form. It was working absolutely fine when I used IE6. But now when I open the infopath form it gives me an error saying that A Runtime error has occured Line: 38 Error: Object Expected When I open it in the debugger it shows me an error at <body onLoad="onLoad()">. Could someone please advice! I appreciate a quick response. Thanks oops! sorry i created the new thread in the wrong forum. I need to put it in IE7 forum. Could someone tell me how I do that Thanks ...Show All