Helen999888's Q&A profile

• SQL Server Management Studio Error trying to change mdf file size

  Setting: Windows 2003 Server, x64 edition, SP1 ( ) sql 2005, x64 edition, SP1. We have a modest size datawarehouse database: 80GB. In management Studio, for the mdf file, I set the autogrowth increment to 2 GB and the max size to about 102GB. Today when I opened Management Studio, right-clicked the DW database (Properties > files) I find this for the mdf file: "Autogrowth by 131072 percent restricted growth to 102400MB" I never use percent for autogrowth. In fact, this very problem had occurred a few weeks before. I found that Management Studio (at that time and again presently) would not let me change these settings. (Has to be done via t-sql). Here's that error message I get from ...Show All

• SQL Server ForEach Loop container issue!!!

  Hi everyone, I am having hard time with foreach loop container. The for each loop container in my package goes over all the rows in a ADO enumerator recordset variable and shows row values one by one in message box. The problem is that it just keeps printing the first row infinitely. Could anyone tell me what could be wrong Thanks in Advance, Check this feedback: ForEach enumeration of ADO recordset can cause infinite loop when using checkpoints https://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx FeedbackID=125915 ...Show All

• SQL Server "Keys lock row not found" error

  Jens I also am having trouble with the reporting services not being able to the report server databases. I get the error "Keys lock row not found". I can't find any citation to help me figure out what this means nor how to fix it. Any help you can give me would be greatly appreciated. Ron What version of Reporting Services are you using How did you create your report server database Did you make any changes to it manually using OSQL or Enterprise Manager or Management Studio -Lukasz ...Show All

• Microsoft ISV Community Center Forums Count characters in a string using VBA in excel

   Hi all, How can I count the number of characters in a string so it works as the example below Len() works quit well but I would like it to stop on blanks. <some function> (me) ''' return 2 <some function>(me_rest) ''' return 7 <some function>(rest s) ''' return 4  Thankful for help. \Jonas   Hi, you can use something like this: Function LenOfFirstWord(byval YourString As String) As Long   Dim i As Long   i = InStr(YourString, " ")   If i > 0 Then     LenOfFirstWord = i-1   Else     LenOfFirstWord = Len(YourString)   End If End Function The above will return 0 for " hello world", so if you want leadi ...Show All

• SQL Server Books Online July 2006 issue

  The SQL Server Books Online was working installed on my workstation fine until this morning. Now when I open it up it does not show me T-SQL reference with all the commands and functions. Yesterday I was on the MSDN website using the Books Online. Could some pointers in the program been corrupted I have uninstalled and reinstalled Books Online to no avail. Please help. Thanks, Fred Hi Gail, Yes, the Contents tab is there. When I expand "SQL Server 2005 Books Online" entry in the Contents tab and then expand "SQL Server Language Reference" it shows only "Transact-SQL Reference". It used to show more. Then when I expand "Transact-SQL Reference" it only sh ...Show All

• Visual Basic Create database on install

  Hi Everyone I'm a bit new on the whole database side within a program. Want i want to know is when you install your program. How does one go about creating the database on that system when installing your program. Any responses will be great. Thanks in advance I think that the way to instal a db is when you run your program for the first time. however, you need to know: 1 - you have to know which kind of db are you going to use ( Access or Sql Server or ....) 2 - you have to see if that database does not exist in that system. if it does not exist then activate those instruction specific for creating the db. Each kind of db has a specific set of instruction for creation. ( see 1) 3 - you will have to create the table ...Show All

• Software Development for Windows Vista Any Utils Available To Sync Activities With SqlTrackingService?

  Hi, Specifically synch'ing between the workflow and the Tracking DB - Activity table I've been playing around with a simple doc approval workflow and today wanted to add some approval timeouts. So, I added a couple of EventDrivenActivity items with appropriate DelayActivities, etc. and ADDED a couple of trackData() calls to log some info. This broke the SqlTrackingService stuff when retrieving the ActivityTrackingRecord data with sql null value errors. I managed to chase it down to the new activities not being defined in the Activity table. I manually added them with the right type identifier and voila! - the SqlPersistenceService objects (eg, ActivityTrackingRecord) started to function again. I was just wondering if there's a utility ava ...Show All

• Visual Studio Express Editions how to open another windows form ??

  First off want to say hi to everyone as i am new to the forums and also c#. I will try to explain what i am doing so that i can get help, and just to let you know that yes i have tried looking through the C# express help file and still can not find what i am looking for. Ok, here it goes... I have my standard windows form (the main one called Planner.cs), and i created a 2nd windows form (called NewEvent.cs). What i am trying to do is make a button so that when it is clicked it will open the NewEvent.cs Form so they can fill it out. "Then my next step will be trying to figure out how to get it to save to the database." but any help on my question is appreciated thank you. You would ...Show All

• SQL Server Why is database so large?

  Hello! I have a database with one table inside. The table has six columns with the following datatypes: col1 -->smallint (2byte) col2 -->int (4byte) col3 -->smallint (2byte) col4 -->smallint (2byte) col5 -->smallint (2byte) col6 -->int (4byte) I have insert 1.359.320 rows with data and the size of the sdf file is 40.116.224 byte. According to my calculation: 1.359.320 * 2byte + 1.359.320 * 4byte + 1.359.320 * 2byte + 1.359.320 * 2byte +1.359.320 * 2byte + 1.359.320 * 4byte = 21.749.120 byte I hope somebody can explain me, why the database is so large. Thank you Sascha You can try to compact the database and check if the total size comes down. It should remove the existing free pages. ...Show All

• Visual C++ Trouble with TreeView Label Editing

  Hi, I'm Dan. I'm fairly new to Win32 programming but have been doing it for several months now (independant, no classes/books/etc) and am starting to grasp it. I have been trying to, as a learning experience, create a game design program that would allow for easy PC game creation with little coding experience (similar to GameMaker if any are familiar). Anyway, I am currently trying to implement a TreeView to display resources that the game designer adds into the project (sprites, objects, etc). Before I begin delving into more critical details of the program, I am trying to first establish the overall environment. I have recently allowed the user to add resources (though they do nothing so far) and have put in context menus for the resourc ...Show All

• SQL Server Constraing Question

  Converting a program from VS03/MSDE to VS05 Pro/SQL Express... In VS05, in Datasouse tab, "edit with Dataset with designer", click on relation between two tables, choose "edit relation" from context menu, under "Choose what to create" there are 3 radio buttons: - Both relation of foreign key constraint - Foregin Key constraint only - Relation only I have discovered that the choice made dramatically affects the Fill order of tables. In general I use the first one. I would like more information on these options than I have been able to find in help. Here is the specific issue (simplified)...two tables UserID -> Recordings. In a specific senerio, I must fill recordings table first ...Show All

• Visual Studio Team System Is this type of development scenario supported...?

  Hi, I'm evaluating how we'll leverage VSTS for DB pros and I'm just wondering if this scenario is supported: Back in the day, we used to all point our dev workstations at a single instance of a DB running on a dev SQL server. This proves to be extremely fragile and limiting because of the need to constantly evolve/refactor the DB. We moved to a model where every developer runs a local copy of the DB themselves that corresponds to the version of the code they are working with. We did this with "regular" DB projects in VS.NET. We're still using "regular" DB projects in 2005, but they have unfortunately been crippled beyond usefulness in 2005, so now I'm looking to move to VSTS for DB pros. Obviously all my devs are ...Show All

• SQL Server SQL mail using external mail server

  Hello We are using SQL Server 2000 SP4 Standard Edition and would like to use the e-mail function to monitor certain alerts. However, an e-mail server (SMTP server) is not installed on that box, but on a different IP address within the network. I have set up the e-mail operator, enabled e-mail in SQL Agent and set the Mail Configuration in Support Services. However, on testing I get the following error : Error 18030: xp_test_mapi_profile : Either there is no default mail client or the current mail client cannot fulfill the messaging request. Please run Microsoft Outlook and set it as the default mail client. As I cannot install Outlook on this server, I am now stuck. Has anyone a suggestion how I can overcome this issue ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. XNA GSE B2 Tutorial 1 Texture problem

  Hi, I am new to XNA, just saw the posts about "Beta 2" and have started to dig in. I started on the tutorials in the help file in "Getting Started -> Going Beyond" and found an issue with Tutorial #1. (This may be an old issue, but I could find no posts on the topic.) The spaceship texture is never loaded onto the ship. In steps 1 and 2 we get the model and the texture and load them into a content folder. Then, in step 3 we load the model (but never the texture). Then, toward the bottom, we see a screenshot of the program output and the spaceship has a texture on it. Can someone please tell me how to skin a texture onto a 3d object When I complete the tutorial I have a black ship with no texture. Thanks. ...Show All

• Visual Studio 2008 (Pre-release) How to capture client's infomation on server process?

  Hi Eveyone, I have a wcf service runs on the server as a console application (sefthost). Currently, I have many clients connect to that service and all of them work very well. Now I try to improve my system a little bit by trying to capture client’s info whenever a client requests the service on the server to do something. Does anybody have any example or any ideal how to do this Thanks in advance. Jdang You'd have to add an application header on the client side and then read it on the server - there's no built in way to see where the client is connecting from. On the client, when sending the message, do something like: using ( OperationContextScope scope = new Operati ...Show All