SQL Server

Page 2514




  • Topics
    Replies
    Last post
  • Incorrect processing order for views
    by aero1
    6 Replies
    Last post by aero1
      • I am using SQL 2005 merge replication with SP1 hotfix build 9.00.2227.00. This build is in use rather than SP2 because a fix I need is not yet available for SP2 Essentially the problem is as follows: 1) Initial state is that merge replication of table and views is working fine 2) I then alter one view which reference s a new view in the same publication 3) Synchroniz
  • How to insert into a table with a function?
    by FransM
    11 Replies
    Last post by FransM
      • I want to add a record into a table, using a function. This function needs to give back the number of records of a given table. Function ImportResults @NumberOfRecords int @TableName varchar(60) @ImportDate datetime @Result bit @Result = 1 @ImportDate =getdate() --Open Table with tablenames select TableName from Tbl_ImportTables For each r
  • Data disappearing during Run time
    by J_Dude2003
    7 Replies
    Last post by J_Dude2003
      • When I enter data into a SQL database and save it, the data that I have just added disapears, but when I close the applicaiton and re-open it, it's still there - is there any reason for this and any way to get it to stay Any ideas
  • Store Membership information using Access .mdb database
    by Realaxed
    5 Replies
    Last post by Caddre
      • Hello, I'm trying to create a web page that is protected by a user login. I want the user data to be stored in an access database file and not an SQL Server express database. I was following this guide on msdn: http://msdn2.microsoft.com/en-us/library/879kf95c(VS.80).aspx However, I was doing everything locally using a file system and not IIS. (Which seemed to work fine)
  • Analysis Services Roles - Dimension Data
    by Mark J Robinson
    3 Replies
    Last post by MarkR64
      • Is there a way to assign dimension data member restrictions within AS 2005 Roles to all attribute hierarchies within a dimension For example we have a dimension with 4 attribute hierarchies : Office Code Office Name Office Group Office Overseas Office Code and Office Name roll up to Office Group (within Office Overseas) We want to restrict certain Active Direct
  • Why does OPENROWSET not connect?
    by SillyMS
    2 Replies
    Last post by Raj Kasi - MSFT
      • We have lots of OPENROWSET usage here, all with embedded user id's and passwords. In an attempt to find a way to eliminate such a foolish practice I created a system DSN on my PC and tried to use it to connect to our sqlserver 2000 database as follows: SELECT a.* FROM OPENROWSET('MSDASQL','DSN=TargetDB', 'SELECT * FROM table1') AS a Server: Msg 7399, Level 16, State 1, Line 1 OLE DB
  • Order By not ordering Month names the way I want
    by TheEnglishman
    4 Replies
    Last post by hunchback
      • Ok ok ok - I'm not very good at this, but I can't figure out how to get the 'order by' statement working correctly. It's ordering the 'ReportDate' column alphabetically and not by month order. Anyone help select id, DATENAME(mm,ReportDate) As ReportDate, max(items) as Items from mytable group by id, DATENAME(mm, ReportDate) order by id, ReportDate Output:- id ReportDate Items 240 July 16024 2
  • How to make an insert table lock
    by Dietz
    10 Replies
    Last post by Tom Phillips
      • Hi There i Have some t-sql that basically does something like : INSERT INTO TABLEA SELECT * FROM TABLEB There are alot of rows involved and sp_lock tell me that a table lock is being put on TABLEA during this insert. This is a big problem for us. I have often used locking hints on selects etc but never an insert, how can i get the insert to never use a table lock
  • How to sort a table with a parameter
    by Selectis
    4 Replies
    Last post by Selectis
      • I have a "Sales shipments" report with several colums. I want a parameter for the user so he choose how to sort. I have two colums in my report I want to sort on: ItemNumber and DeliveryDate. I added a Report Parameter UserSort with two labels (and values): Item (ItemNumer) and Date (DeliveryDate). Then I tried to set the sorting
  • How to truncate the log file
    by PhillS
    11 Replies
    Last post by Magic21
      • How do I truncate the log file using TSQL   My client's log file is 44 gig and there isn't enough HD space.  Thanks
  • Conditionally count rows in a table
    by MartyP
    3 Replies
    Last post by larry smithmier
      • I am building a Table Report where I need to "count" the number of cells in a column conditionally. I have a column of data where the values will be "Orange", "Apple", "Banana", NULL The pseudocode would be something like this: iCountOfOranges as Integer iCountOfApples as Integer iCountOfBananas as Integer IF Cell.Value = "Orange" THEN iCountOf
  • Why 'sa' execute this script????
    by tsohtan
    2 Replies
    Last post by tsohtan
      • use [XXXXXXX] SELECT is_member(N'db_accessadmin') AS [IsDbAccessAdmin], is_member(N'db_backupoperator') AS [IsDbBackupOperator], is_member(N'db_datareader') AS [IsDbDatareader], is_member(N'db_datawriter') AS [IsDbDatawriter], is_member(N'db_owner') AS [IsDbOwner], is_member(N'db_securityadmin') AS [IsDbSecurityAdmin], is_member(N'db_ddladmin') AS [IsDbDdlAdmin], is_member(N'db_denydataread
  • OLAP Multi Value Parameter error:Members Belong to Different hierarchies in the STRTOSET function
    by rpress
    0 Replies
    Last post by rpress
      • Hi - I am building a reoprt (SSRS, SQL Server 2005) with a multi value parameter that exposes a picklist on the report page - when ALL is selected, or certain combinations of the elements in the picklist are chosen, I get the following error, that a query failed for a dataset because: Members Belong to Different hierarchies in the STRTOSET function. I have built reports with multiple val
  • Business Intelligence Dev. Studio (BIDS) install fails
    by Friggle
    0 Replies
    Last post by Friggle
      • We're trying to upgrade to SQL Server 2005 (from 2000), but we're having consistent problems getting BIDS to install correctly. The BIDS installation has failed on four of seven machines we've tried installing the SQL Server 2005 tools on. Not very good odds. Note that the rest of the SQL Server tools installed correctly; only BIDS is hosed. Two of the three machines where BIDS installed correctly
  • Flat File Source option missing in the Sql Server Import & Export Wizard.
    by p2kumar1123
    1 Replies
    Last post by Will Riley
      • Hi All, I want to import a txt file data to a sql server database table, to do this i used sql server import and export wizard. In this when we choose a Data Source, the option Flat file source is not coming up in the combo box in the wizard. I am using sql server 2005, Management Studio to do this. steps 1. right click on the database --> all tasks --> import data --> sq
  • Cannot connect to server
    by lexandra
    2 Replies
    Last post by Hemantgiri S. Goswami
      • I have a problem, I can't connect to database through SQL server 2005 express edition. My database resides in other computer, I want to access the database. Please give the list of reasons behind this problem and also some solution. Thank you....
  • Generate and save a report from reporting service ( remote processing)
    by AlucardHellSing
    3 Replies
    Last post by AlucardHellSing
      • If I have an asp page with a button, what are the means or methods to trigger the event to process a report, save into a report and store in a file server or any directory All these is done backend without the need to display to the browser. Using RS Web services or Delivery extension programming things like that Regards Alu
  • Decimal datatype conversion from DB2 to SSIS throught Microsoft OLE DB Provider for DB2
    by Andr&#
    4 Replies
    Last post by Nicolas Vivarelli
      • Hi All, Here is a description of the issue I'm facing about decimal datatype conversion from DB2 to SSIS throught Microsoft OLE DB Provider for DB2. I first discovered it when I tried to use a LookUp trans. and selected a decimal typed field. I was unable to validate it and clicking the OK button threw the error copied below: TITLE: Microsoft Visual Studio ------------------------------
  • Infinitive recursion for my AS2000 calculated member
    by cka11
    4 Replies
    Last post by cka11
      • Hi, Can someone please help me on this. I get following error when I browse my virtual AS2000 cube: <Infinite recursion detected during execution of calculated member Sum({Descendants....> I have implemented a 'dummy' utility dimension with one calculated member: (I have used a parentchild dimension because that's only way I know how to get the formula a from source view): --
  • Using Catalog Views to Create Data Dictionary in SQL Server 2005
    by dmillson
    3 Replies
    Last post by Jens K. Suessmeyer
      • I have been maintaining a data dictionary for my company as an Excel spreadsheet. However, we would like to be able to generate it automatically with a stored procedure in T-SQL. The items in the data dictionary are: Table Name Table Description Field Name Field Description Primary Key Null/Not Null Data Type Maximum Length Precision Scale Default Value
  • installation verification issue
    by boodito
    3 Replies
    Last post by GregSQL
      • Hello I Just installed Reporting Services 2005 and I have a problem to make work After installing it and setting different properties in the Reporting Services Configuration Manager, When it comes to verifying the installation, http://localhost/ReportServer or http://localhost/Reports pops up a Login Window, Where I enter Windows Account Username/Password, but this windows pops up again
  • Script Component can't find the binary code
    by Daphne.cheng
    5 Replies
    Last post by Daphne.cheng
      • Dear all£º I have set the PrecompileScriptIntoBinaryCode property to true ,but the Script Component show the message "can't find the binary code" after I finish the script language and save it . What's wrong with it I ever tried the same code, and it's OK with no problem. When did the problem happen Please give me a help ....Thanks a lot!
  • Foreach endless loop
    by thames
    14 Replies
    Last post by thames
      • I'm having a problem where I'm using a Execute SQL Task to retrieve a dataset and storing that in an object variable. Then on success of that execute sql task I use a foreach loop task to go through the dataset and do 2 tasks inside the foreach loop. When I execute this package I have ~12 records in the dataset however when I get to the foreach loop in the 2nd iteration it keeps repeating it. It a
  • Exception 0xc0000005 EXCEPTION_ACCESS_VIOLATION reading address 637B7FC0 at 0x77387EAC
    by araw012
    7 Replies
    Last post by araw012
      • Hi i am connecting to a DB2 database on a AS400 machine from SQL server 2005. I have setup a linked server to connect to the DB2 database. Most of the time the query ( select * from OPENQUERY(lnkd_svrname,'select abc from svr_name.lib_name.tablename') ) works fine but at times it comes up with the following error. I am running SQL server 2000 Std. Edition on a WIN 2000 machine. Any help would
  • Very Newbie To XML and SQL Server
    by ansonee
    4 Replies
    Last post by Pintu Shukla
      • I've just recently begun working with XML in SQL Server 2005. I have plenty of SQL Server experience but not a whole lot with XML. I've got a couple of quick questions... I've got a table called CLMNT, with a column of datatype XML called CUSTOMCOLUMNS, in this format: < customcolumns > < CustomColumns > < LoanDate /> < Lender /> < Dealership