SQL Server

Page 4905




  • Topics
    Replies
    Last post
  • ReportQuryParameter' missing Help me
    by polachan
    0 Replies
    Last post by polachan
      • Dear , Please help me o to pass parameter value thru report builder to get drill thru from report1 to report2. I done the following ways 1. Type LocalHost/Reportserver 2. Take report builder and created two reports ie, report1, report2 3. Created drillthrough with Sql server management studio for datasource in the model in report2 4. After that when I run the report , the
  • Converting Array into table in SSRS
    by Tess88
    0 Replies
    Last post by Tess88
      • I am getting a array (multiple columns of similar information) from my Oracle stored procedure and need to put that in a table. I think I may to write some code, and I am no expert, any thought. Thanks
  • Having trouble installing SQL Server 2005 SP2
    by Judy W
    10 Replies
    Last post by Judy W
      • I tried the hotfix listed in the "Unable to install SQl Server 2005 SP2 - Unexpected error" thread and it did not work. Something I'm running into that I haven't seen here is I cannot install or uninstall anything at all. I am getting a message that says I'm still in the process of installing something, please finish that first. I assume it is the install of SQL SP2. Here is the log file
  • Rolling up a Dimension Property
    by gnieboer
    10 Replies
    Last post by gnieboer
      • I'm reasonably new to MDX, and am trying to create a calculated member for MTBF (Mean TIme Between Failure) (I've simplified the below scenario to keep it straightforward) The basic equation in my scenario is: (Time * Quantity Installed) / Failures My current Calculated Member is this: IIF([Measures].[Count of Failures] = 0, NULL, ( (IIF([Item Codes].[Item Code].C
  • SSIS Package step errors and logs from SQL Job Agent?
    by JCNET
    6 Replies
    Last post by JCNET
      • I've deployed an ssis package to the database server through the manifest file over the network.. The package runs great when testing through vs.net on my client. I've added the package to a job step in the sql server job agent. When I test the new job, the package step fails, but there is no error or log information in the job history. Wwhere can I get error informatio
  • Queries going to Suspend state with wait type ASYNC_NETWORK_IO
    by knvdssr
    5 Replies
    Last post by oj
      • Recently we observed a problem. We are running stored procedure through our c# code. Three machines access the server and update or insert in the required tables in the server. If there is no data in the server, on installing first time our application usually our database is clean. then stored procedure works fine, it takes around 10 to 15 sec to execute. Next time if execute the time goes up to
  • How to migrate updated data alone?
    by swan_sg
    5 Replies
    Last post by swan_sg
      • Hi, Can anybody pls help me with this, i have to migrate data from one sql server(1) to another sql server(2) using SSIS,Which is a bit easy,the concern here is that after doing it the data in server(1) is getting updated due to inserts,now i need to bring the updated data alone.Is anybody having experience in this can anyone pls help me or give me sugessions on how i need to proceed.
  • Restoring a backup of a Subscriber database to a new database
    by Tim Ward
    6 Replies
    Last post by CTS_Dba
      • I have a Subscriber database updated using transactional replication and want to create a copy for development & testing. The Distribution database is running on the same 2005 instance as the Subscriber and the Publication database on another server running SQL Server 2005. If I use a TSQL script to run the restore, the database is restored to a usable state but I get the follo
  • What is CUBE and ROLLUP???
    by prashant_victory
    4 Replies
    Last post by Louis Davidson
      • Hi, Can anyone explain me that WHAT IS CUBE AND ROLLUP Statments for Why to use, Where to use and When to use Are they usefull in any point of view from ADO.NET
  • Renamed computer and connected to sql server without problem...
    by Ach25572
    8 Replies
    Last post by SanG_123
      •   I have read that if I change "computer name" and then try to startup sql server it will recognize the changes automatically BUT you need to execute sp_dropserver and sp_addserver procedures too in order to set all thing right.But yesterday I tried it on a Personal edition on xp and after reboot sql server came up without any problem and I could connec it without executing sp_dropserver and
  • I've got a SQL database and I need to see what the data it looks like
    by Charlie Gallie
    2 Replies
    Last post by Jens K. Suessmeyer
      • Is there a program like Access that can open a SQL database and display the information
  • How to get Report in text format in SSRS?
    by Virendra Wadekar
    14 Replies
    Last post by Lisa Nicholls
      • Hi, Can aybody help me in the below requirement. I have a report like below: <<Name Of Compnay>> <<Name Of Report>> <<Todays Date>> <<ReportPeriod>> From Date - To date The above is header and then the data in the report should come as the <<Data>> and # to be used as separator for co
  • Reporting Services not showing in central admin
    by GryphonsClaw
    1 Replies
    Last post by Prash Shirolkar - MS
      • I downloaded and installed SQL Server 2005 SP2 update on my reporting services server. I think downloaded and installed the share point reporting services admin to my share point dev server. I open up the central administration and there is no reporting services menu option under the Application menu. The sharepoint server is a farm with backend database on one server and all the web apps on the o
  • use SQLCMD with tempdb #table?
    by barkinglily
    1 Replies
    Last post by Madhu K Nair
      • I am currently using XP_cmdshell to execute sqlcmd, extracting a table query to an output file. Is it possible to reference a temporary table for extraction in the query If so, what is the correct syntax I currently have it working with a regular table, but would prefer to use a temporary one instead. SELECT @cmd = 'sqlcmd -d studio_2007 -Q "SET NOCOUNT ON SELECT cmdStatem
  • Script component - column iteration within
    by Phil Brammer
    12 Replies
    Last post by Phil Brammer
      • I have a synchronous script component and have added 5 fields to the output (field1, field2... field5). Can I iterate those fields In sudo language, I'd like to do: Code Snippet Public Overrides Sub Input0_ProcessInputRow(ByVal Row As Input0Buffer) dim i as integer = 1 while i < 6 row.field[i] = "somevalue: " + i.ToString end while end sub Somehow, I'd like to
  • Report Manager Virtual Directory
    by TomFrancis
    13 Replies
    Last post by Amit kr mishra
      • I am trying to configure the Report Manager Virtual Directory but cannot do it. In the Configure Report Server screen, the option is greyed out (there is a tick next to it to say that it has been configured, but this is greyed out too)! Any ideas Thanks Tom
  • Data flow based on a DSV
    by JBlad160907
    13 Replies
    Last post by JBlad
      • Hi, I've got this feeling that something is missing in Integration Services. You can add a DSV in any Integration Services project, but you can't use it inside a data flow. Can someone please tell me why this is Let me explain why i want this: In Dynamics AX you've can make perspectives. These perspectives are a combined set of tables. From these perspectives you can automatically de
  • Headers and Groups
    by sarolabelle
    7 Replies
    Last post by sarolabelle
      • How do I put information only at the top of a page and have it change whenever a group occurs. I want to do something like this. Have this on the top of every page: Country: current country State: current state City: current city There is a group on country, state and city. Whenever city changes the next page will display a new city. Whenever state changes the next pa
  • Setup question: ASP.Net Version Registration Requirement warning message
    by Eric George
    9 Replies
    Last post by ScoutFu
      •   Hi there, I have only this warning message during the System Configuration Check: ASP.Net Version Registration Requirement (Warning) Messages ASP.Net Version Registration Requirement 64-bit ASP.Net is Registered. Required 32-bit ASP.Net to install Microsoft Reporting Services 2005(32-bit). Does this mean that I can't install Reporting Services or should I pay no
  • Communiation Link Failure
    by DStevic
    2 Replies
    Last post by wesd
      • I haev an ssis package that copies mulitpple tables from one sever to another. Halfway thru one of the table copies i get: [OLE DB Source [1]] Error: An OLE DB error has occurred. Error code: 0x80004005. An OLE DB record is available. Source: "Microsoft SQL Native Client" Hresult: 0x80004005 Description: "Protocol error in TDS stream". An OLE DB record is available
  • restoring 2005 backup with 8.0 compatability mode on 2000 - help
    by JohnCampbell
    2 Replies
    Last post by Madhu K Nair
      • Hi, I have a database that is in the SQL Server 2000 compatability mode on my SQL 2005 server. I am trying to restore a backup of this database on my SQL Server 2000 database on another server and keep getting strange messages. First trying Red-Gate and then plain SQL Server with no luck. It seems as I remember that the 7.0 and 2000 compatibility issue between backups did not arise when the
  • Update Records
    by netgame
    1 Replies
    Last post by Jens K. Suessmeyer
      • Here is my question if anyone can help... I have two tables Table 1 EmpName PolicyNumber Table 2 EmpName PolicyNumber NewEmpName I would like to update Table 1 with the data from Table 2. Here is my problem..Lets say that I have two records in Table 2 that have the same policyNumber but two different NewEmpNames, it only takes the first. In other
  • Bring File In As Binary Field
    by 1Dave
    7 Replies
    Last post by Phil Brammer
      • I want to have an SSIS package that processes a file in the normal insert, update style. But at the end I want to store the file as a binary field to another table for archive purposes. I am having trouble finding a good way to do this. Any samples, ideas, or articles would be appreciated.
  • moving data from one DB schema to another DB schema using SSIS
    by Vita
    2 Replies
    Last post by Vita
      • Hello, I would like to use SSIS tool to move the data from one database schema to another database schema. For example: Source table has 1. UserName (varchar 20) (no null) 2. Email (varchar 50) (can be null) Destination table has 1. UserID (uniqueidentifier - GUID) 2. UserName (varchar 50) (no null) 3. EmailAddress (nvarchar 50) (can be null) 4. Da
  • Failure exporting configuration file in SSIS
    by PietHuynen
    4 Replies
    Last post by phuynen
      • Hi, the message below is generated when I try to generate an SSIS configuraiton file. The link does not provide any help. Do you have any suggestion what could cause this error Thanks, Piet ========== TITLE: Microsoft Visual Studio ------------------------------ Could not complete wizard actions. ------------------------------ ADDITIONAL INFORMATION: Could not ge