Answer Questions

• Jonas Folleso Upgrade from SQL2005 Beta to release Version

  Hello guys.  I'm planning on installing SQL2005 (developer Edition) Beta on a windows 2003 machine, and start building some applications.  But I was wondering if I will be able to update from the Beta version to release version once it's released.  or would I have to un-install the beta and start fresh with the release version.  If so, Do you think any databases that I create now (with the beta version) will survive such a tr ...Show All

• Ted Curtsinger what version of Sql Server is paired with Reporting Servcies sp2?

  Anyone know what version/Service pack of Sql Server 2000 is paired with Reporting services sp2. I know we have to have at least sp3a. Do you have to have an sp4 Sql Server Db in order to have a Report server running sp2 access the sp4 DB Thanks You can still use Sql 2000 sp3a with RS 2005 sp2. ...Show All

• ETUX Prediction Query in MS Association Rules

  Hi! I'm building a mining model wiht MS Association Rules. After processing this model, the result includes some rules(example): E = Existing, C = Existing -> B = Existing F = Existing -> E = Existing C = Existing, B = Existing -> E = Existing F = Existing -> B = Existing B = Existing, A = Existing -> C = Existing F = Existing, B = Existing -> E = Existing F = Existing, E = Existing -> B = Existing D = Existing -&g ...Show All

• gerich Adding a loggin to a server

  In DMO the server object had an add method on the Logins collection.  Does anyone know how this works in SMO the logins collection does not have an add.  I have spent hours on this and just cannot figure out how to create a new login on a server using SMO.  I guess I could allways script the login but there must ba a way to do this in SMO.   Thanks You can create a login as follows ...Show All

• Thomas_ Problem creating diagrams

  I just upgraded an existing sql server 2000 installation with the RTM sql server 2005 (developer). I went to work on a database that I've been working on for a couple of weeks before the upgrade, and wanted to create a database diagram. However, when I click on the "Database Diagrams" tree node, I get this message: TITLE: Microsoft SQL Server Management Studio ------------------------------ Database diagram support objects cannot be installed ...Show All

• David Tran XML Datatype Usage & Performance

  I'm interested in hearing any feedback on the following idea for utilizing the XML datatype in SQL 2005. I am building a customer profiling engine for use by multiple clients. The database is shared. Clients do not have their own seperate databases or schema's. The purpose of the system is to store, record, and transmit customer profile information. Such information would likely include attributes such as: name, email, phone, various demographic ...Show All

• PC Webman Unable to delete a user from sys.sysusers

  Hi, I have a user in my SQL server 2005 database sys.sysusers table with following values. I am unable to delete this user and unable to create a user with this same user name. Please tell some one what is status=16 and issqluser=0 status     16 ame       \CMSXXCMSTESTER roles     NULL altuid     5    hasdbaccess      0 ...Show All

• merc SQL Server 2000 Diagrams.. where?

  In Visual Studio .NET 2005 Beta 2, I've connected to an SQL Server datasource.  I know there is a database diagram, but I am unable to work out how to view/design it.  Can somebody explain how please It's there in Enterprise Manager and VS.NET 2003. Rob The following steps worked for me. 1. From Server Explorer, expand Data Connections and then expand the database you're connected to. 2. Right-c ...Show All

• ramonungos query plans differ when using QA or reporting services

  I have a query that is very simple: select * from vw_shipsummary The logic behind this view is very complicated and joins many tables and uses other views and also has a linked server. When I run this query from query analyzer it takes a very very long time. I have never let it run to completion. When I run from Reporting Services, it takes about 30 seconds. I finally traced it with profiler with the execution tree turned on. I get differe ...Show All

• renato sabo which is the most efficient query to find out the total number of rows in a table?

  which is the most efficient query to find out the total number of rows in a table other than using - SELECT COUNT(*) ... in query It is used for internal purposes only. There is no guarantee that they will be maintained in real-time and the workings will not be documented. So you cannot rely on it for accuracy. SQL Server keeps the row count in sysindexes and it can be retrieved there . ...Show All

• celli Can we include User Defined Functions in the Report Model

  I have certain user defined functions in my database. Can we include User Defined Functions in the Report Model. Thank you, Hi- You can create custom expressions within a model using any combination of the supported semantic query functions in Model Designer. For example, you could create Employee.BirthWeek in a model by using the semantic query function Week(Employee.Birthday). The Employee.BirthWeek could then be consumed ...Show All

• Al Grant Sample Code - Custom Increment Task Sample

  Hi Books online mention the existence of sample code for several custom tasks, including the one mentioned in the title. But, when I try to find this code in the location mentioned it is nowhere to be found. I have run a search on the rest of my drive and come up empty. Can anyone tell me where to find this Thanks You need to install the samples off the CD first as far as am aware. -Jamie ...Show All

• Jim Spath Porting IFilters or Wordbreakers from 32-bit to 64-bit SQL 2005

  (repost) We have a custom wordbreaker coded and working in SQL 2000 32-bit, and are trying to get it to work in SQL 2005 64-bit. A simple cross-compile as an IA-64 dll worked with no errors, but getting SQL to load or use the file is proving difficult. To make things worse, the LRTEST.EXE that ships with SQL 2005 32-bit seems to be missing for the 64-bit version of SQL 2005, making diagnostics on any wordbreaker or ifilter next to impossible. ...Show All

• cmenge Multilingual Support in Analysis Services

  Hi Currentely i am using analysis Services with SQL SERVER 2000 OS:- Windows 2000 Server Datasource:-Oracle We need to show the data in the cubes for multiple countries. But we are not able to show the data for diferent languges at the same time becoz in windows 2000 default language on the server can be set to only one language and the data in the cube can be shown in same language Ex Let say we wud liket see ...Show All

• Myoest1 Copying database using "Copy Database"

  I am struggling with the "Copy Database Wizard" in SQL Server 2005. I am used to working with DTS to copy data from one server to another, but with the new tools, I am having serious problems (in fact, it's unusable) 1. When copying a database using the "SQL Management Object" method, I always get errors concerning logins. If I select not to copy logins, I get errors "sp_grantdbaccess failed". If I do select to copy logins, the logins can't b ...Show All