Answer Questions

• bubu SharePoint Integration

  I originally installed SQL Server 2005 and configured Reporting Services to run on a different port and website and all worked fine. I can access it via localhost:15540/reportserver and also use BI Development Studio to creat and publish reports. I updated to SQL Server 2005 SP2, selected SQL Server integration on Reporting Services Configurator, created a new Report servcies database. Now when I go to localhost:15540/reportserver, the reports I had previously had available do not show... that may be ok However, I go to Sharepoint 3.0 Central Admin, no entry for Reporting Services show under App Management. Should it I also notice that link localhost:15540/reports no longer work... Where should I be able to go to get access to the ...Show All

• ippological Which method to use for synchronization?

  I have three options in my mind to synchronize my data of sql server compact edition with sql server 2000/sql server 2005. 1)Merge Replication 2)Remote Data Access 3)Web Service All the data would be residing on Sql server 2000/2005 and user will get their data after being authenticated and will change the data and add new data and then again will synchronize with server with new changes. Please suggest me solution, my opinion is going towards Web service. Thanks SOA is a nice ideal but the amount of pain involved in "rolling your own" nearly always outweighs the benefits of having total control. IMHO you are much better off using a predefined sync technology (such as rda, mer ...Show All

• dfl Update Help Requested

  Dim command As SqlClient.SqlCommand = New SqlClient.SqlCommand( "UPDATE Table SET RATING=" & "D" & " WHERE ID=" & Num - 1, connection) I keep getting NO column named "D". I wanted to update the colomn "RATING" to "D" Or Update Table and set column RATING to D where ID = Number. Can some write it correctly for me Thanks. Dim command As SqlClient.SqlCommand = New SqlClient.SqlCommand( "UPDATE Table SET RATING='D' WHERE ID=" & Num - 1, connection Found it in an earlier code. Thanks ...Show All

• andyfraser free memory

  i'm using BULK INSERT to insert data into table let say my function is: void foo() { char query = " BULK INSERT ABC FROM \"c:\\xxx.csv\" WITH (FIELDTERMINATOR = ','); rc = SQLAllocStmt( g_hdbc, &statement ) ; rc = SQLExecDirect( statement, ( unsigned char *)query, SQL_NTS ); rc = SQLFreeStmt(statement,SQL_CLOSE); rc = SQLFreeStmt(statement,SQL_DROP); } each time i'm run the function the memory the SQL SERVER service consume is about 100MB and it's never goes down what is the reson for this when i drop the statment dont i free the memory ir should i config some thing in the database thanks ishay its ok even if it's keep going up to 2 GB ...Show All

• INeedADip Synchronous Merge replication(Automatic)

  hi there I am using SQL SERVER 2005. I am creating a Merge replication(between two databses), its working well, but i need to goto the Local publications & right click there & select the "View Synchronization Status" & then start the Agent manually to Synchronous the databases. Now I want the Two databses should be replication (Merge) automatically without going to any menu. I mean the Synchronization takes place when any of the Databases changes, automatically, without touching anything. For Example: If one record is inserted in a table(on commit) of Database ONE, it should be Reflected to the other table of the database TWO. Any Idea, or Link or solution Gurpreet S. Gill ...Show All

• Bobby DeRosa regedt32.exe

  if you're using win2000 do what the guy said to do. Don't use the regedit, use regedt32.exe. then copy the numbers of the last messages and place them in the correct place. You're absolutely right! This should have been a replay to http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=356308&SiteID=1 . Hi Justin It seems like you had opened a new thread rather than repling any current one Regards ...Show All

• Callavin Enabling remote errors

  Hi, I am accessig reports through report manager. The RS and report manager are installed on same remote machine. i have edited the ConfigurationInfo table in the report server database to set EnableRemoteError to True but still i am gettin the following error when i try to access the reports from my machine through report manager(installed in remote machine) An error has occurred during report processing. (rsProcessingAborted) Cannot create a connection to data source 'Prague DB'. (rsErrorOpeningConnection) For more information about this error navigate to the report server on the local server machine, or enable remote errors I have done that, but still i am getting ...Show All

• Andy Wilkinson LDAP - HOW DO I CONNECT TO LDAP DB FROM SQL SERVER 2005?

  This is something that should not be so difficult, but it is proving to be very cumbersome. I need to query an LDAP database on a Linux server FROM a sql server, namely sql server 2005. I have found bits and pieces, but can’t seem to put it all together yet – it should be easy, but it’s proving to be very difficult. It seems like you can either link an LDAP server through sp_addlinkedserver OR through enterprise manager/sql server studio, you can create a LINKED SERVER. The problem is HOW to do this. Here are the parameters for the ldap server: Server name: serverabc Ldap info (which I don’t know how to label) is: 'ou=Hosts,dc=mc,dc=vanderbilt,dc=edu'. I was able to somehow get this to work last week, but now it ...Show All

• Mark J. hidden cell in excel

  Hello, Can someone please tell me why there's ALWAYS a hidden cell in Excel when a report has a more than one page for example, a report has 10 page breaks and after exported to Excel it has the first row hidden in each sheet except the first sheet. Why this happens always is there any workaround to avoid this thanks Hi Geert, Although I didn't build the reports myself, I spoke with the author, and inspected the layout view (and RDL), and we are NOT using Document Maps. Might there be another reason for the "hidden row" issue with exported Excel reports John Hey Ham, Yes, one long continuous sheet in Excel, but the page brea ...Show All

• Scott Chang Open encryption key in stored procedure

  Hi, I would like to create a stored procedure, which accept RunAsUser, MasterKeyPassword and also ASymmetricKeyPassword. In this stored procedure, it call OPEN MASTER KEY and etc. I put these code in stored procedure so that my support staff can call it when doing maintenance by passing the parameter. I don't expect them to remember OPEN MASTER KEY and etc syntax. However, I hit error "Invalid Syntax" when I run my code as below. Any ideas Thank you -- ================================================ -- Template generated from Template Explorer using: -- Create Procedure (New Menu).SQL -- -- Use the Specify Values for Template Parameters -- command (Ctrl-Shift-M) to fill in the parameter -- values below. -- -- This block of comm ...Show All

• Wasim 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 Yeah, i did that and everything i could... After many searches ive found a comment saying that everything worked after reins ...Show All

• moveit Forecasting in analysis tab cannot view

  Hi I installed the add-in for excel data mining but when i try to select a table, in the tab of analyze, dont have any properties. please help me. carlos of southamerica Did you select a cell within a table Do you see "Table Tools" above the ribbon Do you see "Analyze" and "Design" ribbons (they are usually the last 2 ribbons) If all answers are yes, what do you see in the Analyze ribbon ...Show All

• Suman Ghosh Upgrade SQL express database to SQL server Standard database

  Can I upgrade SQL express database to SQL server Standard database Please give information to me! Thank you! Yes, you can upgrade from Express to Standard. Just pop in the Standard media and start the installer. On the instance selection screen, select the name of the Express instance, and continue. This will upgrade the instance and allow you to add the new components you selected. If you do not select the Express instance, it will install the SQL Standard edition side-by-side. Thanks, Sam Lester (MSFT) Thank you for your information. ...Show All

• Jason D. Camp User!UserID subscriptions and snapshots

  In order for subscription to work when report parameter uses User!UserID global I use this function: public function Username() try Return Report.User!UserID catch Return "" end try end function However this will not work for the snapshots. Any ideas, why same as subscription, however the fix above is good for subscription only. Because a snaphot is run without a user context, reports that use the userID property can not be run as a snapshot execution. We would not know what user to use. ...Show All

• Ryan Hawkins SQL Server Setup failed to modify security permissions

  Last night at home on my 64 bit Vista machine, I encountered the same error 29506 that said that the management studio express could not be installed.  I looked up the error message and below is what I received.  I also installed the 64 bit .net framework which installed just fine before trying to install the SSSME. I followed the instructions below but this did not seem to make a difference.  However, I did not reboot after applying new permissions.  I have installed this software a few times now on 32 bit machines for both XP and RC1 Vista, and have not had a problem.  Last night, I did use the 64 bit version.  Also, there is no data file yet because after the install it rolls back, so I gave myself ...Show All