Answer Questions

• syhzaidi Web Sync: strange behaviour with the snapshot size

  Hi There's *strange* behaviour with snapshot size during subscription initialization. So... The initial snapshot has size about 9Mb at the publisher. After subscription creation, I notice that the subscriber downloads about 21 MB. It seems to me, that the snapshot is unpacked on the IIS, next, part of the files are packed again and just after it the changed snaphot is sent to the subscriber. Why How it can be solved It brings some extent nuisance... Thanks Paul It could be merge metadata, or it could be changes. You can find out by querying the MSmerge_sessions table at the subscriber or publisher to see if there were any other rows/changes uploaded or downloaded. Also, the ...Show All

• Tony Abraham repeat information

  Hello everyone, I have a report that shows some people’s information (sex, birthday, phone number, e-mail...) And I did a table that shows these information by expanding the person name.. for example: + Pedro + Mike + Matt and when I click on Pedro should appear: - Pedro Sex: Male Birthday: 02/15/1987 + Mike + Matt My problem is when the information is collapsed, it shows: - Pedro Male 02/15/1987 - Mike Male 12/12/1985 - Matt Sex: Male Birthday: 06/21/1980 Does anyone know why this is happening PS: Im sorry if this thread has some gramaticals problems. ...Show All

• Duane Haas Incremental Update

  Good afternoon, I was wondering if someone could help. I'm busy researching into SSAS's capabilities, specifically Incremental Updates, however this would be the first time I'm working on SSAS, so I don't know where to begin. I've read through the BOL July 2006, and it explains that you have to enable this option; however to me it's not very clear. I followed the steps outlined in the Book; however when I go and update the source table, the partition does not update automatically. Could anyone please let me know if there is a website detailing how Incremental Updates work, and also how to set it up correctly Thanks Colin. Hello Colin, I would like to stress Tomas's warning about converting ...Show All

• WillieSea INSERT rows while SELECT returning large volumes of data against same table

  I'm taking over some legacy coding and am checking to see if there may be a better approach to some sql code I've inherited. Any input would be appreciated. Here was the problem that the implemented code was to address: Given a high volume (10 to 50 thousand inserts daily) transaction table, it was observed that when executing a stored procedure that executed a SELECT against the table while inserts were being attempted, there was considerable delay before the inserts were committed. It turns out the SELECT query was taking 100% CPU. Because of the business needs of the environment, the inserts were required to be committed in a very timely fashion. Present Solution: The currently implemented workaround implements a cursor that ...Show All

• Docpro777 exporting an analysis server db from one server to another

  how do i export an analysis services from one server to another i recently upgraded from analysis services 2000, so i didnt create the analysis services database and cubes in server 2005. Remember how you could save your db in analysis server 2000 as a cab file. is there any way to do that in analysis server 2005, so that i could simply then copy teh file over to a new server and add it my problem is trying to get the cubes as a SSAS2005 project. they are deployed using 2005, but just cant get them as a project. In BI-Dev studio there is a project/template where you can import and generate scripts for that SSAS ...Show All

• Praveen Dayanithi BIDS and SSMS very slow on Windows XP SP2

  Hi, opening SQL Server Management Studio 2005 or Business Intelligence Development Studio 2005 on my Windows XP SP2 Professional Edition is extremely slow. Espacially in BIDS it take several seconds for each action. Is anybody aware of this problem We didn't have those problems on Win2000 so I guess it is XP related. Any ideas Regards Norbert Bender I would start by making sure you have sufficient memory on the machine. Both SSMS and BIDS have a large number of .NET managed code components. .NET applications use quite a bit of memory, so they are much more performant on machines with lots of memory. SSMS runs fine on my 1.2 GHz P3 laptop, but it has 1GB of RAM. Next, if you are runn ...Show All

• Tryin2Bgood method call works from .Net form and not from SQL CLR - EnterpriseLibrary used

  Hello I created a wrapper class for a function, and exposed it through CLR. However, if I call this function form SQL it blows up but if I call directly from a test Windows Form the call works fine. The blow up is related to EnterpriseLibrary.Data, where my Queue class uses that library to do all data access call ops Here's my wrapper class: namespace inlineCLRsql { public static class Wrapper { public static void CallQueueEntry( int queueId, int deskNo, int missed) { inLineLib. Queue oQueue; inLineLib. QueueEntry oQueueEntry; oQueue = new inLineLib. Queue (queueId); oQueueEntry = oQueue.callQueueEntry(deskNo, false ); Microsoft.SqlServer.Server. SqlConte ...Show All

• Muhammad Azeem Azam MSI - VdProj project

  I have SSIS package and configuration file. Configuration file refer to some file/exe/dll. I need to create a installer for this to install / copy all this to a target (destination) machine. I am executing the SSIS package using the BAT File with command dtexec etc.. The execution of the SSIS package i.e. execution of the BAT file in turn is done using windows task scheduler. Please suggest me the steps (example) how to create such Vdproj project using Visual Studio 2005. ...Show All

• Kyle Anderson I have a simular problem as clay.routh, Can you help me please?

  Here is my sumary.txt log file from SQL Express. Microsoft SQL Server 2005 9.00.2047.00 ============================== OS Version : Microsoft Windows XP Home Edition Service Pack 2 (Build 2600) Time : Sun Aug 27 08:16:07 2006 HOME-D84394AF4F : Microsoft Internet Information Services (IIS) is either not installed or is disabled. IIS is required by some SQL Server features. Without IIS, some SQL Server features will not be available for installation. To install all SQL Server features, install IIS from Add or Remove Programs in Control Panel or enable the IIS service through the Control Panel if it is already installed, and then run SQL Server Setup again. For a list of features that depend on IIS, see Features Supported by Ed ...Show All

• atzmon Navigation buttons

  Is there a way to add the navigation bar with next page, previous page etc buttons at the bottom of the report. If the report is long the users dont want to scoll up to click on next page. Thank you Daniel. There is no easy way to accomplish this. It can not be done in Report Manager. If you are writing your own web app you could do this by writing your own tool bar, but it would require quite a bit of code. ...Show All

• Corby111 Unspecified error 80004005 only in Windows 2000

  Connecting to the database to change a record works fine in xp/xphome but trying the same thing in 2000 workstaton causes the error above. Here is the script....tried adding a password to sa, but same results Any help would surely be appreciated '========================================================================== ' NAME: templateselector.vbs ' DATE : 6/22/2006 ' ' COMMENT: Runs from an External Process. Assigns a template to an client ' and starts a PXE reset '========================================================================== 'Define sConnection from View -> console options - copy/paste database connection string sConnection="Provider=SQLOLEDB.1;Persist Security Info=False;User ID=sa;Initial Catalog=WINSTALL8;Data So ...Show All

• foobarX Dealing with quotes in a quote encapsluated column

  I know this issue has been raised here before, but I have a different angle/question on it. Flat File source, SQL Destination. No column from the source file has a consistent real width, just consistent to be less that the SQL column. Issue: CHAR(12), SMALLINT, CHAR(78), BIGINT "100012",0,"This is the ""Memo"" of the record, it needs to be imported.",12 This row errors out due to the double quotes around the word MEMO. Additionally, the entire package stops processing due to there being a comma in the memo after the quote encapsulation is escaped. Has this issue been addressed in any of the SP's If not, how about this thinking: 1.) Character index the pattern ," and take the ...Show All

• KRSE Web Synchronisation Throuth SSL

  hi, i have done Web Synchronisation Using RMO , where i have an remote server at a remote place, where the Virtual Directory is Configured With SSL, for testing purpose if i access from the Client Computer entering http://72.17.246.214/SyncAbita/replisapi.dll diag " in the address of IE giving an errormessage "Unable to Reach Remote Host", if i remove SSL on the Server , i am able to access "SQL Websync diagnostic information" Page from the Client Machine, is it not possible to get perform Web Synchronisation With SSL, then i have inStalled 7 days Trial Version SSL on the Sever. Can any body help me out on this Issue Make sure the name of the machine on the certificate and the one you are using on the ...Show All

• wiscon Eternal 'Enable Pending' on SQL2005

  Hi! I have this problem... im kinda new to sql2005, and im responsible for creating some notification services. Ive done a lot of tutorials, books and samples and every time, when i reach the step of enabling the instance, i get this... Generator-Enable Pending Distributor-Enable Pending Even doing the Microsoft's Notification Services Tutorial. Ive tried everything I could figure, registering the instance with a user with every permission there could be... doing this local or on a client... and ive been 2 weeks stuck here... Any tip or clue will be thankfull. M.Eng.Leandro Melendez Well, i thought that i should start the windows service after enabling the instance... but ive tried also that, ive already tri ...Show All

• Crazy Engineer Kid Create Table with variable name

  This should be simple, but... I want to create a table in a stored proc using a variable name instead of something hard coded. I was hoping to do something like.... CREATE PROCEDURE foo -- Add the parameters for the stored procedure here @TableName char = null AS BEGIN SET NOCOUNT ON ; CREATE TABLE @TableName ( [HRMONTH] [int] NULL, [HRYEAR] [int] NULL ) ON [PRIMARY] But no combination of names '@'s , etc, allows me to use a variable name that I passed into the procedure. What am I missing I will either receive a syntax error or the procedure will create a table called TableName rather than whatever TableName really stands for... Thanks, Tom ...Show All