Answer Questions

• pavvu_kk Report Builder Matrix

  How can I turn off the aggregate feature for matrix report created in Report Builder (I can do this in Report Designer). I want to show actual dates in the data section of the matrix report not summary counts. Thank you. ...Show All

• Le Sage How to export report to csv without column lables exporting as the first row

  I tried to export a report with no hearders nor footers - just rows(details) - to CSV format, however, the lable for each column is exporting out as the first row in the CSV file. How do I export a report to CSV without the column lables exporting Example of what my export looks like: lable1,lable2,label3_Department 223,John,Accounting 256,Mary,Marketing (I don't want lable1, lable2,label3_Department to show up in my export) thanks, h. You can set the DeviceInfo parameter "NoHeader" to True to suppress column headers when rendering to CSV: http://msdn2.microsoft.com/en-us/library/ms155365.aspx -Chris I am wrong. It is not the header that is showing up in the export. It is the label for the column n ...Show All

• Kim Carlsen Installed SQLServer 2005 TrialEdition

  Hi Fellows, I am really in a fix.I have downloaded the trial version from MIcrosoft site and run setup with named instance. But I cannot find my management console link anywhere. Can anyone help me here . My site is : Windows XP Professional SP2 Installed : SQLServer 2005 180Day Trial Pack downloaded from Microsoft Network. I ran setup from : server directory and also from tools directory. In my programes menu I can only see Configuration Toolsunder which there are three options : 1) SQL Server Configuration Tool 2) SQL Server Surface Configuration Tool and 3) SQL Server Error and Usage Reporting I dont know . I just downloaded the server from MSDN site it was an x86 ...Show All

• Charity_student09 SQL SERVER 2005 ENTERPRISE EDITION installing problem on vista ultimate RTM

  when i was installing   ss2005  i got two warnings: - SQL Server Edition Operating System Compatibility (Warning) Messages SQL Server Edition Operating System Compatibility   I-IS Feature Requirement (Warning) Messages IIS Feature Requirement then in the next step ,there was only one option i could choose(workstation components,books online and develop tools), all the services were grey and not selected ,here 's the log file Microsoft SQL Server 2005 9.00.1399.06 ============================== OS Version      : Professional  (Build 6000) Time            : Wed Dec 06 13:01:54 2006   TJM-PC : The current system ...Show All

• Nightmare_BE File System Task Error - Process in use

  Hi, In the integration services package i'm working on i connect to an excel database and have two data flows which deal with two work sheets in the excel spreadsheet. The data flows do some transformation and then write the data out to a SQL database (two differnet tables). This is all working great however what i want to do once both data flows are complete is to move the directory which contains the current file that is being looped through. At present there is a foreach loop going through a number of directories. I have tried to implement the File System Task object to move the directory but get the following error: [File System Task] Error: An error occurred with the following error message: "The process cannot access the file be ...Show All

• Kevin Dente Dates

  Hi, I have date columns in my tables defined as smalldatetime. How do I perform a Select that will retrieve records with dates equal to the date selected in a calendar control as follows: < asp : SqlDataSource ID ="SqlDataSource3" runat ="server" ConnectionString =" <%$ ConnectionStrings:ReservationsConnectionString %> " SelectCommand ="SELECT [TIM_Time], [TIM_ID], [TIM_Valid_From] FROM [Times] WHERE ([TIM_Time] = @TIM_Time)"> < SelectParameters > < asp : ControlParameter ControlID ="Calendar1" Name ="TIM_Time" PropertyName ="SelectedDate" Type ="DateTime" /> </ SelectParameters > I ...Show All

• deviparimala not seeing report builder button

  I'm not seeing report builder button from the report manager. What could be the problem Thanks in advance!!! You need to add the user to the " System User " Role in the site wide role assignments screen I finaly figured it out!!! How are you logged in your computer If you login using VPN then you probably won't see the button. Try login Citrix through VPN. The System User Role has this option checked by default but you are right in saying that it's specifically dependant on the "Execute Report Definitions" permission. Excellent - now if I can get mine to work! I'm local to our network no VPN at all. :( Okay, so I must be missin ...Show All

• saaniok How to search for a Stored Procedure?

  Hi, Could anybody please tell me how I can search for a stored procedure in SQL Server 2005 I know the name of the stored procedure and I want to find in which database that stored proc is located/stored and I want to see the code of it. (I have all the necessaary previleges.) Please tell me how I can I do this. Thanks in advance. Regards, Ram. Hi, you can check for existance of stored procedure as .. declare @name varchar (100) declare @spname varchar(100) declare cu1 cursor for select name from master..sysdatabases open cu1 fetch next from cu1 into @name while @@fetch_status =0 begin exec ('select * from ' + @name + '..sysobjects where xtype = ''P'' and name = ''' + @spname +'''') if @@rowcount> 0 begin select @name a ...Show All

• JKountouroglou SP1 Install Caused Problems

  Had a couple questions about some Event ID 6702 errors on the server I’ve been getting recently. I can’t seem to find any intelligible information on Microsoft’s site about it; however, I did find this: http://support.microsoft.com/kb/842006/en-us#XSLTH5294121122120121120120 There are no replication partners for all I know on this server. As far as the A records that it wants me to check, when I take a look at dnsmgmt -> Forward Lookup Zones -> DI-COMM.local, there are several A records for all the machines on the network. The support doc is telling me to delete all A records except those corresponding to the actual server. As far as I know, I NEED these A records for the name lookup to resolve to IP. Wh ...Show All

• Enlikil updating automatically an SSAS 2005 cube

  hello to every one. i have a small problem. well in order to create the data source for my cubes i created a relational database (static) by merging 2 databases . i order to do that, i used integration services. my question is how can i update/add data to my cubes automatically do i need to add data to the ralational database by running the application over and over (when the 2 databases are updated), can i do that automatically and update the dimensions and the partitions can i program integration services to look periodically at the two databases and do the update thank you in advance for your answers As part of your SSIS package udating relational databases you can have Analysis Services processing ...Show All

• builtsoftware SQL Server 2005 Mobile edition using server tools

  I have installed SQL Server 2005 Mobile edition and also the server tools. I configured a website to sync with my mobile application. When I go t check the SQL server Mobile agent with this url: http://localhost/MobileTest/sqlcesa30.dll i get a http 500 internal error I am using remote desktop to access the machine, when I am directly on the machine there is no error I get the correct message in the browser "SQL Server Mobile Server Agent 3.0" Is access to the web site via remote desktop a problem jawahar I figured it out - need to use a specific IP address when connected within a Home network -Jawahar ...Show All

• Matt Falzon Specify excel sheet as a configuration property.

  Hi, I'm just starting with SSIS and want to create a reusable package which imports from an excel file which can be specified at runtime. I can expose the filename of the excel file as part of the connectionString property but the sheet is the openrowset property which is a custom property and therefore isn't exposed as part of the external configuration. Does this make sense Is there an easy way to specify the sheet to import at run time Regards, Anthony. Yes please, assistance would be appreciated :) I tried to assign a variable as a value of the OpenRowset property but it didn't seem to want to use it. Regards, Anthony. Anthony, I don't know why you cannot see ...Show All

• nmfl Insert image using clr stored procedure

  I tried to insert a row using a clr stored procedure where a field was a varbinary(max) and the data was a jpg file. The data was truncated to 8000 bytes. A similar T-SQL sp did not truncate the data even though the parameters were identical. With the clr sp I tried varbinary, variant and image for the parameter type. The variant gave an exception. The others worked but the data was truncated. I used sqlpipe.executeandsend. Someone asked elsewhere if the pipe had an 8000 byte limit but was told it had not. Any ideas Thanks, John IMHO, i don't think either of these replies are on topic to the original question, since the original question dealt with a varbinary(MAX) column and effectively a byt ...Show All

• snegidhan in what situations principal database might become unavailable ?

  Is it correct to say in any case exept when data or log file not available pricipal db will be availabe and manual failover could be done only from from principal Refer to ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/udb9/html/00a5fbc0-af53-46a7-bfb1-405b9ad2427b.htm BOL topic in this case for your doubts. ...Show All

• Greg Rotman how can i check date, hour and minutes only?

  I am using this code to insert starttime and endtime. INSERT INTO working_schedule ( id_number , starttime , endtime , created_user , created_pc , created_version , created_domain , created_os , created_workingset ) VALUES ( @id_number , @starttime , @endtime , @created_user , @created_pc , @created_version , @created_domain , @created_os , @created_workingset ) and this code to check for duplicate before inserting.. IF EXISTS ( SELECT id_number , starttime , endtime FROM working_schedule WHERE id_number = @id_number AND starttime = @starttime AND endtime = @endtime ) but it's checking the seconds as well.. how can i only check date, hour and minutes (without the ...Show All