nioB's Q&A profile

• SQL Server How can i find 'broken' records ?

  Version: Microsoft SQL Server 2000 - 8.00.2040 (Intel X86) Problem: Server: Msg 8964, Level 16, State 1, Line 1 Table error: Object ID 515532920. The text, ntext, or image node at page (1:377289), slot 1, text ID 897099563008 is not referenced. Server: Msg 8964, Level 16, State 1, Line 1 Table error: Object ID 515532920. The text, ntext, or image node at page (1:377447), slot 1, text ID 897100939264 is not referenced. <... and 4 same errors> DBCC results for 'CC_Document'. The repair level on the DBCC statement caused this repair to be bypassed. <same messages> The repair level on the DBCC statement caused this repair to be bypassed. There are 192 rows in 6 pages for object 'CC_Document'. CHECKTABLE found 0 ...Show All

• SQL Server Insert view fail?

  1) on server "ServerHqp" create partition table: CREATE PARTITION FUNCTION [col_partition](bigint) AS RANGE RIGHT FOR VALUES (51) go CREATE PARTITION SCHEME [col_scheme] AS PARTITION [col_partition] TO ([second], [second]) go CREATE TABLE [dbo].[H1_ServHqp]( [HID] [uniqueidentifier] NOT NULL, [Col] [bigint] NOT NULL, [ClassID] [bigint] NULL, CONSTRAINT [PK_H1] PRIMARY KEY CLUSTERED ( [HID] ASC, [Col] ASC )WITH (PAD_INDEX = OFF, IGNORE_DUP_KEY = OFF) ON [col_scheme]([Col]) ) ON [col_scheme]([Col]) GO ALTER TABLE [dbo].[H1_ServHqp] WITH CHECK ADD CHECK (([Col]<=(50))) CREATE TABLE [dbo].[H2_ServHqp]( [HID] [uniqueidentifier] NOT NULL, [Col] [bigint] NOT NULL, [ClassID] [bigint] NULL, CONSTRAINT [PK_H2] PRIMARY KEY ...Show All

• SQL Server Stored Procedures

  SET QUOTED_IDENTIFIER ON GO SET ANSI_NULLS ON GO What are these used for Also, the procs I've seen in the past always dropped the procs before creating them. From what I'm reading, it looks like you should use the 'Alter' stmt. instead so you don't have to re-do permissions. Is this correct Unlike ALTER , DROP/CREATE will clear permissions. You typically use drop/recreate for script robustness i.e. : the script will work regardless of whether or not the objects exist. Conversely, an alter script will fail if the proc does not exist. The 'best' method is a drop/recreate with an explicit permissions grant afterwards, however, if you know all the objects already exist, then an alter script is the easist as you do not need to wor ...Show All

• Visual Studio VSTA Document-level add-ins and dynamic object model

  Hi, I've been through almost all VSTA tutorials but I haven't found the description of how to create add-ins to be load at the document level. My question is: Do we build document-level add-ins the same way we build application-level add-ins For example, with the Shape application sample, we can imagine that the user can create a new drawing (which is the document). Then, the user wants to enhance his drawing by code (because he wants to perform some operations the GUI does not provide). This means that he needs to access to the instantiation of the object model (his drawing) and not with the object model itself. It seems to me that the add-in mechanism allows you to create a new document but does not allow you to enhance an ...Show All

• SQL Server Script tasks don't work in Production

  Hallo, In SSIS Version 9.00.2047.00 I have build a few packages using script tasks. These packages work well in development. When I try to run them Using DTUtil the systems displays in the Package Excecution Progress-window the message: 'Error: The tasks "reading registry" cannot run on this edition of Integration services. It requires a higher level edition.' Emptying the script task from its variables and script doesn't make a difference. I did not find an explanation in BOL. Concerning script tasks I only find The Script task uses VSA as its engine for writing and running scripts. To run a script, you must have VSA installed on the computers where the package runs. But since I even get these messages when I try to ...Show All

• Visual C++ String Decomposition

  I guess the best way I can ask this question is by creating an example. string text = "some long amount of text that I need to break down so it does not over run into a new line in a command window, thus breaking up words and becoming less legible."; int textLength; textLength = text.length(); From there I want to take at least 50 characters but stopping at the next white space (so that I wont split a word) extract that to a new variable, then be able to extract the remaining amount to another variable so that the text can be properly formatted to the output screen. Thanks for any suggestions in advance! ...Show All

• Smart Device Development Windows Mobile KeyDown bug fix

  Mark Ihimoyan posted in  http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=354069&SiteID=1  on 11-16-2006 that "the [keydown] issue described in the initial post ... has been verified to be a bug and it has been fixed in the next release." I couldn't tell whether it was a fix to Windows Mobile 5 or some other software. Where can I find that fix  Thanks. I've been able to work around it by catching Keys.F23 in my KeyDown event handler. It's goofy logic, because when I set Focus to the next [TextBox] control, it gets Keys.Enter from the same keystroke, which I have to ignore. (I suspect Symbol's implementation in the MC9060 and MC9090 PocketPC scanners may be an issue as well.) Thanks. ...Show All

• Visual Studio Express Editions Dataset and Crystal reports

  Hey guys ...I have a little problem and i need your help... Well i have a dataset that i fill from the oracle db .That dataset is modified by myself in the code.By modification i mean i have updated some of the cells values .Now i have to create a report using that dataset how can i do that .The problem is that i didnt make an external dataset by drag and drop from the data menu but manually defined it in the code .Now i need to access that dataset once the program runs and the dataset gets filled so that i can apply group by on the dataset and get some info on my crystal report....Please reply soon thanks alot ...Show All

• SQL Server Peer-to-Peer Replication (Programmatic Control and Setup)

  I have reviewed the BOL documentation on how to configure Peer-to-Peer replication via T-SQL and how to use the Replication Wizard to implement replication. What I would like to find out is how do I configure the peer-to-peer replication process to use an existing column on a table that contains a GUID instead of creating an extra column with a uniqueidentifier GUID value. When you use the Wizard each table article has this extra column added to it. I don't seem to be able to find it in the books-on-line. Can some one point me to the correct article or BOL page. Thank you. ...cordell... I do not think that P2P replication adds a uniqueidentifier column to a published table. Transactional queue ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. animating textures

  Hi there - this is probably a very simple problem but I've not stumbled over the answer yet. My Art Monkey has just sent me a model with an animated gif file attached. XNA complains about this texture so presumably gifs are not yet supported. Is there a way round this For instance a simple way to apply a texture to a model, or change the UV coordinates a model is using, so I could have a big bitmap with the necessary graphics on it and just change the UV Or even some way to load a bitmap into another structure, perhaps a Texture3D, which I've just noticed, and apply it to a model. Apologies if this is painfully simple or has been covered elsewhere. Cheers Robin. Three options: 1) Texture sh ...Show All

• .NET Development Get source code file path at runtime

  I would like to get a source code file name and full path at runtime for a specific class. Say I have a type MyClass and I want to use reflection or PDB to get the source code for that class. So the method should look like: string GetSourceCodePath(Type t) when I pass typeof (MyClass) it returns C:\MyProject\MyClass.cs Thank you You can get the stack frame of the current method or any of its callers by creating an instance of the StackFrame class. However I don't think this is really what you want to do given your further comments. You can't decompile your code through the standard .NET classes. Therefore you can't do this easily at runtime. You could use something like ildasm or so ...Show All

• Windows Forms Focus mystery

  Dear All, I have this MDi application in one form upon loading I load the combo box from select statement of database then I put cb1.selectedIndex =0; cb1.focus(); This works fine and the first element get selected. The funny part I use the same code in another form and I put cb2.selectedIndex=0;cb2.focus(); and it doesnt get the foccus. I checked via the cb2.Focused and it shows false Anybody knows this problem. Thanks. Control.Focus() doesn't work in the Load event, the control isn't visible yet. Use Control.Select() instead. ...Show All

• SQL Server Displaying value of a variable during runtime

  Greetings all, Apologies if this question has been asked in the past but how I display the valuw of a variable during runtime Thanks for your help in advance. dreameR.78 wrote: Dear Rafael, I am fallin in love with you LOL Glad you got it! ...Show All

• Windows Forms How would I search for a control by its string Id from server side

  From the sever side, I want to be able to select the value in a drop down. The problem is that the dropdown is one of 6. One of these 6 dropdowns is selected based on another dropdown's selection. i.e ID=DropDown1 Options=A, B, C , D, E, F will then cause one of the following to have the ID=DropDownA Options=... ID=DropDownB Options=... ID=DropDownC Options=<appropriate value selected> ID=DropDownD Options=... ID=DropDownE Options=... ID=DropDownF Options=... So essentially, I will have: "DropDown" + DropDown1.SelectedValue as a string representing the ID of the dropdown which I then want to search for in the page... What method/procedure do I use to search for the right control in the page Right P. ...Show All

• SQL Server Unsecure transport and dialogs

  Hi There SInce day one i have configuring service broker to use transport and dialog security with certificates. However i am not 100% sure how to setup service broker between 2 instances without security. Would the following work, or what steps am i missing 1.Setup the endpoint with WINDOWS authentication instaed fo certificates, the instances are in the same domain, grant necessary permission to the service account for each instance. 2.Create dialogs with the create remote service bindings with the anonymous = ON and grant send to public for the services. Would this work Also am i correct in thinking that if encryption is required the use of certificates is mandatory Thank YOu At th ...Show All