Hi, I want to restore my databases from the old SQL Server installation into a new installation of SQL Server. My new installation of SQL Server has different data path from the old installation. In addition, the data owners of some databases in the old SQL Server installation are not dbo. I ...more >>

I have a SQL database with an Access front end. In the database I have a read only and a read write role. When a read only user opens the database I want all the fields on the form to be locked so that the user will not try to change data and get an error from the server. Right now I am doin...more >>

Hello, I have a following SP I want to add an extra field "ranking" that just increments the row number. Another feature would be: if several users have an equal totalvalue, they should have an equal ranking number. the rankings following users would have to be adjusted as well. thanks SET QU...more >>

Hi! I have a large table in SQL Server 2000 with a datetime-column 'dt'. I want to select all rows from that table, excluding days which fall on holidays or weekends. What is the best way to accomplish this? I considered creating a new table called "holidays" and then selecting all rows (sort ...more >>

Is there a way to call an Oracle Procedure using the MS OLD DB Provider for Oracle object in a SQL Server 2000 DTS package? If it can't be done this way, is there another way to retrieve data from an Oracle database using an Oracle procedure to a SQL Server table? Also, can parameters be passe...more >>

Hi all, I just start using SQL Server for my project. I have some questions related to set operations. Suppose I have two tables, Table A and Table B, as following. TableA TableB ======= ======= --------------- --------------- | ID | DATA ...more >>

I have access tables which are linked to SQL database by ODBC connection. By using Access, i can easily see my table contents. but when i am using ASP, i con not. I am getting this error message Microsoft JET Database Engine (0x80004005) ODBC--connection to 'SQL ServerMYDATABASE' failed. wi...more >>

How do you create a new table from a SELECT statement of another table using MS SQL Server. This is part of a distributed database topic for university. Unfortunately I can only seem to get the new table created in Oracle and not MS....more >>

Hi, I have a question in SQL Server 2K, I use SQL Profile to trace, and find Stored Procedure was auto recompiled, like this row in the trace: SP:Recompile 15 1680 76 2004-02-27 16:01:11.610 How can I stop the auto recompile. Thanks Harold...more >>

Is there a stored procedure installed by sql server 2000 that I can call and just pass in the name of a new database and have it create the database for me? If not, how do I do it in sql? Thanks....more >>

Something strange is happening to our SQL Server DB (2000). The tempdb transaction log file continues to grow (quite slowly) for no apparent reason. We have it in simple mode, and I have tried a manual checkpoint command and manual shrink (of the log file only). There are no unusual SQL's (la...more >>

Dumb question perhaps, but hey. SQL Agent on sql2k, client sp3a, server vanilla. In EM Agent Icon Status does'nt show. Server running status doesnt show till explicitly connected. Agent has both start and stop menu options enabled, and no green arrow/red square (Green Arrow, Red Square ... ...more >>

Hi, I need manuals, tecnical papres, instalation guide, etc about how to install one cluster sql server 2000 64 bits with windows server 2003. It`s posible a need one document step by step about this Thanks, RaulGZ....more >>

I have a client that has a server running Windows 2000 Server. another company has installed MSDE (version unknown) on this server. I need to install SQL 2000 on the same server. Will the two coexist peacefully? Tia CruznOz *** Sent via Developersdex http://www.developersdex.com *** ...more >>

We can find a lot of recommandations about how to secure a SQL*Server configuration. Does anyone have scripts to do it ? Any advices or links are welcome...more >>

I am trying to use the haversine function to find the distance between two points on a sphere, specifically two zip codes in my database. I'm neither horribly familiar with SQL syntax nor math equations :), so I was hoping I could get some help. Below is what I'm using and it is, as best as I ca...more >>

i am using sqlserver 2000, and i was wondering how do i go about setting the query time out. is there a way to configure the query timeout for a specific user id?...more >>

Hello everybody.. Is there a way to fix the SQL Server 2000 installation when the Server after the server has been disjoined form its old domain and added to a new domain with a different computer name too? Sounds like a joke, but stuff happens. TIA -arifi ...more >>

I have two tables in my DB for an e-commerce app. This allows for 1 order to have multiple products. I want to select the OrderID from the Orders table but only when all the corresponding records in the OrderDetails table all have their Despatched value = 0. Can anyone offer any help please? Sim...more >>

I have a database that is used to store a lot of data. We load the data on a daily basis, several thousand records per day. The Log file is not needed, so whats the best way to delete the records in it and reduce the size Thanks Derrick ...more >>

COuld someone tell me if its possible to get hold of stats about all Databases on a SQL Server. The sort of things I would like are Name of DB Location of DB Size of DB Location of Logfile Size of DB Owner Users Authorised to access the DB Is there somethi...more >>

Hello, What could possibly cause data in the SQL server database to be removed, except being deleted manually? We had a couple of situations where data in certain records disappeared although the records were still there. The data is entered and editted through the web interface in ASP. The w...more >>

Dear all, Sometimes I happened the require that the number of input parameters of SP is not fixed, Can sql T-SQL handle the array (dynamic array)? Does anybody ever used an array name as the input parameter to call the SP? thanks, Robert...more >>

In Access 97, I am trying to attach to a table in my SQL Server 2000 db. I use File/Get Data, which displays all the SQL tables including the one I can't attach to. (I can attach to all the other SQL tables.) But, when I select that table I get a message that tells me the name is invalid. ...more >>

Hi, I've got what I think (probably incorrectly) should be a simple SELECT : Two colums with data like col1 col2 1 50 1 51 2 50 2 51 3 50 3 54 I'm trying to bring back items in col1 that have values of both 50 and 51 ( and potentially m...more >>

Hi all, How can get the primary key string from the given table name? i know it should from system tables of "sysobjects, syscolumns, and sysconstraints", but when i execute the statement like that: select a.name from syscolumns a,sysobjects b,sysconstraints c where a.id = b.id and b.name ...more >>

I have a SP that returns the information I want but it returns it in 2 separate queries. Example: Query 1 Name, Number, Class Row 1- Mike Phillips, 154AA, AA and Query 2 Time, Manual Row 1 -12:45:22,0 Row 2 -13:04:56,0 What I want it to look like is: Name, N...more >>

Hi all I need to add data from two Excel sheets (both on the same workbook) to an existing table in my SQL DB. The problem is that each sheet holds different fields for the same record, though the records are sorted by row numbers. (I had to split the fields to different sheets because Excel ha...more >>

Hi all-- I am trying to execute the following query in MS SQL Server 2000. SELECT 1 AS Tag, NULL as parent, 'x' AS [A!1!B], NULL AS [C!48], NULL AS [RepurchaseDetails!49] UNION ALL SELECT 48, 1, NULL, 'y', NULL UNION ALL SELECT 49, 48, NULL, NULL, 'z' ...more >>

Hi I received the below error when trying to run an update from one SQL Server to another. I can insert and select. I cannot delete or update. The permissions have been changed to allow the linked server user to carry out everything, the linked servers are working but we cannot change the ...more >>

I have just tested 3 queries using QA. The complete test information : ------ CREATE TABLE agls1 ( fyear char(4) NULL , fprefix char(3) NULL , fvcno char(20) NULL , fdate datetime NULL , fid char(15) NULL , fiddate datetime NULL , fdesc char(60) NULL , facc char(12) NUL...more >>

I have a table that i want to query and group the records by the month, what SQL stanment would i use? Somthing like this? apart from i know that the "Group BY (MM/YYYY)" wont work !:) Select Date,Name FROM Table Group by (MM/YYYY) Does this make sense? Willa...more >>

Hello All, I have a SQL Query with multiple correlated Subqueries in it. When it gets executed it runs rather slow due to the size of the QT table. Does anybody have any suggestions how to alter this query to make it run faster, or any index suggestions to assist it with. Query is as follow...more >>

Hi all I am implementing a stored procedure which needs to recursively call itself until specific condition is reached, Could anyone give some advice about that? Thanks a lot Robert Song...more >>

Hello, Easy one for the SQL experts. I have a simple table. For the example let's say it looks like this: CREATE TABLE doc_exb ( column_a INT, column_b VARCHAR(20) NULL) Now I want to alter this table and make the column column_a a float instead of an INT. How do I do that? I cannot DR...more >>

Greetings, Our former SQL Server 2000 DBA backed up everything in a single disk file. By everything I mean, full backup, differential backup and transaction logs. See below for details of how the backup is currently set up. When I did 'view contents' of DBBackup, I saw it contained the ...more >>

I have a large table that I recently purged a year of data from. However, the table size in sp_spaceused hasn't decreased as much as I would expect. (there are no text or large object columns on this table, BTW) Running sp_spaceused on the table shows the following. rows ...more >>

We are running into problems on our development environment with extra parameters being added on to a stored procedure call. Instead of the expected stored procedure call, the trace shows something like this: declare @P1 int set @P1=NULL <<expected stored procedure call>> , @P1 output, <<rep...more >>

I am trying to set up a production and test machine on a LAN. The LAN is behind a firewall. Machine 1: Production machine. with SQL server (Server name Prod) Machine 2: Test machine. With SQL server (server name Test) trying to register Prod sql server in Test Sql server via Ent Manager. ke...more >>

I have created a crystal report connecting an OLAP cube .But once i try to view a report it took around 15 minutes and finaly gave an error like "cannot retrieve data from cube".I want to know why it is and how can i create a crystal report for OLAP CUB....more >>

If you are using my lock-monitoring procedure aba_lockinfo, there is now a new version available at http://www.sommarskog.se/sqlutil/aba_lockinfo.html. I recommend that you replace your existing version with this one. Functionally, there are only minor difference, but the older version did no...more >>

Hello - I'm using the following syntax: WHERE pages.ParentID=0 AND CONTAINS(pages.regionID,'#request.thisRegion#') ....and I get the folowing error: [SQLServer JDBC Driver][SQLServer]Execution of a full-text operation failed. A clause of the query contained only ignored words. I'm tryin...more >>

Hello, Forgive a newbie's question ... Can I access SQL Server and the databases and tables within using windows script? If so, could someone point me in the right direction? Regards, Bob ...more >>

Hi there, We have a user name convention here that specifies users in the following way: jane.doe john.smith In order to change a database object I must specify the owner name along with the object name. Does anyone know the proper syntax for doing this with a user name that contains a per...more >>

Hi, I have lost my win 2k server where I had my Sql 2000 data. Now I need to attach to sql server my database, but I have lost the log file. If I use the enterprise manager I get an error, if I use a stored procedure I get an error. How can I do to attach my .mdf file to Sql Server...more >>

I am using the Dynamic Cross-Tab code supplied in an article from SQL Server Magazine (http://www.winnetmag.com/SQLServer/Article/ArticleID/15608/15608.html). I modified the script to generate a temp table inside the stored procedure, and then use this temp table as the source for the cross-tab....more >>

Is is possible to create a composite primary key on a table variable? Neither of these two statements are successful: DECLARE @opmcjf TABLE ( jobdetailid INT NOT NULL, cjfid INT NOT NULL, cjfvalue VARCHAR(100) NULL ) ALTER TABLE @opmcjf ADD CONSTRAINT [PK_opmcjf] PRIMARY KEY CLUSTE...more >>

I have a SP set up to take an input param and then fire the following sp_xml_preparedocument OPENXML (With a select statement) sp_xml_removedocument This works fine with the XML syntax that microsoft provides in its documentation ... <ROOT> <Customer> <CustomerID>VINET</CustomerID> ...more >>

Hi, Is there any website which lists the various SQL Server related questions which might be helpfull for interviews. I am looking for one that contains complex Queries that includes all kinds of operators like GROUP BY, HAVING etc... Regards, Kamlesh...more >>

hello, I have a little (big?) problem with a software in ASP / SQL Server. This is a demo of the problem: ID= 12458 Data=21/01/2004 21:14:45 txt txt txt ID= 12458 Data=21/01/2004 21:14:45 txt txt txt ID= 12458 Data=21/01/2004 21:14:45 txt txt txt ID= 12458 Data=21/01/2004 21:14:45 txt txt tx...more >>

I have this stored procedure that takes a few parameters like date and merchant ID, and basically goes through a set of if-then statements to build a SQL SELECT string. When we upgraded from SQL Server 7.0 to 2000, the stored procedure still worked from Query Analyzer, but not in BCP. It used...more >>

Can anyone see anything obviously wrong with this statement? I'm not really an SQL kind of guy SELECT ProductID, Title FROM Products WHERE PlatformID LIKE % AND CategoryID = 'f5e45b55-95de-47f4-a79b-b24969178b52' ORDER BY Title PlatformID contains a GUID and I thought passing a wildcard woul...more >>

I also posted similarly in mailing.database.mysql I have created a rather large (60 table database) website dealio in PHP that works with MS SQL Server, Oracle, MySQL and presumably any other data base I add to the wrapper functions that I created. All the development was done in Oracle, but...more >>

Hello, In the below SQL I am getting Error at COUNT. Can anyone tell me what is wrong with this query: SELECT DISTINCT A.EMP_NO, A.ENT_DT, CASE A.SHIP_NO WHEN (SELECT COUNT(DISTINCT SHIP_NO) FROM EMP_S...more >>

Hi All, I have a table that currently contains approx. 8 million records. I'm running a SELECT query against this table that in some circumstances is either very quick (ie results returned in Query Analyzer almost instantaneously), or very slow (ie 30 to 40 seconds to return results), and I...more >>

Hi, I have a table that stores a list of IDENTITIES that references different tables. Two rows in this table refreence the same key from a table: tbl_myTable(myTableID, swUserID, hwUserID, etc...) tbl_user (userID, userName) where swUserID and hwUserID references userID of the tbl_user ...more >>

hi. Trying to concatenate two columns: select uname+' '+uaddress as NameAdr from tblUser I only get the first field, name!!?? The datatype is both nvarchar. 100 and 50 chars long. If I run this query: select uname, uaddress from tblUser theres no problem. Any suggestions? Th...more >>

I have one table of new records (tableA) that may already exist in tableB. I want to insert these records into tableB with insert if they don't already exist, or update any existing ones with new data if they do already exist. A column (Action) in tableA already tells me whether this is an INSER...more >>

Hi Can an application populate two Grids from the database, simultaneously without using the multithreading using ADO.NET Thanks in advance MR_FBI mr_fbi2020@yahoo.com...more >>

My SQL Server 2000 does not use the accent insensitive collation setting (collation containing _AI) in full-text serches: While SELECT * FROM <table> WHERE <column> LIKE '%a%' returns 'Mäuse', SELECT * FROM <table> WHERE CONTAINS(*, 'a') does not. Setting 'default full-text language' to neutra...more >>

In our database we have a list of devices in a "Device" Table, each having one or more IP's located in the "IP" Table linked through a forein key on the DeviceID Column. I would like to retrieve this information as Such DeviceID IpAddress 1 10.0.0.1, 10.0.0.2, 10.0.0.3...more >>

Hi chaps Just been having my head messed with... I was running a trace capturing all errors and SQL. Had a bucket of error 208's (invalid object name). Found the SQL that caused it - an SP. Ran the sp by hand, no messages come up - error 208 logged in the trace. Couldn't work it out...more >>

Here are my rows TimeIn TimeOut Reason ------------------------------------ 01/01/04 8:00 01/01/04 12:00 Out - Lunch 01/01/04 12:00 01/01/04 1:00 Lunch Hour 01/01/04 1:00 01/01/04 5:00 Out - FTD Here is what I want to return from this data Date In Out/...more >>

Hello I have some problems with converting varbinary to float in T-SQL stored procedure. In my C# application i have table of structures with double type fields. Size of this table is variant. I have to send this table to SP. Because of performance i want to send it only once and whole. So I hav...more >>