ShadowRayz's Q&A profile

• SQL Server question mark sent instead of parameter value

  When I add a parameter to a query against view that points to a linked server table, the query fails. The Where clause IN THE ERROR MESSAGE looks like this: WHERE "Tbl1001"."F0000">= " The actual SQL is: WHERE     (F00000 >= @Year) The question mark should be 2005, but the replacement dosen't occur. I was making it too hard. I was trying to force the syntax, when all I had to do was edit the sql and add an @someparm. The designer adds report parameter settings automagically. Nice ...Show All

• SQL Server Performance Tuning Advice Needed For This table. Assitance Greatly Appreciated.

  I really need some performance advice here. Machine Windows Server 2003 processors (4) RAM (4 Gig) Hard Drives (4) --c: \system --d: \data volume --H: \data volume --I: \data volume The number of records in this database is about 250,000 I cannot prevent a Table Scan from the Application that uses this database. I cannot re-write or change the application as it is outside of my control. However the Application pulls the data from this table in a "Paged" fashion only hitting the database for 30 records at a time. I am really looking for any advice here also regarding. Indexing this: Table Partitions (4 drives) (4 processors) and if partitioned should the files sit ...Show All

• SQL Server Maintenance Wizard error...

  Hi, I'm just trying to use the Maintenance Wizard for the first time, but the SQL Server Management Studio shows me an error message about 'Agent XPs' is not running on my server; and I should activate it through 'sp_configure' I've tried to understand 'sp_configure' by searching it on MS TechNet, etc. But of course, because I'm not a SQL Server expert user; I don't even know how to use 'sp_configure' at all.... Anyone know how to work this thing around Appreciate all the help... PS: I almost forgot to mention, that I'm using MS Windows Small Business Server R2 2003 with SQL Server 2005 Workgroup Edition. Sam, Thanks for your reply there... But unfortunately, I am a very novice at SQL S ...Show All

• SQL Server SQL Server CE Replication: Integrity error, but not at all

  Error information: NativeError: 28549 HRESULT: -2147217873 Message: OrdersHeader,Delete,{0503BF00-BB05-11C6-8000-36BC4ADEE342} Description: The row update or insert cannot be reapplied due to an integrity violation. Server side: SQL Server 2000 or MSDE Client side: SQL Server CE or SQL Mobile This error is usually caused because of an error on the filters. But not in this case, i think. I assume it's not a filter error because if I delete the SDF and run the sync it works. The error occurs when I delete some rows in the server (parent( OrdersHeader ) and child( OrderLines ) tables) and the PocketPC stills have this rows. On the next synchronization It seems that replication process tries to delete the OrdersHeader rows before the OrderLin ...Show All

• Windows Forms WebBrowser control in service

  know this is an incredibly crappy design, but the only way I could figure to solve my problem. I need to use the webbrowser control in my service to navigate through a set of pages, maintain session, follow redirects, submit forms, all that. For those reasons I can not simply use webrequest. This all works great in a windows app but when I try to port it over to a service then problems start. The major one right now is in my document complete event I am not able to read any of the properties relating to the document, everything throws an invalid cast exception. The control actually will navigate to page but on completion where I would normally parse through the html document, nothing can be done. Does anybody have any ideas on how to get ...Show All

• SQL Server Getting records in a line (commalist)

  Hi, i searched for many hours now and I need help from the community ;) I have a list of records and want to include the records as a comma sperated list in an other select statement. I tried it with std. SQL and later with T-SQL, and I am sure it will work ith a stored procedure, but I am not that professional in this (try to learn...). Background: I have a lot of data (users) and want to create a records set without having the data processed in my scripts. So i have: records in table krgroupusers (example data): lgroupid, luserid 3 , 1 3 , 48 4 , 1 197 , 1 197 , 48 197 , 250 197 , 251 207 , 1 207 , 250 Weiter habe ich eine Tabelle kruser (example data): lid, strusername , strmail 1 , Administrator , admi ...Show All

• SQL Server Cleaning up after myself

  How should I go about releasing any objects I've created I've got a very complex CLR stored proc that creates a dataset, many sqlcommand objects, an adapter, etc, etc. It's used to evaluate high school transcripts for completion of the core subjects. It's a very complex SP that takes a single SSN as a parameter. Right now it works as expected when I call it from a query window in SQL Mgmt Studio, I can stack 39 calls in a row like: exec usp_Evaluate_eTranscript '011...' exec usp_Evaluate_eTranscript '012...' ... exec usp_Evaluate_eTranscript '039...' And if I build a little test harness in VB.Net calling it in a populated dataset For ... Next loop, it works just fine for the 39 valid values I have. But, when I build a curs ...Show All

• .NET Development Can you help me please

  How can in the database to save project Example: I create database in the MS Access and i export to VB Express edition, but in the form i create button with name "Save" and when you clicked , it will save the your new fatures (Name,Lastname,City,Country,State etc). Just Save no .txt or others. Thank you! Fundementals of ADO: http://msdn.microsoft.com/library/default.asp url=/library/en-us/ado270/htm/mdconadofundamentals.asp Overview of Saving Data: http://msdn2.microsoft.com/en-us/library/ms299758.aspx ...Show All

• SQL Server Restoring a backup of a Subscriber database to a new database

  I have a Subscriber database updated using transactional replication and want to create a copy for development & testing. The Distribution database is running on the same 2005 instance as the Subscriber and the Publication database on another server running SQL Server 2005. If I use a TSQL script to run the restore, the database is restored to a usable state but I get the following messages: Msg 15247, Level 16, State 1, Procedure sp_MSrepl_check_job_access, Line 112 User does not have permission to perform this action. The replication agent job [job name] was not removed because it has a non-standard name; manually remove the job when it is no longer in use. (I’ve removed the job name from th ...Show All

• SQL Server Microsoft Support for SQL Server 2000

  Hello, I would like to see if Microsoft has issued any announcement on SQL Server 2000 end of support. If anyone is aware of this or seen new posts/articles, please let me know. Thank you! MS official Lifecycle support for SQL 2000 is posted here: http://support.microsoft.com/lifecycle/ p1=2852 Thanks, AWAL ...Show All

• Visual Basic Programming Languages

  Hi, I'm relatively new to programming, and Visual Basic doesn't seem to be that good of a language, and not that much used in real applications. I want to move onto a different language, one that is very popular, can do almost anything, and can be and IS used in professional applications. Another important factor is platform compatibility. Java provides that, but Java isn't that popular for Windows, and Windows is my primary target. C++ works, but I have a couple of questions: 1) Can C++ be used on any OS Is it a good language to use as my primary language 2) Is C# going to replace C++ Does that work on other OS's C# is newer, and so I'm thinking maybe its the new version of C++ that's going to replace it, as xhtml is probably going to do ...Show All

• SQL Server Choosing the most frequent

  There must be a way to do this simply. We're running SQL Server 2000. I'm looking for some generic SQL statement that I can apply. If I have a table with a person column and a location column and multiple records for the same person / locatioin combination, how do I select the person with the location they most frequently visited Say George visits Mexico 5 times, and the Bahamas twice and costa rica once. I would have 8 records in my table for George. The data looks something like this: George/Mexico George/Mexico George/Mexico George/Mexico George/Mexico George/Bahamas George/Bahamas George/Costa Rica Ben/Brazil Ben/Brazil Ben/Peru The results would be: George/Mexico Ben/Brazil Thanks! Myles ...Show All

• Smart Device Development C# and HHT

  I'm currently working on a project that would involve C# and Hand Held Devices. Just wondering if there are any good reference sites out there that could help me out and lead me in the right direction. Appreciate the help MS Forum members. Cheers, SOTY_Programmer I've been searching for the past couple of days to find a solution for this, but I haven't had any luck. I must not have the correct wording for what I want to do. I'm working in a Visual Studio.NET 2003 Dev environment (C#), and I need to detect when a user places a PocketPC into its cradle. When that happens, it will open up a program that would do its duty. I'm not writing an app to go onto the PocketPC, just a regular windows app. ...Show All

• SQL Server populate variable values

  Hi How can I populate values for package variables inside a data flow task I could do this inside a script task in control tab, but how inside a data flow task Thanks Ramani You can use a script component. Just depends on what you're doing. OLE DB Commands can output to a variable, if you're using SQL. Otherwise, you can use the script component to do it on the fly. There are a few examples in this forum if you search for them. ...Show All

• Visual C# I cannot get Intellisense to work in C#

  When I start a new project, as soon as a put just a few components on a form and start writing code for an event, Intellisense stops working. I have to holf Ctrl+Space to see the options, step through the alphabet by typing a character at a time and holding Ctrl+Sapce again to see the next set of options. How can I get Intellisense to work Note that I have found solutions to what appears to be this very problem for C++ projects, but I do not see any relevance in these solutions for me because they talk about .h files and other things that are hidden or not present in C#. I am also having some weird issue with Intellisense in C# on VS 2003. CTRL+Space works fine but the "." doesn't work any ...Show All