SQL Server

Page 4824




  • Topics
    Replies
    Last post
  • Can I retrieve a result set from a sp into a variable within a Execute SQL Task?
    by agentf1
    14 Replies
    Last post by Phil Brammer
      • Can I retrieve a result set from a sp into a variable within a Execute SQL Task
  • Creating Stored Procedure in SQLServer2005
    by Sirenetta
    7 Replies
    Last post by Lisa Nicholls
      • I have been using SQL Server 2000 and creating Stored Procedure. I need these Stored Procedure to create Reports in Crystal Reports. In SQL Server 2000: it is very simple to create a stored procedure: Go to Enterprise Manager->Databases-> Choose a database-> stored procedure->New-> Simply Add to the following syntax: CREATE PROCEDURE [OWNER].[PROCEDURE NAME] AS GO My pro
  • Help with modifying a data source's query at runtime
    by Donny Ma
    2 Replies
    Last post by Bob Bojanic - MSFT
      • Please help figure out what is wrong with my code. The script is supposed to load a package (from file). The loaded package already has everything set up to run a query against a local server and output the results to an Excel file. The reason for the outer script is because I need to change the query based on a global variable. When the query changes, though, I think the existing dataflow Path is
  • Two Dimensions Sharing same Parent Table
    by Joao Cruz
    5 Replies
    Last post by Joao Cruz
      • Hi, I have a serious problem when I explore my Dw Model. I have one Fact table and Two Dimensions: Brand Dimension and Department Dimension. Both Dimensions share at Top Level Company Attribute. The Schema is like this : Brand Dimension : Brand (Brand Table), Brand Group(Brand Group Table), Company (Company Table) Department Dimension : Department( Department
  • Can't shrink DB
    by Yossi Pelech
    5 Replies
    Last post by Yossi Pelech
      • Hi, The DB size (MDF) is getting too big, sp_spaceused returns: reserved data index unused 1418656 KB 250168 KB 1408 KB 1167080 KB I've tried both SHRINKFILE and SHRINKDATABASE with all types of options. The DB designed on SQL 2000 and ported to SQL 2005 EXPRESS, I've laso used DBCC UPDATEUSAGE. Any ideas Thanks, YP
  • Reporting services in SharePoint integration mode problems
    by MikeN123
    0 Replies
    Last post by MikeN123
      • Hi, I'm having problems setting up Reporting Services in SharePoint Integration mode. The development environment works fine, but I can't get it to work in production. Problem seems to be in the authentication between SharePoint and Reporting Services. When I go to "Set Server Defaults" in the SharePoint central administration I get the following message: Co
  • Recursive Query Without Self-Referencing Structure
    by SeanAleks
    2 Replies
    Last post by SeanAleks
      • I need a statement that can return a hierarchy of folders. There are a number of good articles out there describing how to do this in SQL 2005 with a Common Table Expression (CTE) that references itself under a UNION ALL. Yet every example I come across involves a self-referencing table. Unfortunately the architect of my project did not use that simple structure. Instead, we have a Folder table an
  • c# reusing parameters
    by marric
    2 Replies
    Last post by marric
      • I have a select statement which requires numerous parameters. here is a snippet. SqlCommand cmd = new SqlCommand("SELECT this from MyTable WHERE Answer1 = @Att 1AND Answer2 = @Att2 AND Answer3 = @Att3", connection) my parameters are added as follows. SqlParameter Att1 = new SqlParameter("@Att1", SqlDbType.VarChar, 50); Att1.Value = Attributes1; cmd.Parameters.Add(Att1); and so
  • allocation problem/disk space disappears when processing cube
    by mobigital
    9 Replies
    Last post by mobigital
      • Preston M. Price wrote: I get this error while processing my cubes: Error: Memory error: Allocation failure : Not enough storage is available to process this command. There is plenty of space left on the hard disks on this machine, I can't find a remedy for this problem on Google either. Any help would be appreciated. Thanks in advance. I am seeing the same dis
  • searching a Unicode data within a Image data type
    by HarshalChoksi
    11 Replies
    Last post by HarshalChoksi
      • How to Searching a unicode data if we have Image Data Type within our SQL Server 2000. Hi, I have the problem with to finding a data from Image Data type using Full Text Catalog if i have some unicode data to find. so tell me solution to applying a Full Text Catalog to Image Data type which contains some Unicode value. waiting for your response soon. i have to find some &qu
  • SQL 2005 32-bit vs 64-bit guidance
    by SQL 2k5 Newbie
    1 Replies
    Last post by Arnie Rowland
      • What some good reasons to select 64-bit rather than 32-bit for SQL Server 2005 We are preparing to install a very large SQL Server 2005 cluster. Initially, the primary database is estimated at 1 Terabyte, with 5 more databases that will add up to another Terabyte. After a few years, the estimate jumps up to 20 Terabytes for the largest DB and another 20 for the other five, combined. We've ma
  • Setting a filter in the SELECT-statement
    by Cactus77
    4 Replies
    Last post by Cactus77
      • Is it possible to set a filter in the SELECT-statementpart Normaly you the filter is set in the WHERE-statementpart, but that is too late for me in my statement. Right after the SELECTing the field I want to set a filter to the query Is it possible My statement looks like this now: SELECT [DatabaseName$Item].No_, [DatabaseName$Item].Description,
  • ADO Error: an insufficient number of arguments....
    by EssCee
    10 Replies
    Last post by EssCee
      • Im currently using Access 2000 which is connected to a SQL database. I have a query (Or View) that runs every month. The problem i had was i had to manually make some changes every month to get to the data i needed so i changed this View into a Function with a parameter so i can input the detail(s) i need and it will run correctly - this works so far but the original View was also used within othe
  • Installing SQL Server 2000 SP3a
    by IamTheo
    5 Replies
    Last post by kelv1979
      • I got this mess ag e from Backup Exec for Windows Servers Environment Check 1.0 for SBS1 QUOTE An instance of Microsoft SQL 2000 was found that is not updated to Service Pack 3a. An instance of Microsoft SQL Server was found that is not updated to the correct service pack. Using this SQL Server instance with Backup Exec may cause errors. To install Backup Exec successfully, upgrade this
  • Bookmark in Code not working.
    by BigGuy
    1 Replies
    Last post by Ian Michael Clark
      • I have a report in reporting services that has a bookmark value asigned to each row. In the following Page_Load event for the page, I'm getting the following error on the ReportViewer1.JumpToBookmark("6") statement: "An exception of type 'System.InvalidOperationException' occurred in Microsoft.ReportViewer.WebForms.dll but was not handled in user code Additional information:
  • Slow Running Insert After Changing OLE DB Destination Data Access Mode
    by cdun2
    14 Replies
    Last post by Rafael Salas
      • Hello, In a Data Flow Task, I have an insert that occurs into a SQL Server 2000 table from a fixed width flat file. The SQL Server table that the data goes into is accessed through an OLE DB connection manager that uses the Native OLE DB\Microsoft OLE DB Provider for SQL Server. In the OLE DB Destination, I changed the access mode from Table or View - fast load to Table or View because I nee
  • SQL Server Assertion ERROR
    by Kamath Vikram
    6 Replies
    Last post by SedonaMan38
      • We have a browser based application that is doing some updates on the database. This app was earlier built to run on SQL server 2000 and we are in the process of migrating to SQL server 2005. Until now the application was seamlessly working on the new SQL server 2005 database. I got the following error message on the web when an item was clicked on the web that triggered a set of database updated
  • Management Studio -> Could Not Find Function xp_msver in library xplog70.dll
    by JustinK101
    8 Replies
    Last post by JustinK101
      • Hello, When I click into Microsoft SQL Server Management Studio Express and login with windows auth and right click the top of tree, the acutal SQL server instance name, and click properties I get the following error. http://www.ftoperations.net/screen_shot.jpg Any ideas what is causing this Everything else works perfect in Studio Express, and am able to view tables, stored pr
  • SP2 Calculated Member Issue
    by BobP - BIM
    1 Replies
    Last post by Jeffrey Wang
      • I have had this calculated Member for over a year, when I applied SP2, I am returned an error. I have looked on MSDN for something that would indicate what the change was, but cannot find it. Here is the MDX: Case When IsEmpty( [Measures].[Loan Amount] ) Then 0 Else ( [Product].[All] * [Channel].[All] * [Date Closing Funded].[All] * [Loan Status].[Status Rollup].&[Closed]
  • about database and table protect
    by alphais
    4 Replies
    Last post by alphais
      • hello, We wrote an erp,and provide a platform to participator to extend my erp system,so I will give my participator database dictionary,but I only want to give partial database dictionary,I will hide some table and some field, I want they cann't open the database thouth sql server management studio or other tools,only can using our interface to access database,how can I do -- I use sql se
  • Database Mirroring. Asp application (IIS 6.0) does't forward connections to mirror server
    by Sergey P
    7 Replies
    Last post by sajh
      • Hi! I have setup a database mirroring session without witness - ServerA is the principal, ServerB is the mirror,. Each SQL Server instance is hosted on its own machine on sql2005 EE SP2. The mirroring is working correctly. If I submit to server ServerA command: ALTER DATABASE MYDBNAME SET PARTNER FAILOVER , ServerB becomes the principal, it means that mirroring works correctly.
  • SQL2005 C# connection problem
    by RussC_UK
    1 Replies
    Last post by Jens K. Suessmeyer
      • When attempting to connect to a SQL2005 database using Visual C# Express edition I receive the following message: The user instance login flag is not supported on this version of SQL Server. I do not have this problem when using SQLExpress
  • how to design queries graphically?
    by Liquidloop
    5 Replies
    Last post by Chris Howarth
      • Are there anytool, which would allow me to design queries graphically, if not design then atlease analyse them graphically. Tool should atleast show join of 4tables graphically. Thank You.
  • ASP: error when trying to insert record
    by dbecca
    6 Replies
    Last post by vinoth kumar.R
      • I receive the following error when trying to INSERT INTO; am using Access db. Microsoft OLE DB Provider for ODBC Drivers error '80040e07'[Microsoft][ODBC Microsoft Access Driver] Data type mismatch in criteria expression. The code is as follows: <% Dim dbConn set dbConn = server.CreateObject("adodb.connection") dbConn.open("connect") dbConn.Execute("INS
  • insert into exec distributedprocname
    by mflancour
    7 Replies
    Last post by mflancour
      • There must be some workaround for this. I need to grab the data from a stored proc on another server and place it into a temp table. I do not have the option to change the proc. help if you can.