SQL Server

Page 2117




  • Topics
    Replies
    Last post
  • How to Add Reporting Services in Microsoft Dynamics CRM 3.0
    by Subodhs
    8 Replies
    Last post by Hans I.
      • How to Add Reporting Services in Microsoft Dynamics CRM 3.0
  • Accessing Reports on local LAN
    by sidheart
    2 Replies
    Last post by sidheart
      • Hi, My reports are deployed on reporting server installed on my machine. Now i want to access the reports on other machines which are on local LAN along with my machine. When i try to access reports from some other machine browser gives error page not found. Can any one tell me how to do this. Thanks in advance..
  • Express Edition SP2 - How long to wait for complete installation?
    by Matt Kerr
    2 Replies
    Last post by Matt Kerr
      • Just curious if there's a reason why everytime I try to apply the Microsoft SQL Server 2005 Express Edition Service Pack 2 from Windows Update that it will sit at "Installing" and appear to do nothing (no hard drive activity, but the MSI and setup processes are chewing a little bit of CPU time). How long should I give this update to complete I am running a 2-CPU dual-core Xeon 3.0GHz w/ 2GB of RAM
  • LEFT JOIN Conundrum
    by rwerner
    7 Replies
    Last post by rwerner
      • I have, what I think, is a simple query to perform but I can't figure it. Maybe someone can help There are 3 simple tables: tblMain Idx FirstName LastName ReasonID tblReasons ReasonID_R Reason tblOtherReason Idx_R OtherReason tblOtherReason is only used if the user chooses "Other". Then their freeform reason is stored in tblOtherReason.OtherReason. ReasonID is an integer field. It's
  • DMV data lifetime
    by GethWho
    5 Replies
    Last post by Clifford Dibble - MSFT
      • I'm interested to know how long data 'resides' in a DMV - what causes that data to change etc. since they are dynamic views, and not tables, and I'm sure I've queried that, onyl to find that, later, the data is no longer in there. Is it on server restart, or is there a process or something else that defines how I've reviewd the BOL ( http://msdn2.microsoft.com/en-us/library/ms188754.aspx )
  • SSAS 2005. Low performance of AverageOfChildren.
    by Vladimir Chtepa
    3 Replies
    Last post by Deepak Puri
      • Hi I confront with unpredictable performance loss of AverageOfChildren measure. Has anybody confronted with such problem too Query #1. (Fact Table has about 10000 Mio. records. Its an inventory snapshot cube with granularity attribute Day). with member [Calendar].[YQMD].[ 2007 . 01 + 2007 . 02 ] as aggregate({[Calendar].[YQMD].[Month].&[ 200701 ], [Calendar].[YQMD].[Month].&
  • Connect to DataBase
    by Fl&#22
    14 Replies
    Last post by Flávio
      • Could someone help me with this error: "Under the default settings SQL Server does not allow Remote Conections." I have SQL installed in my personal machine and I want to connect to "Local" DataBase.
  • Automatic sync between SQLce and Access
    by Batkuip
    6 Replies
    Last post by ErikEJ
      • Hi, I am converting an old eVB application to CF.NET 2. It's a very simple setup. 1) An Access database sits on the host and has occasional edits applied to it. 2) An application on the PDA with a mirror copy of the Access database (filtered data) and also has occasional edits applied 3) When the user puts the PDA in the cradle the databases get automatically synchronized with each other. Pr
  • Drop all tables in db that have specific name convention
    by kstus
    6 Replies
    Last post by Naras
      • I have 1000's of tables. Some are of the form dbo.VT_2006-10-12. I'd like to drop all tables with the "VT" in the table name. How is the best done
  • Maintenance Cleanup Task¡­¡­
    by Gish
    8 Replies
    Last post by Deepak Rangarajan
      • SQL Server 2005 Standard Edition Windows Server 2003. I have created an ¡®Backup Database Task¡¯ to create the database backups and checked the option ¡°Create a subdirectory for each database¡±. When I add the ¡°Maintenance Cleanup Task¡± I am not getting the similar option to clean the backup files in the subdirectory. Any suggestion on how to solve this I can alway
  • Data Flow Task Stuck
    by Corey M.
    7 Replies
    Last post by Jeremy D.
      • I have a simple data flow task setup... 2 ADO.NET connection managers, each referencing a DSN pointed to a Unidata database. 2 DataReader sources, each using a single ADO.NET connection managers, running a simple SELECT statement from a table. I have a Union All transform setup to merge the data and write to a OLE DB Destination (SQL05 database) When I run the package, each source w
  • sql server 2005 report errors
    by TJ_1
    2 Replies
    Last post by Sean Nie
      • Hello All, I re-installed the IIS and sql server report services. Then I config the sql server 2005 report. After that I run the http://servername/reports . The version of the report server database is either in a format that is not valid, or it cannot be read. The found version is 'Unknown'. The expected version is 'C.0.8.40'. To continue, update the version of the report ser
  • Chart Axis
    by plengski
    4 Replies
    Last post by plengski
      • I created a graph which retrieves value from database.And currently,my axis is in ranged 0-10.But i have a doubt that my value in will exceed my maximum y-axis value 10..My question is, could it be possible that i make my y-axis dynamic Thanks!!
  • Can I make intall Sql Server 2005 as server in XP Professional Edt.
    by backer
    2 Replies
    Last post by Ajmer Dhariwal
      • I am Using Sql Server 2005 and XP OS Can i use sql server as a server by xp, if yes how pls help thanks in advance
  • xquery query path without elements
    by lkh
    4 Replies
    Last post by lkh
      • The Demographics xml data type column in AdventureWorks. Sales . Store contains the row sample below. How would I write the path for Demographics.query() to retun all rows with AnnualSales >=300000 I'm using variations of this statement but can't find an example of a path without elements. SELECT demographics . query ( 'declare namespace AWMI="http://schemas.microsoft.com
  • New to sql server 2005
    by Donald Allan
    3 Replies
    Last post by Donald Allan
      • Hi there.. I would like to ask help on what's wrong with this T-SQL I wrote. Its seems to have no problem with sql server 2000 when using visual basic 6 as front end. But problem arises when I migrated to C# 2005 and SQL server 2005: This is the exception: " The ROLLBACK TRANSACTION request has no corresponding BEGIN TRANSACTION " C# code calling the stored procedure: public void SaveBra
  • SQL Server Management Studio problem
    by BertinL
    2 Replies
    Last post by SQL Guru
      • Hi, i got a problem for which a question has already been raised but closed without solution (or working solution). When i launch SQL Server Management Studio i receive 2 times a "Package ' Microsoft SQL Server Management Studio Package' failed to load. i've already resinstalled SQLTools90 but without any impact or event reapply sp2. Someone has an idea
  • HELP - cannot use "dynamic" Connection String with Excel?
    by sadie519590
    12 Replies
    Last post by jwelch
      • This method has worked beautifully for all my SSIS pkgs thus far. Basically, I use a Script Task to derive the name of the newest file in a local directory. Then I save the name of the file to user a user variable, e.g. User::File. Then, in my flat file properties > Expressions, I set "ConnectionString" to reference User::File. However, when attempting to use this
  • Using User Defined Function in Execute SQL Task within Foreach Loop
    by Racsco
    4 Replies
    Last post by Racsco
      • hi I am trying to execute a UDF in an Execute SQL Task within a Foreach loop. I have an Execute SQL task to get the dataset (Firstname, Lastname, CompanyID) which is going into a full result set called @PendingPar. The Foreach Loop is set to a Foreach ADO Enumerator against @PendingPar and I have created 3 variables at the Foreach Loop scope level called @Firstname (String), @Lastname (S
  • In-place upgarde not removing the SQL 2000 hotfix - 2191
    by Ritesh305
    2 Replies
    Last post by Ritesh305
      • Hi All, We recently did the in-place upgrade of SQL 2000 server having the hotfix - 8.00.2191 (Intel IA-64). The server got upgraded successfully without any error and everything seems to work. However, after the upgrade the SQL 2000 hotfix -2191 - didn't get uninstalled. I would like to know :- 1. How we can remove this hotfix if we remove from add\remove programs it doesn't get rem
  • Dynamic Oledb Destination
    by Sameer Gadewar
    7 Replies
    Last post by srfitz2000
      • Hello, I am a beginner for the SSIS and would like to know how to modify the OLDEB Destination connectionString property at run time like using "for each loop container". My requirement is that I have a single source which would be Sql Server 2005 and my destination is in MS-Access database residing in 100 places. I do not want to manually design in the data flow to these 100 desti
  • Drop All Views
    by MaryOS
    6 Replies
    Last post by MaryOS
      • Is there a command or a way to drop all views of a database with one command or must one do a drop command for each view
  • Setting the Locale of Reports
    by lholmes
    4 Replies
    Last post by SteffoS
      • I am having a problem with date formats in reports. I have a two servers, one setup as En-US and the other En-UK in Windows. I have various reports that are rendered using the report viewer control in local mode. In my reports I have not set a language on any text boxes or on the report itself (using Default option in VS 2005). As I understand reporting services should therefore use the locale set
  • Programmatically configuring error and truncation dispositions for row redirection
    by mlernie
    13 Replies
    Last post by mlernie
      • Hi, I have created a SSIS package programmatically using C#. The package should do the following take data from source A, and place rows into destination B, if there are any error rows then redirect the rows to destination C. In my package I have the following components: DTSAdapter.OLEDBSource.1 - Used as the Source DTSAdapter.OLEDBDestination.1 - Used for the Destinat
  • Way to find registered classes/functions for the Assemblies added in Analysis Service.
    by Santosh Ransubhe
    2 Replies
    Last post by Santosh Ransubhe
      • Hi, Is there some way through which we can find the classes and function registered with Analysis Services, when we add Assembly code for Stored procedures Thanks, Santosh.