Answer Questions

• Shaolyen SQL 2005 partitioning

  Can anyone tell me for certain in which versions of SQL 2005 is Table and Index Partitioning functionality available Thanks, Dan That's what I assumed, but I was hoping for a different answer. I have a DB that has a few very large tables, but the rest are manageable. And the amount of demand on the database is on the low side. However, I wanted to be able to p a rti tion the larger tables to allow for better reporting performance and easier archiving. I wanted to do this without having to shell out the $15K for Enterprise. Thanks, Dan Enterprise only - see this link for more details ... http://www.microsoft.com/sql/prod ...Show All

• hobie_3 Full-Text Search setup

    When I attempt to define a full-text index with the SQL Server management studio, I can complete all steps successfully except the last where you define your catalog population schedule.  When I go to complete the setup process, I get this error when it gets to the setup of my population schedule: - Create catalog population schedule test on testDB.test (Error) Messages Create full-text population schedule failed. ------------------------------ ADDITIONAL INFORMATION: Failed to connect to server .. (Microsoft.SqlServer.ConnectionInfo) ------------------------------ An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that ...Show All

• nhaas SQLMobile

  What is merge when I update the row on SQLMobile(Subscription) is it Publication will updates too if you're talking about merge replication, if you update row on the subscriber, the change should be propagated back to the publisher when you synchronize. You can find more information in Books Online. ...Show All

• Salman Maredia RS2005: Rendering Drill-down to HTML w/o dynamic load?

  Is it possible to render a drill-down report to HTML with no dependency on a direct web site connection I created a report with expandable regions ("drill-down"/visibility toggle functionality), and am using C# code to render directly from a ReportServer web reference. The HTML returned contains Javascript that makes a new call to the report server each time a region is expanded. I would rather return all of the data and have the region be expandable only for display purposes. Is there a report or server property that can enable this functionality I am using Reporting Services 2005 and C# 2.0. Thanks, Paul Whitaker Currently performing this kind of interactivity is not supported without re-rendering th ...Show All

• lamont_23 Export SQL DB into a plaintext format

  Hi, Is it possible to export SQL DB into a plaintext format Just as I would use mysqldump to export a MySQL DB. I got to the point when it extracts the DB structure into plaintext format, but all the data is missing. I would highly appreciate if someone could assist! Wow! That was a complete description. In my case, I create a script to execute in all database tables. This will generate an INSERT script which I will include in the database schema script you were mentioning. bcp Utility The bcp utility copies data between an instance of MicrosoftR SQL Server 2000 and a data file in a user-specified format. Syntax bcp {[[ database_name . ][ owner ] . ]{ table_name | view_name } | &quo ...Show All

• ar_pad 2005 Management Studio Find in Result Grid?

  Is there any way to do a find in the query results pane when the results are displayed in a grid I love using the grid for results because it compacts everything, but I very often have to search through the results. Unfortunately, we don't offer this functionality. Could you file this as a suggestion on Microsoft Connect http://connect.microsoft.com/SQLServer/ Post the Connect URL to your bug back in this thread so that others reading this can vote on it. Lame Workaround: Can you copy it into Excel Paul A. Mestemaker II Program Manager Microsoft SQL Server Manageability http://blogs.msdn.com/sqlrem/ No, not AFAIK. HTH, Jens K. Suessmeyer. --- http://www.sqlserver2005.de --- ...Show All

• yandrea no more suprise in my tables

  Hi, every one, i've a problem. i use catalogs in my DB, in fact i dont have any more for the moment to insert in that tables, i try to protect it from others persons than use the same user to make replication from this DB, since they started the replication started the problems,i cant protect from them my information , and i'm no sure if they need all the permission and what kind of role they need what can i do to protec my tables from the protecters   tavoras wrote: Hi, every one, i've a problem. what can i do to protec my tables from the protecters You can start by asking in a more appropriate forum. This forum is for SQL Server Integration Services, not security . Thanks, Phil ...Show All

• MrPenny Sample database not found?

  I install the SQL 2005 Evaluation. I selected to install samples and documentation during the installation wizard. It finished successfully but I could not find the sample databases on the SQL Management Studio. Why Thanks. Joe. Thanks Jens. I cannot any sample databases on the path you mentioned. Can I download them individually Thanks. Joe. I have never used the trial version but look in C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data to see if the sample database files exist. If they do you can simply attach them via Mgmt Studio. D Derek gives good advice so I'd try his op ...Show All

• WIreD 0x90 How to Use Data Type GUID in UserVariable or foreach loop?

  Hi Folks, I am trying to build a Package that selects a list of Uniqueidentifiers by "Execute SQL-Task" and then loops through the ResultSet of the query using ADO.Net Enumerator to do something with this GUID Value, namely deleting all entrys with this PK in a different DataBase. The main Problem I am facing is that you can’t select the type "GUID" for a user Variable in "Execute SQL-Task". All the Datatypes are there except for GUID! This leads to the following error: Error: 0xC001F009 at Package: The type of the value being assigned to variable "User::ImagicID" differs from the current variable type. Variables may not change type during execution. Variable types are strict, except f ...Show All

• Lostlogic SQL Server Manager Studio: Error when loading

  All of a sudden I am getting this error when I run SQL Express Server Manager Studio. any Ideas whay and how to fix it ------------------------------------------------------------------- See the end of this message for details on invoking just-in-time (JIT) debugging instead of this dialog box. ************** Exception Text ************** System.BadImageFormatException: An attempt was made to load a program with an incorrect format. (Exception from HRESULT: 0x8007000B) at Microsoft.Win32.Win32Native.SHGetFolderPath(IntPtr hwndOwner, Int32 nFolder, IntPtr hToken, Int32 dwFlags, StringBuilder lpszPath) at System.Environment.GetFolderPath(SpecialFolder folder) at Microsoft.SqlServer.Management.UI.ConnectionDlg.Personalization.get_ ...Show All

• QWERTYtech Cannot open user default database. Login failed.

  Hi, I got this application system having SQLExpress as database (ABCSystem.mdf). I'm connecting to the database thru connection string specifying database path in App.config. At the same time, I got two paths for the mdf files. The first one is the path for my database project while the second one is the path to conduct testing. (This means that I got identical ABCSystem.mdf in two paths) 1) C:\Program Files\Company ABC\ABCDatabaseProject\ 2) C:\Program Files\Company ABC Limited\ABCSystem\Database\ In my development machine, I can run my application where database path is testing path (number 2). When I tried to copy the ABCSystem.mdf and ABCSystem_log.LDF and my application program files to another PC to test, I got ...Show All

• Marzullo XML Data Source (from .NET library call)

  Is it possible (maybe by use of the report code) to bind an XML data source to the return of a call to a .NET library in the GAC Yes, I had already read that. It doesn't provide any help for my particular scenario. The built-in xml data extension can invoke web services over SOAP and also read xml files directly from a url. If you want to invoke for library and map the result to a RS dataset, there is the option to implement your own custom data extension that makes the necessary conversions (starting point in the documentation: http://msdn2.microsoft.com/en-us/library/ms154655.aspx ; there are also several RS books that provide examples of custom data extension impl ...Show All

• bsam Understanding ROLAP

  We are looking at adding a real-time aspect to our SSAS cube set, to allow reporting against a relatively small but constantly changing data Our initial thought was to use ROLAP partitions and dimensions - we were under the impression that the queries would always be satisfied from the underlying relational tables. However, in our explorations we are finding that understanding to be incorrect - SSAS is in fact caching data, so it ends up returning stale data. We've configured our paritions and dimensions for ROLAP and disabled all proactive caching (we would like this solution to work with SSAS Standard Edition, which precludes the use of proactive caching). Is there something else we need to figure Are are we headed down the wrong path h ...Show All

• tochaitüs possible to access postgresql from sql server ce

  I am wondering if it is possible to access a remote postgresql database using the sql server ce access classes. I do not want to run a postgresql server on windows ce, just access one from a mobile device. No, you can not. As name implies you can only access SQL Server CE with SQL Server CE access classes. After doing a little research based on what you said I would need, I did find a beta OLEDB provider for postgresql http://pgfoundry.org/projects/oledb/ (which may or may not work on CE) But if there's not Ado.net provider for CE, then it's a moot point. Windows CE has no support for ODBC. It has support for OLEDB, but there's no OLEDB ADO.Net p ...Show All

• IceAngel89 Applying CASE in Stored Procedures

  I'm creating a stored procedures, and pass in few parameters, which is @keys, @fields, @types and @likes, whereby I will select from certain table based on the @types, where the @fields equal to @keys, I also wanted to implement the LIKE to the statement as well, but I found out some problem, so ends up my stored procedure looks like this: ALTER PROCEDURE searchBooks @keys varchar(50), @fields varchar(50) AS SELECT * FROM books WHERE (CASE @field WHEN 'Author' THEN Author WHEN 'Publisher' THEN Publisher WHEN 'Title' THEN Title WHEN 'ISBN' THEN ISBN END)= @keys This statement run well, but I would like to specify the table to select with parameter instead of specified it, but I found it won't works, not even let me s ...Show All