Answer Questions

• William Bartholomew Disk activity

  We are about to go to SQL 2005 and that means getting some new Servers and i am wondering if our SAN is adequate. I like to measure over the next few weeks the amount of data that is sent to the SAN and how long its taking to come back....i.e if someone is running a large report how much data is sent and how long it takes to return. This is for 2000 SQL (i like to get all these results to build my migration plan and hardware configuration). I like to see...........18 mb of data , date time and how much read / write etc if possible the sql. Any ideas Look at Performance Monitor (perfmon). It's under Administrative tools on the Start/Programs menu. Check out the LogicalDisk and System Performance Objects and the counte ...Show All

• wiyosaya Sql Server Mobile Install Issues.

  I am a complete loss, here is what I have tried. I uninstalled what I thought was Sql Mobile and downloaded and installed SqlMobile30DeviceSDKENU.msi. I have the following directory structure I have tried to install the files marked with <==== each time I have seen the pda tell me that SQL MObile 2005 was installed but no ISQL under programs and when I run ISQL on the PDA and try to contect to a database it tells me the provider is not found and that SQL mobile is not installed correctly. What am I doing wrong The device is a Ipaq 2795 running windows mobile 5 -Program Files -Microsoft SQL Server 2005 Mobile edition +Client - Mobile -3.0 + tablet - wce400 armv4 ...Show All

• Principher Convert row with text field to column

  Hi experts; How can I generate the result using typical SQL statement based on the following tables Table a - Salesman (salesId, Name) pk : salesId Table b - Invoice(InvoiceNo, salesId, InvoiceAmt) pk : invoiceNo fk : salesId -> Table a The result set : salesId, Name, sum(InvoiceAmt), InvoiceNos with comma separator For example: Table a SalesId Name S001 Peter S002 Alice Table b InvoiceNo SalesId InvoiceAmt INV001 S001 $100 INV002 S001 $100 INV003 S001 $400 INV004 S002 $200 Result set SalesId Name Sum(InvoiceAmt) InvoiceNos S001 Peter $600 INV001, INV002, INV00 ...Show All

• amahbod The call to WinSock originated from dbnetlib!ConnectionRead+3b6

  Hi, I have Problem of asp.net 1.1(win2003SerSP1) Hanging And Crushing Dail More than 5 times, Ok when i use debugdiag to trace errors i recieve those two errors. so it cames every debugdiag i generate. The following threads in w3wp.exe__DefaultAppPool__PID__4684__Date__09_12_2006__Time_09_08_02AM__173__IIS Hang Dump.dmp are waiting on data to be returned from another server via WinSock. The call to WinSock originated from dbnetlib!ConnectionRead+3b6 ( 2 ) 33.33% of threads blocked when i go thread 2 it gives me this message Thread 2 - System ID 5448 Entry point mscorsvr!ThreadpoolMgr::intermediateThreadProc Create time 9/12/2006 9:02:39 AM Time spent in user mode 0 Days 0:0:0.328 ...Show All

• Abhishekbhadouria Display Report Description within Report Body

  Hi all. I wanted to use the Report Properties|Description within the report.I thought it would be something like Globals!Description, but it seems not. Has anyone else found the syntax to use that (or Author) within the body Thanks Will. In that case I'll look into an alternative. HN I'm pretty sure that when i tried to do this I was advised that The author and description properties are not available to textboxes. Therefore you need to either hard code the values into a textbox(es) or to add the information to a table and pull it into the report using a dataset. ...Show All

• rstevens Executing on a different database.

  Gday guys. I have a question on a problem I'm unable to solve. Help would be much appreciated. I'm using SQL2005 at the moment, Basically what I'm trying to do is Execute a string. The trick is that I want to do it on a different database than the one I'm currently working on. I get the execution string from the Information_Schema.ROUTINES system table, so they cannot be modified to suit my needs. Basically, I'm trying to move all UDF's and stored procedures that meet certain criteria to a different database using one script. I know all about the USE statement, but I can't append it infront of the execution string, because it complains that CREATE or ALTER needs to be the first statement. I also can't use the USE stateme ...Show All

• MattHei what errors normally should i log for my SSIS package?

  I got an SSIS package that first "truncate the product table" then populate the table with new rows....if there is an error then i will invoke the send email task. However in the "truncate the product table" task, the sql i put "truncate dbo.product" instead of "truncate table dbo.product" but this error is not captured in the text file that I m going to send an email to the appropriate personnel. Under logging, and when i go into "truncate product table" tasks , "Details", i saw "OnError", "OnWarning" and other error handlers...which should i tick in order for the text file to ONLY show errors I encounteered during the running of the SSIS packa ...Show All

• MMCompton Integration services Globla variable and scheduling issue

  I have one main package from which i am executing 5 other packages.I want to use one single DB connection in all the packages which i am declaring in Main package and it should be available in all the child packages. How can i Do this Few Variables are common is all the packages so i want to keep it Globally so how can i access those variables How can i schedule package in sql server Thanks Priyank Gajera wrote: I have one main package from which i am executing 5 other packages.I want to use one single DB connection in all the packages which i am declaring in Main package and it should be available in all the child packages. How can i Do this You can use package configuration in your children packa ...Show All

• guy2006 Copy Table in same database

  I'm using partitions in my project to age data that's older than some predetermined number of days. Normal deletion of the data takes too long, but the following sequence of operations seems to work well when testing with raw sql queries: Split (to create a new partition for new data) Create (a new temporary table to hold the oldest partition's data) Switch (to move the oldest partition's data into the new temporary table) Merge (to combine the oldest two partitions, "removing" the oldest one in the process) Drop (to drop the temporary table and all the old data that we don't want anymore) My current problem arises at step 2, "Create." The precise column/index/etc layout of the data being aged is no ...Show All

• Robin Debreuil How to allow remote connections to SQL Server 2005 Express database

  I've developed an asp.net 2.0 web app with vs 2005 and am using a SQL Server 2005 Express database. The app works fine locally, but after uploading to the remote web server the following error occures: An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified) How do I go about granting remote connections to SQL Server Express Does the web server have to have SQL Server Express installed in order to run apps that utilize SQL Server 2005 Express databases Do I grant access locally ...Show All

• rusty_dev SQL serveur Express

  I have downloaded SQL serveur express and I can not start the program. I have this error: (see at the end of log file: What can I do 2006-09-21 20:28:11.21 Server Microsoft SQL Server 2005 - 9.00.1399.06 (Intel X86) Oct 14 2005 00:33:37 Copyright (c) 1988-2005 Microsoft Corporation Express Edition on Windows NT 5.1 (Build 2600: Service Pack 2) 2006-09-21 20:28:11.21 Server (c) 2005 Microsoft Corporation. 2006-09-21 20:28:11.21 Server All rights reserved. 2006-09-21 20:28:11.21 Server Server process ID is 2456. 2006-09-21 20:28:11.21 Server Logging SQL Server messages in file 'C:\Program Files\Microsoft SQL Server\MSSQL.2\MSSQL\LOG\ERRORLOG'. 2006-09-21 20:28:11.21 Server This instance of SQL Server last repo ...Show All

• jchris1710 Maintenance Cleanup task not functioning properly???

  Using SQL Server 2005 Management Studio and backing up databases. When I add the task Maintenance Cleanup to remove database backups older then 1 day the task fails What part of this TSQL code does SQL Server 2005 Management Studio not understand EXECUTE master.dbo.xp_delete_file 0,N'\\pdxsql03\SQL Backup\POSSQL_Server',N'.bak',N'05/15/2006 08:09:37' The database file backup extension is .bak and the file is older than one day which was specified. It is just not deleting the file. We have deleted the maintenance task and recreated it with no effect and this has been happening for over a month. Any help here would be greatly appreciated. Carl carlt@gicw.org I tried to load up SP2 (thought I had already ...Show All

• earthdance Need to copy All oracle tables to SQL Server 2005

  I am racking my brain on this one. I am migrating Oracle data to SQL Server and would like an SSIS package that will copy the oracle data from every table to SQL server. I already have the schema set up in SQL and a straight copy of a specified table works fine between the OLEDB source and OLEDB destination. However, when I set up a loop which sets a global variable for the table names, which are identical on both dbs, and try to set the OLEDB Source and Destination OpenRowsetVariable to the global variable, the process fails with these errors with all validation turned off: [OLE DB Source [18]] Warning: Cannot retrieve the column code page info from the OLE DB provider. If the component supports the "DefaultCodePage" property, the code ...Show All

• enric vives Drillthrough action

  Hi, Is there any way in AS2005, I can specify a cube action which will bring up an HTML page displaying the Drillthrough MDX for the cell that I just initiated the action on Also, will this MDX work across all cube partitions (no need for FIRSTROWSET clause) Thanks, JGP Any idea how I would go about retrieving the action schema rowset Any samples would be greatly helpful. I'm trying to get this working from the ProClarity clients (Standard and Professional). Thanks, JGP Drillthrough actions return a DRILLTHROUGH statement to client application (e.g. cube browser) which in turn executes the statement and displays the results. The results will co ...Show All

• tfrazier Dynamic transformation to upload flat files into database

  Hi, My scenario: I have 4 different flat files types each having different no. of column, order of columns etc. I want to upload all the 4 types into the same destination table in the SQL database. Before uploading I need to apply transformation to each column in the flat files. The transformations could be like 1) Multipying the source column by 100 2) Put an if condition for 2 source columns and then select one column to be copied into the destination. I have the flat files schema with me and also all the transformations that are required. Question: Can SSIS provide me with a component that can read the flat file schema and the transformations from the database and apply them to the source data and then upload it to ...Show All