I received the following error when I tried to run a C# WinForms application on a Windows Server 2003 Standard Edition SP1 machine that was connecting to a SQL server 2000, converting the data in the WinForms app and inserting the converted into a SQL server 2005 application. I am connecting to each database using SSPI. The code was co...
I am using SQL2000 and I would like to join two table together based on their positions For example consider the following 2 tables: table1 ------- name ------- 'cat' 'dog' 'mouse' table2 ------ cost ------ 23 13 25 I would now like to blindly join the two table together as follows based on their order not on a matching columns (I ...
Hi all, I'm wondering if anybody has had any experience in trying to install SQL Server 2008 Express along side with SQL Server 2000. We have a production server running 2000 which all of our current stuff is running on. However, something new is in the pipeline that uses SQL Server 2008 Express. Hitting Google thus far has given m...
I have a stored procedure in SQL Server 2000 that performs a search based on parameter values. For one of the parameters passed in, I need a different WHERE clause depending on its value - the problem is that the 3 values would be where MyColumn IS NULL IS NOT NULL ANY VALUE (NULL AND NOT NULL) (essentially no WHERE clause) I'm hav...
Has anyone seen the issue with SQL Profiler 2000 where you cannot pause or stop a trace? The only way I can stop it, is by doing a control - alt - delete and then end the application process. This just randomly started happening. Also the pause and stop buttons grey out. Any help on this issue is greatly appreciated. ...
i am using the freetexttable in my search but i am not getting the exact results how can i get the exact results.... ...
i am using sql server 2000 can i use full text search on the view of a table.. ...
I have a database that we are having problems with. Somehow the log has became 400 Gb and the database has been rendered useless. I want to drop all existing connections to the database and then detach the database. Basically what I'm going to do is get rid of the giant log file and create a new one and reattach if it works. If not, ...
I have a stored procedure which executes a select statement. I would like my results ordered by a date field and display all records with NULL dates first and then the most recent dates. The statement looks like this: SELECT a,b,c,[Submission Date] FROM someView ORDER BY [Submission Date] ASC Now this will display all records with NU...
I have a SQL Server 2000 database that will not display the column list for any tables in the View "designer" in Enterprise Manager This problem exists when either designing a new view or when editing existing views. All that is displayed for each table in the diagram is "* (All Columns)". The views otherwise work. I do NOT have this...
I am using SQL Server 2000 and I am using full text indexing on a table. Can I use full text indexing on a view of this table? If yes, then how can I use? If no, then what should I do? Actually, I am doing refinement of the results obtained from a table and for this refinement I am using a view of this table... ...
History: I had a deployment the other night which involved executing a script that creates a stored procedure. However when running the script, an error occurred about the collation of the DB. The Problem: With the help of our friend Google, I managed to find out that the problem I was having was because on our live environment's db ha...
In a similar vein to my previous question I again ask the SO guys for your collective wisdom and help. In a stored procedure and after passing some checks I need to insert a new row and return the newly created id for it. The check if a row exists works so it is the bit after that which I am undecided upon. The table has two important ...
Title says it all. I need a query for SqlServer 2000 to get a list of all foreign keys. Additional info: Whoops I guess the title doesn't say it all. I meant to add "that point to a particular column" ...
I have a table. The table needs to store a number values about a location, so initially I had just the two columns without the incrementing column, giving the following: RefID | TypeID 1 | 1 1 | 3 1 | 6 2 | 3 3 | 5 3 | 6 Where the first column is the reference for a location and the second is the actual values....
Let's say I have a SQL Server 2000 table, any name will do, it's irrelevant for this topic. On this table I have a trigger that runs after update or insert. The user is able to insert and update the table on which the trigger is attached, but not on other tables that the trigger targets. If the user modifies data in the original table...
Hi, I was wondering if there is a way in SQL Server 2000 to create all dates given a start and end date as a result. I know I can achieve this with T-SQL looping. I am looking for a non looping solution. Also in 2005 you can use the recursive with clause. The solution can also be using a T table that has numbers in it to join with the ta...
I need to quickly implement a read-only database containing data pulled from two identically structured live databases. The live dbs are actually company dbs from a Dynamics accounting system so I'm happy for any Dynamics specific advice but this is mostly a SQL question. It's a fairly old version of Dynamics from before Great Plains wa...
I am using sql server 2000 and asp.net with c# for making a search engine and i want to refine the results obtained from a search without making server connection again and again due to speed factor how can i make my search fast?..............how can i make sql server connection lesser?... ...
how can dataset filtering be done? ...