Answer Questions
Laurel Hale Report Headers
I'm new to Reporting Services, but am familiar with other reporting tools. My question is, is there really no way to reference a field in a page header If so, I suppose you could repeat some header information on subsequent pages from the detail section of the report using a text box, but how is that done because when I check the property box "Repeat report item with data region on every page" nothing happens. What is the best way to ...Show All
AIMDBA SQL Server Management Studio
This question has been asked and discussed in other threads/forums but I couldn't find a simple and definite answer. My problem is why after installing SQL Server 2005 Express through a command prompt, SQL Server Management Studio was not installed. I have tried using the following: ADDLOCAL=All and ADDLOCAL=Client_Components but the Management Studio was nowhere to be found. These are the commands that I used: 1. setup.exe /qb INSTA ...Show All
bignack Trouble with OLEDB Data Source
A little background first. I have a header table and a detail table in my staging area/ods. I need to join them together to flatten them out for load. The Detail Table is pretty deep - approx 100 million rows. If I use the setting (table or view) and set the table name (say, the detail table), the package starts up nicely. But if I switch the OLE DB Source to using a SQL Statement and then join the tables in the SQL, then the Pre-Execute phas ...Show All
JodyT Upgrading replication environment
Hi There Ok i have a publisher, remote distributor and subscriber all SQL2000. Now i need to upgrade this environment to 2005, i know that i have to upgrade the distributor first but what effect does this have on the replication that is busy running That is will all publications and subscription continue to work What happens during the upgrade Are the log reader and distribution agents stopped. What happens when the distributor is upgraded can i ...Show All
Mok4402 Concatenating column values for each uniqueid
I have a table like this. OrderId QueueId Template Subject RecdDtim SentDtim 1 1 TEM1 Sub1 11/3/2005 8: 10:10 11/3/2005 9: 00:15 1 2 TEM3 Sub2 11/3/2005 10:25:45 11/3/2005 10:40:35 2 3 TEM1 Sub2 11/3/2005 11:45:35 11/3/2005 12: 00:00 1 4 TEM2 Sub3 11/4/2005 10:25:00 11/4/2005 10/30:00 2 5 TEM3 Sub3 11/4 ...Show All
Roco72 SSIS Requests...
May be it's too late, but I think this requests could be scheduled at least for a SP1 if it's not possible for the RTM. 1) Execute Task without debugger: it would be very nice to be able to execute a single task without going in debugging mode. Just as you would ask "Start Without Debugging CTRL+F5" but for a single task 2) Customize default properties for task and component: when you drag a task on the package you get a default value for the ...Show All
Mark Storen How to create trigger to check column in any inserted record
How can I create a trigger to watch a couple of field values in each insert that happens on my table and peform an if statement on those values then replace those values with another value if the statement is true also, I am not sure whether to use an AFTER or INSTEAD of to accomplish this. What I want to do is essentially: Create trigger triggername on tablename watch for any insert o ...Show All
davidb64il Simple convert question!
Hello all! Never did a convert, I been looking for samples but I don't quite get it. I get this error message in my vb.net app, Taking a number value from a textbox, adding it to a table, with a money field. "Implicit conversion from data type money to nvarchar is not allowed. Use the convert function to run this query" Here is the SP it's pulling, CREATE PROCEDURE dbo.AddWg (@UserID NvarChar(50), @Credits Money) AS IF EXIS ...Show All
Daniel E. marx Adding Subreport Total to Main Report Total
Hi, can anyone help I have created a Report using Visual studio-the report displays a subreport within it. On the Subjective Report I have 12 values for each month of the year. For the first month the value is =sum(Fields! Month_1.Value) , and I have named this text box ’ SubRepM1 ’ The name of the subreport is ‘ subreport1 '. On my Main Report, again I have 12 values for each month of the year. For the firs ...Show All
Steve4125 Transferring SQL Server environment completely to a new server
We had a raid controller go belly up on one of our SQL Server boxes. The emergency fix performed by our LAN team was to pull the drives and pop them into a temporary server. This worked, but I now need to transfer that entire SQL environment to a newer, more capable server. The required outcome is to end up with the server environment reproduced on the new server with the new server having the same name as the old (name of the old server will, o ...Show All
Mustang SQL Server memory leak
I was doing a quick test with SQL Server Express and noticed that there is memory leak Here is the pseudo code do loop //1000 times { 1. Open connection to the database 2. Build SQL statement 3. Construct SQLDataAdapter 4. Fill DataSet using ( adaptor.Fill(dataSet); ) 5. Close connection to the database 6. Dispose whatever is disposable } When I ran this test I saw that SQLServer service memory usage is going up ...Show All
Andre.Ziegler Could not find stored procedure 'msdb.dbo.xp_sqlagent_notify'
I have started getting this new error after installing SQL 2005 service pack 1 whenever I start the SQL agent : Log SQL Agent (Current - 6/5/2006 12:28:00 AM) Message [298] SQLServer Error: 2812, Could not find stored procedure 'msdb.dbo.xp_sqlagent_notify'. [SQLSTATE 42000] (DisableAgentXPs) I don;t see any problems because of it but would like to fix it because it is an error and might be affecting something I don't know about. Thank ...Show All
Ian L SQL Server Mobile - Latest Version?
Hi, I've had troubles in the past with this bug - http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=158671&SiteID=1 - where 'join's with 'order by' did not work correctly. So is there a new version where I don't need a workaround and if yes, where is this version available The latest version I know of is 3.0.5214.0, but in the meanwhile SQL Server 2005 SP1 had been released so I did remember that there is this open bug in SQL Server M ...Show All
Clifflane Problem with non-standard dimension
I am very new to Analysis Services and have a problem that I don't have any idea on the direction to go or where to look for the answer. I have included a very simple example of the tables to hopefully explain what I am trying to do. I have a WIP billing table that is used as my Fact Table. I am using the Adjustment column for my measure. I have three dimensions "Region by Employee", "Region by Client", "Service Code". The different reg ...Show All
iotaomikron333 Replication error with sqlserver mobile:A request to send data to the computer running IIS is failed, see Hrresult"
I have smilar kind of an issue with replication. I had sucessfully done replication with Sqlce2.0 on sql server 2000. In development machine I had VS 2003, sqlce development tools. Now I use the same code done in VS 2003 into VS2005, it sucessfully converted the code. In server machine (win 2003) I installed sql server 2000, sql server 2000 service pack 4, SP4 merge replication components, sql server 2005 mobile server tools and ...Show All