SQL Server

Page 4830




  • Topics
    Replies
    Last post
  • MSSQL2005 Express SP2 on Vista Professional does not support Extended SP?
    by Lepsik
    6 Replies
    Last post by Lepsik
      • Can you explain please why Extended SP does not work under Vista Microsoft SQL Server 2005 - 9.00.3042.00 (Intel X86) Feb 9 2007 22:47:07 Copyright (c) 1988-2005 Microsoft Corporation Express Edition on Windows NT 6.0 (Build 6000: ) UAC turned off. MSQSL runs under Administrator account. Any call of user esp - and SQL server goes to loop. If I call system esp - all works fine.
  • T-SQL Challenging Product
    by R2D2RABEAU
    14 Replies
    Last post by R2D2RABEAU
      • Hi There, I need some advice: I have the following table: Id Desc Level Parent Value 1 aaaa 1 0 null >> 1.5 * 4 = 6 2 doz 2 1 44 3 bb 3 2 1.5 4 cc 3 2 4 5 bbbb 1 0 null >> 5 * 2 = 10 6 roz 2 5 77 7 bb 3 6 5 8 cc 3 6 2 I want
  • Business intelligence studio - Integration services project problem
    by Gemma
    10 Replies
    Last post by Gemma
      • Hi Guys, I'm trying to create an Integration services project from Business intelligence studio but i can't go further then this: Could not load file or assembly "Microsoft.DataTransformationServices.Wizard" or one of its dependencies. I have SQL Server 2005 Enterprise edition and Integration services service is started. I tried stopping the service and restarting it but it doesn'
  • connecting to sqlserver reporting services
    by satyanarayana
    1 Replies
    Last post by Bryan O
      • how to connect sqlserver reporting services can i connect through sql server management studio Note: this is no joke a serious Question
  • How could I do backups for my packages?
    by enric vives
    9 Replies
    Last post by DarrenSQLIS
      • Hi all of you, Formerly when we ran dts we had DtsBackup2000. So we could to arrange lots of backups around the network in a centralized way. But now how to run backups in groups no individually way We've got five sql25k along with its dtsx packages and we'd like have all of them in the same place. Any tool or idea Thanks in advance,
  • Connection String for classic ASP global.asa to SQL Server 2005
    by BugInfested
    8 Replies
    Last post by William Vaughn
      • I migrated my SQL Server 7 database to the new SQL Server 2005 that I installed on my PC.  I have classic ASP programs on my PC that used to access the SQL Server 7 database.  However, global.asa and these ASP programs can no longer connect to the new SS 2005 database. The access to the SS 2005 instance is with Local System for "Log on as". I've tried all the following connection st
  • Execute As Anomilies
    by Nadreck
    5 Replies
    Last post by Raul Garcia - MS
      • Hi I have a requirement to select data from sysjobs_view in MSDB. In order to allow normal users to acheive this I created a procedure using a sysadmin logon and the Execute as Owner option. A simplified example is below. CREATE PROCEDURE [dbo] . [prc_SelectfromMSDB] WITH EXECUTE AS OWNER AS BEGIN ------------------------------------------------------------
  • Access Permissions on server scoped objects for login
    by John_Enters
    14 Replies
    Last post by Asvin Ananthanarayan MSFT
      • We are having problems with the response times from UPS WorldShip after switching from SQL Server 2000 to 2005. I think that the problem can be fixed from the database end by setting the permissions correctly for the user/role/schema that is being used by WorldShip to connect to the server but, I'm not sure how to do it. The Setup Client UPS WorldShip 8.0 running on XP Pro SP2 Connecting
  • configuring dataset dynamically
    by ngk
    6 Replies
    Last post by ngk
      • HI , I am using SQL Server 2005 Reporting Services. I have many parameters to pass to the dataset. Is there a way to change the dataset dynamically based on the parameters selected Suppose If param1 is selected, I want to use dataset1 and if param 2 is selected. I want to use dataset2 and so on... in my reports. Any help is greately appreicated! Thanks in advance!
  • File System Error after Restore
    by Ashok Ojha
    8 Replies
    Last post by Troy Sherrill
      • Hi Guys, I have issues in restoring our Analysis Services database. Any help will be great. I took backups of our production olap database and Unfortunately, I had to restore next day and it didn't worked out very well. Restore process was successful but when I tried to Query database I was getting error - "File system error: The following error occurred while the
  • ReportingService2005 API / CreateSubscription Permission
    by Lee R.
    2 Replies
    Last post by Lee R.
      • I have successfully used the ReportService2005 services to create a subscription. The problem I am running into is I need to create subscriptions on behalf of other people. This would mean that they would be owners of these subscriptions. The CreateSubscription web service does not take the owner as a paramter. This leads to a problem where someone would not be able to unsubscribe if I programmati
  • How to removing document map
    by 24sharon
    3 Replies
    Last post by soundwords
      • I add document map to my report but I forgot how can I remove it thanks!
  • Compare 2 char strings?
    by kodela
    14 Replies
    Last post by Adamus Turner
      • Hi, How do i compare 2 dates which are char datatypes Example: declare @d1 char(24) declare @d2 char(24) SET @d1 ='2007-04-24 00 :00:00:000' SET @d2 = '2007-04-24 00 :00:00:000' IF(@d1=@d2) print '1' Else print '2' output: out put is 2 instead of 1. It works fine if i use >= or <= but not =. --Kodela.
  • MultiValue Parameter Help
    by &amp;#290;&amp;#38;&am
    14 Replies
    Last post by Mainiac007
      • I have passed a list of parameters to a multivalue parameter in a SQL Report. I can click the drop down and see the list of parameters that were passed. In my select statement for the report, here is the condition I am using in the where clause. AND ( SUBSTRING ( C . CHARTOFACCTSACCOUNTNO , 9 , 3 ) IN ( @RUs )) Nothing is returned in the result set if more than one v
  • All my stored procedures are getting created as system procedures!
    by Jason Shadonix
    14 Replies
    Last post by Louis Davidson
      • Using SQL 2005, SP2. All of a sudden, whenever I create any stored procedures in the master database, they get created as system stored procedures. Doesn't matter what I name them, and what they do. For example, even this simple little guy: CREATE PROCEDURE BOB AS PRINT 'BOB' GO Gets created as a system stored procedure. Any ideas what would cause that and/or h
  • Select rows by page
    by David Scherf
    6 Replies
    Last post by David Scherf
      • What is the best way to do this (least amount of memory required) Example table id bigint name nvarchar(255) select rows 20 to 30
  • Execute SQL greyed out in Query Designer?
    by Steve Powell
    3 Replies
    Last post by Steve Powell
      • If I right click in a query pane and select Query Designer in SQL management Studio, or select an existing query and do the same I get the query designer and can monkey about with the SQL add tables etc... But I can't Execute the SQL or see the results. These options are greyed out. This is a pain as I keep having to select the SQL and paste it back into the query window, easy enough but when i
  • Case in Inner Join? SQL statement help!!
    by Jon1989
    5 Replies
    Last post by Arnie Rowland
      • Hi, I have a 2 different telephone number tables, Table 1 has some numbers beginning with '0' i.e. 08001234567 and some without the '0' i.e 8001234567 on my Table2 i only have numbers starting with '0' i.e 08001234567. I would like to make a INNER JOIN statement and check if the telephone number dont have a starting '0', then append to it and try to do the join so I get both se
  • Olap viewing question.
    by xascendent
    6 Replies
    Last post by jwelch
      • My question is this.. Say a user has full rights to a cube thus he is able to see all the sales data for our company say this user is the director of sales. Now the director has sales managers that work for him, and the managers have brokers that work for them. Now then.. I have given the director full rights, and I have given the sales managers and brokers read only to there dim's of the cube
  • Is @@rowcount and scope_identity() thread safe?
    by Antonio Valencia
    3 Replies
    Last post by valenant
      • Hopefully this is the right forum! Im guessing they both are since they return the values pertaining to the current scope. I don't want to use transactions when I dont have to. What do you guys think
  • Questions on Matrix
    by Vinodonly
    3 Replies
    Last post by Vinodonly
      • i Have report created with matrix in this format :- PO No Sizes i.e. S,M,L, XL, Then Total Po No1 2, 4, 6, 2 - Total is 14 Now currently this is coming in report. I want to do 2 things here :- 1. The total of size column is being displayed at end of the report, whereas i want to bring it after the Po No. 2. In the Row, where Po No is coming, i want to do some calculation on T
  • Where "Visit" is less then 6
    by tenchyz
    2 Replies
    Last post by tenchyz
      • I am trying to edit this query i already have that is fully functional for another report in reporting services. The report has visits sales reps made to stores, broken down by period, week and then date. Now, i need to filter it out by Visits. They want the Sales Reps who had less then 6 visits a day. How would i code that out in my stored procedure When i have Stores and Account Status( which ma
  • Modifying DTS in 2005
    by SAMINShanghai
    1 Replies
    Last post by ggciubuc
      • Can I modify 2000 DTS in 2005.I mean to say add some functionality to the existing DTS.
  • DTS: migrating many, multiple, new databases regularly
    by N402271
    6 Replies
    Last post by N
      • I am looking for some advice on best ways to use DTS between our various test database servers. I need to test an application against MS SQL Server 2000/2005 and Oracle 9i/10g. This includes creating new databases,logins etc on each server. And also means I need to recreate all my test data again at least twice; on Oracle and MS SQL Server(i.e I can backup and restore my databases between MS SQL a
  • Print each tables in new page Options
    by Raghu Deshpande
    4 Replies
    Last post by Raghu Deshpande
      • Hi All, I have a report which has four tables in it. But I have only one Dataset. Since this dataset has more then 30 fields, I have divided this into four tables to be shown in a report. This will help the user to take print of the report and place each print out side by side for view. Showing each table in a new page is just fine. It works. But when we take print out some times rows of se