Answer Questions

• Derek Baird How do SQL 2000 service packs play a role in upgrading?i.e.Can SQL 2000 Standard with no SP be upgraded to SQL 2005 Standard

  How do SQL 2000 service packs play a role in upgrading That is, can SQL 2000 Standard with no Service Packs(SP) be upgraded to SQL 2005 Standard, or does SQL 2000 Standard have to have a certain service pack Hello Priya, It is possible to upgrade without SP1. I have recently upgraded a workgroups 2000 to SQL 2005 WGP and it went smooth. I dont see any reasons why SQL 2000 Std wont be upgradable to SQL 20005 Std if SP is not installed. Thanks, Rubal Jain ...Show All

• Thomaschr what is the best way to do this search?

  what is the best way to do this search I want a stored procedure which can serach in any of the filled form on my C# windows application. The textBoxes are: txtFileNo txtIDNumber txtContactNumber txtName txtBuilding txtBlock txtBox txtEmail I want SQL Server to search for any fiiled text, so if the user enterred txtName and txtEmail this it will onlt search for txtName and txtEmail. I know how to do this directly from the form but I want to perform this using stored procedure. i tried it again and this is the SELECT @sql_string SELECT file_no, id_number, person_name FROM persons WHERE 1 = 1 AND file_no = @string_file_no ORDER BY person_name but what i don't understand, why it showing the co ...Show All

• Leonid B Identify which reports are running

  Is there a way to identify which reports are currently running Hi, There is a table SessionData in ReportServerTempDB database that may be used to see what reports are currently running. Whenever a report executed the Report Server creates a record in this table. The Report Server deletes the records once the session time out reached. This may help you What if I query using WITH(Nolock) Don't query the tables directly, you could cause locking which will affect stability of the report server. You should instead use the ListJobs() SOAP api. http://msdn2.microsoft.com/en-us/library/microsoft.wssux.reportingserviceswebservice.rsmanagementservice2005.reportingservice2005.listjobs.aspx ...Show All

• Vinod Sa Web Synchronisation

  iam able to open the web sync diagnostic information using URL https://itneersrv.abitta.com:443/Synchronise/replisapi.dll in the internet explorer but while running throuth the c# code to run Merge agent i am gettin the following error , [0%] InProgress The Merge Agent could not connect to the URL 'https://itneersrv. abitta.com:443/Synchronise/replisapi.dll' during Web synchronization. Please ver ify that the URL, Internet login credentials and proxy server settings are corre ct and that the Web server is reachable. A security error occurred I am trying the synchronise through Internet where i have an publisher is at different country and subscriber at my office in India , i have given all privileges but then too i am getting same e ...Show All

• Cute_Celina Import from Access - Datatype conversions

  I have to do a lot of inporting from Access files.  Is there a place where I can change the default datatype conversion for Access Text from nvarchar to varchar Thanks. Kato Outstanding. Exactly what I was looking for. Thank you. If you are using the import wizard then you can affect this with the mapping files at: %PROGRAMFILES%\Microsoft SQL Server\90\DTS\MappingFiles I'm guessing that the one you want is JetToSSIS.xml If you are building packages manually then you can change this in the source adapter. -Jamie ...Show All

• David Mack Specific record and comparing it

  This is what I need to do and hope you can help me. I have a client record table in whic I have the Client ID, Name, and Services Dates. I have already Grouped the records by Client ID and then by Services Dates. SO what I want to do is first, make SQL just to pick the last record, meaning the most recent according to the service date, and then just show me the clients who haven't received any services in the last 45 days.(or any amount of days I enter) hope ypu can help me. Thanks iT IS EXACTLY WHAT I NEED THANKS!!, BUT FOR SOME REASON IS NOT WORKING I GET AN ERROR MESSAGE, I THINK IT HAS TO DO WITH THE WAY I HAVE THE CODE ORDER. WHAT I DEED I JUST INTRODUCED THE CODE YOU GAVE ME AT THE END BUT I THINK THERE'S ANOTHER ORDER. HE ...Show All

• einaros Aggregation Problem with Hours and Minutes in Time Dimension

  For the first time, I have created a time dimension that includes hours and minutes, in addition to the Year, Quarter, Month, and Date that I am familiar with. I want to display the average of my measures at whatever level of Time the user chooses. I thus chose "AverageOfChildren" as the aggregation method for these measures. Unfortunately, SSAS aggregates these measures by Sum over Hours and Minutes, and then by AverageOfChildren over Date, Month, Quarter, and Year. I am confused. How can I force it to perform an "AverageOfChildren" at all levels First, have a look at this document( http://www.microsoft.com/technet/prodtechnol/sql/2005/realastd.mspx ) and think about yo ...Show All

• M1tt Derived Column Logic to replace empty string with null?

  Ok.. so I have a fixed position data feed. I read the file in as just whole rows initially, process a specific position and evaluate a conditional split to determine direction of the file for proper processing (file contains multiple recors with different layouts). This all works fine. I then use the derived column feature to process all the columns. Most of the columns are as simple as SUBSTRING(RecordData,1,10) for example to get the first column. This all works for string data. I then have a column that is a date field. The problem occurs that the code SUBSTRING(RecordData,20,10) returns either a date or empty set of data if no date was in the original file. When this gets sent to the OLEDB connection (SQL Server 2005) into the date ...Show All

• StumblingInTheDark SQL 2005 Std. Ed. won't install!

  For some reason, OWC11 fails during setup. The first thing I see that's out of place in the OWC11 log is "failed to get resource store handle for cabinet: PA655502.CAB". I've seen the thread online where someone had installed the latest OWC11.exe and that solved their problem, I have not been so lucky. This has been ongoing for over a month. Can someone please help (relevent log files are below) (Setup Summary text) Microsoft SQL Server 2005 9.00.1399.06 ============================== OS Version : Microsoft Windows XP Professional Service Pack 2 (Build 2600) Time : Sat Jan 13 16:57:07 2007 Machine : STUDIO Product : Microsoft SQL Server Setup Support Files (English) Product Version : 9.00.1399.06 Install : ...Show All

• sooline Can I use Custom UI for executing Package in C#?

  Hi I've a doubt. I don't know whether it is possible or not. I've a very less knowledge in DTS packages. When I execute a package in C#. it is displaying predefined GUI for showing process. Can I've my own UI when executing DTS. Thanks in advance. Thank u Michael . Thanks for ur support to know these. And finally one , can u provide some resource to learn , how to create custom UI. and executing package.etc Thanks alot Michael. Execution is multithreaded, you'll need to gather information you need from the event and pass it to the UI thread, and probably call package.Execute() on a different thread too to avoid locking up the UI. There are many events and log information, see Books Onl ...Show All

• JJOSHI What DataType is best ... float, double or decimal?

  I am using sql express 2005 and sql server 2005 with C# 2.0. I am a bit confused about which data type i should be using for several fields. Right now I am declaring all of my fields in sql server as float for everything except for money fields which are using money. When loaded into C# these fields are converted to double and decimal because C# does not have a float datatype. Should I be using Decimal or Double for everything instead Here are a few examples QtyInvoiced (float) - holds the number of items invoice possible values look like this 1.0, 1.25 or 1.5 PercentDiscount (float) - holds a percentage possible values look like this 10.25, 20.50, 50.00 I appreciate the help. I'm no ...Show All

• Michael Morris Error when I try connect to a database

  Hi! I just have downloaded VWD C# express and get a big problem when I try to connect to a database, I use the SQL data source object and when I'm trying to connect to a database I can't use the INSERT, DELETE and UPDATE object in the database. I now that I have to click to advanced button and click for INSERT, DELETE and UPDATE objects but I don't even can click for that so something is very wrong, but what I use Microsoft SQL server database file as a data source and if I try to use Microsoft SQL server (sqlclient) instead I get this huge error: " An error has occured while establishing a connection to the server. When connection to SQL Server 2005, this failure may be caused by the fact that under the default SQL server does not a ...Show All

• lamont_23 Excel 2003 and Analysis Services 2000

  Does anyone have any performance guidelines for this combination. I am experiencing slow refresh rates, both when I refresh data and change or add dimensions. The Fact table - so far - has only 17500 rows, one of the dimension tables has over 200,000 rows (majority of these as yet unnused) I have looked on the server where AS is installed and there does not seem to be much activity. On the PC where I am doing the refresh Excel gets up to 98% CPU and can use 160K of memory. Anyone any clues Steve Are you using AS2000 and Excel 2003. If so,you can have a problem with the dimension with 200 thousand rows. A lot of meta data and data for this dimension that is loaded down to the local cache(ie pi ...Show All

• Nisa Issues With SQL 2005 Encryption

  Are there any pitfalls i should look out for when using the encryption in SQL 2005 I'm just learning SQL and i'm very green but hope to become more seasoned in time. Thank you. Jeff Welch Yes, Thank you. I'm having an issue with altering the Symmetric Key. I open the key By running Open Symmetric Key EncryptTestbase decryption by Password = 'mypassword' . it runs sucessfully and then I run the Alter Syntax to alter the Key and it tells me The key 'EncryptTestbase' is not open. Please open the key before using it. Whats up with that. Thanks for your help. Jeff Welch I opened the key then used the Alter Statement. Thanks ...Show All

• Natalie276398 Creating an Expression to Modify a Date Field

  In my Derived Column Transformation Editor I have something like this: DAY([Schedule]) + MONTH([Schedule]) + YEAR([Schedule]) where [Schedule] is a database timestamp field from a OLEDB Datasource. I want to produce a string something like: "DD/MM/YYYY" using the expression above, I get something really wierd like "1905-07-21 00:00:00" Help much appreciated! Perfect! Thanks! Hey Jhon, DAY, MONTH and YEAR functions return integers; so if you evaluate for example 1905-07-21 with the expression you posted you will get 1933 (1905+7+21), so that weird date you are getting may be the translation of that integer into a date d ...Show All