Answer Questions

• Anurag007 Number of User Databases

  Hello, I am being asked to support a third part y app that will create a new database per session with upwards of 500 databases being created per month, now I know that this is not good but my bosses are asking for the technical reasons why this is not good, can someone help please There are the obvious #of databases to maintain ie backup etc but what else can I add Thanks Julian I can think of ...Show All

• hz Problem with text field: text input too long, weird characters

  Hi, Im a programmer for an university webportal which uses php and msssql. When an user creates a new entry and his text is too long the entry is cut short and weird characters appear at the end of the entry. For example: http://www.ttz.uni-magdeburg.de/scripts/test-messedb/php/index.php option=show_presse&funktion=presse_show_mitteilung&id=333 How can I set the text limit to unlimited Could it be something else Is there a way of splitt ...Show All

• AstralPilot how to encrypt and decypt as a IUSR with read and write only rights

  How to decrypt or encrypt without making user a db_owner. It is for a web application and I do not want make the web user a db_owner. Is there a way to make this work without making the user a db_owner. Currently the user is a db_datareader and db_datawriter. I created an asymmetric key for encryption by password. I am not using a master key because I want to keep the password seperately on the web server, so a hacker cannot get access to ...Show All

• JWeil sp_executesql, actual sql ?

  Hi Guys I pick up the following in a profiler trace. exec sp_cursorexecute 197, @P1 output, @P2 output, @P3 output, @P4 output, 'PSRF_REPORTING_FOLDERS', 'Jan 1 1900 12:00:00:000AM' Normally to find the actual sql that executes i go up in the trace until i find the relevant cursor prepare. In this case the one for 197 cursor prepare. But this time around i cannot find it, these are app servers connected so for all i know the cursor could be p ...Show All

• Daniel B. Query Designer in SQL 2005 is total %#%!@

  What happened to the Query Designer   It's a modal window that doesn't allow you to drag tables from other databases into the query.  SQL 2000's verion of Query Designer was so much better than 2005.  What happened   Are the developers at Microsoft completely retarded   Also, why do I have to log into my database servers everytime I open "Server Management Studio"   Who thought up that nice feature   Probabl ...Show All

• Sergey Ch OLE DB for OLAP Schema Rowsets - MDSCHEMA_KPIS GUID?

  I'm trying to get the KPI's (Key Performance Indicators) from SQL Server 2005 - Analysis Services 9.0 by using VB6 and the OpenSchema method. According to SQL Server Books Online the MDSCHEMA_KPIS rowset should do it. Anyone know where to find MDSCHEMA_KPIS GUID Rgds, Jan This is GUID for KPI schema rowset: {2AE44109-ED3D-4842-B16F-B694D1CB0E3F} I checked it with SchemaRowsetExplorer from SQL Server 2000 Reso ...Show All

• Follish SQL Impesonate Logon Problem

    Hi. I am currently working on an ASP.NET application which has to log on to SQL using a specific windows user account. As far as I am aware the only way to do this is by adding the Integrated Security=true ; property to the connection string. If you specify a user id and password then it will try to log you in as a SQL user. Is this all correct   To be able to login to the SQL server we explicitly call the LogonUse ...Show All

• alwz_nikhil Remove RS Server from Web Farm Setup SQL 2005

  In order to get a new machine up and going, I found I had to configure the two servers as a farm. I thought I would be able to just uninstall the software on the old machine, then remove it from being initialized from the remaining server. This did not prove to work out for me. So my question is, is there a way to manually remove the non-existant server now I would like to not have to install join it back, then remove to just uninstall. I ...Show All

• Mikey0727 Caching problem?

  If I create a view and then a mining structure run it everything works fine BUT if I then alter the view (e.g change a filter setting in a named query) or the actual contents of the database, the OLD contents persist. Using the view refresh says there are no changes (which is correct as I don't change any column names etc.). If I remove Keep Training Cases, this fixes it, but for Time Series, it then gives an error, so you have to go back and ...Show All

• SaurabhGangwal Default Values not Selected on Report Manager

  I have a report with quite a few parameters, both multivalue and single, all populated from a query.  In the Report Designer I have set up default values and everything works great.  When I deploy these reports the default values are not being set.  Am I missing a step It's a SQL report or an MDX report In the report manager when you choose the parameters and execute the report. It's rendered fine ...Show All

• T-oha New Query Connect Dialog

  The "Microsoft SQL Server Management Studio" opens a connection dialog with every new query. Please tell me there is setting to prevent this. Thanx, Greg Done, haven't answered a question on EE for a while Thank you for your reply, your answer does work nicely. It would seem this would be something you could define a default for. It is taking a little time to get used to the SQL 2005 tools after using SQL 20 ...Show All

• Protean Error 18452

  Hi, If I connect to SQLServer Express via Windows Authentication it works fine. But if I use SQL Server Authentication it doesn't work with a new created user and sa (with a new password) too. I turned mixed mode on, registry key HKLM\Software\Microsoft\Microsoft Sql Server\MSSQL.1\\MSSQLServer\login has the value 2 and all ports are set to 1433 but there is still error 18452. Any suggestions Restar ...Show All

• turik Re : Enabling / Disabling Data Flow Tasks

  Hello, I have created around 10 seperate packages for our application data load. Now I am planning to create a master package (or a wrapper package) which will execute all the 10 packages (thru execute package task). Then I have a job which executes the master package at a given date and time. Question : How can I enable / disable execution of each package within the master package depending upon a flag variable. The reason why I need ...Show All

• Vedat Nommaz Windows Mobile 5 connecting to SQL Server 2005

  Can't get winmobile 5 to connect to my sql server 2005 (using vs2005). Here's the connect string: "Data Source=tcp:XXXXXX\default,1433;Database=YYYYYY;" _ & "Integrated Security=SSPI;" This very same string, and variations of it, work in a vs2005 winforms app, but not a windows mobile 5. I'm (obviously) using system.data.sqlclient. MS documentation says it's supported on both platforms with no syntax changes. ...Show All

• cpradhan Error Type 'System.Xml.XmlTextWriter' is not defined

  I use this Code in SSIS Destination Script Transforamtion:   Imports System   Imports System.Data   Imports System.Math   Imports Microsoft.SqlServer.Dts.Pipeline.Wrapper   Imports Microsoft.SqlServer.Dts.Runtime.Wrapper   Imports System.Xml   Public Class ScriptMain   Inherits UserComponent   Dim xWriter As XmlTextWriter ' get this Error: Type 'System.Xml.XmlTextWriter' is not defined   Publ ...Show All