SQL Server Management Studio with SQL Server 2000
How to use SQL Server Management Studio with SQL Server 2000 ...
sql-server-2000
Dumping an ADODB recordset to XML, then back to a recordset, then saving to the db
I've created an XML file using the .Save() method of an ADODB recordset in the following manner. dim res dim objXML: Set objXML = Server.CreateObject("MSXML2.DOMDocument") 'This returns an ADODB recordset set res = ExecuteReader("SELECT * from some_table) With res Call .Save(objXML, 1) Call .Close() End Wi...
Permissions required to run REPLMERG.EXE
We use merge replication in one of our programs and I would like to allow our users to force synchronization of their laptops with the publisher on an as-needed basis (we are using push subscriptions). I got this working using REPLMERG.EXE (see my previous question). However, when the users trid to run the script they received the foll...
SQL Server 2000 pivot without temporary tables?
Hi. I'm trying to pivot some data in SQL Server 2000, but the user that runs the application only have read/write permissions. I've looked the solutions posted here, but all involving create/destroy temporary tables. ...
SQL Server join and wildcards
I want to get the results of a left join between two tables, with both having a column of the same name, the column on which I join. The following query is seen as valid by the import/export wizard in SQL Server, but it always gives an error. I have some more conditions, so the size wouldn't be too much. We're using SQL Server 2000 iirc ...
Getting age in years in a SQL query
Hello I've been tasked with doing a few queries on a large SQL Server 2000 database. The query I'm having trouble with is "find the number of people between ages 20 and 40" How would I do this? My previous query to get a count of everyone looks like this: select count(rid) from people where ... (with the ... being irrelevant cond...
T-SQL Picking up active IDs from a comma seperated IDs list
I have two tables "Product" having following structure: ProductID,ProductName, IsSaleTypeA, IsSaleTypeB, IsSaleTypeC 1, AAA, N, N, N 2, BBB, N, Y, N -- active 3, CCC, N, N, N 4, DDD, Y, N, N -- active 5, EEE, N, N, N 6, FFF, N, N, N 7, FFE, N, N, N 8, GGG, N, N, N 9, HHH, Y, N, N -- active The second table "ProductAllowed" having ...
SQL Server 2000: Why is this query w/ variables so slow vs w/o variables?
I can't figure out why this query would be so slow with variables versus without them. I read some where that I need to enable "Dynamic Parameters" but I cannot find where to do this. DECLARE @BeginDate AS DATETIME ,@EndDate AS DATETIME SELECT @BeginDate = '2010-05-20' ,@EndDate = '2010-05-25' -- Fix date range to...
Visual Studio 2010 Connect to SQL Server 2000?
We recently upgraded a major application to Visual Studio 2010. Unfortunately, we are still using several database servers that are still running SQL Server 2000 (8.0.2055 to be precise). According to this article (http://blogs.msdn.com/b/habibh/archive/2009/07/27/visual-studio-2010-rip-list-partial.aspx), "Since mainstream support for...
Recursive query question - break rows into columns?
I have a table "Families", like so FamilyID PersonID Relationship ----------------------------------------------- F001 P001 Son F001 P002 Daughter F001 P003 Father F001 P004 Mother F002 P005 Daughter F002 P006 Mother F003 P007 Son F00...
Error Handling in T-SQL Scalar Function
Ok.. this question could easily take multiple paths, so I will hit the more specific path first. While working with SQL Server 2005, I'm trying to create a scalar funtion that acts as a 'TryCast' from varchar to int. Where I encounter a problem is when I add a TRY block in the function; CREATE FUNCTION u_TryCastInt ( @Value as VARCH...
NHibernate not dropping foreign key constraints.
I'm new to NHibernate, so this is probably my mistake, but when I use: schema.Create(true, true); I get: SchemaExport [(null)]- There is already an object named 'XXX' in the database. System.Data.SqlClient.SqlException: There is already an object named 'XXX' in the database. I grabbed the SQL code nHibernate was using, ran it dire...
SQL SPID Blocking itself
I'm running SQL Server 2000. I have a situation where users are timing out. In enterprise manager I look at the locks/ProcessIDs. I see spid 79 (Blocked By 79) How is it possible for a session to block itself? ...
sql server procedure error
CREATE PROCEDURE USP_SEARCH_HOTELS ( @Text varchar(50), @Type varchar(40) ) AS BEGIN Declare @Query VARCHAR(60) IF @Type = 'By Country' BEGIN SET @Query = 'Hotel.countryName like '+ @Text+'%' END ELSE IF @Type = 'By State' BEGIN SET @Query = 'HOTEL.stateName like '+ @Text+'%' END ELSE IF @Type='By Property Name...
How to determine sql server object name from object id and database id (sql2000)?
I need the behaviour of sql2005 where function OBJECT_NAME takes two arguments obj id and db id, while sql2000 takes only obj id so the execution must be in the context of the database to which inspected object belongs to. Solution must be possible to implement in a function, so it can be used in a select query. ...
Who deleted my sql table rows?
I have an SQL table, from which data is being deleted. Nobody knows how the data is being deleted. I added a trigger and know the time, however no jobs are running that would delete the data. I also added a trigger whenever rows are being deleted from this table. I am then inserting the deleted rows and the SYSTEM_USER to a log table, ho...
updating only date part from datetime in sql server 2000
hi Experts, I have data in the table like the following. col1 col2 col3 -------------------------------------------------------- 6/5/2010 18:05:00 6/2/2010 10:05:00 Null 6/8/2010 15:05:00 6/3/2010 10:45:00 6/5/2010 11:05:00 6/3/2010 15:05:00 Null 6/7/2010 12:0...
SQL server 2005 FOR XML RAW performance/behaviour issue.
I have a really weird problem that baffled even seasoned DBA's here where I work. I'm trying to troubleshoot performance problems with this legacy app that was originally developed with VB/SQL 2000. Most clients using this app with SQL 2000 don't have any performance issues. Some clients have SQL 2005 and have really bad performance exe...
check select statement is valid or not in c#.net
i want to check select statement(string) is valid or not in c#.net, if select statement is right then retrieve data and fill dropdown list box else drop down should be empty ...
How can Bookmark look up be ignored?
Bookmark look up is taking long time when executing a SQL 2000 query. How can this issue be solved using Query hint or Index? ...