AlexBB's Q&A profile

• Visual Studio Team System Upgrade script

  Hi All I am new to VSDBProf and currently assessing it for ourself. New project will be started soon and I am thinking to use DB edition for database source control. Databases for previous projects we were building using our own tool. We keep structure changes, source (st.proc, triggers etc) in VSS. When we need clean database it will create and populated with reference data. Database goes through its evolution: baseline (major version release) created then changes applied for minor releases, one by one. If I need an upgrade I can execute set of scripts from one minor version to another. In that way we have abilility to upgrades and clean installs using the very same scripts. Now I am looking at VSDBProf. It keeps database structure in Sou ...Show All

• Visual Studio Express Editions Survey Manager - Membership login problem

  Hi, I am trying to play with the Survey manager, compiled the win app, added 2 users beside the thardy user already shipped with the aplication. I can not pass the ogin page, I always get the following message on the login page : "Your login attempt wasnot successfull" In spite of the fact I tried to harden the passwords with special caracters, length of passwords more than 12 caracters...no way I don't know how to debug the membership component, any help would be highly appreciated Hi, here is the URL http://msdn.microsoft.com/vstudio/express/sql/samples/ Best regards, ...Show All

• Visual Studio 2008 (Pre-release) TcpTransport with ManualAddressing

  Hi I work with router sample, and I want to route message to service that listens on net.tcp address. The service has security settings, and message is signed. Because I don't want to change To field in message header ( it is signed, and if router change it, signature check on service fails) i set ManualAddressing to true in transport settings of router binding. This works fine if I route message to service that listens on http address, but when I try to do the sam thing but only to change adress to net.tcp and to change transport and encoding I get error: "Cannot create channel for a contract that requires request/reply and a binding that requires manual addressing but only supports duplex communication." The code that cre ...Show All

• SQL Server Loading images into SQL

  I have created and inserted successfully images into table but when I use Gird View, or other Control can’t see the photo. Any help. please Juvan Here is the query Create Table EmployeeProfile ( EmpId int, EmpName varchar(50) not null, EmpPhoto varbinary(max) not null ) Go User following to to insert image: Insert EmployeeProfile (EmpId, EmpName, EmpPhoto) Select 1001, 'Vadivel', BulkColumn from Openrowset( Bulk 'C:\Blue Lace 16.bmp', Single_Blob) as EmployeePicture Hi Andrea, Yes I am sure. I can see all the field in Preview Data window but can't see image field in Gird view. Thanks. Juvan ...Show All

• Visual Studio Team System query doesn`t work. problem < today

  hi, i tried to import with my new process template the following query and i get an error message: < xml version="1.0" encoding="utf-8" > <WorkItemQuery Version="1"> <Wiql>SELECT [System.WorkItemType], [pweb.pm.startDatum], [System.AssignedTo], [System.Id], [System.State], [System.Title] FROM WorkItems WHERE [System.TeamProject] = @project AND [System.WorkItemType] = 'Run' AND [pweb.pm.startDatum] < @today ORDER BY [pweb.pm.startDatum], [System.AssignedTo] </Wiql> </WorkItemQuery> the problem is the sequence [pweb.pm.startDatum] < @today. if i replace the "<" with "=" everything works fine. so can somebody tell me what is wrong please. the ...Show All

• SQL Server window batch shell

  how do I write a batch script that can tell whether sql express already exist with some instance on the current machine Checking the registry is not the supported way to do detection of SQL 2005, including Express. The registry changes from version to version, and sometimes even from service pack to service pack. For 2005, we released a WMI provider for SQL Server and we will be maintaining this going forward to allow for detection and even certain management tasks. You can write a WMI script to return information about installed instances of SQL Server. If SQL Server is not installed, you will get a trappable error caused by the failure to find the WMI namespace for SQL. Here is a C# sample that re ...Show All

• Community Chat Help with Windoes Screen Saver

  I was wishing that when I have certain applications or programs running is there a way to make the screen saver not come up It would be helpfull. Thanks ...Show All

• SQL Server Toolbox is all grayed out and IUIService Could not be located received

  Every time I try to edit a Control flow or Data flow task I am getting the following error. My toolbox options are all grayed out also.  TITLE: Microsoft Visual Studio ------------------------------ The service System.Windows.Forms.Design.IUIService could not be located. For help, click: http://go.microsoft.com/fwlink ProdName=Microsoft%u00ae+Visual+Studio%u00ae+2005&ProdVer=8.0.50727.42&EvtSrc=Microsoft.DataTransformationServices.Design.SR&EvtID=UnableToLocateService&LinkId=20476 ------------------------------ BUTTONS: OK ------------------------------ Any help is appreciated Gulden I had to re-install Visual Studio. The error message disappeared. However I ha ...Show All

• Architecture Visio 2002 (Professional) and SQL 2005 Express Edition

  I tried to reverse engineer from a database created with sql server 2005 express edition, configuring and using the SQL Native driver. The odbc was successfuly created with the native driver, but as soon as I go forward to resume the process, and right after I was promped for the user name and password to login to the database, I got the following error: "The currently selected Visio driver is not compatible with the data source" Maybe I missed something. However it seems that I would need an updated Visio driver for this version, capable to connect with SQL Native data sources. Did I do something wrong How can I get the driver Luger Hi! If you "Reverse Engineer" Choose ...Show All

• Visual Studio Team System Undoing exclusive checkouts

  All: My question/problem is this: A TFS user has a number of files checked out for exclusive checkout. The user has subsequently left the company. His domain user account has been deleted. We've tried a number of command line commands to unlock the files, undo the operation, delete the workspace etc. However these approaches all seem to require workspace/owner information, & are unable to find/process the workspace the files were checked out to. How can I undo/delete the checkout operation if the workspace or domain user account no longer exists Thanks in advance, Dave Riches Hello, I'm desperate for help on the same issues that the person above was experiencing. It doesn't seem like a resolu ...Show All

• .NET Development help with EventInfo please...

  I have to use reflection to get the methods added to an event. How do I do this Thanks in advance, Devin How would I objtain all the events as objects in a given object and also the EventInfo for each event as well -Devin ...Show All

• Visual C++ Regular expressions for VC6?

  Hello Comunity, i read about ATL Class Library that they habve an functions for regular expressions in VC6, if this is true, where can i download this library, please post an link(url) for me! With best regards Mirsad ATL should be one of the libraries installed with VC6. http://msdn2.microsoft.com/en-us/library/6w2611dd.aspx has an article on how to use the classes. If you find that ATL is not the thing for you, Boost Regex can be a good alternative. See http://www.boost.org/libs/regex/doc/index.html for more information on those. ...Show All

• Windows Forms Communicating with Printer drivers?

  I need to write a C# program to print data through printer driver. I am not sure if this is possible but these are the things I need to do: 1) List all the printer drivers installed on the PC 2) Send a print job to a particular printer driver for printing 3) Check the print status through the printer driver 4) Send a "Cancel print job" request through the printer driver Really not sure what API to use. Any URL or sample source code will be greatly appreciated. Please kindly help and enlighten me. Thank you very much .NET doesn't let you enumerate the printers. Something about not getting it done in time. Check this Google query for alternatives. ...Show All

• SQL Server Running Totals at group level

  Hi, I have a report that groups data by day - I have created a running value to show cumulative sales for Monday, Monday+Tuesday, Monday+Tuesday+Wednesday etc. I have a group below this level that expands out the customer. I wish to create a cumulative sales value for that customer for that day of the week. i.e. Customer A Monday value, Customer A Monday+Tuesday value. When you use RunningValue with scope Nothing, ie. RunningValue(Fields!nett_value.Value, Sum, Nothing), the value returned on Tuesday is Total Monday value plus each customer Tuesday value cumulative adding. If you use scope at customer group level it cumulatively adds that day’s customer totals. I need to recreate: Daily Cumulativ ...Show All

• SQL Server can i restore sql 2000 from veritas under sql 2005?

  While ago my SBS 2003 which had SQL 2000 crashed so I had to rebuild everything and this time I used SBS 2003 R2. My SQL 2000 databases were backed up under Veritas 10 and now I'm trying to restore them under SQL 2005. Is this possible Please advice. Thanks, Mike Try asking the SQL Server Disaster Recovery forum. http://forums.microsoft.com/MSDN/ShowForum.aspx ForumID=744&SiteID=1 ...Show All