SQL Server

Page 3023




  • Topics
    Replies
    Last post
  • SQL Server 2000 and ASP.NET connection problem
    by any_student_2007
    6 Replies
    Last post by any_student_2007
      • Respectde Friends, My aspx page is trying to connect to a remote server with SQL Server 2000 installed on it, the ip of the server is 172.16.3.111 and the same is the instance of SQL Server, sql server is running in SQL Server Authentication mode, user id is "test" and password is "test123", name of database is myDB,the connection string which I am providing is as follows:
  • sql server security problem...
    by michal554253
    2 Replies
    Last post by michal
      • Hi All! I have created a package, and now want to deploy it as a sql agent job. I have: -Set the security protectionlevel to "don't save sensitive" -saved a copy of the package to the sql server (using sql server authentication with 'sa' username and password) -Created a new job on the sql server - name is 'test' - owner is sql1 -added a step -type is Integration services package
  • Combining Output PDF files
    by Brad Corbett
    4 Replies
    Last post by Brad Corbett
      • Is there a way to output reports to the same PDF file. Basicly Appending several reports to the one PDF.
  • Measure Weirdness
    by JohnBGood
    0 Replies
    Last post by JohnBGood
      • have a measure that is a running total based on a formula: SUM({NULL:[Time].CurrentMember}, [Actual Work] / [Estimated Work] * [Planned Cost]) When this measure is rolled up for all time (for example 2007) the calculation is correct. For individual weeks or months, the calculation is not correct. See any issue here
  • SQL2005 SP2 Dec CTP Sharepoint AddIn install problem
    by Martin00
    9 Replies
    Last post by Martin00
      • Hi, I've installed the Dec CTP of SP2 on a Windows Server 2003 SP1 virtual machine. Sharepoint and SQL2005 are running on the same machine. It currently has 1GbRAM allocated. I configured the Report Server to use a Sharepoint integrated report server database. (Missed this first time round). Then I installed the SharepointRS.msi. I see no sign of the Reporting Services section in C
  • Reporting Services Instance not found
    by SQLChamp
    5 Replies
    Last post by Dathendra
      • Hi, I am getting the following error - "Report Services instance could not be found".  However, from services, I am able to start and stop SQL Server Reporting Services.  I get the error when I try to connect to Reporting Services from Management Studio.  I am using Sept CTP.  How do I verify that I have this installed correctly   From the folder structure, I'm seeing MS
  • SSIS - Several Bugs in creating a simple task
    by Robert F Bouillon
    7 Replies
    Last post by Jamie Thomson
      • I was creating an SSIS package, seemingly simple. One of the tasks I needed to do involved copying our production database to a seperate DB instance for staging. I wanted an SSIS package that would stage production so we could push and test changes. My first problem is that I tried to create a simple Transfer Database task. When I tried to run the task, I got an error stating that our Stored Pr
  • The SELECT permission was denied on the object 'tblName', database 'dbName', schema 'dbo'
    by LeeCripps
    2 Replies
    Last post by LeeCripps
      • Hi, I'm in need of a few more pointers when it comes to SQL Server 2005 Security setup for accessing a database through IIS web services. There's loads of great advise in these forums which I've followed so pls forgive me if I've missed a post that finally resolves this. I know I'm so close but it feels so very far... Anyhow, here's the set up: - Server 2003 / SQL Server 200
  • Substring and Patindex having an User Defined Function
    by MannuBhai
    1 Replies
    Last post by MannuBhai
      • Hi All, Can we use the SUBSTRING or PATINDEX function with a User Defined Function as one of the parameters Something like this: Code Block Select SUBSTRING ( Select * from DB.dbo.Function( 'Parameter' ), PATINDEX ( '%\%' , Select * from DB.dbo.Function( 'Parameter' ), 8) Mannu.
  • Why was ReadWriteVariable not populated/updated with a value of the dynamically generated string?
    by qluo
    5 Replies
    Last post by qluo
      • Hi, I have a script task in SSIS which dynamically generates a string for a file name to be used as flat file source. I execute the task and it executed with success; but when I checked the result of the variable TotFileName from the Expression builder window for the flat file connection manager it was not populated with a file name like \\MyServer\MyDrive\MyFolder\200706daily.txt . So something m
  • DTS Code works only with VS 2003 but not with VS 2005 ?
    by GeeMann
    2 Replies
    Last post by GeeMann
      • Hi; I wanted to use the following code to run a DTS package from a 2005 Web Page code behind partial class. This code works fine in a VB 2003 module going against  SQl Srvr 2000. Here is the code: (It initiates from a button click handler) Dim conn As New SqlConnection( "initial catalog=MY_Data;server= XYZ081552X7X441\TRSQL;integrated security=SSPI" ) Dim hold1 As In
  • i want know the difference between "SQL Server 2005 -Std Edition" and "SQL Server 2005 Std license"
    by anandh
    5 Replies
    Last post by Arnie Rowland
      • hai to all, i want know the difference between "SQL Server 2005 -Std Edition" and "SQL Server 2005 Std license" can any one tel regarding that.
  • Report Definition
    by DotNet_Guy
    3 Replies
    Last post by DotNet_Guy
      • Is it possible to control the number of table rows that can be displayed by modifying the report definition
  • Access To Dts.Variables Causes Exception
    by GianniBrasco
    1 Replies
    Last post by Karunakaran
      • Hey all...I'm pretty new to SSIS packages and things are coming along nicely. My problem is accessing variables in script tasks. I've created two variables (package scope, strings, readonly = false) - aDetailFiles and strDetailFile Within a Foreach Loop I loop through a folder. I've added a script task and within that I try the following: Dts.Variables("User::aDetailFiles").Value = Dts.V
  • Property DefaultSchema is not available for Database [DatabaseName]
    by Gilles Lafreniere
    14 Replies
    Last post by Dalmuti
      • We're using Windows Authentication with our SQL Server.  We've added a domain group to the SQL Server groups and would like to give it a default schema.  The properties window is the same for users and groups but the default schema field is enable only for user entities.  We cannot add a default schema to a group.   Is this by design,  a bug or a proble
  • Cannot insert duplicate key
    by Dan Crowell
    5 Replies
    Last post by Danny Crowell
      • I am using SQL Server 2000. I have a table (tbDupes) with duplicate records. I want to populate another table (tbUnique) with unique records. My tbDupes has about 50 columns and three of them make up my primary key in tbUnique. I thought I could get unique records by using the following SQL statement. Code Snippet INSERT INTO tbUnique SELECT * FROM tbDupes I rec
  • RS Integration with SharePoint 3.0 - Query with userid parameter
    by M.P
    1 Replies
    Last post by Jens K. Suessmeyer
      • When integrating SQL Reporting Services 2005 with Sharepoint Services 3.0, and you have a SRS report that runs over a view with the UserID as a parameter (to filter the records the user has access to), will the SharePoint ReportViewer passover the UserID to RS and RS to SQL Sharepoint security with Reporting Services stops at Item level or does it impersontate down to SQL Should authenticating
  • SQL 2000 - All Client Tools
    by IRShenton
    2 Replies
    Last post by IRShenton
      • I've been asked to buy a license for the above. I've had a look on the net for this and I'm not sure if I'm being thrown a spanner. Does anyone know if this is just a generic term for several client tools for SQL 2000 or is this actually a component / product I can/could have bought thanks for your help
  • Printing in Reporting Services hangs
    by VPDJ
    14 Replies
    Last post by CodingVeteran
      • Please Help!!! We have never been able to get the printing to work on any of our reports using SQL Server Reporting Services 2005 SP2 in our production environment. Without this feature of printing a report, we cannot go live with SSRS at all. We have tried adding the SP2 after a clean install on a new server -- yet we still have this problem. I read a few some posts about uninstall the old Active
  • SUM in Report
    by Leandro Rodrigues
    4 Replies
    Last post by Leandro Rodrigues
      • I need to do a function in my report, i'm trying use =Sum(Fields!FlagPresents.Value) but it sum all value in my table, i need some how =Sum(Fields!FlagPresenca.Value = 1), i want that when my value = 1 then sum, but i don't know how i can do it. Help me please. Thanks a lot!
  • Failed to load expression host assembly. Details: The type initializer for 'CableReporting.Utilities' threw an exception
    by Apurv1301
    3 Replies
    Last post by Apurv1301
      • Hi I am using sql reporting service 2005 with .NET 2.0. I have created a custom dll file for report and put this dll in appropriate folder. Report is running fine in designer project. but when I am trying to view this report after uploading to report manager it give me an error like Failed to load expression host assembly. Details: The type initializer for 'CableReporting.Utilities' threw an
  • Could not create Maintenance Plan
    by Markus Fritz
    14 Replies
    Last post by Daveko
      • Hello, if I try to create a Maintenance Plan from my local workstation I get the following Error Message: TITLE: Microsoft SQL Server Management Studio ------------------------------ The action you attempted to perform on a remote instance of SQL Server has failed because the action requires a SQL Server component that is not installed on the remote computer. To proceed, install SQL Server 2
  • Cascade Issue
    by ITTECH123
    3 Replies
    Last post by Dimitar Bosevski
      • By: IT In: microsoft. public. sqlserver. programming I have 2 tables A and Table B respectively: Table A: SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[aa]') AND type in (N'U')) BEGIN CREATE TABLE [dbo].[aa]( [aa1] [int] NOT NULL, [aa2] [int] NULL, [aa3] [int]
  • An error occurred during local report processing. Index was outside the bounds of the array.
    by LowellTurner
    5 Replies
    Last post by LowellTurner
      • I got rid of the .rdl.data files, which apparently has been a successful fix for this problem in the past. Everything worked fine Thursday when I left (I was off Friday - Saturday), but today I get this error for all but one of the reports in the solution when I try to preview the report. BTW, the published stuff works fine. Thanks in advance for any help.
  • Unable to connect to the remote server
    by eralper
    2 Replies
    Last post by BlackStallion
      • Hi, After installation when I browse home page of Reports folder http://localhost/Reports$SQL2008/Pages/Folder.aspx I got the following message Unable to connect to the remote server What have I missed, do you have any suggestions Thanks