Answer Questions

• Aaron Whitney Vrtual Lab

  When I go to Virtual Lab for SQL Serevr 2005, the screen displays "No Connection". I am not able to logon to Virtual lab ever! pls. help http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=145803&SiteID=1&PageID=0 HTH ...Show All

• Noorali SQL2005: Configuring Web synchronization for merge replication

  I'm trying (and failing!) to get Web synchronization for merge replication working with SQL Server Standard 2005 Sept CTP. I've created and configured a merge publication and have configured the publication for Web synchronization using the 'Configure Web Syncrhonization' wizard. I've followed all the setup instructions in the Configuring Web Synchronization article in Books Online and have tried testing that it works by accessing https://<ma ...Show All

• baeriali How to create Merge Replication with latest update always from subscribers

  Hi , I am trying to create Replication Topology (Merge Replication) like below. Subscriber1 --> Publisher <-- Subscriber2. I have created both subscribers with Subscription Type as Server with Priority as 75. I am updating the Column A of Row_10 in Subscriber1 on time say 11 am. After i am running the Starting synchronizing agent from Subscriber1. The value propagated to Publisher now publisher contains the latest value in Colum ...Show All

• visa79 Package from Package Sore does not work as Job

  Dear All, I try to run a Package which is placed in the Package Store via a job - but this does not work. Some things about the package: - The package evokes some warnings, because I do not use all columns from the datasource - Package runs in BI Studio - log is written - Package runs if startet from the Package Store - log is written - Package Execution stopps immediately if started via job - without writting in the log As hint - needl ...Show All

• Cliff Williams Attempted to divide by zero

  Hello. I'm having a little bit of a problem and i have no clue what's going on. May be somebody can explain me how the following expression could generate the "Attempted to divide by zero" error. I would really appreciate good advice. Briefly about report itself - one dataset, on single table with three groups this is a thid one. Grouping works just fine, but SUM/SUM in a footer of group #3 gives an error. Datatypes: JTD_Hours is decimal(1 ...Show All

• DamonPeng Connecting SQL2000 problem

  Hi All, I have a sqlserver 2000 & 2005 both installed on same server with the instance name as servername\sql2000 and servername\sql2005. When i try to connect the sql2000 database from dotnet2002 or 2003, It comes up with an error as sql server doesnot exist or access denied but when i tried with dotnet2005, i am able to connect it. I guess it has to do with an dotnet framework 1.0 & 1.1 but i am not sure where to look for it. ...Show All

• Nick Davidson Replication Question

  Hello everyone, We are desperately wanting to perform transactional replication from a Sybase 12.5 Databse to an SQL server 2000 database. Unfortuneately we cannot migrate the entire Sybase system to SQL server!! Bascially we want to replicate a small subset of the tables from the Sybase database to a SQL server where we can manipulate this isolated data... Any suggestuions on wether this is possible, and what new software products we may ...Show All

• adidion how to configue the reportserver?

  hi, I have recently start learning reporting service! A problem is that when I try to run the report, a error message like "report server can not be found" always occur how can i solve it thx There is probably something wrong in the configuration of your report server. Did you do a default install of report server Were there any errors showing in the configuration tool Is there anything useful in the log file ...Show All

• Gary_H Saving large text file in table

  Have created an SQL Server 2000 table which includes two columns each data type varchar(8000) in order to accomodate a semi-large amount of text (want to avoid using text data type). I enter the max in the first column but I keep getting an error of "Cannot create a row of size 12066 which is greater than the allowable maximum of 8060" when I try to save any more in the second column of the table. What am I doing wrong ...Show All

• JohnCo loading to SQL Server

  What is the fastest way I can load data into SQL SErver -- it seems to me it's with Bulk Copy and minimal logging. But that seems very slow when I look at Orace's Data Pump and DB2's LOADer. Does SSIS help here -- from what I can tell, you help me tons and tons on the ET part, but the L is what I'm wondering about... It is very fast but the performance comes at a cost. It can only attach to local instances of ...Show All

• Jagger_Mack Putting Integration Services tools back on the Start menu

  A well-intentioned effort to clean up the SQL Server entries on the Windows Start menu has made it more difficult to locate some of the commonly-used Integration Services tools and wizards. The VBScript shown below can be saved as a .vbs file and run from the command line. Use it as a starting point to add a new Integration Services submenu to the SQL Server 2005 menu with dtexecui, the Import and Export Wizard, and the Package Migration Wizard. ...Show All

• ErinMartell How to use AMO to determine if a cube is being processed by another user?

  Hello, We have a cube in AS2005, and it is going to be used by multiple users. The users will all have the ability to process the cube by clicking on a button. Is there a way to to use AMO to check whether the cube is currently being processed Thank you very much, Hsiao-I This is pretty easy. Take a look at return value for the State property of the major objects. Edward. -- This posting is pro ...Show All

• GotFocus How to Store System Variables in DB?

  Hi, I want to store the System::StartTime in my Integration Table Log. Please guide how can I use this in my Execute SQL Task Block. I write this SQL Statement: INSERT INTO CMN_tblIntegration VALUES ('HRM_tblParty', ) Which the is for the parameter. I go to parameter mapping tab and map the System::SatrTime to parameter0, but the package fails to run. I also changed the to @IntDate and also changed the parameter name but the error was the ...Show All

• Snyper_10 Server goes slow roughly every 24 hours

  I have a problem where by sql server slows down roughly every 24 hours to the point where all queries time out. This happens early in the morning about 6 am. If you let it go it lasts about 2 hours. If you restart the service it is ok ie. it does no go back to what ever it was doing before the restart. There are no jobs shedualed, nothing set up to happen automaticly. You can connect via managment studio but as I say queries time out. I have ...Show All

• SQ Report Packs and SQL Server Express

  I am trying to use the IISLog report packs with SQL Server Express reporting services. The guidance in http://blogs.msdn.com/sqlexpress/ indicates that I need to change the target URL and the connection string so that the report packs work with SQL Express. I cannot see how to centrally change the connection string, so that it will affect all the Datasets in the report project. If I try and open a report page and click on the Data tab I get the ...Show All