Answer Questions
Gess Man Restoring database from MS SQL 2000 to SQL Express 2005
Hello, I tried to restore a database which I backuped from MS SQL 2000 to SQL Express 2005 but it always failed with the following error message. What could be the problem Restore failed for Server 'SERV\SQLEXPRESS'. (Microsoft.SqlServer.Express.Smo) Additional information System.Data.SqlClient.SqlError: The backup set holds a backup of a database other than the existing 'gtp' database. (Microsoft.SqlServer.Express.Smo) Thanks hi, i still encounter the same problem after i have followed all your suggestions and help. Do I need to create a blank database in sql 2005 express edition prior to backing up Thanks a lot Hi, The database size is small, only 12 MB. Regards/ ...Show All
nesrine The IDMClusteringAlgorithm interface
Good morning, Well... I'm implementing a clustering algorithm following the examples given on the Managed Plugin Algorithms tutorial. As the samples are in C# and I'm implementing it on C++, I'm facing some problems, but nothing really significant. But I've some conceptual questions about the implementation: 1) It necessary to implement the IDMClusteringAlgorithm interface in order to implement the ClusterMembership() and the CaseLikelihood() methods, right 2) The changes needed to be done on the Navigation class have nothing to do specifically with clustering. These changes are only to set calculated statistics to be shown, and if I want, I can simply don't implement them. Is this correct 3) Is there any documentation on ...Show All
-D- Formatting Date as integer
I want to for that format the date in YYYYMMDD and MMDDYY, with no '-' as data type is integer I have used the following code (not the conversion function as I don’t need Hyphen '-') for YYYYDDMM SET @DATE = CONVERT ( INT ,( CONVERT ( VARCHAR ( 4 ), DATEPART ( YYYY ,GETDATE())) + CONVERT ( VARCHAR ( 4 ), DATEPART ( MM ,GETDATE())) + CONVERT ( VARCHAR ( 4 ), DATEPART ( DD ,GETDATE())) )) & for MMDDYY SET @DATEUS = CONVERT ( INT ,( CONVERT ( VARCHAR ( 3 ), DATEPART ( MM ,GETDATE()))+ CONVERT ( VARCHAR ( 3 ), DATEPART ( DD ,GETDATE())) + SUBSTRING ( CONVERT ( VARCHAR ( 4 ), DATEPART ( YY ,GETDATE())), 3 , 4 ) )) I am getting the result YYYYMMDD= 200688 MMDDYY =8806 ...Show All
AdriM Change Color of Textbox Depending on Value
I have the following: =IIF( Sum(Fields!Percentile.Value, "RegionalSnaps") < 10.0, "Yellow", "Black") Doesnt appear to be changing color to the numbers, actually its just putting the work black in all the cells in the report, the nubmer are % numbers, like 10.53% of 3.45%, and if its great than 10.00 % I want the textbox to show up yellow, if its >10% i want it to show up normal. Any help would be greatly appreciated. Hi Duane! Are you putting your expression in the BackgroundColor property of the textbox. From what you described, it sounds like you are putting it in the value property. Jennifer Sorry Duane, I have yet to build a matrix style report ...Show All
AlucardHellSing Beginner's questions
Hello, I have two database servers that I am interested in sending messeges between them. I am not interested in security or encryption at this point, only a simple message sending and recieving. Can someone please provide simple scripts for object setup (certificates, queues etc) and message send and recieve a link to such a script will be great as well. I am just a bit lost understanding all the new concepts (certificates, service, service binding.....) Thank you I. I installed the tool and followed the instructions but all it did was to create a document with the service name and endpoint. what do I do from here Thanks I. The error you men ...Show All
Ayukawa Expression help needed
I use the following expression to convert zero length character strings to and int value of 0 : comno_type == "" "0" : comno_type however, some of the data I'm trying to copy contains 1 character long blank strings or " " to be precise. Can I get the above expression to handle both the zero and 1 char strings at the same time. I've tried things like: comno_type == "" , " " "0" : comno_type but this is a syntax error. Would I need to do separate expressions to handle each type of string and if so, how do I get them into the same destination column Thanks Yes and yes, ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/extran9/html/8b804 ...Show All
pitks Could not create Maintenance Plan
Hello, if I try to create a Maintenance Plan from my local workstation I get the following Error Message: TITLE: Microsoft SQL Server Management Studio ------------------------------ The action you attempted to perform on a remote instance of SQL Server has failed because the action requires a SQL Server component that is not installed on the remote computer. To proceed, install SQL Server 2005 Management Tools on the remote computer, and then try again. For more information, see "How to: Install SQL Server 2005 (Setup)" in SQL Server 2005 Books Online, or find the article on MSDN at http://go.microsoft.com/fwlink/ LinkID=57083 . (ObjectExplorer) For help, click: http://go.microsoft.com/fwlink/ LinkID=57083 On my loca ...Show All
WXS123 Reporting Services Data Connection Problems
First, I am very new to programming, so please use the most basic descriptions in any replies. I have created a simple program in VB express and would like to be able to generate a report for a database used in my program through SQL Server Express. My goal was to have someone using my program on a laptop (not connected to a server or network) to be able to generate this report through my program in VB express without installing additional software, based on the local database on their computer. So, I thought using Reporting Services would best accomplish this. I went through the AdventureWorks tutorial and had to play with the connection settings so it would finally let me connect to the DB in the Visual Studio "Report Wizard". ...Show All
Rouretain Concatenating Fields With NULL Values
Hey everyone, This is probably a very simple question, but I am just stumped. I am storing different name parts in different fields, but I need to create a view that will pull all of those fields together for reports, dropdowns, etc. Here is my current SELECT statement: SELECT m . FName + SPACE ( 1 ) + m . MName + SPACE ( 1 ) + m . LName + ', ' + m . Credentials AS Name , m . JobTitle , m . Company , m . Department , m . Address , m . City + ', ' + m . State + ' ' + m . Zipcode AS CSZ , m . WorkPhone , m . FAX , m . Email , c . Chapter , m . Active , s . Sector , i . Industry FROM tblMembers m LEFT OUTER JOIN tblChapters c ON ...Show All
Sc0tty Fixed Database Roles vs Application Roles
After reading Books Online, I am still confused with Database Role vs Application role. My intention is to control the end users' authority on the database, where the end users will access through Winforms client application. With proper assignment of schema and database roles to an user, I believe this will enough to control the permisison of an user. If this is the case, why Application role exists When and why should I use Application Role How is it different from Fixed Database Role Application roles shouldn’t become orphaned. The root cause of the orphaned users is that the associated SID is invalid after restoring the DB on a different server (because the corresponding login doesn’t exist on t ...Show All
Libol MS SQL Server 2000 Enterprise Edition installation error
My laptop has VS 2005 installed. I am trying to install MS SQL Server 2000 Enterprise Edition, when i run "install database components", it gave error: "MS SQL Server 2000 Enterprise Edition component is not supported on this operating system. Only client components will be available for installation". then when i click on "ok", then "next", when i click on "next" on the "computer name" page, it gave another error: "A previous program installation created pending file operations on the installation moachine. You must restart the computer before running setup". I restarted my laptop following the instruction, but same thing happened when i run the installation. Plz help Really this was helped very much after changing the registry smoo ...Show All
TJ2007 Using VB.Net for Applications and the VBA Editor from Custom Components?
Hi, Is it possible to make use of VB.Net for Applications and the VBA editor from your own Custom Transform Components (like the script component does) I would like to create a component that generates boiler-plate VBA code and that then allows developers to add their own specialised code in certain methods using the editor (just like the script component) If so, is there any documentation anywhere on how to go about this Thanks in advance, Lawrie it's a separate entity, available through the VSIP program. Donald Hi Jason, Thanks for the link. But is the VBA SDK/compiler and the VBA editor actually part of Visual Studio I thought it was a seperate entity. Cheers, Lawrie. ...Show All
UK_12 How Detect SMO is installed?
Hi all I'm using Microsoft.SqlServer.Management.Smo namespace for retrieve a list of avaible SQL Servers. The problem is when SMO is not installed in the client machine. The application crashes although I put the command in a try - catch block. try { DataTable dtSQLServers = SmoApplication .EnumAvailableSqlServers( false ); } catch { notInstalled = true } Are there any easy way to know if SMO is installed , so i can advice the user that he must install SMO first Thanks. You either have to lookup the file references assembly or use a component to check the reference to the GAC: http://www.codeproject.com/dotnet/Assemblydependencies.asp df=100&forumid=31276&exp ...Show All
&#33;&#61;MaYHeM Delete connection file
I've inherited a procedure that performs a few transforms and writes to flat files in a working directory using a connection in connection manager. After the manipulation, the system cleans up by deleting the working files. Works fine in development, but from the command line gives: The process cannot access the file <filename> because it is being used by another process.". I suspect this is because connection manager still has the file open. Any ideas Thanks Guy Can u show the code you have written Then i can favor you better. Also, can u solve my problem I have a flat file with name " Employee.txt " (Full url: C:\Employee.txt ) .The File c ...Show All
Moldau sql query
Hello All, I am using sql server 2005. I have a table with the following data.... Name date time load base Joe 01-01-2006 8pm-9pm 100 500 Joe 01-15-2006 8pm-9pm 100 500 Joe 02-10-2006 8pm-9pm 100 500 Joe 01-15-2006 8pm-9pm 200 500 Joe 02-10-2006 8pm-9pm 200 500 Joe 02-25-2005 8pm-9pm 200 600 Mark 01-20-2006 8pm-9pm 100 500 The first three rows have common data, but for the date. Similarly, the 4th and 5th row are similar to first three rows, but for the "load& ...Show All