Answer Questions

• chakravarthy_b Migrating from ASP

  I have a bunch of contracts built in asp and I need them to be published on report server. Is there any easier way than rebuilding them in report designer There is not migration path from ASP to Reporting Services reports. You can store the asp contracts in reporting services as resources, but they will not be executed as reports. ...Show All

• Quimbo DW partitioning advice needed by lost soul

  We are putting our first DW together. One of the consultants, not familiar with the MS SQL database, suggested we consider "parititioning" our data for ease or reloading, distaster recovery etc. His idea was that we could parition the data based on, say, year, and that way, in case of a disaster, we would only need to reload that year's worth of data from our backups. (So I guess he is talking about software partitioning, not hardware partitioning ) I can't imagine how this approach wll work with our nightly backup strategy or the changes the need to be made to the DW import code to to handle these partitons. Furthermore, in case of a disaster how is one to even know what parititon(s) to reload. (I'd be incliined to reload the ...Show All

• Giridhar Damodaram Cascading query with parameters

  I need to get at some information and this is the only way I know how to do it but I need to run these queries in order and using the previous query output. I don't know how to set up the output parameters so they can be used in the second query and the second query results to be used in the third query. In a nutshell: The first query gets a number from a user as a parameter and pulls one record containing multiple fields. Some of those fields will be needed as parameters in the second query to pull mutltiple records. I need to put some where statements in to narrow down the result set. Then this part I haven't figured out either, but then the third query takes one record from the second result set and pulls mutliple records to put ...Show All

• Nadav Popplewell I need the following details About CDI and MS SQL Server 2005 A.Services

  Hi I need the following details About CDI and MS SQL Server 2005 A.Services Why CDI is Require What are the benefits of CDI Challenges faced to achieve CDI Process for CDI What is CDI architecture Current tools available and how MS SQL Server 2005 A.Services having added advantage on others What is feature of CDI How does adopting CDI benefit Insurance Industry This all are my quires on CDI So that I can tell my client and suggest for MS SQL Server 2005 A.Services tool for CDI PS – If you have any white paper on this Pl give us the details so we can know more about this. Thanks & Regards Rajesh Ladda what is CDI you refer to Is it http://www.cdilearn.com/ Edward ...Show All

• John Portnov Can't Drop table in Replication

  Dear friends I restore one database in two database servers which is running on SQL server 2000.I replicated these two through snapshot relication.Snapshot agent is creating snapshot.But when I am starting to synchronize it's telling can't drop table because that table is in replication. Backup I taken from a replicated database.so it's having rowguid both the servers.Another thing the table which it is telling not able to drop it's having primary key.please tell me what may be the problem.In replication why it is going to drop table it's only what to transport data na Filson The database that's restored at the subscriber probably still has ...Show All

• Kamii47 Limit to number of connections to the SQLCLR?

  Is there a limit to the number of connections that can be made to the SQLCLR If so, what is that limit and is it adjustable Thanks! No, I am referring to access to the SQLCLR from any edition of SQL Server 2005. 2005 does not by default limit the number of user connections to the SQL Server instance. Internally to SQL Server, is there a limit to how many connections to the SQLCLR that can be made So for example, if had 1,000 connections open to SQL Server, will I be limited to only 200 (or some number) of them accessing SQLCLR procedures Or, assuming server resources are adequate, can an unlimited number of clients access SQLCLR procedures concurrently You canno ...Show All

• Gordon F What system stored procedures have changed between SQL 2000 and SQL 2005?

  What system stored procedures have changed between SQL 2000 and SQL 2005 I don’t know such paper either, I think the main internals was, that they changed the access to the system tables, as they are now put into schemas, rather than just owners. HTH, Jens Suessmeyer. --- http://www.sqlserver2005.de --- i dont know of any such document, though I may create one and post it to my blog. That being said, open up BOL 2005/Index and type in the following "system stored procedures [sql server]" which will take you to the main directory of sysProc documentation in BOL. You can find all the changes (breaking, behav ...Show All

• Jehan Badshah Is it possible to enable TCP/IP connection to SQL Server programmatically? Is there any function in SMO?

  Anyone know I'm making an installation package and I want my installation program (which is a custom action class inherited from Installer Class) to adjust the network configuration of SQL Server, for example enable TCP/IP. What can I do Is that any function in SMO package that can do this for me Hi, that is a registry setting, you have to switch the appropiate network protocol values in this section to get it working: HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\MSSQL.1\MSSQLServer\SuperSocketNetLib HTH, Jens Suessmeyer. --- http://www.sqlserver2005.de --- ...Show All

• webflier Problem accessing SDF file larger than 128 MB

  Hello. I created SDF database files for "SQL compact" with a size larger than 128 MB (which is default for creation). Now when I try to open these files with VS2005 I get the error "The size of the databasfile exceeds the configured maximum...Required Max Databse size (in MB; 0 if unknown)" (translated from german). The real problem is that I can not change the connectionstring in VS, cause all field which show the connectionstring are readonly (greyed out). I know I have to set the option "Max Database Size = 512" or so in the connectionstring to get the things runnning, but don't know any way to do that in VS2005. My attempt to access the SDF files when copied to the device via active sync results in the sam ...Show All

• GP-BLR SQL Server Reporting from VS2005 not Deploying

  hi I build a SQL Server Report using VS2005 in SQL Server 2005, Application is building with out any errors..I am able to preview the report data also If I deply the application on http://localhost/ReportService I am getting the A connection could not be made to the report server http://localhost/ReportServer . (Microsoft Report Designer) error. please help me, what is the problem thanks Rukku I had the same problem after installing SQL 2005. To solve the problem I have to go into the report sever configuration utility ( All programs/Microsoft SQL Server 2005/Configuration tools/Reporting service configuration) to configure. All the circle button must have green and the encryption keys ...Show All

• GlennZarb Company Dimension

  We deal with multiple vendors who provide us information via text/xml files. Vendor A may provide financial data, vendor b provides litigation data, vendor c provides ratings data. Our current structure has databases for each vendor with its own company table which basically makes all this data disconnected. Of course each vendor has its own proprietary company id to make records unique. All of the data is based on companies so the grain of data would be at a company level. I would like to be able to link this information together by creating a dimensional model that has a single company table (DimCompany) and has facts populated based on the type of data we receive. Would this be the right sequence of events 1. My initial load (h ...Show All

• Harry_Leboeuf SemiAdditive measures, LastNonEmpty, Standard Edition - I need something special

  My understanding is that the LastNonEmpty semi-additive measure: Is only supported by Enterprise Edition. Sums across all dimensions except time, where it takes the last non-empty value. What I'm looking for: A solution that works on Standard Edition and Enterprise Edition Does no aggregation at all across any dimension except time, where it takes the last non-empty value. Ideas Recommendations My current solution is to make the measures non-aggregating (i.e. AggregationFunction set to None) and the replicate the data across all values of my time dimension. This works, but it results in storing potentially 1000's of times more data in the cube than I'd like. The measures in question are limits that are used i ...Show All

• simon75uk Data Extract - Partitioning

  Hello, I have a table containing 3 columns Department Name, RiskScenario and Cost. I am trying to create a data extract that contains the top 3 Risk Scenarios (sorted by Cost) per Department. I tried using this sql statement in MSQuery but it doesn't work. Any ideas where I'm going wrong or if there is a simpler way to do this Select * from ( Select DepartmentName, `Risk Scenario`, Cost, row_number() OVER (PARTITION BY DepartmentName order by Cost) rn FROM 'Departmental Risks`) where rn <=3 Please help. Just can't figure this out! Meera Meera: Exactly what kind of error(s) are you experiencing It appears to me that you have spurious "quotes" in your query. Da ...Show All

• Michael Herman - Parallelspace Moving database from one Server to another

  I am sorry for such a basic question. But i have done a search and the answers dont seem to be relevant in my situation I have two servers with the same setup where the sql is installed in default C/programme and the db is in D/some folder So the file structure is the same Back in SQL 2000 days the transfer was so painless, where I made the DB offline and transferred the main db.mdf and log to the new server and i attached it to the new sql server in the new server. Now this process does not work. I have tried the old method and it says something like you should do it with Move or something. I transfer the back up and try and restore and it says that it is read only. Surely things should get easier with sql 2005 or sql ...Show All

• rankorn Internal SQL Server error.

  Hey, I'm working on a Sql Server 2000 and I have piece of code that raises a error message all the time: Server: Msg 8624, Level 16, State 13, Line 36 Internal SQL Server error. I found this article on microsoft http://support.microsoft.com/ kbid=830466 and i installed SP4 but i still get this message... What even stranger is that the same code runs without any problems on another database on the same server. I really confused, does anyone know how to solve this problem You could also try this two articles: http://support.microsoft.com/kb/885442 http://support.microsoft.com/kb/290817 ...Show All