Answer Questions

• Chad Meyer Aggregates in Matrix Reports

  I am having a similar issue in a Matrix report. The following is a message from someone else having the same problem. I have a calculation (Aggregate) that has a scope that is for both the Row and the Column. Example: What is the percent of total sales and percent of total category sales How do I do these Percentages in a Matrix                 &nbs ...Show All

• KennyKls Align image

  I have an image in a table cell in my report. Naturally not all images fit 100% in the cell which is why I'd like to align the images in the middle of the cell, horisontally and vertically. I've been unable to figure out how to do this in Reporting Services for SQL Server 2000. Am I missing something or is this simply not possible Does anyone know whether it can be done in 2005 http://blogs.msdn.com/ChrisHays/ this link tells you what i ...Show All

• AJ Yu unhandled exception when using management studio

  Hi guys am getting unhandled exception when scrolling thru objects in object explorer in sql server management studio. it happens intermittently when i click different objects like diagrams,tables etc., any help on this much appreciated. BTW previously i had RC1 but now i have standard edition.i used get similar error with RC1 also. the error i get is "Unhandled exception has occured in a component in your application.if you click continue, the ...Show All

• RGunasekaran Occasionally slow to connect to a sql2005 database

  Hi We have a VB app talking to SQL 2000 and SQL2005 databases. Most of our clients use SQL2000, but the new ones we are deploying with SQL2005 Sometimes the app is slow in establishing a connection to the database when it is SQL2005. The provider is sqloledb. We never get this delay in SQL2000. Sometimes it takes seconds to establish a connection - this is even the case when the app is on the same machine as the database. We are us ...Show All

• tequila63 Restoring a primary log shipping database - will it ship ?

  Hi, If I perform a point in time restore on a database that is currently a primary log shipping database, will the rollback be reflected on the secondary servers or are extra steps neccesary to accomplish this Thanks. No, it will not be. You will have to reinitialize log shipping. ...Show All

• TareqFityani Does SSIS have these features????

  1> Support for rules based and change-data-capture extracts 2> Push and Pull methods supported 3> Convert between ASCII and EBCDIC 4> Ability to extract from packages like SAP and Peoplesoft natively 5> Extract from multiple sources simultaneously 6> Support for native database features like database bulk loaders sam_idea wr ...Show All

• etan SQL Server memory leak

  I was doing a quick test with SQL Server Express and noticed that there is memory leak Here is the pseudo code do loop //1000 times { 1. Open connection to the database 2. Build SQL statement 3. Construct SQLDataAdapter 4. Fill DataSet using ( adaptor.Fill(dataSet); ) 5. Close connection to the database 6. Dispose whatever is disposable } When I ran this test I saw that SQLServer service memory usage is going up ...Show All

• raaj_001 Installing Quickstart DB-Samples

  Hello I just installed configsamples.exe with SQL Server 2005 Express Edition. Then I installed the Quickstart Databases "Northwind", "Grocer" and "Pubs". After that I tried to grant access to the ASPNET-useraccount with command (command copied and pasted from HTML-File "Configurationdetails for MS .NET Framework SDK-Quickstart (in german)): sqlcmd -E -S (local)\SQLExpress -Q "sp_grantlogin ...Show All

• bazinou Copy Database error on Execute SQL Server Agent Job

  Interestingly I can get further with Copy Database than I did in the last beta. It still won't finish successfully though. Here's a log from one of my attempts. Thanks in advance! #Fields: event,computer,operator,source,sourceid,executionid,starttime,endtime,datacode,databytes,message OnPreValidate,RATBERT,NT AUTHORITY\SYSTEM,CDW_CSIADRESKO_RATBERT_0,{00F97964-A8B9-4816-9A87-A39C952A31AA},{3F1C9CB0-A9E8-47E8-B0FA-E07F7EA9AE55},11/15/2005 1:15:3 ...Show All

• Mike Schultz "Microsoft.Jet.OLEDB.4.0" has not been registered

  Using OpenDataSource I run into this problem. I have an SQL Server 2005 installed on Windows 2003 64 bit server (no itanium) I have a 32 bit client where I run Management Studio. This is the full detail of the error: -------------------------------------------- Msg 7403, Level 16, State 1, Line 1 The OLE DB provider "Microsoft.Jet.OLEDB.4.0" has not been registered. -------------------------------------------- I have tried installing a ...Show All

• popoi90 Table control causes pdf Format skipping pages

  Whenever I use a table control a in report in SQL Server Reporting Services. When I save that report to a PDF format, every other page is  blank in a multipage report. Every other page is skipped. Has anyone else run into this problem Hi, I have also this same problem.If multirow table can fit into a single page,It skips a page and renders into the next page.This happens only when we export to PDF. any help would be great ...Show All

• tarusoft Errors in DB Integrity Check

  I set up a test database to try and understand table partitioning. Since deleting the partition schemas, functions and all relevant info on the database properties page, I am getting the following errors during the weekly database integrity check: Msg 8914, Level 16, State 1, Line 1 Incorrect PFS free space information for page (1:223) in object ID 60, index ID 1, partition ID 281474980642816, alloc unit ID 71776119065149440 (type LOB data). ...Show All

• Paymon CLR Stored procedure to access Ole datasource, how?

  I tried to write a CLR stored procedure using C# in SQL 2005 to access an Access database. When I use the OleDbConnection class in System.Data, the procedure throws SecurityException at runtime. Output as following: System.Security.SecurityException: Request for the permission of type 'System.Data.OleDb.OleDbPermission, System.Data, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089' failed. at System.Security.CodeAccessSe ...Show All

• Eduardo Sagredo SSIS Job Failed

  I created a simple SSIS package. I build the package. I can run the package with no problem. However, when I schedule a job, the job always fail. Does anyone know what is the problem The error message of the job doesn't help at all. Here is the error message I got from job history: Date 5/19/2006 2:02:21 PM Log Job History (ssistest) Step ID 0 Server ABC Job Name ssistest Step Name (Job outcome) Duration 00:00:01 Sql Severity 0 S ...Show All

• Katil cant access report manager options

  Hi friends i installed sql server 2005 standard edi with reporting services on win2003 server. i can open report manager page in IE but i cant access anything i mean report builder,upload file link option etc., they are disabled for some reason. Yes i went to site settings(interestingly i can access this !!) and gave all rights i see there to the user but no avail. interestingly i can access all options from IIS manager ! any ideas how to fix th ...Show All