Answer Questions

• Pockey Identity Range Management

  Hello all, I am just beginning to get into replication and have a couple questions for the experts. When I set up replication (transactional with queued updates), the default identity range was set to 10,000 for the publisher and 1,000 for the subscriber. I understand that if I try to insert 1,100 records at the subscriber, I will get an error saying that the identity range has been exhausted and I need to run sp_adjustpublisheridentityrange on the publisher and the Distribution Agent for the subscriber. My questions are: Why wouldn’t someone increase the identity range to a very large number, just in case something happens and the publisher/subscriber link is broken for an extended period of ...Show All

• Grant Jenkins ReturnProviderSpecificTypes

  Is it possible to set this in Analysis Services 2005 I am going against an oracle number and Analysis Services is picking Double as the datatype but it is not working I am getting the following as the error- 'Errors in the high-level relational engine. The following exception occurred while the managed IDataReader interface was being used: Arithmetic operation resulted in an overflow..' If I cast the column to number(28) it works which is the size of  system.decimal Is there anything i can do in analysis services to accept the number(38) that oracle is sending instead of casting to number(28) Moved to SQL Server Analysis Services forum. For AS gro ...Show All

• LukeBMS Can't access analysis cube from other machines

  Hi, I have created an analysis cube in my machine. Now I am trying to access this cube from other machines. But analysis server is not being accessable from other machines. Hence I am unable to acces the cube as well. Please give some light on it. It is really urgent for me... Thanks Sourav Dhar Hi Sourav Are you using 2000 or 2005. Sounds like permissions problems between the machines and users that are trying to connect. If you are using 2005 you may also need to check the surface Area configuration to make sure that the set up for analysis services allows access from other machines. Michael If you are running your AS2000 cube from your workstation, with Wi ...Show All

• Wolvenshade SQL Server Management Studio Express will no longer start

  I used to have both SQL Server 2005 Express and SQL Server Management Studio Express up running just fine until I installed (removed SQL 2005 Express) SQL Server 2005 for Developers and re-installed SQL Server Management Studio Express - now, SQL Server 2005 for Developers works, but I can not start SQL Server Management Studio Express No error messages, simply nothing happens when I execute ssmsee.exe. Should I be using a different version of Studio Thanks, Tor I am struggling with the same problem. The template.ini is in the SQL Server installation package next to setup.exe. You can set different things with parameters like ADDLOCAL, REMOVE and UPDATE. I tried different things to make space for the Client Component ...Show All

• Aditya Kirloskar SELECT statement with two retrieved columns originating from the same dbase fields

  Hello, I've been busy all night searching and reading trying to figure out how I can do the following. I have a table that tracks user IDs in multiple fields. When I select records from this table I need a way to resolve those ID fields back into user names by referencing the users table. SQL statement thus far... SELECT A.Username as NameA, B.Username As NameB, FROM theTable, Users As A, Users As B WHERE theTable.UserIDA How do I resolve theTable.UserIDA and theTable.UserIDB back to Users.Username so that the records returned fill the fields NameA and NameB Your help is greatly appreciated. Thanks, -Mike Hi Mike, Your query might look something like: SELEC ...Show All

• Mitesh Shah923 Expanding All SubQuery Nodes In Reports

  Hi Everybody, I've got a report that builds out top level data and adds the plus symbol (+) for collapse/expand next to each of the rows for me to display a detail level tied to that record. The problem is when we do an export or print, it only applies to the top level instead of all of the detailed information. Is there a way to automatically expand all tree-nodes in a report for these subqueries Thanks in advance. Best Regards, Justin Thanks again for your quick reply - this forum is a life saver! I've got the visibility dialog up, but I'm not sure how to change it to 'Expand All'. Currently the Visibility radio button is set to 'Visible'. Is there an expression, or something el ...Show All

• jomanlk Creating a Proxy Account

  I am trying to run SSIS packages under SQL Server Agent 2005 and I keep getting a package failed error in the event viewer. I've heard that I need to set up a proxy account. I have found the following code and need a little explanation on what all the parts mean since I am very new to this: Use master CREATE CREDENTIAL [MyCredential] WITH IDENTITY = 'yourdomain\myWindowAccount', secret = 'WindowLoginPassword' Use msdb Sp_add_proxy @proxy_name='MyProxy', @credential_name='MyCredential' Sp_grant_login_to_proxy @login_name=' devlogin', @proxy_name='MyProxy' Sp_grant_proxy_to_subsystem @proxy_name='MyProxy', @subsystem_name='SSIS' Let's say for the sake of argument my domain is called CompanyInc and I log into wind ...Show All

• Bhupendra_Singh_4c7760 Date out of range?!

  Greetings! I have a data source that gets generated based on a variable with the following SQL : "select * from result where deletion_ind = 1 and when_deleted >= '" + (dt_str, 50, 1252) @[User::Last_Run_Date] + "'" But when I run my package I get an error message saying: The conversion of CHAR to DATETIME resulted in a DATETIME value out of range The Last_Run_Date variable is set to '2006-06-25 14:35:05.450' When I run the code in a QA session it works, but in the package it complains! What am I doing wrong Thanks for your help in advance. Does the error get thrown by SSIS eval;uating the expression or by SQL Server when it gets executed If the latter...use SQL Profiler to ...Show All

• Mitch84095 Deleting million rows after checking duplication

  I have a table(9 fields) which contains around 10 million records. Within these 10 million records, don't know how many are duplicated rows. I wrote a cursor which checks duplication on all of the 9 fields within each row, and then returns back with the count of rows that are duplicated. I subtact 1 row and delete all the other rows. Problem is that this thing takes a lot of time to execute. At the current rate(approx. 90 records/hour) this cursor is going to take months to clean the table. There is no PK or no indexing what so ever on the table, and I HAVE to check each and every field for duplication(all except 1 fields are nvarchar). Please help me. I need to sort this out What about doing a ...Show All

• davidacoder Back-up DB but keep the files for 3 days?

  Hi I have created a job to backup all our database. It works fine and creates .bak files in default folder. I have scheduled the task to run every 4 hours. My question is how can i modify or program this backup plan to keep the backup files for only last 3 days and delete older backup files Mits I did some digging and I found out that there is in fact a way to delete old backup files within the SQL management studio. I was told this functionality was going to be added with SP1 and apparently it was, just not where I expected to find it. I haven't had a chance to test it very much so I'm going to continue running my VB Script, but it is there. Basically there are two ways to create backup jobs ...Show All

• OmegaMan "Incorrect syntax" exception when prefacing SP names with "dbo." and named parameter issues

  We're currently trying to evaluate SQLJDBC 2005 1.1 June CTP's support for database mirroring automatic failover. Unfortunately we're getting unexpected exceptions for calls that work fine w/ jtds that our blocking our ability to perform these evaluations without us making substantial changes to our codebase. The first issue is with the name used when calling a stored procedure -- SP names that start with "dbo." give us the following error: com.microsoft.sqlserver.jdbc.SQLServerException: Incorrect syntax near '.'. src:{call dbo.xyz( , , , , , , , )} The call will work if we change the SQL statement to {call xyz(...)}. I don't understand why we would need to do this, especially given that the documentation for the dr ...Show All

• ZUTI SQL 2005 Install Error - WMI Configuration

  I'm getting an error when the SQL install program checks the system - "The SQL Server System Configuration Checker cannot be executed due to WMI configuration on the machine DI-ERP2 Error:2148007941 (0x80080005). I've tried a bunch of stuff as suggested by some of the other threads, but nothing is working so far... Any ideas would be greatly appreciated. To anybobody else that runs into this problem...I've found the only way for me to fix this was to re-install windows on top of the old installation, install SQL, then AFTER SQL is installed, visit the windows update site. After windows update, I continued to have problems with other programs that needed to be installed, but they were minor, and easy to fix. ...Show All

• iJonny The annoying WMI configuration error

  I'm recieving the following error: The SQL Server System Configuration Checker cannot be executed due to WMI configuration on the machine 'machine information' Error: 2147749896 (0x80041008). I've researched the error and found out some people were running batch scripts to reinstall wmi, but none of them worked for me. One of them I gave up on after thirty minutes and it wasn't doing anything. Please give some suggestions on how I can resolve this issue. Yay! I've actually maged to get it working! More or less. If anyone else is having similar troubles, here's what I did. As on this page http://windowsxp.mvps.org/repairwmi.htm , I downloaded, READ ABOUT, and ran the WMIDiag script. That pointed ...Show All

• TA123 Multiple Instance of DTS

  I have a DTS package I created that is dadabase driven to process source data from multiple sources. Can I run several instances of this package in parallel for each source or would I need to create a copy for each source JavaWaba javawaba wrote: I have a DTS package I created that is dadabase driven to process source data from multiple sources. Can I run several instances of this package in parallel for each source or would I need to create a copy for each source JavaWaba This isn't a DTS forum. I recommend you direct your question to the DTS newsgroup microsoft.public.sqlserver.dts ...Show All

• moemen.ahmed Cannot transfer/copy database in one step like I could with 2000.

  Hi, I would like to know if there will every be a clean way to transfer a database from a remote server to a local server (and back again). I've tried several different approaches, but they all currently have bugs/problems. I've looked into database publishing wizard - but this creates a huge script that takes 10x longer to run than the old DTS transfer. I've tried copying data, and objects separate, but this requires multiple steps, using DTS this was all done in one step. I've tried using SSIS Transfer SQL Objects, but the defaults are not created, using DTS, the ENTIRE database was transfered, which is what I want. I've tried using SSIS Transfer Database, but even when I select "Online" mode, I get an error aski ...Show All