Answer Questions

• SQLScott Access to several SQL Servers implementing trusted connection

  Being an IT consultant, I have to visit a number of customers having applications running on SQL Servers that implement trusted connection security model. In addition, all of these companies have their own DOMAIN settings, and security implementation. How can I access to databases without changing the DOMAIN settings of MY notebook I do not want them to switch to SQL security model, and I do not want to create any security hole in those companies. What shall I want from the system administrator so that I can login into their domain without changing my domain settings Thanks, EIO. May I ask: How I understand that: 1. I have to ask all the administrators in those separate companies to create a user account for ...Show All

• Aureon SQL EXPRESS - WEB ASSISTANT Sp's

  I ve installed SQL EXPRESS ADV on fresh XP and I get this error when I try to run xp_makewebtask: Msg 17750, Level 16, State 0, Procedure xp_makewebtask, Line 1 Could not load the DLL xpweb90.dll, or one of the DLLs it references. Reason: 1114(error not found). (1 row(s) affected) I checked and xpweb90.dll is missing... but I do have the option to enable then... They took them out Or smthing is wrong on my pc (2 installations same problem) I also have a standard edition and developer edition wich are working fine. I tried to copy the files but I get same error /// Thks in advance for any help " So it is. I'll have to talk to those SAC folks and see what gives. ...Show All

• Learning VB Cluster setup

  We are on SQL Server 2000 A/A cluster and are moving to SQL Server 2005 cluster. Following are the list of things before proceeding, please let me know if it needs any corrections and add-ons: (side-by-side) Planning for new installation of SQL Server 2005 ( SQL2005INST1 and SQL2005INST2) on node1 and node2 and restoring the databases on SQL2005INST1 and SQL2005INST2 from respective 2000 instances. 1) SQL2005INST1 SQL Network Name SQL IP address 2) SQL2005INST2 SQL Network Name SQL IP address As 2000 is already existing on the cluster.Want some clarity on following questions. Can I keep the data files on the same disk as 2000 was using Do I need to have new disk for the Quoram drive Under & ...Show All

• macca01 Insert or Update SSIS for Composite Primary Key

  Hi , We have scenario like this .the source table have composite primary key columns c1,c2,c3,c4.c5,c6 .when we move the records to destination .we have to check columns (c1+ c2 + c3 + c4 + c5 + c6) combination exist in the destination. if the combination exist then we should do a update else we need to do a Insert . how to achive this .we have tryed useing conditional split which is working only for a single Primary key . can any one help us . Jegan.T Linkies, As dit jy is, stuur vir my jou foon nommer dat ons weer n slag kan chat. My e-mail address is jolivier@pizzadelight.ca Jakes Hi Peter , Thanks for the suggestion .but my source table does not have ...Show All

• laboremus AMO: Looping to delete partitions

  Hi I am trying - in AMO code - to loop over the partitions in my different measure groups and drop these. But apparently I am not allowed to do it with the following code, since I am modifying the collection which I am looping (because I drop the partitions which exist in the collection). .... For Each oMeasuregroup in oCube.MeasureGroups For Each oPartition in oMeasureGroup.Partitions oPartition.Drop() Next Next ... Can anyone help me with a solution Thanks. Hi, You need to iterate over the partitions collection with integer index. PartitionCollection partitions = ...; for( int i=partitions.Count-1; i>=0; --i )     partitions[ i ].Drop(); Adrian Dumitrascu ...Show All

• mbeninca Bug?? Transfer SQL Server Objects Task - error when copying Views

  I'm trying to copy data over using a Transfer SQL Server Objects Task however I get problems trying to copy over views. I get the similar error (pre sp1) when using import/export wizard and copying over views. Now with SP1 the views just don't transfer. I'm transferring from SQL 2005 to SQL 2005. The error I get is: Error: 0xC002F363 at Transfer Data (NEW), Transfer SQL Server Objects Task: Table "vw_XXXX" does not exist at the source. Task failed: Transfer Data (NEW) I know the view exists at the source because: A) I can select it in the Views List Collection within the Transfer SQL Server Objects Task B) I'm using the view on the source Somehow the views are not transferring. Anyone have any ideas ...Show All

• Graham Wager filegroup auto-growth - know when it happens?

  Hey guys, I'm running SQLServer 2000. I am in the process of looking over our current filegroups and providing reports based on file size increases. One thing I'd like to know is when (date and time) a filegroup last "auto-grew". Is there a way to know when this occurs thanks, Jason Thanks for the info. Appreciate the help. Jason Derek, Thanks for the info. I should have re-worded my question I think: Is there a way to know when the date/time a filegroup last auto-resized Let's say it auto-resized last friday, is this timestamp stored somewhere Profiler would tell me only if I was running it at the time of the resize. I'm trying to co ...Show All

• Sergio Ordine Snowflake with nullable foreign key

  I have a snowflake dimension with a nullable foreign key. It looks like when I process my dimension it only keeps the rows that have a value in this column, and filters out the rows with a null. Is there any way to keep the rows with the null value Thanks, I was hoping to avoid assigning a value to nullable records, but it seems like this is the only way. I actually created a Named Calculation in my data source view using COALSCE so I could keep the null value in my relational table, and did the join on the named calc column so the inner join always succeeds. As for the UnknownMember property, I thought this only applies to fact tables referencing the dimension. I don't see its usage for a snowfla ...Show All

• bishoycom Changing "Connection String" in SSIS package ???

  Hi! I create a SSIS Package for ETL on my own machine. During development database was also on my machine. For access to this database an OLE DB connection was defined within a package in BI Development Studio. Everything worked well both in debug mode and testing package itself. Finally I need to load data to a database on a different machine using this package. I used several scenaries: 1) simply copied the package-file to estination machine, open it for execution, in section "Connection Managers" I edited connection string manually - changed server name and Initial Catalog. And try to execute. 2) on the destination machine I manually created an OLE DB connection (using Microsoft Data Link) to a different datab ...Show All

• krackedude HOW TO - maintenance wizard, direct delete backup after N days?

  Howdy - Must be missing something or going blind but, I cannot find in the maintenance wizard where I can say, for instance 'delete .bak after 4 weeks' when creating a maintenance plan for a database. Am I blind or was this important functionality left out of the wizard Anyone know Tia randyvol Under SSMS -> Management -> Maintainence Plan you actually have to drag-and-drop the "Maintainence Cleanup Task" from the toolbox there you'll find the settings (folder path, how many days, etc...) In our Maint. Plan we have 1. Back Up Database task -> Cleanup Task -> Shrink Task Good luck Hi All, With SQL Server 2005 SP2, the Maint Plan Wizard no ...Show All

• Boris Zakharin want to implment DRILLTHROUGH IN SSRS

  I am trying to implment following statement in my SQL Server Report 2005. My data source is AS2005. ***************************************************************************** DRILLTHROUGH SELECT ([Measures].[Total Test Count]) ON columns FROM [OLAP Test Cube] WHERE [Dim Station].[Station Name].&[1ST CHOICE EMISSIONS & INSPECTIONS] RETURN KEY([$Dim Station].[Dim Tests],0) ,KEY([$Dim Station].[Dim Tests],1), [$Dim Test Cycle].[Test Cycle], [$Dim OverallResult].[Overall Result] ****************************************************************************** When I execute above statement in AS SQL Query Analyzer then it is working fine but same statement I am executing during Report creation (Query Builder) that time it giving ...Show All

• Bharat Gadhia limit rows for a user

  Is it possible to set a limit for the number of rows to the user that connects to sql server (something like: whatever is the query this user does, set @@rowcount to 10000) Thanks. Alberto One way to do this in SQL Server 2005 would be to use the TOP clause in view definition/SPs (this assumes that you are using one of these as primary data access mechanism). You can have a table that contains say the user and the number of rows. You can then add a TOP clause to your query like: select TOP(select rowcnt from user_quota where user_name = SYSTEM_USER) ... from ... order by ... You can use same technique in SQL Server 2000 in SPs and use SET ROWCOUNT. I don't think so unless you ha ...Show All

• Tej62007 new to sql, don't understand "text filegroup" PRIMARY

  Thanks for any help in advance. I'm new to MS SQL and I'm having trouble adding a table with the property, "Text filegroup" = PRIMARY. Frankly, I haven't done much reading (I've done lots of googling though, but to no avail) about the subject, but nevertheless it seems that I can't add data to my table unless the 'text filegroup' is set to PRIMARY. However, I can't figure how to set it to primary. Even when I create a new table the default (I think ) seems to not set it to PRIMARY. By the way, I'm using Microsoft SQL Server Management Studio Express. Did you read Books ONline I bet it says the default is primary. You can always script out the table to see what the default is (if it's availabl ...Show All

• GustavMahler Accessing Report

  Hi, I am using IIS 5 and MS SQL Server 2005. My problem is I can deply the report in report server but unable to access.After deplyin g the report when I typed the url( http://localhost/reportserver/......) in internet exploer I am getting an internal error. How can I solve this problem..... Best Regards, Anupam. See if the Service of Report Server is started (Reporting Server in the Service Manager), see if the virtual directory was created during the installation of SQL Server. Try to connect to localhost/reportserver (which is the webservice) to see if the problem is only located on the report manager interface (which is localhost/report). HTH, Jens K. Suessmeyer. --- http://www. ...Show All

• PSDCHD update

  hi i cant use update like this. how set ANSI_NULLS ON set QUOTED_IDENTIFIER ON go ALTER PROCEDURE [dbo] . [tt] AS BEGIN SET NOCOUNT ON ; DECLARE @t1 TABLE ( a int , b int , c int ) DECLARE @t2 TABLE ( a int , b int , c int ) insert into @t1 select a , b , c from table_1 where a = 1 insert into @t2 select a , b , c from table_1 update table_1 set c = @t1 . c where ( @t2 . b = @t1 . b ) END ALTER PROCEDURE [dbo].[tt] AS BEGIN SET NOCOUNT ON; DECLARE @t1 TABLE(a int,b int,c int) DECLARE @t2 TABLE(a int,b int,c int) insert into @t1 select a,b,c from table_1 where a=1 insert into @t2 select a,b,c from tab ...Show All