SQL Server

Page 5454




  • Topics
    Replies
    Last post
  • Checkpoint not being set? Log not truncating?
    by graemeo
    2 Replies
    Last post by Vidhya Sagar
      • Hi, I've set up a number of jobs (not a maintenance plan) via a script in SQL 2005. These jobs do the following: 1) Full backup every sunday night 2) Differential backup every weeknight 3) Log backup every hour The database is obviously in the full recovery model. The backups all seem to be running, with one issue - the log file is still growing and is not being truncated. I was under the impressi
  • Collations in SSAS. How should it work?
    by Vladimir Chtepa
    4 Replies
    Last post by Vladimir Chtepa
      • Hi SSAS gurus, Could you tell me, please, what collation gets a new dimension (cube), that collation isn't specified in create script, from Server collation or from data base collation In the MSDN there isn't clear information related to it. If I create a new database from script, where only the collation of the database specified, all dimension and cubes get collation from server, but not f
  • Calcaluting total nu of people based on their name field
    by shamen
    14 Replies
    Last post by Adam Tappis - IMGroup
      • I want to create a report which should be looked like this. Members Joined Members Borrower Depositor Members Joined Yesterday 8 4 4 Members Joined Last 7 days 39 20
  • Package execution stability ?
    by Steve Wang 2006
    14 Replies
    Last post by Steve Wang 2006
      • I am running into some issue that i have found any good clue on this forum... although have seen a few threads dicussions. I have a master package which invokes a dozen of child packages. 1) If I only open master package inside IDE, I am keeping getting the following error when i run the master packages inside Visual Studio 2005 IDE. The connection type "FLATFILE" specified f
  • Need sp_addlogin with CHECK_POLICY = OFF
    by Gurpreet Singh Gill
    4 Replies
    Last post by Raul Garcia - MS
      • Hi We are using SQL Server-2005 as backend, i had code like, sp_addlogin 'a', 'a' this give error as "Password validation failed. The password does not meet Windows policy requirements because it is not complex enough" as this is not full fill the Windows Password policy. I too check the Local Security Settings is disable for the password settings. I know i can us
  • Connection Problem
    by sureshv
    10 Replies
    Last post by sureshv
      • I created a package with two oledb connections in the connection manager....which was running perfectly...later i deleted these connections and added two new connections....and applied these to task with the new connection.. Now i run the package i come up with the following error...connection not found Error 1 Error loading test.dtsx: The connection "SQL-DEV.sql_dev" is not fo
  • Script Task debug error
    by jkline
    8 Replies
    Last post by Belsteak
      • Good afternoon - Info: Microsoft SQL Server Management Studio 9.00.1399.00 Microsoft Analysis Services Client Tools 2005.090.1399.00 Microsoft Data Access Components (MDAC) 2000.085.1117.00 (xpsp_sp2_rtm.040803-2158) Microsoft MSXML 2.6 3.0 4.0 5.0 6.0 Microsoft Internet Explorer 6.0.2900.2180 Microsoft .NET Framework 2.0.50727.42 Operating System 5.1.2600 I am trying to deb
  • log shipping in sql server 2000
    by Bijal
    3 Replies
    Last post by Deepak Rangarajan
      • hi, i have log shipping between 2 servers on sql server 2000. the log shipping failed because of some problem with transaction log backup files. somehow the files are missing and it is not able to apply transaction log. can someone please tell me how can i restore the log shipping between 2 servers. please help asap..need to fix it in couple hours
  • Getting the name of the updated table
    by Craigster
    14 Replies
    Last post by Alphi
      • I am writing a generic trigger in VS 2005 that selects records from the inserted table, and updates an audit table. I am, however, unable to retrieve the name of the table that the insert occurred on. I am using the following code to select the records, and obtain the name.. Can anyone offer any alternatives to accomplishing this task Thanks in advnace for any help you can provide. Craig Sql
  • Unable to Connect to Report in Windows Form
    by GNWebSoft
    4 Replies
    Last post by Bennymac78
      • I have deployed report on my hosting server and now I want to access it using Windows Form ¨C Report Viewer Control. Following is the code which I use. public Demo() { InitializeComponent(); reportViewer1.ProcessingMode = ProcessingMode.Remote; reportViewer1.ServerReport.ReportServerUrl = new Uri("https://rs.hoster.net"); rep
  • nvarchar(max) gets truncated at 4000 chars(?)
    by KitWest
    11 Replies
    Last post by Tom Phillips
      • I¡¯m trying to call sp_ExecuteSQL with a query that exceeds 4000 characters. DECLARE @sq NVARCHAR ( MAX ) DECLARE @from NVARCHAR ( MAX ) SET @sq = N 'SELECT Quite, AFew, Columns' SET @from = N ' FROM NumerousTables WHERE LotsOfConditions=''very big query...''' SET @sq = @sq + @from PRINT @sq -- This appears truncated at 4000 chars in the Messages tab.
  • Format expressions(converting seconds to minutes)
    by raj416
    1 Replies
    Last post by raj416
      • can any one tell me how to change seconds to minutes by using if condition in rss... for example i have value of seconds=50, minutes should come like this 50/60=0.833333.... i got the answer ... but the problem is how to roundoff or truncate the minutes to 0.83 or 0.84 from 0.8333333... Thanks in anticipation raj
  • Call Web Service From Script Task
    by James Mac William
    16 Replies
    Last post by James Mac William
      • I am trying to call a web service using the web service task and passing it variables, but even when I set variables to be Strings/any other data type, they always get passed out as objects. The call is then rejected based on the fact that there is no web service that accepts those parameter types. If there is a workaround to this problem, that would be great, otherwise I think I'm going to have t
  • Copying procedures in SQL from one server to another using VBA in excel
    by Aghajan1
    2 Replies
    Last post by Joe Webb
      • Is there any sample code or help on trying to copy/replace views or prodecure in SQL or Oracle Im using VBA in Excel...
  • Maintance Plan dbcc checkdb
    by mmasnou
    2 Replies
    Last post by mmasnou
      • Hi, When I exectue the maintance plan dbcc checkdb it doesn't do anything because it takes 1 second to do de check. Doesn't appers any error. When I execute the command in the query analizer it takes 2 hours to do the check. Can you help me Thanks, Marta Masnou
  • How to interact with OLAP cubes within SharePoint Portal?
    by Helen999888
    6 Replies
    Last post by Helen999888
      • Hi, all experts, I wanna know how can we interact with OLAP cubes (by dragging and dropping dimensions, measures from OLAP cube data) within SharePoint portal What web parts or what else we need to emmbed within sharepoint portal to achieve this I am looking forward to hearing from you and thanks a lot for your help. With kind regards, Yours sincerely,
  • AS2005 - Calculation Tab - DimensionMembers: MemberC = MemberB - MemberA
    by Mastroyani
    4 Replies
    Last post by Mastroyani
      • Hi to all, I have one problem: I have a dimensionshierarchy "Example" like this: 1 A1 B1 C1 2 A2 B2 C2 1 and 2 are parents. C1 and C2 are dummy members, so I want to filll them in the calculation tab with this formula: C1 = B1-A1 C2 = B2-A2 That's what is standing now in calculation tab: [Example].[1].[C1] = [Example].[1].[B1
  • Record navigation
    by LAT4551
    4 Replies
    Last post by LAT4551
      • I have created a one-page client summary report. My problem is that I can only get the report to show one client and there are many. How do I add record navigation functionality to my report
  • Round Up to next integer
    by jschroeder
    2 Replies
    Last post by jschroeder
      • Is there a way to round up a value to the next integer For example 2.1 needs to be 3 and 4.9 need to be 5.
  • Errors in the OLAP storage engine: The attribute key cannot be found
    by mktexpress
    4 Replies
    Last post by mktexpress
      • I'm somewhat new to using SQL server analaysis services so bear with me on this post. I am getting the following error when trying ot process a simple cube I built: Errors in the OLAP storage engine: The attribute key cannot be found: Table: dbo_vwInvoice, Column: Invoice_x0020_Date, Value: 3/7/2004 10:00:00 AM. This cube use an Invoice table as the fact table and then a &
  • Getting Unique entire row records based on one unique column..
    by den2005
    12 Replies
    Last post by den2005
      • Hi, I like to get all records(all columns) for any employee who has more than 2 unique SuggestedTraining..As simple as possible and execution (performance optimized) speed is as fast as possible. Data: Table structure below Assessment Table AssessmentID EmployeeID CourseID SuggestedTraining Date ....more columns 1 4 1 'Training 1' <date> 2 2 2 'Tr
  • Displaying print statements of Stored Procedures in SSIS Logs
    by Imtu
    1 Replies
    Last post by Phil Brammer
      • Hi I have few print statements in a stored procedure that gets called from the SSIS package. How do I make sure that these are captured in the SSIS log meaning how do I get them to be displayed in the Package Explorer window when running from the Business Intelligence Studio IDE.
  • unable to attach a database to the MSDE instance
    by GRK
    3 Replies
    Last post by GRK
      • Hi I'm creating a database instance with the MSDE 2000 using the Command line(executing a batch File) and once the installation is finished(from the same batch file) I'm trying to attach a database to it. but the database is not attached to the database. but when I go to the sql server and register this new database and run the same command the database is attaching. can any one suggest how to
  • Data incorrectly repeating itself
    by TJ Bernard
    1 Replies
    Last post by TJ Bernard
      • I have run into a strange issue that I believe is a SQL Reporting Services issue. I have a report laid out in landscape setting that has 4 columns of text. Two of the columns are sub-reports (due to the complexity and size, we did not flatten out the data in the stored procedure) and two of the columns are regular fields. The 2 columns of regular fields are smaller, and normally only
  • Sub query problem!!please help..
    by loplayers
    5 Replies
    Last post by hunchback
      • Table a Testid CFPID 100 1004 Table b CFPID Active 1004 1 the type of all coulmn is varchar(Max) When i execute this query, the reult is none, is this query wrong SELECT Active FROM b WHERE b.CFPID = (SELECT a.CFPID FROM a WHERE a.TestID = '204') The result is nothing...then i prefer the result is 1.