SQL Server

Page 171




  • Topics
    Replies
    Last post
  • Domain group logins failing on SQL 2k5 workgroup
    by Jim Kilmer
    14 Replies
    Last post by Jim Kilmer
      • This question is regarding a brand new out-of-the-box SQL Server 2005 Workgroup Edition install. The old SQL Server 2000 server is working properly with regard to the issue we're having: We are using Windows Authentication, and have created SQL logins for about 40 different groups on our domain. We've given those logins the appropriate permissions on the databases they're suppose
  • Matrix Report, groups and subtotal error
    by Michael MP
    3 Replies
    Last post by adolf garlic
      • Please, i need a very urgent help, for this question... tkssss :-) I need to create a report with dynamic columns. I try use Matrix, but in this time, i dont konw how to calcutate the subtotal e groups in the correct way. The data for generate the report ( http://xs116.xs.to/xs116/07233/DataReport.JPG ) This is the actual report ( 2 rows groups and 1 columns group ) ok, but how group dates now ( h
  • how to balance the database
    by Victor F
    2 Replies
    Last post by Victor F
      • Hello, I started to use data mining sql server recently, and I have a little problem: I'm trying to predict a boolean variable, but my database has only 1/4 of true results, because of that my predict probability is a little bit low in this kind of cases. My question is: Is there a way of increasing the importance of a database entry in order to avoid editing a database with 40000 entries
  • msdb table backupmediafamily does not show transaction log backup sometimes
    by hvdtol
    7 Replies
    Last post by hvdtol
      • Hello, We have a self-written procedure to restore transaction logs on a standby server (Sql Server 2000 sp4) We do this by joining 2 msdb tables, to find out which backups have been performed: backupmediafamily and backupset. Sometimes backups are NOT registred in table msdb..backupmediafamily. Underneath 2 examples. OK - underneath queries shows the time the backup was created in t
  • Interesting Challenge..
    by plengski
    12 Replies
    Last post by plengski
      • I am making a report in Visual Studio..Now my question is,is there anyway that i can add a tab control for my rdl Hope to here from anyone out there with a know how..Thanks guys!!
  • Problem with named calculation
    by Manolis
    3 Replies
    Last post by Edward Melomed
      • Hi, I wish all the best fro the new year. I encounter a serious problem with creating a named calculated colunm programmatically to the DSV of an analysis database. \i would like to create this named calculated column by means of VB but any help in C# is acceptable. I have already created this column in Microsoft Visual studio design but I need to be created programmatically now. T
  • Cross assembly or cross domain calls not supported
    by furmangg
    11 Replies
    Last post by furmangg
      • If I compile a simple .NET DLL with the following function and register it as an assembly in Analysis Services: public static int MyFunction(object o) { return 99; } When I run the following query I get an error which reads " Execution of the managed stored procedure failed with the following error: Cross assembly or cross domain calls not supported!. Execution of the managed stored pro
  • Replication Architecture question - Pull subscriptions on a SQL cluster...
    by Lee Everest
    6 Replies
    Last post by Hilary Cotter
      • Greetings: I am working on a replication setup using transactional replication using with pull subscriptions and a separate distributor. The pull subscriptions are located on a SQL cluster using the virtual SQL Server name as the subscriber; when the box fails over, we get an error of missing replication.dlls. Researching further, we found that replication only works on one node of the
  • Report with measures in row
    by Shearer
    2 Replies
    Last post by Shearer
      • Hi, I would like to create a report on a cube with Report Server (Query Builder) with one dimension in columns and the "measures" dimension members in rows: Jan Feb Mar ... Measure1 10 12 14 Measure2 20 22 24 .. How to create with either Tabular or Matrix report type Thanks, Marcus
  • Enable User Instances in SQL Server
    by DDH
    14 Replies
    Last post by Anonymous
      • I'm just starting out and trying to connect to my first database using the following string: Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\RFPdb.mdf;Integrated Security=True;Connect Timeout=30;User Instance=True I get the following error during debug: " Generating user instances in SQL Server is disabled. Use sp_configure 'user instances enabled' to generate user insta
  • Trigger on ProjectServer tables, please help!
    by Jbud
    0 Replies
    Last post by Jbud
      • I am trying to put a trigger on a ProjectServer table to copy the updated data to a specified table. When I add the trigger, MS Project will no longer let me change any of the project information. I'm stumped, here is my trigger, any ideas (I'll post this in the project section as well) set ANSI_NULLS ON set QUOTED_IDENTIFIER ON go alter trigger [UpdateStatusColors] on [dbo]
  • Document Map doesnt display in IE7
    by Anonymous568426
    1 Replies
    Last post by Teo Lachev
      • Can anyone help, I have created a report which works great when the users run from IE6, but when anyone runs report from IE7, the report displays ok, but the document appears to build but displays absolutely nothing. Has anyone seen this problem with IE7 using Reporting Services 2000 Thanks people
  • Package Synchronization?
    by RickGaribay.NET
    2 Replies
    Last post by Michael Entin - MSFT
      • What is the best strategy for maintaining package execution synchronization when using the SSIS API For example, I have discovered that it is quite possible to fire off several intances of the same package simultaneously. Is a best practice perhaps to put the db in single user mode prior to kicking off the package and if so, how would you limit subsequent ASP.NET connectons, for example TIA
  • stored procedure help
    by Brown Knight
    10 Replies
    Last post by Arnie Rowland
      • I would like to create a stored proc to Get The oldest employee at the time they were hired was [Firstname] [Lastname], who has been with the company for [X] years, months and days. i am lost on the learning process.
  • List Filtering NOT Working
    by PPCUBAN
    2 Replies
    Last post by PPCUBAN
      • I have a Report where i want to show in a DataList only those values Filtered by one of the fields of my dataset. I want to show a Date value ONLY if another column value in that row in my dataset = "IN". But nothing seems to happen here. No records are shown. It's like the condition is never true. Steps: 1. I drag a DataList 2. I drag a DatasetField inside the DataLi
  • Looking for feedback: Is SQL Express "too big"?
    by Mike Wachal - MSFT
    14 Replies
    Last post by maadamo
      • I¡¯d like everyone¡¯s help is do some research into an often heard, but rarely explained, complaint related the SQL Express. Your answers will help me plan future versions of SQL Express. Feel free to respond directly in the forum or by sending e-mail to me. (Note: Remove the word online from the e-mail address in my profile or it will bounce.) The complaint: ¡°SQL Express is too big.¡± I¡¯m tryi
  • Create .SDF from .MDF File
    by dlussier
    5 Replies
    Last post by ErikEJ
      • So we have this database in SQL 2005, and we want to create a SQL Mobile database filled with a subset of data from that SQL 2005 database. Replication is NOT an option for us (otherwise, believe me, we would be down that road in a heartbeat). Hence why we're trying to create the files manually. Now, I know I could write an app that creates the .SDF file, gets the data from the master and pu
  • Max number of Database Master Keys?
    by JJKusch
    4 Replies
    Last post by JJKusch
      • Is there max number of Database Master Keys that can be used in a single instance of SQL Server 2005 If I have 12 unique client databases that all need a unique Database Master Key, can this be accomplished Thanks ALL!
  • SSIS & Replication
    by hhoward
    3 Replies
    Last post by JayH
      • I'm not sure how to go about setting this up, please assist I need to replicate a survey database. With each new survey, a new table is created within the database. I only need to replicate the new survey table to a remote database. I tried using SQL Server Replication but the catalog is fixed and if a new table is created, it will not be selected as part of the tables to be replicated.
  • Very Urgent, Done a mistake. please help
    by StephenMas
    10 Replies
    Last post by Satya SKJ
      • I am using Sql Server 2005, i have two tables master and details. accidently i excuted an update query to change column name called transaction refererence(t_ref). in master and details table t_ref is the reference column. instead of update one record in detail. my updated query change change all the reference into one. i feel like escape from my company. i scared pls help. any way to roll back.
  • PerformUpgrade Failed - In What Manner?
    by John Saunders
    6 Replies
    Last post by John Saunders
      • I'm in the midst both of developing and using a custom Transformation. Of course, every time I change the assembly version and reopen Visual Studio, I get the error: DTS.Pipeline: The component metadata for "component "Map SERVICE_CERT String Locale" (195692)" could not be upgraded to the newer version of the component. The PerformUpgrade method failed. Out of cur
  • Update/Insert rows from one table in multiple tables
    by Bernardo Salazar
    10 Replies
    Last post by Arnie Rowland
      • Hi everybody... im a newb and i have this question... I have a table1 that have 10 records (code, number, ammount), i need that rows inserted/updated in 3 tables that have identical structures of the table1, the problem is that the another 3 tables have already one of more of the rows, but the challenge to me resides in update the existing rows (increase the ammount), and insert the inexistent
  • splitting up columns mid-process
    by Jim Work
    1 Replies
    Last post by Phil Brammer
      • When I accept my input data, it's convenient to read it in from a flat file as a fixed width file with a width of 100. Then I run a splitter to split the input into two different paths (path_1 and path_2, say), based on an indicator field. The output of path_1 has 1 column with width of 100, but now I want to split it up into lots of little columns. The output of path_2 also has 1 column with a wi
  • Attaching a db - missing log (ldf)
    by h1
    10 Replies
    Last post by EngASO
      • Hello, I'm trying to re-attach sqlserver 2005 db. I have the mdf file but I don't have the log file. When I try to attach, I get the appended error. Is there anyway, around this Thanks Houman TITLE: Microsoft SQL Server Management Studio ------------------------------ Attach database failed for Server 'SERVER'. (Microsoft.SqlServer.Smo) For help, click: http://go.microsoft
  • Configure Report Server
    by Nelson564376
    5 Replies
    Last post by Shyam Sundar
      • I'm having problem with initialization tab on Configure Report Server All tabs are checked and green , but when I click initialize I got this error: ReportServicesConfigUI.WMIProvider.WMIProviderException: The report server installation is not initialized. (rsReportServerNotActivated) at ReportServicesConfigUI.WMIProvider.RSReportServerAdmin.ThrowOnError(ManagementBaseObject mo) at